2014-11-05 01:08:35 UTC [63162]: [1-1] user=,db=,client= LOG:  database system was shut down at 2014-11-05 01:08:33 UTC
2014-11-05 01:08:35 UTC [63161]: [1-1] user=,db=,client= LOG:  database system is ready to accept connections
2014-11-05 01:08:35 UTC [63166]: [1-1] user=,db=,client= LOG:  autovacuum launcher started
2014-11-05 01:08:36 UTC [63168]: [1-1] user=[unknown],db=[unknown],client= LOG:  connection received: host=[local]
2014-11-05 01:08:36 UTC [63168]: [2-1] user=sekondquad,db=postgres,client=[local] LOG:  connection authorized: user=sekondquad database=postgres
2014-11-05 01:08:36 UTC [63168]: [3-1] user=sekondquad,db=postgres,client=[local] LOG:  disconnection: session time: 0:00:00.009 user=sekondquad database=postgres host=[local]
2014-11-05 01:08:36 UTC [63181]: [1-1] user=[unknown],db=[unknown],client= LOG:  connection received: host=[local]
2014-11-05 01:08:36 UTC [63182]: [1-1] user=[unknown],db=[unknown],client= LOG:  connection received: host=[local]
2014-11-05 01:08:36 UTC [63181]: [2-1] user=sekondquad,db=dbt3,client=[local] LOG:  connection authorized: user=sekondquad database=dbt3
2014-11-05 01:08:36 UTC [63182]: [2-1] user=sekondquad,db=dbt3,client=[local] LOG:  connection authorized: user=sekondquad database=dbt3
2014-11-05 01:08:36 UTC [63182]: [3-1] user=sekondquad,db=dbt3,client=[local] LOG:  statement: INSERT INTO time_statistics (task_name, s_time)
	VALUES ('PERF.POWER', CURRENT_TIMESTAMP);
2014-11-05 01:08:36 UTC [63181]: [3-1] user=sekondquad,db=dbt3,client=[local] LOG:  statement: SHOW server_version_num;
2014-11-05 01:08:36 UTC [63181]: [4-1] user=sekondquad,db=dbt3,client=[local] LOG:  duration: 0.717 ms
2014-11-05 01:08:36 UTC [63181]: [5-1] user=sekondquad,db=dbt3,client=[local] LOG:  disconnection: session time: 0:00:00.011 user=sekondquad database=dbt3 host=[local]
2014-11-05 01:08:36 UTC [63182]: [4-1] user=sekondquad,db=dbt3,client=[local] LOG:  duration: 2.434 ms
2014-11-05 01:08:36 UTC [63182]: [5-1] user=sekondquad,db=dbt3,client=[local] LOG:  disconnection: session time: 0:00:00.012 user=sekondquad database=dbt3 host=[local]
2014-11-05 01:08:36 UTC [63185]: [1-1] user=[unknown],db=[unknown],client= LOG:  connection received: host=[local]
2014-11-05 01:08:36 UTC [63185]: [2-1] user=sekondquad,db=dbt3,client=[local] LOG:  connection authorized: user=sekondquad database=dbt3
2014-11-05 01:08:36 UTC [63185]: [3-1] user=sekondquad,db=dbt3,client=[local] LOG:  statement: SELECT version();
2014-11-05 01:08:36 UTC [63185]: [4-1] user=sekondquad,db=dbt3,client=[local] LOG:  duration: 1.022 ms
2014-11-05 01:08:36 UTC [63185]: [5-1] user=sekondquad,db=dbt3,client=[local] LOG:  disconnection: session time: 0:00:00.004 user=sekondquad database=dbt3 host=[local]
2014-11-05 01:08:36 UTC [63189]: [1-1] user=[unknown],db=[unknown],client= LOG:  connection received: host=[local]
2014-11-05 01:08:36 UTC [63189]: [2-1] user=sekondquad,db=dbt3,client=[local] LOG:  connection authorized: user=sekondquad database=dbt3
2014-11-05 01:08:36 UTC [63191]: [1-1] user=[unknown],db=[unknown],client= LOG:  connection received: host=[local]
2014-11-05 01:08:36 UTC [63189]: [3-1] user=sekondquad,db=dbt3,client=[local] LOG:  statement: INSERT INTO time_statistics (task_name, s_time)
	VALUES ('PERF.POWER.RF1', CURRENT_TIMESTAMP);
2014-11-05 01:08:36 UTC [63191]: [2-1] user=sekondquad,db=dbt3,client=[local] LOG:  connection authorized: user=sekondquad database=dbt3
2014-11-05 01:08:36 UTC [63189]: [4-1] user=sekondquad,db=dbt3,client=[local] LOG:  duration: 1.542 ms
2014-11-05 01:08:36 UTC [63189]: [5-1] user=sekondquad,db=dbt3,client=[local] LOG:  disconnection: session time: 0:00:00.005 user=sekondquad database=dbt3 host=[local]
2014-11-05 01:08:36 UTC [63191]: [3-1] user=sekondquad,db=dbt3,client=[local] LOG:  statement: SHOW ALL
2014-11-05 01:08:36 UTC [63191]: [4-1] user=sekondquad,db=dbt3,client=[local] LOG:  duration: 1.053 ms
2014-11-05 01:08:36 UTC [63191]: [5-1] user=sekondquad,db=dbt3,client=[local] LOG:  disconnection: session time: 0:00:00.004 user=sekondquad database=dbt3 host=[local]
2014-11-05 01:08:36 UTC [63195]: [1-1] user=[unknown],db=[unknown],client= LOG:  connection received: host=[local]
2014-11-05 01:08:36 UTC [63195]: [2-1] user=sekondquad,db=dbt3,client=[local] LOG:  connection authorized: user=sekondquad database=dbt3
2014-11-05 01:08:36 UTC [63196]: [1-1] user=[unknown],db=[unknown],client= LOG:  connection received: host=[local]
2014-11-05 01:08:36 UTC [63196]: [2-1] user=sekondquad,db=dbt3,client=[local] LOG:  connection authorized: user=sekondquad database=dbt3
2014-11-05 01:08:36 UTC [63195]: [3-1] user=sekondquad,db=dbt3,client=[local] LOG:  statement: SELECT nextval('dataset');
2014-11-05 01:08:36 UTC [63196]: [3-1] user=sekondquad,db=dbt3,client=[local] LOG:  statement: SELECT tablename FROM pg_tables WHERE schemaname = 'public'ORDER BY tablename;
2014-11-05 01:08:36 UTC [63195]: [4-1] user=sekondquad,db=dbt3,client=[local] LOG:  duration: 1.639 ms
2014-11-05 01:08:36 UTC [63195]: [5-1] user=sekondquad,db=dbt3,client=[local] LOG:  disconnection: session time: 0:00:00.004 user=sekondquad database=dbt3 host=[local]
2014-11-05 01:08:36 UTC [63196]: [4-1] user=sekondquad,db=dbt3,client=[local] LOG:  duration: 6.367 ms
2014-11-05 01:08:36 UTC [63196]: [5-1] user=sekondquad,db=dbt3,client=[local] LOG:  disconnection: session time: 0:00:00.010 user=sekondquad database=dbt3 host=[local]
2014-11-05 01:08:36 UTC [63199]: [1-1] user=[unknown],db=[unknown],client= LOG:  connection received: host=[local]
2014-11-05 01:08:36 UTC [63199]: [2-1] user=sekondquad,db=dbt3,client=[local] LOG:  connection authorized: user=sekondquad database=dbt3
2014-11-05 01:08:36 UTC [63199]: [3-1] user=sekondquad,db=dbt3,client=[local] LOG:  statement: SELECT indexname FROM pg_indexes WHERE schemaname = 'public' ORDER BY indexname;
2014-11-05 01:08:36 UTC [63199]: [4-1] user=sekondquad,db=dbt3,client=[local] LOG:  duration: 6.569 ms
2014-11-05 01:08:36 UTC [63199]: [5-1] user=sekondquad,db=dbt3,client=[local] LOG:  disconnection: session time: 0:00:00.009 user=sekondquad database=dbt3 host=[local]
2014-11-05 01:08:36 UTC [63207]: [1-1] user=[unknown],db=[unknown],client= LOG:  connection received: host=[local]
2014-11-05 01:08:36 UTC [63207]: [2-1] user=sekondquad,db=dbt3,client=[local] LOG:  connection authorized: user=sekondquad database=dbt3
2014-11-05 01:08:36 UTC [63206]: [1-1] user=[unknown],db=[unknown],client= LOG:  connection received: host=[local]
2014-11-05 01:08:36 UTC [63206]: [2-1] user=sekondquad,db=dbt3,client=[local] LOG:  connection authorized: user=sekondquad database=dbt3
2014-11-05 01:08:36 UTC [63207]: [3-1] user=sekondquad,db=dbt3,client=[local] LOG:  statement: COPY (SELECT EXTRACT(EPOCH FROM TRANSACTION_TIMESTAMP()) AS ctime, relname, pid, mode, granted FROM pg_locks, pg_class WHERE relfilenode = relation ORDER BY relname) TO STDOUT (FORMAT CSV, HEADER);
2014-11-05 01:08:36 UTC [63206]: [3-1] user=sekondquad,db=dbt3,client=[local] LOG:  statement: COPY (SELECT EXTRACT(EPOCH FROM TRANSACTION_TIMESTAMP()) AS ctime, datname, pid, usesysid, usename, application_name, client_addr, client_port, backend_start, xact_start, query_start, waiting, query , state, state_change FROM pg_stat_activity) TO STDOUT (FORMAT CSV, HEADER);
2014-11-05 01:08:36 UTC [63208]: [1-1] user=[unknown],db=[unknown],client= LOG:  connection received: host=[local]
2014-11-05 01:08:36 UTC [63207]: [4-1] user=sekondquad,db=dbt3,client=[local] LOG:  duration: 3.087 ms
2014-11-05 01:08:36 UTC [63209]: [1-1] user=[unknown],db=[unknown],client= LOG:  connection received: host=[local]
2014-11-05 01:08:36 UTC [63207]: [5-1] user=sekondquad,db=dbt3,client=[local] LOG:  disconnection: session time: 0:00:00.006 user=sekondquad database=dbt3 host=[local]
2014-11-05 01:08:36 UTC [63208]: [2-1] user=sekondquad,db=dbt3,client=[local] LOG:  connection authorized: user=sekondquad database=dbt3
2014-11-05 01:08:36 UTC [63210]: [1-1] user=[unknown],db=[unknown],client= LOG:  connection received: host=[local]
2014-11-05 01:08:36 UTC [63209]: [2-1] user=sekondquad,db=dbt3,client=[local] LOG:  connection authorized: user=sekondquad database=dbt3
2014-11-05 01:08:36 UTC [63210]: [2-1] user=sekondquad,db=dbt3,client=[local] LOG:  connection authorized: user=sekondquad database=dbt3
2014-11-05 01:08:36 UTC [63206]: [4-1] user=sekondquad,db=dbt3,client=[local] LOG:  duration: 3.615 ms
2014-11-05 01:08:36 UTC [63206]: [5-1] user=sekondquad,db=dbt3,client=[local] LOG:  disconnection: session time: 0:00:00.006 user=sekondquad database=dbt3 host=[local]
2014-11-05 01:08:36 UTC [63208]: [3-1] user=sekondquad,db=dbt3,client=[local] LOG:  statement: COPY (SELECT EXTRACT(EPOCH FROM TRANSACTION_TIMESTAMP()) AS ctime, datname, numbackends, xact_commit, xact_rollback, blks_read, blks_hit, tup_returned, tup_fetched, tup_inserted, tup_updated, tup_deleted FROM pg_stat_database) TO STDOUT (FORMAT CSV, HEADER);
2014-11-05 01:08:36 UTC [63209]: [3-1] user=sekondquad,db=dbt3,client=[local] LOG:  statement: COPY (SELECT EXTRACT(EPOCH FROM TRANSACTION_TIMESTAMP()) AS ctime, a.schemaname, a.relname, seq_scan, seq_tup_read, idx_scan, idx_tup_fetch, n_tup_ins, n_tup_upd, n_tup_del, n_tup_hot_upd, n_live_tup, n_dead_tup, heap_blks_read, heap_blks_hit, idx_blks_read, idx_blks_hit, toast_blks_read, toast_blks_hit, tidx_blks_read, tidx_blks_hit FROM pg_statio_all_tables a, pg_stat_all_tables b WHERE a.relid = b.relid) TO STDOUT (FORMAT CSV, HEADER);
2014-11-05 01:08:36 UTC [63210]: [3-1] user=sekondquad,db=dbt3,client=[local] LOG:  statement: COPY (SELECT EXTRACT(EPOCH FROM TRANSACTION_TIMESTAMP()) AS ctime, a.schemaname, a.relname, a.indexrelname, idx_scan, idx_tup_read, idx_tup_fetch, idx_blks_read, idx_blks_hit FROM pg_stat_all_indexes a, pg_statio_all_indexes b WHERE a.indexrelid = b.indexrelid) TO STDOUT (FORMAT CSV, HEADER);
2014-11-05 01:08:36 UTC [63209]: [4-1] user=sekondquad,db=dbt3,client=[local] LOG:  duration: 11.985 ms
2014-11-05 01:08:36 UTC [63208]: [4-1] user=sekondquad,db=dbt3,client=[local] LOG:  duration: 12.626 ms
2014-11-05 01:08:36 UTC [63209]: [5-1] user=sekondquad,db=dbt3,client=[local] LOG:  disconnection: session time: 0:00:00.014 user=sekondquad database=dbt3 host=[local]
2014-11-05 01:08:36 UTC [63208]: [5-1] user=sekondquad,db=dbt3,client=[local] LOG:  disconnection: session time: 0:00:00.015 user=sekondquad database=dbt3 host=[local]
2014-11-05 01:08:36 UTC [63210]: [4-1] user=sekondquad,db=dbt3,client=[local] LOG:  duration: 16.528 ms
2014-11-05 01:08:36 UTC [63210]: [5-1] user=sekondquad,db=dbt3,client=[local] LOG:  disconnection: session time: 0:00:00.018 user=sekondquad database=dbt3 host=[local]
2014-11-05 01:08:42 UTC [63216]: [1-1] user=[unknown],db=[unknown],client= LOG:  connection received: host=[local]
2014-11-05 01:08:42 UTC [63216]: [2-1] user=sekondquad,db=dbt3,client=[local] LOG:  connection authorized: user=sekondquad database=dbt3
2014-11-05 01:08:42 UTC [63216]: [3-1] user=sekondquad,db=dbt3,client=[local] LOG:  statement: BEGIN;
2014-11-05 01:08:42 UTC [63216]: [4-1] user=sekondquad,db=dbt3,client=[local] LOG:  duration: 0.325 ms
2014-11-05 01:08:42 UTC [63216]: [5-1] user=sekondquad,db=dbt3,client=[local] LOG:  statement: COPY lineitem
	FROM '/home/sekondquad/dbt3/dss/lineitem.tbl.u2'
	USING DELIMITERS '|';
2014-11-05 01:08:50 UTC [63216]: [6-1] user=sekondquad,db=dbt3,client=[local] LOG:  duration: 7486.432 ms
2014-11-05 01:08:50 UTC [63216]: [7-1] user=sekondquad,db=dbt3,client=[local] LOG:  statement: COPY orders
	FROM '/home/sekondquad/dbt3/dss/orders.tbl.u2'
	USING DELIMITERS '|';
2014-11-05 01:08:50 UTC [63216]: [8-1] user=sekondquad,db=dbt3,client=[local] LOG:  duration: 354.859 ms
2014-11-05 01:08:50 UTC [63216]: [9-1] user=sekondquad,db=dbt3,client=[local] LOG:  statement: COMMIT;
2014-11-05 01:08:50 UTC [63216]: [10-1] user=sekondquad,db=dbt3,client=[local] LOG:  duration: 22.551 ms
2014-11-05 01:08:50 UTC [63216]: [11-1] user=sekondquad,db=dbt3,client=[local] LOG:  disconnection: session time: 0:00:07.869 user=sekondquad database=dbt3 host=[local]
2014-11-05 01:08:50 UTC [63222]: [1-1] user=[unknown],db=[unknown],client= LOG:  connection received: host=[local]
2014-11-05 01:08:50 UTC [63222]: [2-1] user=sekondquad,db=dbt3,client=[local] LOG:  connection authorized: user=sekondquad database=dbt3
2014-11-05 01:08:50 UTC [63222]: [3-1] user=sekondquad,db=dbt3,client=[local] LOG:  statement: UPDATE time_statistics
	SET e_time = current_timestamp
	WHERE task_name = 'PERF.POWER.RF1';
2014-11-05 01:08:50 UTC [63222]: [4-1] user=sekondquad,db=dbt3,client=[local] LOG:  duration: 4.009 ms
2014-11-05 01:08:50 UTC [63222]: [5-1] user=sekondquad,db=dbt3,client=[local] LOG:  disconnection: session time: 0:00:00.008 user=sekondquad database=dbt3 host=[local]
2014-11-05 01:08:50 UTC [63230]: [1-1] user=[unknown],db=[unknown],client= LOG:  connection received: host=[local]
2014-11-05 01:08:50 UTC [63230]: [2-1] user=sekondquad,db=dbt3,client=[local] LOG:  connection authorized: user=sekondquad database=dbt3
2014-11-05 01:08:50 UTC [63230]: [3-1] user=sekondquad,db=dbt3,client=[local] LOG:  statement: INSERT INTO time_statistics (task_name, s_time)
	VALUES ('PERF.POWER.Q14', CURRENT_TIMESTAMP);
2014-11-05 01:08:50 UTC [63230]: [4-1] user=sekondquad,db=dbt3,client=[local] LOG:  duration: 1.983 ms
2014-11-05 01:08:50 UTC [63230]: [5-1] user=sekondquad,db=dbt3,client=[local] LOG:  disconnection: session time: 0:00:00.005 user=sekondquad database=dbt3 host=[local]
2014-11-05 01:08:50 UTC [63232]: [1-1] user=[unknown],db=[unknown],client= LOG:  connection received: host=[local]
2014-11-05 01:08:50 UTC [63232]: [2-1] user=sekondquad,db=dbt3,client=[local] LOG:  connection authorized: user=sekondquad database=dbt3
2014-11-05 01:08:50 UTC [63232]: [3-1] user=sekondquad,db=dbt3,client=[local] LOG:  statement: BEGIN;
2014-11-05 01:08:50 UTC [63232]: [4-1] user=sekondquad,db=dbt3,client=[local] LOG:  duration: 0.209 ms
2014-11-05 01:08:50 UTC [63232]: [5-1] user=sekondquad,db=dbt3,client=[local] LOG:  statement: EXPLAIN (ANALYZE, BUFFERS)
	select
		100.00 * sum(case
			when p_type like 'PROMO%'
				then l_extendedprice * (1 - l_discount)
			else 0
		end) / sum(l_extendedprice * (1 - l_discount)) as promo_revenue
	from
		lineitem,
		part
	where
		l_partkey = p_partkey
		and l_shipdate >= date '1993-10-01'
		and l_shipdate < cast(date '1993-10-01' + interval '1 month' as date);
2014-11-05 01:08:59 UTC [63232]: [6-1] user=sekondquad,db=dbt3,client=[local] LOG:  duration: 8300.427 ms
2014-11-05 01:08:59 UTC [63232]: [7-1] user=sekondquad,db=dbt3,client=[local] LOG:  statement: COMMIT;
2014-11-05 01:08:59 UTC [63232]: [8-1] user=sekondquad,db=dbt3,client=[local] LOG:  duration: 0.131 ms
2014-11-05 01:08:59 UTC [63232]: [9-1] user=sekondquad,db=dbt3,client=[local] LOG:  disconnection: session time: 0:00:08.305 user=sekondquad database=dbt3 host=[local]
2014-11-05 01:08:59 UTC [63234]: [1-1] user=[unknown],db=[unknown],client= LOG:  connection received: host=[local]
2014-11-05 01:08:59 UTC [63234]: [2-1] user=sekondquad,db=dbt3,client=[local] LOG:  connection authorized: user=sekondquad database=dbt3
2014-11-05 01:08:59 UTC [63234]: [3-1] user=sekondquad,db=dbt3,client=[local] LOG:  statement: UPDATE time_statistics
	SET e_time = current_timestamp
	WHERE task_name = 'PERF.POWER.Q14';
2014-11-05 01:08:59 UTC [63234]: [4-1] user=sekondquad,db=dbt3,client=[local] LOG:  duration: 3.114 ms
2014-11-05 01:08:59 UTC [63234]: [5-1] user=sekondquad,db=dbt3,client=[local] LOG:  disconnection: session time: 0:00:00.006 user=sekondquad database=dbt3 host=[local]
2014-11-05 01:08:59 UTC [63240]: [1-1] user=[unknown],db=[unknown],client= LOG:  connection received: host=[local]
2014-11-05 01:08:59 UTC [63240]: [2-1] user=sekondquad,db=dbt3,client=[local] LOG:  connection authorized: user=sekondquad database=dbt3
2014-11-05 01:08:59 UTC [63240]: [3-1] user=sekondquad,db=dbt3,client=[local] LOG:  statement: INSERT INTO time_statistics (task_name, s_time)
	VALUES ('PERF.POWER.Q2', CURRENT_TIMESTAMP);
2014-11-05 01:08:59 UTC [63240]: [4-1] user=sekondquad,db=dbt3,client=[local] LOG:  duration: 1.428 ms
2014-11-05 01:08:59 UTC [63240]: [5-1] user=sekondquad,db=dbt3,client=[local] LOG:  disconnection: session time: 0:00:00.004 user=sekondquad database=dbt3 host=[local]
2014-11-05 01:08:59 UTC [63242]: [1-1] user=[unknown],db=[unknown],client= LOG:  connection received: host=[local]
2014-11-05 01:08:59 UTC [63242]: [2-1] user=sekondquad,db=dbt3,client=[local] LOG:  connection authorized: user=sekondquad database=dbt3
2014-11-05 01:08:59 UTC [63242]: [3-1] user=sekondquad,db=dbt3,client=[local] LOG:  statement: BEGIN;
2014-11-05 01:08:59 UTC [63242]: [4-1] user=sekondquad,db=dbt3,client=[local] LOG:  duration: 0.202 ms
2014-11-05 01:08:59 UTC [63242]: [5-1] user=sekondquad,db=dbt3,client=[local] LOG:  statement: EXPLAIN (ANALYZE, BUFFERS)
	select
		s_acctbal,
		s_name,
		n_name,
		p_partkey,
		p_mfgr,
		s_address,
		s_phone,
		s_comment
	from
		part,
		supplier,
		partsupp,
		nation,
		region
	where
		p_partkey = ps_partkey
		and s_suppkey = ps_suppkey
		and p_size = 8
		and p_type like '%STEEL'
		and s_nationkey = n_nationkey
		and n_regionkey = r_regionkey
		and r_name = 'AFRICA'
		and ps_supplycost = (
			select
				min(ps_supplycost)
			from
				partsupp,
				supplier,
				nation,
				region
			where
				p_partkey = ps_partkey
				and s_suppkey = ps_suppkey
				and s_nationkey = n_nationkey
				and n_regionkey = r_regionkey
				and r_name = 'AFRICA'
		)
	order by
		s_acctbal desc,
		n_name,
		s_name,
		p_partkey
	LIMIT 100;
2014-11-05 01:09:08 UTC [63242]: [6-1] user=sekondquad,db=dbt3,client=[local] LOG:  duration: 9770.800 ms
2014-11-05 01:09:08 UTC [63242]: [7-1] user=sekondquad,db=dbt3,client=[local] LOG:  statement: COMMIT;
2014-11-05 01:09:08 UTC [63242]: [8-1] user=sekondquad,db=dbt3,client=[local] LOG:  duration: 0.307 ms
2014-11-05 01:09:08 UTC [63242]: [9-1] user=sekondquad,db=dbt3,client=[local] LOG:  disconnection: session time: 0:00:09.777 user=sekondquad database=dbt3 host=[local]
2014-11-05 01:09:08 UTC [63255]: [1-1] user=[unknown],db=[unknown],client= LOG:  connection received: host=[local]
2014-11-05 01:09:08 UTC [63255]: [2-1] user=sekondquad,db=dbt3,client=[local] LOG:  connection authorized: user=sekondquad database=dbt3
2014-11-05 01:09:08 UTC [63255]: [3-1] user=sekondquad,db=dbt3,client=[local] LOG:  statement: UPDATE time_statistics
	SET e_time = current_timestamp
	WHERE task_name = 'PERF.POWER.Q2';
2014-11-05 01:09:08 UTC [63255]: [4-1] user=sekondquad,db=dbt3,client=[local] LOG:  duration: 3.724 ms
2014-11-05 01:09:08 UTC [63255]: [5-1] user=sekondquad,db=dbt3,client=[local] LOG:  disconnection: session time: 0:00:00.008 user=sekondquad database=dbt3 host=[local]
2014-11-05 01:09:08 UTC [63261]: [1-1] user=[unknown],db=[unknown],client= LOG:  connection received: host=[local]
2014-11-05 01:09:08 UTC [63261]: [2-1] user=sekondquad,db=dbt3,client=[local] LOG:  connection authorized: user=sekondquad database=dbt3
2014-11-05 01:09:08 UTC [63261]: [3-1] user=sekondquad,db=dbt3,client=[local] LOG:  statement: INSERT INTO time_statistics (task_name, s_time)
	VALUES ('PERF.POWER.Q9', CURRENT_TIMESTAMP);
2014-11-05 01:09:08 UTC [63261]: [4-1] user=sekondquad,db=dbt3,client=[local] LOG:  duration: 1.390 ms
2014-11-05 01:09:08 UTC [63261]: [5-1] user=sekondquad,db=dbt3,client=[local] LOG:  disconnection: session time: 0:00:00.004 user=sekondquad database=dbt3 host=[local]
2014-11-05 01:09:08 UTC [63263]: [1-1] user=[unknown],db=[unknown],client= LOG:  connection received: host=[local]
2014-11-05 01:09:08 UTC [63263]: [2-1] user=sekondquad,db=dbt3,client=[local] LOG:  connection authorized: user=sekondquad database=dbt3
2014-11-05 01:09:08 UTC [63263]: [3-1] user=sekondquad,db=dbt3,client=[local] LOG:  statement: BEGIN;
2014-11-05 01:09:08 UTC [63263]: [4-1] user=sekondquad,db=dbt3,client=[local] LOG:  duration: 0.168 ms
2014-11-05 01:09:08 UTC [63263]: [5-1] user=sekondquad,db=dbt3,client=[local] LOG:  statement: EXPLAIN (ANALYZE, BUFFERS)
	select
		nation,
		o_year,
		sum(amount) as sum_profit
	from
		(
			select
				n_name as nation,
				extract(year from o_orderdate) as o_year,
				l_extendedprice * (1 - l_discount) - ps_supplycost * l_quantity as amount
			from
				part,
				supplier,
				lineitem,
				partsupp,
				orders,
				nation
			where
				s_suppkey = l_suppkey
				and ps_suppkey = l_suppkey
				and ps_partkey = l_partkey
				and p_partkey = l_partkey
				and o_orderkey = l_orderkey
				and s_nationkey = n_nationkey
				and p_name like '%peach%'
		) as profit
	group by
		nation,
		o_year
	order by
		nation,
		o_year desc;
2014-11-05 01:09:36 UTC [63278]: [1-1] user=[unknown],db=[unknown],client= LOG:  connection received: host=[local]
2014-11-05 01:09:36 UTC [63279]: [1-1] user=[unknown],db=[unknown],client= LOG:  connection received: host=[local]
2014-11-05 01:09:36 UTC [63280]: [1-1] user=[unknown],db=[unknown],client= LOG:  connection received: host=[local]
2014-11-05 01:09:36 UTC [63278]: [2-1] user=sekondquad,db=dbt3,client=[local] LOG:  connection authorized: user=sekondquad database=dbt3
2014-11-05 01:09:36 UTC [63282]: [1-1] user=[unknown],db=[unknown],client= LOG:  connection received: host=[local]
2014-11-05 01:09:36 UTC [63279]: [2-1] user=sekondquad,db=dbt3,client=[local] LOG:  connection authorized: user=sekondquad database=dbt3
2014-11-05 01:09:36 UTC [63281]: [1-1] user=[unknown],db=[unknown],client= LOG:  connection received: host=[local]
2014-11-05 01:09:36 UTC [63280]: [2-1] user=sekondquad,db=dbt3,client=[local] LOG:  connection authorized: user=sekondquad database=dbt3
2014-11-05 01:09:36 UTC [63282]: [2-1] user=sekondquad,db=dbt3,client=[local] LOG:  connection authorized: user=sekondquad database=dbt3
2014-11-05 01:09:36 UTC [63281]: [2-1] user=sekondquad,db=dbt3,client=[local] LOG:  connection authorized: user=sekondquad database=dbt3
2014-11-05 01:09:36 UTC [63278]: [3-1] user=sekondquad,db=dbt3,client=[local] LOG:  statement: COPY (SELECT EXTRACT(EPOCH FROM TRANSACTION_TIMESTAMP()) AS ctime, relname, pid, mode, granted FROM pg_locks, pg_class WHERE relfilenode = relation ORDER BY relname) TO STDOUT (FORMAT CSV);
2014-11-05 01:09:36 UTC [63282]: [3-1] user=sekondquad,db=dbt3,client=[local] LOG:  statement: COPY (SELECT EXTRACT(EPOCH FROM TRANSACTION_TIMESTAMP()) AS ctime, a.schemaname, a.relname, seq_scan, seq_tup_read, idx_scan, idx_tup_fetch, n_tup_ins, n_tup_upd, n_tup_del, n_tup_hot_upd, n_live_tup, n_dead_tup, heap_blks_read, heap_blks_hit, idx_blks_read, idx_blks_hit, toast_blks_read, toast_blks_hit, tidx_blks_read, tidx_blks_hit FROM pg_statio_all_tables a, pg_stat_all_tables b WHERE a.relid = b.relid) TO STDOUT (FORMAT CSV);
2014-11-05 01:09:36 UTC [63279]: [3-1] user=sekondquad,db=dbt3,client=[local] LOG:  statement: COPY (SELECT EXTRACT(EPOCH FROM TRANSACTION_TIMESTAMP()) AS ctime, a.schemaname, a.relname, a.indexrelname, idx_scan, idx_tup_read, idx_tup_fetch, idx_blks_read, idx_blks_hit FROM pg_stat_all_indexes a, pg_statio_all_indexes b WHERE a.indexrelid = b.indexrelid) TO STDOUT (FORMAT CSV);
2014-11-05 01:09:36 UTC [63280]: [3-1] user=sekondquad,db=dbt3,client=[local] LOG:  statement: COPY (SELECT EXTRACT(EPOCH FROM TRANSACTION_TIMESTAMP()) AS ctime, datname, numbackends, xact_commit, xact_rollback, blks_read, blks_hit, tup_returned, tup_fetched, tup_inserted, tup_updated, tup_deleted FROM pg_stat_database) TO STDOUT (FORMAT CSV);
2014-11-05 01:09:36 UTC [63281]: [3-1] user=sekondquad,db=dbt3,client=[local] LOG:  statement: COPY (SELECT EXTRACT(EPOCH FROM TRANSACTION_TIMESTAMP()) AS ctime, datname, pid, usesysid, usename, application_name, client_addr, client_port, backend_start, xact_start, query_start, waiting, query , state, state_change FROM pg_stat_activity) TO STDOUT (FORMAT CSV);
2014-11-05 01:09:36 UTC [63281]: [4-1] user=sekondquad,db=dbt3,client=[local] LOG:  duration: 2.469 ms
2014-11-05 01:09:36 UTC [63281]: [5-1] user=sekondquad,db=dbt3,client=[local] LOG:  disconnection: session time: 0:00:00.005 user=sekondquad database=dbt3 host=[local]
2014-11-05 01:09:36 UTC [63278]: [4-1] user=sekondquad,db=dbt3,client=[local] LOG:  duration: 6.237 ms
2014-11-05 01:09:36 UTC [63278]: [5-1] user=sekondquad,db=dbt3,client=[local] LOG:  disconnection: session time: 0:00:00.010 user=sekondquad database=dbt3 host=[local]
2014-11-05 01:09:36 UTC [63280]: [4-1] user=sekondquad,db=dbt3,client=[local] LOG:  duration: 12.794 ms
2014-11-05 01:09:36 UTC [63280]: [5-1] user=sekondquad,db=dbt3,client=[local] LOG:  disconnection: session time: 0:00:00.016 user=sekondquad database=dbt3 host=[local]
2014-11-05 01:09:36 UTC [63282]: [4-1] user=sekondquad,db=dbt3,client=[local] LOG:  duration: 13.891 ms
2014-11-05 01:09:36 UTC [63282]: [5-1] user=sekondquad,db=dbt3,client=[local] LOG:  disconnection: session time: 0:00:00.016 user=sekondquad database=dbt3 host=[local]
2014-11-05 01:09:36 UTC [63279]: [4-1] user=sekondquad,db=dbt3,client=[local] LOG:  duration: 15.074 ms
2014-11-05 01:09:36 UTC [63279]: [5-1] user=sekondquad,db=dbt3,client=[local] LOG:  disconnection: session time: 0:00:00.018 user=sekondquad database=dbt3 host=[local]
2014-11-05 01:10:30 UTC [63263]: [6-1] user=sekondquad,db=dbt3,client=[local] LOG:  duration: 81803.120 ms
2014-11-05 01:10:30 UTC [63263]: [7-1] user=sekondquad,db=dbt3,client=[local] LOG:  statement: COMMIT;
2014-11-05 01:10:30 UTC [63263]: [8-1] user=sekondquad,db=dbt3,client=[local] LOG:  duration: 0.164 ms
2014-11-05 01:10:30 UTC [63263]: [9-1] user=sekondquad,db=dbt3,client=[local] LOG:  disconnection: session time: 0:01:21.807 user=sekondquad database=dbt3 host=[local]
2014-11-05 01:10:30 UTC [63302]: [1-1] user=[unknown],db=[unknown],client= LOG:  connection received: host=[local]
2014-11-05 01:10:30 UTC [63302]: [2-1] user=sekondquad,db=dbt3,client=[local] LOG:  connection authorized: user=sekondquad database=dbt3
2014-11-05 01:10:30 UTC [63302]: [3-1] user=sekondquad,db=dbt3,client=[local] LOG:  statement: UPDATE time_statistics
	SET e_time = current_timestamp
	WHERE task_name = 'PERF.POWER.Q9';
2014-11-05 01:10:30 UTC [63302]: [4-1] user=sekondquad,db=dbt3,client=[local] LOG:  duration: 5.372 ms
2014-11-05 01:10:30 UTC [63302]: [5-1] user=sekondquad,db=dbt3,client=[local] LOG:  disconnection: session time: 0:00:00.010 user=sekondquad database=dbt3 host=[local]
2014-11-05 01:10:30 UTC [63308]: [1-1] user=[unknown],db=[unknown],client= LOG:  connection received: host=[local]
2014-11-05 01:10:30 UTC [63308]: [2-1] user=sekondquad,db=dbt3,client=[local] LOG:  connection authorized: user=sekondquad database=dbt3
2014-11-05 01:10:30 UTC [63308]: [3-1] user=sekondquad,db=dbt3,client=[local] LOG:  statement: INSERT INTO time_statistics (task_name, s_time)
	VALUES ('PERF.POWER.Q20', CURRENT_TIMESTAMP);
2014-11-05 01:10:30 UTC [63308]: [4-1] user=sekondquad,db=dbt3,client=[local] LOG:  duration: 2.395 ms
2014-11-05 01:10:30 UTC [63308]: [5-1] user=sekondquad,db=dbt3,client=[local] LOG:  disconnection: session time: 0:00:00.006 user=sekondquad database=dbt3 host=[local]
2014-11-05 01:10:30 UTC [63310]: [1-1] user=[unknown],db=[unknown],client= LOG:  connection received: host=[local]
2014-11-05 01:10:30 UTC [63310]: [2-1] user=sekondquad,db=dbt3,client=[local] LOG:  connection authorized: user=sekondquad database=dbt3
2014-11-05 01:10:30 UTC [63310]: [3-1] user=sekondquad,db=dbt3,client=[local] LOG:  statement: BEGIN;
2014-11-05 01:10:30 UTC [63310]: [4-1] user=sekondquad,db=dbt3,client=[local] LOG:  duration: 0.202 ms
2014-11-05 01:10:30 UTC [63310]: [5-1] user=sekondquad,db=dbt3,client=[local] LOG:  statement: EXPLAIN (ANALYZE, BUFFERS)
	select
		s_name,
		s_address
	from
		supplier,
		nation
	where
		s_suppkey in (
			select
				distinct (ps_suppkey)
			from
				partsupp,
				part
			where
				ps_partkey=p_partkey
				and p_name like 'salmon%'
				and ps_availqty > (
					select
						0.5 * sum(l_quantity)
					from
						lineitem
					where
						l_partkey = ps_partkey
						and l_suppkey = ps_suppkey
						and l_shipdate >= '1996-01-01'
						and l_shipdate < cast(date '1996-01-01' + interval '1 year' as date)
				)
		)
		and s_nationkey = n_nationkey
		and n_name = 'INDONESIA'
	order by
		s_name;
2014-11-05 01:10:36 UTC [63318]: [1-1] user=[unknown],db=[unknown],client= LOG:  connection received: host=[local]
2014-11-05 01:10:36 UTC [63319]: [1-1] user=[unknown],db=[unknown],client= LOG:  connection received: host=[local]
2014-11-05 01:10:36 UTC [63318]: [2-1] user=sekondquad,db=dbt3,client=[local] LOG:  connection authorized: user=sekondquad database=dbt3
2014-11-05 01:10:36 UTC [63321]: [1-1] user=[unknown],db=[unknown],client= LOG:  connection received: host=[local]
2014-11-05 01:10:36 UTC [63320]: [1-1] user=[unknown],db=[unknown],client= LOG:  connection received: host=[local]
2014-11-05 01:10:36 UTC [63322]: [1-1] user=[unknown],db=[unknown],client= LOG:  connection received: host=[local]
2014-11-05 01:10:36 UTC [63319]: [2-1] user=sekondquad,db=dbt3,client=[local] LOG:  connection authorized: user=sekondquad database=dbt3
2014-11-05 01:10:36 UTC [63320]: [2-1] user=sekondquad,db=dbt3,client=[local] LOG:  connection authorized: user=sekondquad database=dbt3
2014-11-05 01:10:36 UTC [63321]: [2-1] user=sekondquad,db=dbt3,client=[local] LOG:  connection authorized: user=sekondquad database=dbt3
2014-11-05 01:10:36 UTC [63322]: [2-1] user=sekondquad,db=dbt3,client=[local] LOG:  connection authorized: user=sekondquad database=dbt3
2014-11-05 01:10:36 UTC [63318]: [3-1] user=sekondquad,db=dbt3,client=[local] LOG:  statement: COPY (SELECT EXTRACT(EPOCH FROM TRANSACTION_TIMESTAMP()) AS ctime, a.schemaname, a.relname, seq_scan, seq_tup_read, idx_scan, idx_tup_fetch, n_tup_ins, n_tup_upd, n_tup_del, n_tup_hot_upd, n_live_tup, n_dead_tup, heap_blks_read, heap_blks_hit, idx_blks_read, idx_blks_hit, toast_blks_read, toast_blks_hit, tidx_blks_read, tidx_blks_hit FROM pg_statio_all_tables a, pg_stat_all_tables b WHERE a.relid = b.relid) TO STDOUT (FORMAT CSV);
2014-11-05 01:10:36 UTC [63319]: [3-1] user=sekondquad,db=dbt3,client=[local] LOG:  statement: COPY (SELECT EXTRACT(EPOCH FROM TRANSACTION_TIMESTAMP()) AS ctime, relname, pid, mode, granted FROM pg_locks, pg_class WHERE relfilenode = relation ORDER BY relname) TO STDOUT (FORMAT CSV);
2014-11-05 01:10:36 UTC [63320]: [3-1] user=sekondquad,db=dbt3,client=[local] LOG:  statement: COPY (SELECT EXTRACT(EPOCH FROM TRANSACTION_TIMESTAMP()) AS ctime, a.schemaname, a.relname, a.indexrelname, idx_scan, idx_tup_read, idx_tup_fetch, idx_blks_read, idx_blks_hit FROM pg_stat_all_indexes a, pg_statio_all_indexes b WHERE a.indexrelid = b.indexrelid) TO STDOUT (FORMAT CSV);
2014-11-05 01:10:36 UTC [63321]: [3-1] user=sekondquad,db=dbt3,client=[local] LOG:  statement: COPY (SELECT EXTRACT(EPOCH FROM TRANSACTION_TIMESTAMP()) AS ctime, datname, pid, usesysid, usename, application_name, client_addr, client_port, backend_start, xact_start, query_start, waiting, query , state, state_change FROM pg_stat_activity) TO STDOUT (FORMAT CSV);
2014-11-05 01:10:36 UTC [63322]: [3-1] user=sekondquad,db=dbt3,client=[local] LOG:  statement: COPY (SELECT EXTRACT(EPOCH FROM TRANSACTION_TIMESTAMP()) AS ctime, datname, numbackends, xact_commit, xact_rollback, blks_read, blks_hit, tup_returned, tup_fetched, tup_inserted, tup_updated, tup_deleted FROM pg_stat_database) TO STDOUT (FORMAT CSV);
2014-11-05 01:10:36 UTC [63321]: [4-1] user=sekondquad,db=dbt3,client=[local] LOG:  duration: 4.952 ms
2014-11-05 01:10:36 UTC [63319]: [4-1] user=sekondquad,db=dbt3,client=[local] LOG:  duration: 6.620 ms
2014-11-05 01:10:36 UTC [63321]: [5-1] user=sekondquad,db=dbt3,client=[local] LOG:  disconnection: session time: 0:00:00.009 user=sekondquad database=dbt3 host=[local]
2014-11-05 01:10:36 UTC [63319]: [5-1] user=sekondquad,db=dbt3,client=[local] LOG:  disconnection: session time: 0:00:00.010 user=sekondquad database=dbt3 host=[local]
2014-11-05 01:10:36 UTC [63318]: [4-1] user=sekondquad,db=dbt3,client=[local] LOG:  duration: 12.746 ms
2014-11-05 01:10:36 UTC [63318]: [5-1] user=sekondquad,db=dbt3,client=[local] LOG:  disconnection: session time: 0:00:00.016 user=sekondquad database=dbt3 host=[local]
2014-11-05 01:10:36 UTC [63320]: [4-1] user=sekondquad,db=dbt3,client=[local] LOG:  duration: 12.295 ms
2014-11-05 01:10:36 UTC [63320]: [5-1] user=sekondquad,db=dbt3,client=[local] LOG:  disconnection: session time: 0:00:00.016 user=sekondquad database=dbt3 host=[local]
2014-11-05 01:10:36 UTC [63322]: [4-1] user=sekondquad,db=dbt3,client=[local] LOG:  duration: 14.056 ms
2014-11-05 01:10:36 UTC [63322]: [5-1] user=sekondquad,db=dbt3,client=[local] LOG:  disconnection: session time: 0:00:00.018 user=sekondquad database=dbt3 host=[local]
2014-11-05 01:10:39 UTC [63310]: [6-1] user=sekondquad,db=dbt3,client=[local] LOG:  duration: 8378.612 ms
2014-11-05 01:10:39 UTC [63310]: [7-1] user=sekondquad,db=dbt3,client=[local] LOG:  statement: COMMIT;
2014-11-05 01:10:39 UTC [63310]: [8-1] user=sekondquad,db=dbt3,client=[local] LOG:  duration: 0.125 ms
2014-11-05 01:10:39 UTC [63310]: [9-1] user=sekondquad,db=dbt3,client=[local] LOG:  disconnection: session time: 0:00:08.384 user=sekondquad database=dbt3 host=[local]
2014-11-05 01:10:39 UTC [63324]: [1-1] user=[unknown],db=[unknown],client= LOG:  connection received: host=[local]
2014-11-05 01:10:39 UTC [63324]: [2-1] user=sekondquad,db=dbt3,client=[local] LOG:  connection authorized: user=sekondquad database=dbt3
2014-11-05 01:10:39 UTC [63324]: [3-1] user=sekondquad,db=dbt3,client=[local] LOG:  statement: UPDATE time_statistics
	SET e_time = current_timestamp
	WHERE task_name = 'PERF.POWER.Q20';
2014-11-05 01:10:39 UTC [63324]: [4-1] user=sekondquad,db=dbt3,client=[local] LOG:  duration: 3.542 ms
2014-11-05 01:10:39 UTC [63324]: [5-1] user=sekondquad,db=dbt3,client=[local] LOG:  disconnection: session time: 0:00:00.007 user=sekondquad database=dbt3 host=[local]
2014-11-05 01:10:39 UTC [63330]: [1-1] user=[unknown],db=[unknown],client= LOG:  connection received: host=[local]
2014-11-05 01:10:39 UTC [63330]: [2-1] user=sekondquad,db=dbt3,client=[local] LOG:  connection authorized: user=sekondquad database=dbt3
2014-11-05 01:10:39 UTC [63330]: [3-1] user=sekondquad,db=dbt3,client=[local] LOG:  statement: INSERT INTO time_statistics (task_name, s_time)
	VALUES ('PERF.POWER.Q6', CURRENT_TIMESTAMP);
2014-11-05 01:10:39 UTC [63330]: [4-1] user=sekondquad,db=dbt3,client=[local] LOG:  duration: 1.577 ms
2014-11-05 01:10:39 UTC [63330]: [5-1] user=sekondquad,db=dbt3,client=[local] LOG:  disconnection: session time: 0:00:00.005 user=sekondquad database=dbt3 host=[local]
2014-11-05 01:10:39 UTC [63332]: [1-1] user=[unknown],db=[unknown],client= LOG:  connection received: host=[local]
2014-11-05 01:10:39 UTC [63332]: [2-1] user=sekondquad,db=dbt3,client=[local] LOG:  connection authorized: user=sekondquad database=dbt3
2014-11-05 01:10:39 UTC [63332]: [3-1] user=sekondquad,db=dbt3,client=[local] LOG:  statement: BEGIN;
2014-11-05 01:10:39 UTC [63332]: [4-1] user=sekondquad,db=dbt3,client=[local] LOG:  duration: 0.167 ms
2014-11-05 01:10:39 UTC [63332]: [5-1] user=sekondquad,db=dbt3,client=[local] LOG:  statement: EXPLAIN (ANALYZE, BUFFERS)
	select
		sum(l_extendedprice * l_discount) as revenue
	from
		lineitem
	where
		l_shipdate >= date '1995-01-01'
		and l_shipdate < cast(date '1995-01-01' + interval '1 year' as date)
		and l_discount between 0.05 - 0.01 and 0.05 + 0.01
		and l_quantity < 24;
2014-11-05 01:10:52 UTC [63332]: [6-1] user=sekondquad,db=dbt3,client=[local] LOG:  duration: 13531.208 ms
2014-11-05 01:10:52 UTC [63332]: [7-1] user=sekondquad,db=dbt3,client=[local] LOG:  statement: COMMIT;
2014-11-05 01:10:52 UTC [63332]: [8-1] user=sekondquad,db=dbt3,client=[local] LOG:  duration: 0.130 ms
2014-11-05 01:10:52 UTC [63332]: [9-1] user=sekondquad,db=dbt3,client=[local] LOG:  disconnection: session time: 0:00:13.535 user=sekondquad database=dbt3 host=[local]
2014-11-05 01:10:52 UTC [63339]: [1-1] user=[unknown],db=[unknown],client= LOG:  connection received: host=[local]
2014-11-05 01:10:52 UTC [63339]: [2-1] user=sekondquad,db=dbt3,client=[local] LOG:  connection authorized: user=sekondquad database=dbt3
2014-11-05 01:10:52 UTC [63339]: [3-1] user=sekondquad,db=dbt3,client=[local] LOG:  statement: UPDATE time_statistics
	SET e_time = current_timestamp
	WHERE task_name = 'PERF.POWER.Q6';
2014-11-05 01:10:52 UTC [63339]: [4-1] user=sekondquad,db=dbt3,client=[local] LOG:  duration: 3.797 ms
2014-11-05 01:10:52 UTC [63339]: [5-1] user=sekondquad,db=dbt3,client=[local] LOG:  disconnection: session time: 0:00:00.008 user=sekondquad database=dbt3 host=[local]
2014-11-05 01:10:52 UTC [63345]: [1-1] user=[unknown],db=[unknown],client= LOG:  connection received: host=[local]
2014-11-05 01:10:52 UTC [63345]: [2-1] user=sekondquad,db=dbt3,client=[local] LOG:  connection authorized: user=sekondquad database=dbt3
2014-11-05 01:10:52 UTC [63345]: [3-1] user=sekondquad,db=dbt3,client=[local] LOG:  statement: INSERT INTO time_statistics (task_name, s_time)
	VALUES ('PERF.POWER.Q17', CURRENT_TIMESTAMP);
2014-11-05 01:10:52 UTC [63345]: [4-1] user=sekondquad,db=dbt3,client=[local] LOG:  duration: 1.583 ms
2014-11-05 01:10:52 UTC [63345]: [5-1] user=sekondquad,db=dbt3,client=[local] LOG:  disconnection: session time: 0:00:00.004 user=sekondquad database=dbt3 host=[local]
2014-11-05 01:10:52 UTC [63347]: [1-1] user=[unknown],db=[unknown],client= LOG:  connection received: host=[local]
2014-11-05 01:10:52 UTC [63347]: [2-1] user=sekondquad,db=dbt3,client=[local] LOG:  connection authorized: user=sekondquad database=dbt3
2014-11-05 01:10:52 UTC [63347]: [3-1] user=sekondquad,db=dbt3,client=[local] LOG:  statement: BEGIN;
2014-11-05 01:10:52 UTC [63347]: [4-1] user=sekondquad,db=dbt3,client=[local] LOG:  duration: 0.171 ms
2014-11-05 01:10:52 UTC [63347]: [5-1] user=sekondquad,db=dbt3,client=[local] LOG:  statement: EXPLAIN (ANALYZE, BUFFERS)
	select
		sum(l_extendedprice) / 7.0 as avg_yearly
	from
		lineitem,
		part
	where
		p_partkey = l_partkey
		and p_brand = 'Brand#55'
		and p_container = 'MED DRUM'
		and l_quantity < (
			select
				0.2 * avg(l_quantity)
			from
				lineitem
			where
				l_partkey = p_partkey
		);
2014-11-05 01:10:53 UTC [63347]: [6-1] user=sekondquad,db=dbt3,client=[local] LOG:  duration: 477.134 ms
2014-11-05 01:10:53 UTC [63347]: [7-1] user=sekondquad,db=dbt3,client=[local] LOG:  statement: COMMIT;
2014-11-05 01:10:53 UTC [63347]: [8-1] user=sekondquad,db=dbt3,client=[local] LOG:  duration: 0.101 ms
2014-11-05 01:10:53 UTC [63347]: [9-1] user=sekondquad,db=dbt3,client=[local] LOG:  disconnection: session time: 0:00:00.481 user=sekondquad database=dbt3 host=[local]
2014-11-05 01:10:53 UTC [63349]: [1-1] user=[unknown],db=[unknown],client= LOG:  connection received: host=[local]
2014-11-05 01:10:53 UTC [63349]: [2-1] user=sekondquad,db=dbt3,client=[local] LOG:  connection authorized: user=sekondquad database=dbt3
2014-11-05 01:10:53 UTC [63349]: [3-1] user=sekondquad,db=dbt3,client=[local] LOG:  statement: UPDATE time_statistics
	SET e_time = current_timestamp
	WHERE task_name = 'PERF.POWER.Q17';
2014-11-05 01:10:53 UTC [63349]: [4-1] user=sekondquad,db=dbt3,client=[local] LOG:  duration: 3.776 ms
2014-11-05 01:10:53 UTC [63349]: [5-1] user=sekondquad,db=dbt3,client=[local] LOG:  disconnection: session time: 0:00:00.008 user=sekondquad database=dbt3 host=[local]
2014-11-05 01:10:53 UTC [63355]: [1-1] user=[unknown],db=[unknown],client= LOG:  connection received: host=[local]
2014-11-05 01:10:53 UTC [63355]: [2-1] user=sekondquad,db=dbt3,client=[local] LOG:  connection authorized: user=sekondquad database=dbt3
2014-11-05 01:10:53 UTC [63355]: [3-1] user=sekondquad,db=dbt3,client=[local] LOG:  statement: INSERT INTO time_statistics (task_name, s_time)
	VALUES ('PERF.POWER.Q18', CURRENT_TIMESTAMP);
2014-11-05 01:10:53 UTC [63355]: [4-1] user=sekondquad,db=dbt3,client=[local] LOG:  duration: 2.502 ms
2014-11-05 01:10:53 UTC [63355]: [5-1] user=sekondquad,db=dbt3,client=[local] LOG:  disconnection: session time: 0:00:00.006 user=sekondquad database=dbt3 host=[local]
2014-11-05 01:10:53 UTC [63357]: [1-1] user=[unknown],db=[unknown],client= LOG:  connection received: host=[local]
2014-11-05 01:10:53 UTC [63357]: [2-1] user=sekondquad,db=dbt3,client=[local] LOG:  connection authorized: user=sekondquad database=dbt3
2014-11-05 01:10:53 UTC [63357]: [3-1] user=sekondquad,db=dbt3,client=[local] LOG:  statement: BEGIN;
2014-11-05 01:10:53 UTC [63357]: [4-1] user=sekondquad,db=dbt3,client=[local] LOG:  duration: 0.190 ms
2014-11-05 01:10:53 UTC [63357]: [5-1] user=sekondquad,db=dbt3,client=[local] LOG:  statement: EXPLAIN (ANALYZE, BUFFERS)
	select
		c_name,
		c_custkey,
		o_orderkey,
		o_orderdate,
		o_totalprice,
		sum(l_quantity)
	from
		customer,
		orders,
		lineitem
	where
		o_orderkey in (
			select
				l_orderkey
			from
				lineitem
			group by
				l_orderkey having
					sum(l_quantity) > 315
		)
		and c_custkey = o_custkey
		and o_orderkey = l_orderkey
	group by
		c_name,
		c_custkey,
		o_orderkey,
		o_orderdate,
		o_totalprice
	order by
		o_totalprice desc,
		o_orderdate
	LIMIT 100;
2014-11-05 01:11:36 UTC [63376]: [1-1] user=[unknown],db=[unknown],client= LOG:  connection received: host=[local]
2014-11-05 01:11:36 UTC [63376]: [2-1] user=sekondquad,db=dbt3,client=[local] LOG:  connection authorized: user=sekondquad database=dbt3
2014-11-05 01:11:36 UTC [63379]: [1-1] user=[unknown],db=[unknown],client= LOG:  connection received: host=[local]
2014-11-05 01:11:36 UTC [63377]: [1-1] user=[unknown],db=[unknown],client= LOG:  connection received: host=[local]
2014-11-05 01:11:36 UTC [63380]: [1-1] user=[unknown],db=[unknown],client= LOG:  connection received: host=[local]
2014-11-05 01:11:36 UTC [63378]: [1-1] user=[unknown],db=[unknown],client= LOG:  connection received: host=[local]
2014-11-05 01:11:36 UTC [63380]: [2-1] user=sekondquad,db=dbt3,client=[local] LOG:  connection authorized: user=sekondquad database=dbt3
2014-11-05 01:11:36 UTC [63377]: [2-1] user=sekondquad,db=dbt3,client=[local] LOG:  connection authorized: user=sekondquad database=dbt3
2014-11-05 01:11:36 UTC [63378]: [2-1] user=sekondquad,db=dbt3,client=[local] LOG:  connection authorized: user=sekondquad database=dbt3
2014-11-05 01:11:36 UTC [63376]: [3-1] user=sekondquad,db=dbt3,client=[local] LOG:  statement: COPY (SELECT EXTRACT(EPOCH FROM TRANSACTION_TIMESTAMP()) AS ctime, a.schemaname, a.relname, seq_scan, seq_tup_read, idx_scan, idx_tup_fetch, n_tup_ins, n_tup_upd, n_tup_del, n_tup_hot_upd, n_live_tup, n_dead_tup, heap_blks_read, heap_blks_hit, idx_blks_read, idx_blks_hit, toast_blks_read, toast_blks_hit, tidx_blks_read, tidx_blks_hit FROM pg_statio_all_tables a, pg_stat_all_tables b WHERE a.relid = b.relid) TO STDOUT (FORMAT CSV);
2014-11-05 01:11:36 UTC [63379]: [2-1] user=sekondquad,db=dbt3,client=[local] LOG:  connection authorized: user=sekondquad database=dbt3
2014-11-05 01:11:36 UTC [63380]: [3-1] user=sekondquad,db=dbt3,client=[local] LOG:  statement: COPY (SELECT EXTRACT(EPOCH FROM TRANSACTION_TIMESTAMP()) AS ctime, datname, pid, usesysid, usename, application_name, client_addr, client_port, backend_start, xact_start, query_start, waiting, query , state, state_change FROM pg_stat_activity) TO STDOUT (FORMAT CSV);
2014-11-05 01:11:36 UTC [63378]: [3-1] user=sekondquad,db=dbt3,client=[local] LOG:  statement: COPY (SELECT EXTRACT(EPOCH FROM TRANSACTION_TIMESTAMP()) AS ctime, datname, numbackends, xact_commit, xact_rollback, blks_read, blks_hit, tup_returned, tup_fetched, tup_inserted, tup_updated, tup_deleted FROM pg_stat_database) TO STDOUT (FORMAT CSV);
2014-11-05 01:11:36 UTC [63377]: [3-1] user=sekondquad,db=dbt3,client=[local] LOG:  statement: COPY (SELECT EXTRACT(EPOCH FROM TRANSACTION_TIMESTAMP()) AS ctime, a.schemaname, a.relname, a.indexrelname, idx_scan, idx_tup_read, idx_tup_fetch, idx_blks_read, idx_blks_hit FROM pg_stat_all_indexes a, pg_statio_all_indexes b WHERE a.indexrelid = b.indexrelid) TO STDOUT (FORMAT CSV);
2014-11-05 01:11:36 UTC [63379]: [3-1] user=sekondquad,db=dbt3,client=[local] LOG:  statement: COPY (SELECT EXTRACT(EPOCH FROM TRANSACTION_TIMESTAMP()) AS ctime, relname, pid, mode, granted FROM pg_locks, pg_class WHERE relfilenode = relation ORDER BY relname) TO STDOUT (FORMAT CSV);
2014-11-05 01:11:36 UTC [63380]: [4-1] user=sekondquad,db=dbt3,client=[local] LOG:  duration: 5.663 ms
2014-11-05 01:11:36 UTC [63379]: [4-1] user=sekondquad,db=dbt3,client=[local] LOG:  duration: 4.486 ms
2014-11-05 01:11:36 UTC [63380]: [5-1] user=sekondquad,db=dbt3,client=[local] LOG:  disconnection: session time: 0:00:00.009 user=sekondquad database=dbt3 host=[local]
2014-11-05 01:11:36 UTC [63379]: [5-1] user=sekondquad,db=dbt3,client=[local] LOG:  disconnection: session time: 0:00:00.010 user=sekondquad database=dbt3 host=[local]
2014-11-05 01:11:36 UTC [63376]: [4-1] user=sekondquad,db=dbt3,client=[local] LOG:  duration: 15.628 ms
2014-11-05 01:11:36 UTC [63376]: [5-1] user=sekondquad,db=dbt3,client=[local] LOG:  disconnection: session time: 0:00:00.019 user=sekondquad database=dbt3 host=[local]
2014-11-05 01:11:36 UTC [63378]: [4-1] user=sekondquad,db=dbt3,client=[local] LOG:  duration: 14.440 ms
2014-11-05 01:11:36 UTC [63378]: [5-1] user=sekondquad,db=dbt3,client=[local] LOG:  disconnection: session time: 0:00:00.017 user=sekondquad database=dbt3 host=[local]
2014-11-05 01:11:36 UTC [63377]: [4-1] user=sekondquad,db=dbt3,client=[local] LOG:  duration: 16.212 ms
2014-11-05 01:11:36 UTC [63377]: [5-1] user=sekondquad,db=dbt3,client=[local] LOG:  disconnection: session time: 0:00:00.020 user=sekondquad database=dbt3 host=[local]
2014-11-05 01:12:17 UTC [63357]: [6-1] user=sekondquad,db=dbt3,client=[local] LOG:  duration: 83856.495 ms
2014-11-05 01:12:17 UTC [63357]: [7-1] user=sekondquad,db=dbt3,client=[local] LOG:  statement: COMMIT;
2014-11-05 01:12:17 UTC [63357]: [8-1] user=sekondquad,db=dbt3,client=[local] LOG:  duration: 0.139 ms
2014-11-05 01:12:17 UTC [63357]: [9-1] user=sekondquad,db=dbt3,client=[local] LOG:  disconnection: session time: 0:01:23.862 user=sekondquad database=dbt3 host=[local]
2014-11-05 01:12:17 UTC [63392]: [1-1] user=[unknown],db=[unknown],client= LOG:  connection received: host=[local]
2014-11-05 01:12:17 UTC [63392]: [2-1] user=sekondquad,db=dbt3,client=[local] LOG:  connection authorized: user=sekondquad database=dbt3
2014-11-05 01:12:17 UTC [63392]: [3-1] user=sekondquad,db=dbt3,client=[local] LOG:  statement: UPDATE time_statistics
	SET e_time = current_timestamp
	WHERE task_name = 'PERF.POWER.Q18';
2014-11-05 01:12:17 UTC [63392]: [4-1] user=sekondquad,db=dbt3,client=[local] LOG:  duration: 4.313 ms
2014-11-05 01:12:17 UTC [63392]: [5-1] user=sekondquad,db=dbt3,client=[local] LOG:  disconnection: session time: 0:00:00.008 user=sekondquad database=dbt3 host=[local]
2014-11-05 01:12:17 UTC [63398]: [1-1] user=[unknown],db=[unknown],client= LOG:  connection received: host=[local]
2014-11-05 01:12:17 UTC [63398]: [2-1] user=sekondquad,db=dbt3,client=[local] LOG:  connection authorized: user=sekondquad database=dbt3
2014-11-05 01:12:17 UTC [63398]: [3-1] user=sekondquad,db=dbt3,client=[local] LOG:  statement: INSERT INTO time_statistics (task_name, s_time)
	VALUES ('PERF.POWER.Q8', CURRENT_TIMESTAMP);
2014-11-05 01:12:17 UTC [63398]: [4-1] user=sekondquad,db=dbt3,client=[local] LOG:  duration: 2.081 ms
2014-11-05 01:12:17 UTC [63398]: [5-1] user=sekondquad,db=dbt3,client=[local] LOG:  disconnection: session time: 0:00:00.006 user=sekondquad database=dbt3 host=[local]
2014-11-05 01:12:17 UTC [63400]: [1-1] user=[unknown],db=[unknown],client= LOG:  connection received: host=[local]
2014-11-05 01:12:17 UTC [63400]: [2-1] user=sekondquad,db=dbt3,client=[local] LOG:  connection authorized: user=sekondquad database=dbt3
2014-11-05 01:12:17 UTC [63400]: [3-1] user=sekondquad,db=dbt3,client=[local] LOG:  statement: BEGIN;
2014-11-05 01:12:17 UTC [63400]: [4-1] user=sekondquad,db=dbt3,client=[local] LOG:  duration: 0.176 ms
2014-11-05 01:12:17 UTC [63400]: [5-1] user=sekondquad,db=dbt3,client=[local] LOG:  statement: EXPLAIN (ANALYZE, BUFFERS)
	select
		o_year,
		sum(case
			when nation = 'EGYPT' then volume
			else 0
		end) / sum(volume) as mkt_share
	from
		(
			select
				extract(year from o_orderdate) as o_year,
				l_extendedprice * (1 - l_discount) as volume,
				n2.n_name as nation
			from
				part,
				supplier,
				lineitem,
				orders,
				customer,
				nation n1,
				nation n2,
				region
			where
				p_partkey = l_partkey
				and s_suppkey = l_suppkey
				and l_orderkey = o_orderkey
				and o_custkey = c_custkey
				and c_nationkey = n1.n_nationkey
				and n1.n_regionkey = r_regionkey
				and r_name = 'MIDDLE EAST'
				and s_nationkey = n2.n_nationkey
				and o_orderdate between date '1995-01-01' and date '1996-12-31'
				and p_type = 'ECONOMY ANODIZED NICKEL'
		) as all_nations
	group by
		o_year
	order by
		o_year;
2014-11-05 01:12:24 UTC [63400]: [6-1] user=sekondquad,db=dbt3,client=[local] LOG:  duration: 7623.251 ms
2014-11-05 01:12:24 UTC [63400]: [7-1] user=sekondquad,db=dbt3,client=[local] LOG:  statement: COMMIT;
2014-11-05 01:12:24 UTC [63400]: [8-1] user=sekondquad,db=dbt3,client=[local] LOG:  duration: 0.117 ms
2014-11-05 01:12:24 UTC [63400]: [9-1] user=sekondquad,db=dbt3,client=[local] LOG:  disconnection: session time: 0:00:07.629 user=sekondquad database=dbt3 host=[local]
2014-11-05 01:12:24 UTC [63405]: [1-1] user=[unknown],db=[unknown],client= LOG:  connection received: host=[local]
2014-11-05 01:12:24 UTC [63405]: [2-1] user=sekondquad,db=dbt3,client=[local] LOG:  connection authorized: user=sekondquad database=dbt3
2014-11-05 01:12:24 UTC [63405]: [3-1] user=sekondquad,db=dbt3,client=[local] LOG:  statement: UPDATE time_statistics
	SET e_time = current_timestamp
	WHERE task_name = 'PERF.POWER.Q8';
2014-11-05 01:12:24 UTC [63405]: [4-1] user=sekondquad,db=dbt3,client=[local] LOG:  duration: 3.577 ms
2014-11-05 01:12:24 UTC [63405]: [5-1] user=sekondquad,db=dbt3,client=[local] LOG:  disconnection: session time: 0:00:00.007 user=sekondquad database=dbt3 host=[local]
2014-11-05 01:12:24 UTC [63411]: [1-1] user=[unknown],db=[unknown],client= LOG:  connection received: host=[local]
2014-11-05 01:12:24 UTC [63411]: [2-1] user=sekondquad,db=dbt3,client=[local] LOG:  connection authorized: user=sekondquad database=dbt3
2014-11-05 01:12:24 UTC [63411]: [3-1] user=sekondquad,db=dbt3,client=[local] LOG:  statement: INSERT INTO time_statistics (task_name, s_time)
	VALUES ('PERF.POWER.Q21', CURRENT_TIMESTAMP);
2014-11-05 01:12:24 UTC [63411]: [4-1] user=sekondquad,db=dbt3,client=[local] LOG:  duration: 2.129 ms
2014-11-05 01:12:24 UTC [63411]: [5-1] user=sekondquad,db=dbt3,client=[local] LOG:  disconnection: session time: 0:00:00.006 user=sekondquad database=dbt3 host=[local]
2014-11-05 01:12:24 UTC [63413]: [1-1] user=[unknown],db=[unknown],client= LOG:  connection received: host=[local]
2014-11-05 01:12:24 UTC [63413]: [2-1] user=sekondquad,db=dbt3,client=[local] LOG:  connection authorized: user=sekondquad database=dbt3
2014-11-05 01:12:24 UTC [63413]: [3-1] user=sekondquad,db=dbt3,client=[local] LOG:  statement: BEGIN;
2014-11-05 01:12:24 UTC [63413]: [4-1] user=sekondquad,db=dbt3,client=[local] LOG:  duration: 0.190 ms
2014-11-05 01:12:24 UTC [63413]: [5-1] user=sekondquad,db=dbt3,client=[local] LOG:  statement: EXPLAIN (ANALYZE, BUFFERS)
	select
		s_name,
		count(*) as numwait
	from
		supplier,
		lineitem l1,
		orders,
		nation
	where
		s_suppkey = l1.l_suppkey
		and o_orderkey = l1.l_orderkey
		and o_orderstatus = 'F'
		and l1.l_receiptdate > l1.l_commitdate
		and exists (
			select
				*
			from
				lineitem l2
			where
				l2.l_orderkey = l1.l_orderkey
				and l2.l_suppkey <> l1.l_suppkey
		)
		and not exists (
			select
				*
			from
				lineitem l3
			where
				l3.l_orderkey = l1.l_orderkey
				and l3.l_suppkey <> l1.l_suppkey
				and l3.l_receiptdate > l3.l_commitdate
		)
		and s_nationkey = n_nationkey
		and n_name = 'CHINA'
	group by
		s_name
	order by
		numwait desc,
		s_name
	LIMIT 100;
2014-11-05 01:12:36 UTC [63423]: [1-1] user=[unknown],db=[unknown],client= LOG:  connection received: host=[local]
2014-11-05 01:12:36 UTC [63423]: [2-1] user=sekondquad,db=dbt3,client=[local] LOG:  connection authorized: user=sekondquad database=dbt3
2014-11-05 01:12:36 UTC [63425]: [1-1] user=[unknown],db=[unknown],client= LOG:  connection received: host=[local]
2014-11-05 01:12:36 UTC [63425]: [2-1] user=sekondquad,db=dbt3,client=[local] LOG:  connection authorized: user=sekondquad database=dbt3
2014-11-05 01:12:36 UTC [63424]: [1-1] user=[unknown],db=[unknown],client= LOG:  connection received: host=[local]
2014-11-05 01:12:36 UTC [63424]: [2-1] user=sekondquad,db=dbt3,client=[local] LOG:  connection authorized: user=sekondquad database=dbt3
2014-11-05 01:12:36 UTC [63423]: [3-1] user=sekondquad,db=dbt3,client=[local] LOG:  statement: COPY (SELECT EXTRACT(EPOCH FROM TRANSACTION_TIMESTAMP()) AS ctime, a.schemaname, a.relname, seq_scan, seq_tup_read, idx_scan, idx_tup_fetch, n_tup_ins, n_tup_upd, n_tup_del, n_tup_hot_upd, n_live_tup, n_dead_tup, heap_blks_read, heap_blks_hit, idx_blks_read, idx_blks_hit, toast_blks_read, toast_blks_hit, tidx_blks_read, tidx_blks_hit FROM pg_statio_all_tables a, pg_stat_all_tables b WHERE a.relid = b.relid) TO STDOUT (FORMAT CSV);
2014-11-05 01:12:36 UTC [63426]: [1-1] user=[unknown],db=[unknown],client= LOG:  connection received: host=[local]
2014-11-05 01:12:36 UTC [63425]: [3-1] user=sekondquad,db=dbt3,client=[local] LOG:  statement: COPY (SELECT EXTRACT(EPOCH FROM TRANSACTION_TIMESTAMP()) AS ctime, datname, pid, usesysid, usename, application_name, client_addr, client_port, backend_start, xact_start, query_start, waiting, query , state, state_change FROM pg_stat_activity) TO STDOUT (FORMAT CSV);
2014-11-05 01:12:36 UTC [63426]: [2-1] user=sekondquad,db=dbt3,client=[local] LOG:  connection authorized: user=sekondquad database=dbt3
2014-11-05 01:12:36 UTC [63424]: [3-1] user=sekondquad,db=dbt3,client=[local] LOG:  statement: COPY (SELECT EXTRACT(EPOCH FROM TRANSACTION_TIMESTAMP()) AS ctime, relname, pid, mode, granted FROM pg_locks, pg_class WHERE relfilenode = relation ORDER BY relname) TO STDOUT (FORMAT CSV);
2014-11-05 01:12:36 UTC [63427]: [1-1] user=[unknown],db=[unknown],client= LOG:  connection received: host=[local]
2014-11-05 01:12:36 UTC [63427]: [2-1] user=sekondquad,db=dbt3,client=[local] LOG:  connection authorized: user=sekondquad database=dbt3
2014-11-05 01:12:36 UTC [63426]: [3-1] user=sekondquad,db=dbt3,client=[local] LOG:  statement: COPY (SELECT EXTRACT(EPOCH FROM TRANSACTION_TIMESTAMP()) AS ctime, datname, numbackends, xact_commit, xact_rollback, blks_read, blks_hit, tup_returned, tup_fetched, tup_inserted, tup_updated, tup_deleted FROM pg_stat_database) TO STDOUT (FORMAT CSV);
2014-11-05 01:12:36 UTC [63427]: [3-1] user=sekondquad,db=dbt3,client=[local] LOG:  statement: COPY (SELECT EXTRACT(EPOCH FROM TRANSACTION_TIMESTAMP()) AS ctime, a.schemaname, a.relname, a.indexrelname, idx_scan, idx_tup_read, idx_tup_fetch, idx_blks_read, idx_blks_hit FROM pg_stat_all_indexes a, pg_statio_all_indexes b WHERE a.indexrelid = b.indexrelid) TO STDOUT (FORMAT CSV);
2014-11-05 01:12:36 UTC [63425]: [4-1] user=sekondquad,db=dbt3,client=[local] LOG:  duration: 3.415 ms
2014-11-05 01:12:36 UTC [63425]: [5-1] user=sekondquad,db=dbt3,client=[local] LOG:  disconnection: session time: 0:00:00.007 user=sekondquad database=dbt3 host=[local]
2014-11-05 01:12:36 UTC [63424]: [4-1] user=sekondquad,db=dbt3,client=[local] LOG:  duration: 3.067 ms
2014-11-05 01:12:36 UTC [63424]: [5-1] user=sekondquad,db=dbt3,client=[local] LOG:  disconnection: session time: 0:00:00.007 user=sekondquad database=dbt3 host=[local]
2014-11-05 01:12:36 UTC [63423]: [4-1] user=sekondquad,db=dbt3,client=[local] LOG:  duration: 9.194 ms
2014-11-05 01:12:36 UTC [63423]: [5-1] user=sekondquad,db=dbt3,client=[local] LOG:  disconnection: session time: 0:00:00.014 user=sekondquad database=dbt3 host=[local]
2014-11-05 01:12:36 UTC [63427]: [4-1] user=sekondquad,db=dbt3,client=[local] LOG:  duration: 9.040 ms
2014-11-05 01:12:36 UTC [63427]: [5-1] user=sekondquad,db=dbt3,client=[local] LOG:  disconnection: session time: 0:00:00.011 user=sekondquad database=dbt3 host=[local]
2014-11-05 01:12:36 UTC [63426]: [4-1] user=sekondquad,db=dbt3,client=[local] LOG:  duration: 12.085 ms
2014-11-05 01:12:36 UTC [63426]: [5-1] user=sekondquad,db=dbt3,client=[local] LOG:  disconnection: session time: 0:00:00.014 user=sekondquad database=dbt3 host=[local]
2014-11-05 01:13:04 UTC [63413]: [6-1] user=sekondquad,db=dbt3,client=[local] LOG:  duration: 39104.410 ms
2014-11-05 01:13:04 UTC [63413]: [7-1] user=sekondquad,db=dbt3,client=[local] LOG:  statement: COMMIT;
2014-11-05 01:13:04 UTC [63413]: [8-1] user=sekondquad,db=dbt3,client=[local] LOG:  duration: 0.120 ms
2014-11-05 01:13:04 UTC [63413]: [9-1] user=sekondquad,db=dbt3,client=[local] LOG:  disconnection: session time: 0:00:39.110 user=sekondquad database=dbt3 host=[local]
2014-11-05 01:13:04 UTC [63436]: [1-1] user=[unknown],db=[unknown],client= LOG:  connection received: host=[local]
2014-11-05 01:13:04 UTC [63436]: [2-1] user=sekondquad,db=dbt3,client=[local] LOG:  connection authorized: user=sekondquad database=dbt3
2014-11-05 01:13:04 UTC [63436]: [3-1] user=sekondquad,db=dbt3,client=[local] LOG:  statement: UPDATE time_statistics
	SET e_time = current_timestamp
	WHERE task_name = 'PERF.POWER.Q21';
2014-11-05 01:13:04 UTC [63436]: [4-1] user=sekondquad,db=dbt3,client=[local] LOG:  duration: 3.778 ms
2014-11-05 01:13:04 UTC [63436]: [5-1] user=sekondquad,db=dbt3,client=[local] LOG:  disconnection: session time: 0:00:00.008 user=sekondquad database=dbt3 host=[local]
2014-11-05 01:13:04 UTC [63442]: [1-1] user=[unknown],db=[unknown],client= LOG:  connection received: host=[local]
2014-11-05 01:13:04 UTC [63442]: [2-1] user=sekondquad,db=dbt3,client=[local] LOG:  connection authorized: user=sekondquad database=dbt3
2014-11-05 01:13:04 UTC [63442]: [3-1] user=sekondquad,db=dbt3,client=[local] LOG:  statement: INSERT INTO time_statistics (task_name, s_time)
	VALUES ('PERF.POWER.Q13', CURRENT_TIMESTAMP);
2014-11-05 01:13:04 UTC [63442]: [4-1] user=sekondquad,db=dbt3,client=[local] LOG:  duration: 2.147 ms
2014-11-05 01:13:04 UTC [63442]: [5-1] user=sekondquad,db=dbt3,client=[local] LOG:  disconnection: session time: 0:00:00.006 user=sekondquad database=dbt3 host=[local]
2014-11-05 01:13:04 UTC [63444]: [1-1] user=[unknown],db=[unknown],client= LOG:  connection received: host=[local]
2014-11-05 01:13:04 UTC [63444]: [2-1] user=sekondquad,db=dbt3,client=[local] LOG:  connection authorized: user=sekondquad database=dbt3
2014-11-05 01:13:04 UTC [63444]: [3-1] user=sekondquad,db=dbt3,client=[local] LOG:  statement: BEGIN;
2014-11-05 01:13:04 UTC [63444]: [4-1] user=sekondquad,db=dbt3,client=[local] LOG:  duration: 0.182 ms
2014-11-05 01:13:04 UTC [63444]: [5-1] user=sekondquad,db=dbt3,client=[local] LOG:  statement: EXPLAIN (ANALYZE, BUFFERS)
	select
		c_count,
		count(*) as custdist
	from
		(
			select
				c_custkey,
				count(o_orderkey)
			from
				customer left outer join orders on
					c_custkey = o_custkey
					and o_comment not like '%pending%packages%'
			group by
				c_custkey
		) as c_orders (c_custkey, c_count)
	group by
		c_count
	order by
		custdist desc,
		c_count desc;
2014-11-05 01:13:36 UTC [63461]: [1-1] user=[unknown],db=[unknown],client= LOG:  connection received: host=[local]
2014-11-05 01:13:36 UTC [63461]: [2-1] user=sekondquad,db=dbt3,client=[local] LOG:  connection authorized: user=sekondquad database=dbt3
2014-11-05 01:13:36 UTC [63460]: [1-1] user=[unknown],db=[unknown],client= LOG:  connection received: host=[local]
2014-11-05 01:13:36 UTC [63462]: [1-1] user=[unknown],db=[unknown],client= LOG:  connection received: host=[local]
2014-11-05 01:13:36 UTC [63463]: [1-1] user=[unknown],db=[unknown],client= LOG:  connection received: host=[local]
2014-11-05 01:13:36 UTC [63464]: [1-1] user=[unknown],db=[unknown],client= LOG:  connection received: host=[local]
2014-11-05 01:13:36 UTC [63460]: [2-1] user=sekondquad,db=dbt3,client=[local] LOG:  connection authorized: user=sekondquad database=dbt3
2014-11-05 01:13:36 UTC [63461]: [3-1] user=sekondquad,db=dbt3,client=[local] LOG:  statement: COPY (SELECT EXTRACT(EPOCH FROM TRANSACTION_TIMESTAMP()) AS ctime, datname, numbackends, xact_commit, xact_rollback, blks_read, blks_hit, tup_returned, tup_fetched, tup_inserted, tup_updated, tup_deleted FROM pg_stat_database) TO STDOUT (FORMAT CSV);
2014-11-05 01:13:36 UTC [63463]: [2-1] user=sekondquad,db=dbt3,client=[local] LOG:  connection authorized: user=sekondquad database=dbt3
2014-11-05 01:13:36 UTC [63464]: [2-1] user=sekondquad,db=dbt3,client=[local] LOG:  connection authorized: user=sekondquad database=dbt3
2014-11-05 01:13:36 UTC [63462]: [2-1] user=sekondquad,db=dbt3,client=[local] LOG:  connection authorized: user=sekondquad database=dbt3
2014-11-05 01:13:36 UTC [63463]: [3-1] user=sekondquad,db=dbt3,client=[local] LOG:  statement: COPY (SELECT EXTRACT(EPOCH FROM TRANSACTION_TIMESTAMP()) AS ctime, a.schemaname, a.relname, seq_scan, seq_tup_read, idx_scan, idx_tup_fetch, n_tup_ins, n_tup_upd, n_tup_del, n_tup_hot_upd, n_live_tup, n_dead_tup, heap_blks_read, heap_blks_hit, idx_blks_read, idx_blks_hit, toast_blks_read, toast_blks_hit, tidx_blks_read, tidx_blks_hit FROM pg_statio_all_tables a, pg_stat_all_tables b WHERE a.relid = b.relid) TO STDOUT (FORMAT CSV);
2014-11-05 01:13:36 UTC [63460]: [3-1] user=sekondquad,db=dbt3,client=[local] LOG:  statement: COPY (SELECT EXTRACT(EPOCH FROM TRANSACTION_TIMESTAMP()) AS ctime, relname, pid, mode, granted FROM pg_locks, pg_class WHERE relfilenode = relation ORDER BY relname) TO STDOUT (FORMAT CSV);
2014-11-05 01:13:36 UTC [63464]: [3-1] user=sekondquad,db=dbt3,client=[local] LOG:  statement: COPY (SELECT EXTRACT(EPOCH FROM TRANSACTION_TIMESTAMP()) AS ctime, a.schemaname, a.relname, a.indexrelname, idx_scan, idx_tup_read, idx_tup_fetch, idx_blks_read, idx_blks_hit FROM pg_stat_all_indexes a, pg_statio_all_indexes b WHERE a.indexrelid = b.indexrelid) TO STDOUT (FORMAT CSV);
2014-11-05 01:13:36 UTC [63462]: [3-1] user=sekondquad,db=dbt3,client=[local] LOG:  statement: COPY (SELECT EXTRACT(EPOCH FROM TRANSACTION_TIMESTAMP()) AS ctime, datname, pid, usesysid, usename, application_name, client_addr, client_port, backend_start, xact_start, query_start, waiting, query , state, state_change FROM pg_stat_activity) TO STDOUT (FORMAT CSV);
2014-11-05 01:13:36 UTC [63462]: [4-1] user=sekondquad,db=dbt3,client=[local] LOG:  duration: 4.783 ms
2014-11-05 01:13:36 UTC [63462]: [5-1] user=sekondquad,db=dbt3,client=[local] LOG:  disconnection: session time: 0:00:00.009 user=sekondquad database=dbt3 host=[local]
2014-11-05 01:13:36 UTC [63460]: [4-1] user=sekondquad,db=dbt3,client=[local] LOG:  duration: 5.579 ms
2014-11-05 01:13:36 UTC [63460]: [5-1] user=sekondquad,db=dbt3,client=[local] LOG:  disconnection: session time: 0:00:00.009 user=sekondquad database=dbt3 host=[local]
2014-11-05 01:13:36 UTC [63461]: [4-1] user=sekondquad,db=dbt3,client=[local] LOG:  duration: 14.447 ms
2014-11-05 01:13:36 UTC [63461]: [5-1] user=sekondquad,db=dbt3,client=[local] LOG:  disconnection: session time: 0:00:00.018 user=sekondquad database=dbt3 host=[local]
2014-11-05 01:13:36 UTC [63463]: [4-1] user=sekondquad,db=dbt3,client=[local] LOG:  duration: 14.883 ms
2014-11-05 01:13:36 UTC [63463]: [5-1] user=sekondquad,db=dbt3,client=[local] LOG:  disconnection: session time: 0:00:00.018 user=sekondquad database=dbt3 host=[local]
2014-11-05 01:13:36 UTC [63464]: [4-1] user=sekondquad,db=dbt3,client=[local] LOG:  duration: 15.554 ms
2014-11-05 01:13:36 UTC [63464]: [5-1] user=sekondquad,db=dbt3,client=[local] LOG:  disconnection: session time: 0:00:00.019 user=sekondquad database=dbt3 host=[local]
2014-11-05 01:13:38 UTC [63444]: [6-1] user=sekondquad,db=dbt3,client=[local] LOG:  duration: 34385.989 ms
2014-11-05 01:13:38 UTC [63444]: [7-1] user=sekondquad,db=dbt3,client=[local] LOG:  statement: COMMIT;
2014-11-05 01:13:38 UTC [63444]: [8-1] user=sekondquad,db=dbt3,client=[local] LOG:  duration: 0.108 ms
2014-11-05 01:13:38 UTC [63444]: [9-1] user=sekondquad,db=dbt3,client=[local] LOG:  disconnection: session time: 0:00:34.391 user=sekondquad database=dbt3 host=[local]
2014-11-05 01:13:38 UTC [63466]: [1-1] user=[unknown],db=[unknown],client= LOG:  connection received: host=[local]
2014-11-05 01:13:38 UTC [63466]: [2-1] user=sekondquad,db=dbt3,client=[local] LOG:  connection authorized: user=sekondquad database=dbt3
2014-11-05 01:13:38 UTC [63466]: [3-1] user=sekondquad,db=dbt3,client=[local] LOG:  statement: UPDATE time_statistics
	SET e_time = current_timestamp
	WHERE task_name = 'PERF.POWER.Q13';
2014-11-05 01:13:38 UTC [63466]: [4-1] user=sekondquad,db=dbt3,client=[local] LOG:  duration: 3.521 ms
2014-11-05 01:13:38 UTC [63466]: [5-1] user=sekondquad,db=dbt3,client=[local] LOG:  disconnection: session time: 0:00:00.007 user=sekondquad database=dbt3 host=[local]
2014-11-05 01:13:38 UTC [63472]: [1-1] user=[unknown],db=[unknown],client= LOG:  connection received: host=[local]
2014-11-05 01:13:38 UTC [63472]: [2-1] user=sekondquad,db=dbt3,client=[local] LOG:  connection authorized: user=sekondquad database=dbt3
2014-11-05 01:13:38 UTC [63472]: [3-1] user=sekondquad,db=dbt3,client=[local] LOG:  statement: INSERT INTO time_statistics (task_name, s_time)
	VALUES ('PERF.POWER.Q3', CURRENT_TIMESTAMP);
2014-11-05 01:13:38 UTC [63472]: [4-1] user=sekondquad,db=dbt3,client=[local] LOG:  duration: 2.435 ms
2014-11-05 01:13:38 UTC [63472]: [5-1] user=sekondquad,db=dbt3,client=[local] LOG:  disconnection: session time: 0:00:00.005 user=sekondquad database=dbt3 host=[local]
2014-11-05 01:13:38 UTC [63474]: [1-1] user=[unknown],db=[unknown],client= LOG:  connection received: host=[local]
2014-11-05 01:13:38 UTC [63474]: [2-1] user=sekondquad,db=dbt3,client=[local] LOG:  connection authorized: user=sekondquad database=dbt3
2014-11-05 01:13:38 UTC [63474]: [3-1] user=sekondquad,db=dbt3,client=[local] LOG:  statement: BEGIN;
2014-11-05 01:13:38 UTC [63474]: [4-1] user=sekondquad,db=dbt3,client=[local] LOG:  duration: 0.176 ms
2014-11-05 01:13:38 UTC [63474]: [5-1] user=sekondquad,db=dbt3,client=[local] LOG:  statement: EXPLAIN (ANALYZE, BUFFERS)
	select
		l_orderkey,
		sum(l_extendedprice * (1 - l_discount)) as revenue,
		o_orderdate,
		o_shippriority
	from
		customer,
		orders,
		lineitem
	where
		c_mktsegment = 'HOUSEHOLD'
		and c_custkey = o_custkey
		and l_orderkey = o_orderkey
		and o_orderdate < date '1995-03-06'
		and l_shipdate > date '1995-03-06'
	group by
		l_orderkey,
		o_orderdate,
		o_shippriority
	order by
		revenue desc,
		o_orderdate
	LIMIT 10;
2014-11-05 01:14:08 UTC [63474]: [6-1] user=sekondquad,db=dbt3,client=[local] LOG:  duration: 30020.849 ms
2014-11-05 01:14:08 UTC [63474]: [7-1] user=sekondquad,db=dbt3,client=[local] LOG:  statement: COMMIT;
2014-11-05 01:14:08 UTC [63474]: [8-1] user=sekondquad,db=dbt3,client=[local] LOG:  duration: 0.126 ms
2014-11-05 01:14:08 UTC [63474]: [9-1] user=sekondquad,db=dbt3,client=[local] LOG:  disconnection: session time: 0:00:30.026 user=sekondquad database=dbt3 host=[local]
2014-11-05 01:14:08 UTC [63484]: [1-1] user=[unknown],db=[unknown],client= LOG:  connection received: host=[local]
2014-11-05 01:14:08 UTC [63484]: [2-1] user=sekondquad,db=dbt3,client=[local] LOG:  connection authorized: user=sekondquad database=dbt3
2014-11-05 01:14:08 UTC [63484]: [3-1] user=sekondquad,db=dbt3,client=[local] LOG:  statement: UPDATE time_statistics
	SET e_time = current_timestamp
	WHERE task_name = 'PERF.POWER.Q3';
2014-11-05 01:14:08 UTC [63484]: [4-1] user=sekondquad,db=dbt3,client=[local] LOG:  duration: 3.458 ms
2014-11-05 01:14:08 UTC [63484]: [5-1] user=sekondquad,db=dbt3,client=[local] LOG:  disconnection: session time: 0:00:00.007 user=sekondquad database=dbt3 host=[local]
2014-11-05 01:14:08 UTC [63490]: [1-1] user=[unknown],db=[unknown],client= LOG:  connection received: host=[local]
2014-11-05 01:14:08 UTC [63490]: [2-1] user=sekondquad,db=dbt3,client=[local] LOG:  connection authorized: user=sekondquad database=dbt3
2014-11-05 01:14:08 UTC [63490]: [3-1] user=sekondquad,db=dbt3,client=[local] LOG:  statement: INSERT INTO time_statistics (task_name, s_time)
	VALUES ('PERF.POWER.Q22', CURRENT_TIMESTAMP);
2014-11-05 01:14:08 UTC [63490]: [4-1] user=sekondquad,db=dbt3,client=[local] LOG:  duration: 1.510 ms
2014-11-05 01:14:08 UTC [63490]: [5-1] user=sekondquad,db=dbt3,client=[local] LOG:  disconnection: session time: 0:00:00.004 user=sekondquad database=dbt3 host=[local]
2014-11-05 01:14:08 UTC [63492]: [1-1] user=[unknown],db=[unknown],client= LOG:  connection received: host=[local]
2014-11-05 01:14:08 UTC [63492]: [2-1] user=sekondquad,db=dbt3,client=[local] LOG:  connection authorized: user=sekondquad database=dbt3
2014-11-05 01:14:08 UTC [63492]: [3-1] user=sekondquad,db=dbt3,client=[local] LOG:  statement: BEGIN;
2014-11-05 01:14:08 UTC [63492]: [4-1] user=sekondquad,db=dbt3,client=[local] LOG:  duration: 0.202 ms
2014-11-05 01:14:08 UTC [63492]: [5-1] user=sekondquad,db=dbt3,client=[local] LOG:  statement: EXPLAIN (ANALYZE, BUFFERS)
	select
		cntrycode,
		count(*) as numcust,
		sum(c_acctbal) as totacctbal
	from
		(
			select
				substr(c_phone, 1, 2) as cntrycode,
				c_acctbal
			from
				customer
			where
				substr(c_phone, 1, 2) in
					('19', '33', '17', '25', '23', '27', '31')
				and c_acctbal > (
					select
						avg(c_acctbal)
					from
						customer
					where
						c_acctbal > 0.00
						and substr(c_phone, 1, 2) in
							('19', '33', '17', '25', '23', '27', '31')
				)
				and not exists (
					select
						*
					from
						orders
					where
						o_custkey = c_custkey
				)
		) as vip
	group by
		cntrycode
	order by
		cntrycode;
2014-11-05 01:14:18 UTC [63492]: [6-1] user=sekondquad,db=dbt3,client=[local] LOG:  duration: 9474.609 ms
2014-11-05 01:14:18 UTC [63492]: [7-1] user=sekondquad,db=dbt3,client=[local] LOG:  statement: COMMIT;
2014-11-05 01:14:18 UTC [63492]: [8-1] user=sekondquad,db=dbt3,client=[local] LOG:  duration: 0.153 ms
2014-11-05 01:14:18 UTC [63492]: [9-1] user=sekondquad,db=dbt3,client=[local] LOG:  disconnection: session time: 0:00:09.480 user=sekondquad database=dbt3 host=[local]
2014-11-05 01:14:18 UTC [63496]: [1-1] user=[unknown],db=[unknown],client= LOG:  connection received: host=[local]
2014-11-05 01:14:18 UTC [63496]: [2-1] user=sekondquad,db=dbt3,client=[local] LOG:  connection authorized: user=sekondquad database=dbt3
2014-11-05 01:14:18 UTC [63496]: [3-1] user=sekondquad,db=dbt3,client=[local] LOG:  statement: UPDATE time_statistics
	SET e_time = current_timestamp
	WHERE task_name = 'PERF.POWER.Q22';
2014-11-05 01:14:18 UTC [63496]: [4-1] user=sekondquad,db=dbt3,client=[local] LOG:  duration: 3.719 ms
2014-11-05 01:14:18 UTC [63496]: [5-1] user=sekondquad,db=dbt3,client=[local] LOG:  disconnection: session time: 0:00:00.008 user=sekondquad database=dbt3 host=[local]
2014-11-05 01:14:18 UTC [63502]: [1-1] user=[unknown],db=[unknown],client= LOG:  connection received: host=[local]
2014-11-05 01:14:18 UTC [63502]: [2-1] user=sekondquad,db=dbt3,client=[local] LOG:  connection authorized: user=sekondquad database=dbt3
2014-11-05 01:14:18 UTC [63502]: [3-1] user=sekondquad,db=dbt3,client=[local] LOG:  statement: INSERT INTO time_statistics (task_name, s_time)
	VALUES ('PERF.POWER.Q16', CURRENT_TIMESTAMP);
2014-11-05 01:14:18 UTC [63502]: [4-1] user=sekondquad,db=dbt3,client=[local] LOG:  duration: 1.620 ms
2014-11-05 01:14:18 UTC [63502]: [5-1] user=sekondquad,db=dbt3,client=[local] LOG:  disconnection: session time: 0:00:00.004 user=sekondquad database=dbt3 host=[local]
2014-11-05 01:14:18 UTC [63504]: [1-1] user=[unknown],db=[unknown],client= LOG:  connection received: host=[local]
2014-11-05 01:14:18 UTC [63504]: [2-1] user=sekondquad,db=dbt3,client=[local] LOG:  connection authorized: user=sekondquad database=dbt3
2014-11-05 01:14:18 UTC [63504]: [3-1] user=sekondquad,db=dbt3,client=[local] LOG:  statement: BEGIN;
2014-11-05 01:14:18 UTC [63504]: [4-1] user=sekondquad,db=dbt3,client=[local] LOG:  duration: 0.165 ms
2014-11-05 01:14:18 UTC [63504]: [5-1] user=sekondquad,db=dbt3,client=[local] LOG:  statement: EXPLAIN (ANALYZE, BUFFERS)
	select
		p_brand,
		p_type,
		p_size,
		count(distinct ps_suppkey) as supplier_cnt
	from
		partsupp,
		part
	where
		p_partkey = ps_partkey
		and p_brand <> 'Brand#35'
		and p_type not like 'ECONOMY BRUSHED%'
		and p_size in (30, 41, 38, 21, 48, 16, 32, 26)
		and ps_suppkey not in (
			select
				s_suppkey
			from
				supplier
			where
				s_comment like '%Customer%Complaints%'
		)
	group by
		p_brand,
		p_type,
		p_size
	order by
		supplier_cnt desc,
		p_brand,
		p_type,
		p_size;
2014-11-05 01:14:27 UTC [63504]: [6-1] user=sekondquad,db=dbt3,client=[local] LOG:  duration: 9586.664 ms
2014-11-05 01:14:27 UTC [63504]: [7-1] user=sekondquad,db=dbt3,client=[local] LOG:  statement: COMMIT;
2014-11-05 01:14:27 UTC [63504]: [8-1] user=sekondquad,db=dbt3,client=[local] LOG:  duration: 0.101 ms
2014-11-05 01:14:27 UTC [63504]: [9-1] user=sekondquad,db=dbt3,client=[local] LOG:  disconnection: session time: 0:00:09.591 user=sekondquad database=dbt3 host=[local]
2014-11-05 01:14:27 UTC [63509]: [1-1] user=[unknown],db=[unknown],client= LOG:  connection received: host=[local]
2014-11-05 01:14:27 UTC [63509]: [2-1] user=sekondquad,db=dbt3,client=[local] LOG:  connection authorized: user=sekondquad database=dbt3
2014-11-05 01:14:27 UTC [63509]: [3-1] user=sekondquad,db=dbt3,client=[local] LOG:  statement: UPDATE time_statistics
	SET e_time = current_timestamp
	WHERE task_name = 'PERF.POWER.Q16';
2014-11-05 01:14:27 UTC [63509]: [4-1] user=sekondquad,db=dbt3,client=[local] LOG:  duration: 2.561 ms
2014-11-05 01:14:27 UTC [63509]: [5-1] user=sekondquad,db=dbt3,client=[local] LOG:  disconnection: session time: 0:00:00.005 user=sekondquad database=dbt3 host=[local]
2014-11-05 01:14:27 UTC [63515]: [1-1] user=[unknown],db=[unknown],client= LOG:  connection received: host=[local]
2014-11-05 01:14:27 UTC [63515]: [2-1] user=sekondquad,db=dbt3,client=[local] LOG:  connection authorized: user=sekondquad database=dbt3
2014-11-05 01:14:27 UTC [63515]: [3-1] user=sekondquad,db=dbt3,client=[local] LOG:  statement: INSERT INTO time_statistics (task_name, s_time)
	VALUES ('PERF.POWER.Q4', CURRENT_TIMESTAMP);
2014-11-05 01:14:27 UTC [63515]: [4-1] user=sekondquad,db=dbt3,client=[local] LOG:  duration: 2.419 ms
2014-11-05 01:14:27 UTC [63515]: [5-1] user=sekondquad,db=dbt3,client=[local] LOG:  disconnection: session time: 0:00:00.005 user=sekondquad database=dbt3 host=[local]
2014-11-05 01:14:27 UTC [63517]: [1-1] user=[unknown],db=[unknown],client= LOG:  connection received: host=[local]
2014-11-05 01:14:27 UTC [63517]: [2-1] user=sekondquad,db=dbt3,client=[local] LOG:  connection authorized: user=sekondquad database=dbt3
2014-11-05 01:14:27 UTC [63517]: [3-1] user=sekondquad,db=dbt3,client=[local] LOG:  statement: BEGIN;
2014-11-05 01:14:27 UTC [63517]: [4-1] user=sekondquad,db=dbt3,client=[local] LOG:  duration: 0.175 ms
2014-11-05 01:14:27 UTC [63517]: [5-1] user=sekondquad,db=dbt3,client=[local] LOG:  statement: EXPLAIN (ANALYZE, BUFFERS)
	select
		o_orderpriority,
		count(*) as order_count
	from
		orders
	where
		o_orderdate >= date '1993-10-01'
		and o_orderdate < cast(date '1993-10-01' + interval '3 month' as date)
		and exists (
			select
				*
			from
				lineitem
			where
				l_orderkey = o_orderkey
				and l_commitdate < l_receiptdate
		)
	group by
		o_orderpriority
	order by
		o_orderpriority;
2014-11-05 01:14:36 UTC [63527]: [1-1] user=[unknown],db=[unknown],client= LOG:  connection received: host=[local]
2014-11-05 01:14:36 UTC [63528]: [1-1] user=[unknown],db=[unknown],client= LOG:  connection received: host=[local]
2014-11-05 01:14:36 UTC [63528]: [2-1] user=sekondquad,db=dbt3,client=[local] LOG:  connection authorized: user=sekondquad database=dbt3
2014-11-05 01:14:36 UTC [63527]: [2-1] user=sekondquad,db=dbt3,client=[local] LOG:  connection authorized: user=sekondquad database=dbt3
2014-11-05 01:14:36 UTC [63529]: [1-1] user=[unknown],db=[unknown],client= LOG:  connection received: host=[local]
2014-11-05 01:14:36 UTC [63529]: [2-1] user=sekondquad,db=dbt3,client=[local] LOG:  connection authorized: user=sekondquad database=dbt3
2014-11-05 01:14:36 UTC [63530]: [1-1] user=[unknown],db=[unknown],client= LOG:  connection received: host=[local]
2014-11-05 01:14:36 UTC [63530]: [2-1] user=sekondquad,db=dbt3,client=[local] LOG:  connection authorized: user=sekondquad database=dbt3
2014-11-05 01:14:36 UTC [63529]: [3-1] user=sekondquad,db=dbt3,client=[local] LOG:  statement: COPY (SELECT EXTRACT(EPOCH FROM TRANSACTION_TIMESTAMP()) AS ctime, a.schemaname, a.relname, a.indexrelname, idx_scan, idx_tup_read, idx_tup_fetch, idx_blks_read, idx_blks_hit FROM pg_stat_all_indexes a, pg_statio_all_indexes b WHERE a.indexrelid = b.indexrelid) TO STDOUT (FORMAT CSV);
2014-11-05 01:14:36 UTC [63527]: [3-1] user=sekondquad,db=dbt3,client=[local] LOG:  statement: COPY (SELECT EXTRACT(EPOCH FROM TRANSACTION_TIMESTAMP()) AS ctime, a.schemaname, a.relname, seq_scan, seq_tup_read, idx_scan, idx_tup_fetch, n_tup_ins, n_tup_upd, n_tup_del, n_tup_hot_upd, n_live_tup, n_dead_tup, heap_blks_read, heap_blks_hit, idx_blks_read, idx_blks_hit, toast_blks_read, toast_blks_hit, tidx_blks_read, tidx_blks_hit FROM pg_statio_all_tables a, pg_stat_all_tables b WHERE a.relid = b.relid) TO STDOUT (FORMAT CSV);
2014-11-05 01:14:36 UTC [63528]: [3-1] user=sekondquad,db=dbt3,client=[local] LOG:  statement: COPY (SELECT EXTRACT(EPOCH FROM TRANSACTION_TIMESTAMP()) AS ctime, relname, pid, mode, granted FROM pg_locks, pg_class WHERE relfilenode = relation ORDER BY relname) TO STDOUT (FORMAT CSV);
2014-11-05 01:14:36 UTC [63531]: [1-1] user=[unknown],db=[unknown],client= LOG:  connection received: host=[local]
2014-11-05 01:14:36 UTC [63530]: [3-1] user=sekondquad,db=dbt3,client=[local] LOG:  statement: COPY (SELECT EXTRACT(EPOCH FROM TRANSACTION_TIMESTAMP()) AS ctime, datname, numbackends, xact_commit, xact_rollback, blks_read, blks_hit, tup_returned, tup_fetched, tup_inserted, tup_updated, tup_deleted FROM pg_stat_database) TO STDOUT (FORMAT CSV);
2014-11-05 01:14:36 UTC [63531]: [2-1] user=sekondquad,db=dbt3,client=[local] LOG:  connection authorized: user=sekondquad database=dbt3
2014-11-05 01:14:36 UTC [63531]: [3-1] user=sekondquad,db=dbt3,client=[local] LOG:  statement: COPY (SELECT EXTRACT(EPOCH FROM TRANSACTION_TIMESTAMP()) AS ctime, datname, pid, usesysid, usename, application_name, client_addr, client_port, backend_start, xact_start, query_start, waiting, query , state, state_change FROM pg_stat_activity) TO STDOUT (FORMAT CSV);
2014-11-05 01:14:36 UTC [63528]: [4-1] user=sekondquad,db=dbt3,client=[local] LOG:  duration: 6.708 ms
2014-11-05 01:14:36 UTC [63531]: [4-1] user=sekondquad,db=dbt3,client=[local] LOG:  duration: 3.360 ms
2014-11-05 01:14:36 UTC [63528]: [5-1] user=sekondquad,db=dbt3,client=[local] LOG:  disconnection: session time: 0:00:00.009 user=sekondquad database=dbt3 host=[local]
2014-11-05 01:14:36 UTC [63531]: [5-1] user=sekondquad,db=dbt3,client=[local] LOG:  disconnection: session time: 0:00:00.006 user=sekondquad database=dbt3 host=[local]
2014-11-05 01:14:36 UTC [63527]: [4-1] user=sekondquad,db=dbt3,client=[local] LOG:  duration: 8.745 ms
2014-11-05 01:14:36 UTC [63527]: [5-1] user=sekondquad,db=dbt3,client=[local] LOG:  disconnection: session time: 0:00:00.011 user=sekondquad database=dbt3 host=[local]
2014-11-05 01:14:36 UTC [63529]: [4-1] user=sekondquad,db=dbt3,client=[local] LOG:  duration: 9.870 ms
2014-11-05 01:14:36 UTC [63529]: [5-1] user=sekondquad,db=dbt3,client=[local] LOG:  disconnection: session time: 0:00:00.012 user=sekondquad database=dbt3 host=[local]
2014-11-05 01:14:36 UTC [63530]: [4-1] user=sekondquad,db=dbt3,client=[local] LOG:  duration: 12.744 ms
2014-11-05 01:14:36 UTC [63530]: [5-1] user=sekondquad,db=dbt3,client=[local] LOG:  disconnection: session time: 0:00:00.015 user=sekondquad database=dbt3 host=[local]
2014-11-05 01:14:38 UTC [63517]: [6-1] user=sekondquad,db=dbt3,client=[local] LOG:  duration: 10600.368 ms
2014-11-05 01:14:38 UTC [63517]: [7-1] user=sekondquad,db=dbt3,client=[local] LOG:  statement: COMMIT;
2014-11-05 01:14:38 UTC [63517]: [8-1] user=sekondquad,db=dbt3,client=[local] LOG:  duration: 0.118 ms
2014-11-05 01:14:38 UTC [63517]: [9-1] user=sekondquad,db=dbt3,client=[local] LOG:  disconnection: session time: 0:00:10.605 user=sekondquad database=dbt3 host=[local]
2014-11-05 01:14:38 UTC [63533]: [1-1] user=[unknown],db=[unknown],client= LOG:  connection received: host=[local]
2014-11-05 01:14:38 UTC [63533]: [2-1] user=sekondquad,db=dbt3,client=[local] LOG:  connection authorized: user=sekondquad database=dbt3
2014-11-05 01:14:38 UTC [63533]: [3-1] user=sekondquad,db=dbt3,client=[local] LOG:  statement: UPDATE time_statistics
	SET e_time = current_timestamp
	WHERE task_name = 'PERF.POWER.Q4';
2014-11-05 01:14:38 UTC [63533]: [4-1] user=sekondquad,db=dbt3,client=[local] LOG:  duration: 3.758 ms
2014-11-05 01:14:38 UTC [63533]: [5-1] user=sekondquad,db=dbt3,client=[local] LOG:  disconnection: session time: 0:00:00.008 user=sekondquad database=dbt3 host=[local]
2014-11-05 01:14:38 UTC [63539]: [1-1] user=[unknown],db=[unknown],client= LOG:  connection received: host=[local]
2014-11-05 01:14:38 UTC [63539]: [2-1] user=sekondquad,db=dbt3,client=[local] LOG:  connection authorized: user=sekondquad database=dbt3
2014-11-05 01:14:38 UTC [63539]: [3-1] user=sekondquad,db=dbt3,client=[local] LOG:  statement: INSERT INTO time_statistics (task_name, s_time)
	VALUES ('PERF.POWER.Q11', CURRENT_TIMESTAMP);
2014-11-05 01:14:38 UTC [63539]: [4-1] user=sekondquad,db=dbt3,client=[local] LOG:  duration: 1.788 ms
2014-11-05 01:14:38 UTC [63539]: [5-1] user=sekondquad,db=dbt3,client=[local] LOG:  disconnection: session time: 0:00:00.006 user=sekondquad database=dbt3 host=[local]
2014-11-05 01:14:38 UTC [63541]: [1-1] user=[unknown],db=[unknown],client= LOG:  connection received: host=[local]
2014-11-05 01:14:38 UTC [63541]: [2-1] user=sekondquad,db=dbt3,client=[local] LOG:  connection authorized: user=sekondquad database=dbt3
2014-11-05 01:14:38 UTC [63541]: [3-1] user=sekondquad,db=dbt3,client=[local] LOG:  statement: BEGIN;
2014-11-05 01:14:38 UTC [63541]: [4-1] user=sekondquad,db=dbt3,client=[local] LOG:  duration: 0.219 ms
2014-11-05 01:14:38 UTC [63541]: [5-1] user=sekondquad,db=dbt3,client=[local] LOG:  statement: EXPLAIN (ANALYZE, BUFFERS)
	select
		ps_partkey,
		sum(ps_supplycost * ps_availqty) as value
	from
		partsupp,
		supplier,
		nation
	where
		ps_suppkey = s_suppkey
		and s_nationkey = n_nationkey
		and n_name = 'IRAN'
	group by
		ps_partkey having
			sum(ps_supplycost * ps_availqty) > (
				select
					sum(ps_supplycost * ps_availqty) * 0.0000100000
				from
					partsupp,
					supplier,
					nation
				where
					ps_suppkey = s_suppkey
					and s_nationkey = n_nationkey
					and n_name = 'IRAN'
			)
	order by
		value desc;
2014-11-05 01:14:40 UTC [63541]: [6-1] user=sekondquad,db=dbt3,client=[local] LOG:  duration: 2232.591 ms
2014-11-05 01:14:40 UTC [63541]: [7-1] user=sekondquad,db=dbt3,client=[local] LOG:  statement: COMMIT;
2014-11-05 01:14:40 UTC [63541]: [8-1] user=sekondquad,db=dbt3,client=[local] LOG:  duration: 0.118 ms
2014-11-05 01:14:40 UTC [63541]: [9-1] user=sekondquad,db=dbt3,client=[local] LOG:  disconnection: session time: 0:00:02.238 user=sekondquad database=dbt3 host=[local]
2014-11-05 01:14:40 UTC [63545]: [1-1] user=[unknown],db=[unknown],client= LOG:  connection received: host=[local]
2014-11-05 01:14:40 UTC [63545]: [2-1] user=sekondquad,db=dbt3,client=[local] LOG:  connection authorized: user=sekondquad database=dbt3
2014-11-05 01:14:40 UTC [63545]: [3-1] user=sekondquad,db=dbt3,client=[local] LOG:  statement: UPDATE time_statistics
	SET e_time = current_timestamp
	WHERE task_name = 'PERF.POWER.Q11';
2014-11-05 01:14:40 UTC [63545]: [4-1] user=sekondquad,db=dbt3,client=[local] LOG:  duration: 3.856 ms
2014-11-05 01:14:40 UTC [63545]: [5-1] user=sekondquad,db=dbt3,client=[local] LOG:  disconnection: session time: 0:00:00.008 user=sekondquad database=dbt3 host=[local]
2014-11-05 01:14:40 UTC [63551]: [1-1] user=[unknown],db=[unknown],client= LOG:  connection received: host=[local]
2014-11-05 01:14:40 UTC [63551]: [2-1] user=sekondquad,db=dbt3,client=[local] LOG:  connection authorized: user=sekondquad database=dbt3
2014-11-05 01:14:40 UTC [63551]: [3-1] user=sekondquad,db=dbt3,client=[local] LOG:  statement: INSERT INTO time_statistics (task_name, s_time)
	VALUES ('PERF.POWER.Q15', CURRENT_TIMESTAMP);
2014-11-05 01:14:40 UTC [63551]: [4-1] user=sekondquad,db=dbt3,client=[local] LOG:  duration: 1.598 ms
2014-11-05 01:14:40 UTC [63551]: [5-1] user=sekondquad,db=dbt3,client=[local] LOG:  disconnection: session time: 0:00:00.005 user=sekondquad database=dbt3 host=[local]
2014-11-05 01:14:40 UTC [63553]: [1-1] user=[unknown],db=[unknown],client= LOG:  connection received: host=[local]
2014-11-05 01:14:40 UTC [63553]: [2-1] user=sekondquad,db=dbt3,client=[local] LOG:  connection authorized: user=sekondquad database=dbt3
2014-11-05 01:14:40 UTC [63553]: [3-1] user=sekondquad,db=dbt3,client=[local] LOG:  statement: BEGIN;
2014-11-05 01:14:40 UTC [63553]: [4-1] user=sekondquad,db=dbt3,client=[local] LOG:  duration: 0.204 ms
2014-11-05 01:14:40 UTC [63553]: [5-1] user=sekondquad,db=dbt3,client=[local] LOG:  statement: create or replace view revenue0 (supplier_no, total_revenue) as
		select
			l_suppkey,
			sum(l_extendedprice * (1 - l_discount))
		from
			lineitem
		where
			l_shipdate >= '1997-03-01'
			and l_shipdate < date'1997-03-01' + interval '90 days'
		group by
			l_suppkey;
2014-11-05 01:14:40 UTC [63553]: [6-1] user=sekondquad,db=dbt3,client=[local] LOG:  duration: 8.295 ms
2014-11-05 01:14:40 UTC [63553]: [7-1] user=sekondquad,db=dbt3,client=[local] LOG:  statement: EXPLAIN (ANALYZE, BUFFERS)
	select
		s_suppkey,
		s_name,
		s_address,
		s_phone,
		total_revenue
	from
		supplier,
		revenue0
	where
		s_suppkey = supplier_no
		and total_revenue = (
			select
				max(total_revenue)
			from
				revenue0
		)
	order by
		s_suppkey;
2014-11-05 01:14:59 UTC [63553]: [8-1] user=sekondquad,db=dbt3,client=[local] LOG:  duration: 18356.958 ms
2014-11-05 01:14:59 UTC [63553]: [9-1] user=sekondquad,db=dbt3,client=[local] LOG:  statement: drop view revenue0;
2014-11-05 01:14:59 UTC [63553]: [10-1] user=sekondquad,db=dbt3,client=[local] LOG:  duration: 1.117 ms
2014-11-05 01:14:59 UTC [63553]: [11-1] user=sekondquad,db=dbt3,client=[local] LOG:  statement: COMMIT;
2014-11-05 01:14:59 UTC [63553]: [12-1] user=sekondquad,db=dbt3,client=[local] LOG:  duration: 0.470 ms
2014-11-05 01:14:59 UTC [63553]: [13-1] user=sekondquad,db=dbt3,client=[local] LOG:  disconnection: session time: 0:00:18.372 user=sekondquad database=dbt3 host=[local]
2014-11-05 01:14:59 UTC [63557]: [1-1] user=[unknown],db=[unknown],client= LOG:  connection received: host=[local]
2014-11-05 01:14:59 UTC [63557]: [2-1] user=sekondquad,db=dbt3,client=[local] LOG:  connection authorized: user=sekondquad database=dbt3
2014-11-05 01:14:59 UTC [63557]: [3-1] user=sekondquad,db=dbt3,client=[local] LOG:  statement: UPDATE time_statistics
	SET e_time = current_timestamp
	WHERE task_name = 'PERF.POWER.Q15';
2014-11-05 01:14:59 UTC [63557]: [4-1] user=sekondquad,db=dbt3,client=[local] LOG:  duration: 3.851 ms
2014-11-05 01:14:59 UTC [63557]: [5-1] user=sekondquad,db=dbt3,client=[local] LOG:  disconnection: session time: 0:00:00.008 user=sekondquad database=dbt3 host=[local]
2014-11-05 01:14:59 UTC [63563]: [1-1] user=[unknown],db=[unknown],client= LOG:  connection received: host=[local]
2014-11-05 01:14:59 UTC [63563]: [2-1] user=sekondquad,db=dbt3,client=[local] LOG:  connection authorized: user=sekondquad database=dbt3
2014-11-05 01:14:59 UTC [63563]: [3-1] user=sekondquad,db=dbt3,client=[local] LOG:  statement: INSERT INTO time_statistics (task_name, s_time)
	VALUES ('PERF.POWER.Q1', CURRENT_TIMESTAMP);
2014-11-05 01:14:59 UTC [63563]: [4-1] user=sekondquad,db=dbt3,client=[local] LOG:  duration: 1.585 ms
2014-11-05 01:14:59 UTC [63563]: [5-1] user=sekondquad,db=dbt3,client=[local] LOG:  disconnection: session time: 0:00:00.004 user=sekondquad database=dbt3 host=[local]
2014-11-05 01:14:59 UTC [63565]: [1-1] user=[unknown],db=[unknown],client= LOG:  connection received: host=[local]
2014-11-05 01:14:59 UTC [63565]: [2-1] user=sekondquad,db=dbt3,client=[local] LOG:  connection authorized: user=sekondquad database=dbt3
2014-11-05 01:14:59 UTC [63565]: [3-1] user=sekondquad,db=dbt3,client=[local] LOG:  statement: BEGIN;
2014-11-05 01:14:59 UTC [63565]: [4-1] user=sekondquad,db=dbt3,client=[local] LOG:  duration: 0.202 ms
2014-11-05 01:14:59 UTC [63565]: [5-1] user=sekondquad,db=dbt3,client=[local] LOG:  statement: EXPLAIN (ANALYZE, BUFFERS)
	select
		l_returnflag,
		l_linestatus,
		sum(l_quantity) as sum_qty,
		sum(l_extendedprice) as sum_base_price,
		sum(l_extendedprice * (1 - l_discount)) as sum_disc_price,
		sum(l_extendedprice * (1 - l_discount) * (1 + l_tax)) as sum_charge,
		avg(l_quantity) as avg_qty,
		avg(l_extendedprice) as avg_price,
		avg(l_discount) as avg_disc,
		count(*) as count_order
	from
		lineitem
	where
		l_shipdate <= date '1998-12-01' - interval '113 days'
	group by
		l_returnflag,
		l_linestatus
	order by
		l_returnflag,
		l_linestatus;
2014-11-05 01:15:36 UTC [63590]: [1-1] user=[unknown],db=[unknown],client= LOG:  connection received: host=[local]
2014-11-05 01:15:36 UTC [63590]: [2-1] user=sekondquad,db=dbt3,client=[local] LOG:  connection authorized: user=sekondquad database=dbt3
2014-11-05 01:15:36 UTC [63591]: [1-1] user=[unknown],db=[unknown],client= LOG:  connection received: host=[local]
2014-11-05 01:15:36 UTC [63591]: [2-1] user=sekondquad,db=dbt3,client=[local] LOG:  connection authorized: user=sekondquad database=dbt3
2014-11-05 01:15:36 UTC [63593]: [1-1] user=[unknown],db=[unknown],client= LOG:  connection received: host=[local]
2014-11-05 01:15:36 UTC [63593]: [2-1] user=sekondquad,db=dbt3,client=[local] LOG:  connection authorized: user=sekondquad database=dbt3
2014-11-05 01:15:36 UTC [63590]: [3-1] user=sekondquad,db=dbt3,client=[local] LOG:  statement: COPY (SELECT EXTRACT(EPOCH FROM TRANSACTION_TIMESTAMP()) AS ctime, relname, pid, mode, granted FROM pg_locks, pg_class WHERE relfilenode = relation ORDER BY relname) TO STDOUT (FORMAT CSV);
2014-11-05 01:15:36 UTC [63594]: [1-1] user=[unknown],db=[unknown],client= LOG:  connection received: host=[local]
2014-11-05 01:15:36 UTC [63592]: [1-1] user=[unknown],db=[unknown],client= LOG:  connection received: host=[local]
2014-11-05 01:15:36 UTC [63591]: [3-1] user=sekondquad,db=dbt3,client=[local] LOG:  statement: COPY (SELECT EXTRACT(EPOCH FROM TRANSACTION_TIMESTAMP()) AS ctime, a.schemaname, a.relname, seq_scan, seq_tup_read, idx_scan, idx_tup_fetch, n_tup_ins, n_tup_upd, n_tup_del, n_tup_hot_upd, n_live_tup, n_dead_tup, heap_blks_read, heap_blks_hit, idx_blks_read, idx_blks_hit, toast_blks_read, toast_blks_hit, tidx_blks_read, tidx_blks_hit FROM pg_statio_all_tables a, pg_stat_all_tables b WHERE a.relid = b.relid) TO STDOUT (FORMAT CSV);
2014-11-05 01:15:36 UTC [63592]: [2-1] user=sekondquad,db=dbt3,client=[local] LOG:  connection authorized: user=sekondquad database=dbt3
2014-11-05 01:15:36 UTC [63594]: [2-1] user=sekondquad,db=dbt3,client=[local] LOG:  connection authorized: user=sekondquad database=dbt3
2014-11-05 01:15:36 UTC [63593]: [3-1] user=sekondquad,db=dbt3,client=[local] LOG:  statement: COPY (SELECT EXTRACT(EPOCH FROM TRANSACTION_TIMESTAMP()) AS ctime, datname, pid, usesysid, usename, application_name, client_addr, client_port, backend_start, xact_start, query_start, waiting, query , state, state_change FROM pg_stat_activity) TO STDOUT (FORMAT CSV);
2014-11-05 01:15:36 UTC [63594]: [3-1] user=sekondquad,db=dbt3,client=[local] LOG:  statement: COPY (SELECT EXTRACT(EPOCH FROM TRANSACTION_TIMESTAMP()) AS ctime, datname, numbackends, xact_commit, xact_rollback, blks_read, blks_hit, tup_returned, tup_fetched, tup_inserted, tup_updated, tup_deleted FROM pg_stat_database) TO STDOUT (FORMAT CSV);
2014-11-05 01:15:36 UTC [63592]: [3-1] user=sekondquad,db=dbt3,client=[local] LOG:  statement: COPY (SELECT EXTRACT(EPOCH FROM TRANSACTION_TIMESTAMP()) AS ctime, a.schemaname, a.relname, a.indexrelname, idx_scan, idx_tup_read, idx_tup_fetch, idx_blks_read, idx_blks_hit FROM pg_stat_all_indexes a, pg_statio_all_indexes b WHERE a.indexrelid = b.indexrelid) TO STDOUT (FORMAT CSV);
2014-11-05 01:15:36 UTC [63593]: [4-1] user=sekondquad,db=dbt3,client=[local] LOG:  duration: 3.682 ms
2014-11-05 01:15:36 UTC [63593]: [5-1] user=sekondquad,db=dbt3,client=[local] LOG:  disconnection: session time: 0:00:00.006 user=sekondquad database=dbt3 host=[local]
2014-11-05 01:15:36 UTC [63590]: [4-1] user=sekondquad,db=dbt3,client=[local] LOG:  duration: 6.119 ms
2014-11-05 01:15:36 UTC [63590]: [5-1] user=sekondquad,db=dbt3,client=[local] LOG:  disconnection: session time: 0:00:00.009 user=sekondquad database=dbt3 host=[local]
2014-11-05 01:15:36 UTC [63591]: [4-1] user=sekondquad,db=dbt3,client=[local] LOG:  duration: 10.729 ms
2014-11-05 01:15:36 UTC [63591]: [5-1] user=sekondquad,db=dbt3,client=[local] LOG:  disconnection: session time: 0:00:00.014 user=sekondquad database=dbt3 host=[local]
2014-11-05 01:15:36 UTC [63592]: [4-1] user=sekondquad,db=dbt3,client=[local] LOG:  duration: 12.156 ms
2014-11-05 01:15:36 UTC [63592]: [5-1] user=sekondquad,db=dbt3,client=[local] LOG:  disconnection: session time: 0:00:00.015 user=sekondquad database=dbt3 host=[local]
2014-11-05 01:15:36 UTC [63594]: [4-1] user=sekondquad,db=dbt3,client=[local] LOG:  duration: 13.290 ms
2014-11-05 01:15:36 UTC [63594]: [5-1] user=sekondquad,db=dbt3,client=[local] LOG:  disconnection: session time: 0:00:00.016 user=sekondquad database=dbt3 host=[local]
2014-11-05 01:16:17 UTC [63565]: [6-1] user=sekondquad,db=dbt3,client=[local] LOG:  duration: 78774.707 ms
2014-11-05 01:16:17 UTC [63565]: [7-1] user=sekondquad,db=dbt3,client=[local] LOG:  statement: COMMIT;
2014-11-05 01:16:17 UTC [63565]: [8-1] user=sekondquad,db=dbt3,client=[local] LOG:  duration: 0.123 ms
2014-11-05 01:16:17 UTC [63565]: [9-1] user=sekondquad,db=dbt3,client=[local] LOG:  disconnection: session time: 0:01:18.780 user=sekondquad database=dbt3 host=[local]
2014-11-05 01:16:17 UTC [63606]: [1-1] user=[unknown],db=[unknown],client= LOG:  connection received: host=[local]
2014-11-05 01:16:17 UTC [63606]: [2-1] user=sekondquad,db=dbt3,client=[local] LOG:  connection authorized: user=sekondquad database=dbt3
2014-11-05 01:16:17 UTC [63606]: [3-1] user=sekondquad,db=dbt3,client=[local] LOG:  statement: UPDATE time_statistics
	SET e_time = current_timestamp
	WHERE task_name = 'PERF.POWER.Q1';
2014-11-05 01:16:17 UTC [63606]: [4-1] user=sekondquad,db=dbt3,client=[local] LOG:  duration: 3.688 ms
2014-11-05 01:16:17 UTC [63606]: [5-1] user=sekondquad,db=dbt3,client=[local] LOG:  disconnection: session time: 0:00:00.008 user=sekondquad database=dbt3 host=[local]
2014-11-05 01:16:17 UTC [63612]: [1-1] user=[unknown],db=[unknown],client= LOG:  connection received: host=[local]
2014-11-05 01:16:17 UTC [63612]: [2-1] user=sekondquad,db=dbt3,client=[local] LOG:  connection authorized: user=sekondquad database=dbt3
2014-11-05 01:16:17 UTC [63612]: [3-1] user=sekondquad,db=dbt3,client=[local] LOG:  statement: INSERT INTO time_statistics (task_name, s_time)
	VALUES ('PERF.POWER.Q10', CURRENT_TIMESTAMP);
2014-11-05 01:16:17 UTC [63612]: [4-1] user=sekondquad,db=dbt3,client=[local] LOG:  duration: 2.069 ms
2014-11-05 01:16:17 UTC [63612]: [5-1] user=sekondquad,db=dbt3,client=[local] LOG:  disconnection: session time: 0:00:00.005 user=sekondquad database=dbt3 host=[local]
2014-11-05 01:16:17 UTC [63614]: [1-1] user=[unknown],db=[unknown],client= LOG:  connection received: host=[local]
2014-11-05 01:16:17 UTC [63614]: [2-1] user=sekondquad,db=dbt3,client=[local] LOG:  connection authorized: user=sekondquad database=dbt3
2014-11-05 01:16:17 UTC [63614]: [3-1] user=sekondquad,db=dbt3,client=[local] LOG:  statement: BEGIN;
2014-11-05 01:16:17 UTC [63614]: [4-1] user=sekondquad,db=dbt3,client=[local] LOG:  duration: 0.181 ms
2014-11-05 01:16:17 UTC [63614]: [5-1] user=sekondquad,db=dbt3,client=[local] LOG:  statement: EXPLAIN (ANALYZE, BUFFERS)
	select
		c_custkey,
		c_name,
		sum(l_extendedprice * (1 - l_discount)) as revenue,
		c_acctbal,
		n_name,
		c_address,
		c_phone,
		c_comment
	from
		customer,
		orders,
		lineitem,
		nation
	where
		c_custkey = o_custkey
		and l_orderkey = o_orderkey
		and o_orderdate >= date '1994-10-01'
		and o_orderdate < cast(date '1994-10-01' + interval '3 month' as date)
		and l_returnflag = 'R'
		and c_nationkey = n_nationkey
	group by
		c_custkey,
		c_name,
		c_acctbal,
		c_phone,
		n_name,
		c_address,
		c_comment
	order by
		revenue desc
	LIMIT 20;
2014-11-05 01:16:36 UTC [63627]: [1-1] user=[unknown],db=[unknown],client= LOG:  connection received: host=[local]
2014-11-05 01:16:36 UTC [63631]: [1-1] user=[unknown],db=[unknown],client= LOG:  connection received: host=[local]
2014-11-05 01:16:36 UTC [63627]: [2-1] user=sekondquad,db=dbt3,client=[local] LOG:  connection authorized: user=sekondquad database=dbt3
2014-11-05 01:16:36 UTC [63631]: [2-1] user=sekondquad,db=dbt3,client=[local] LOG:  connection authorized: user=sekondquad database=dbt3
2014-11-05 01:16:36 UTC [63628]: [1-1] user=[unknown],db=[unknown],client= LOG:  connection received: host=[local]
2014-11-05 01:16:36 UTC [63628]: [2-1] user=sekondquad,db=dbt3,client=[local] LOG:  connection authorized: user=sekondquad database=dbt3
2014-11-05 01:16:36 UTC [63630]: [1-1] user=[unknown],db=[unknown],client= LOG:  connection received: host=[local]
2014-11-05 01:16:36 UTC [63627]: [3-1] user=sekondquad,db=dbt3,client=[local] LOG:  statement: COPY (SELECT EXTRACT(EPOCH FROM TRANSACTION_TIMESTAMP()) AS ctime, datname, numbackends, xact_commit, xact_rollback, blks_read, blks_hit, tup_returned, tup_fetched, tup_inserted, tup_updated, tup_deleted FROM pg_stat_database) TO STDOUT (FORMAT CSV);
2014-11-05 01:16:36 UTC [63630]: [2-1] user=sekondquad,db=dbt3,client=[local] LOG:  connection authorized: user=sekondquad database=dbt3
2014-11-05 01:16:36 UTC [63631]: [3-1] user=sekondquad,db=dbt3,client=[local] LOG:  statement: COPY (SELECT EXTRACT(EPOCH FROM TRANSACTION_TIMESTAMP()) AS ctime, a.schemaname, a.relname, a.indexrelname, idx_scan, idx_tup_read, idx_tup_fetch, idx_blks_read, idx_blks_hit FROM pg_stat_all_indexes a, pg_statio_all_indexes b WHERE a.indexrelid = b.indexrelid) TO STDOUT (FORMAT CSV);
2014-11-05 01:16:36 UTC [63628]: [3-1] user=sekondquad,db=dbt3,client=[local] LOG:  statement: COPY (SELECT EXTRACT(EPOCH FROM TRANSACTION_TIMESTAMP()) AS ctime, relname, pid, mode, granted FROM pg_locks, pg_class WHERE relfilenode = relation ORDER BY relname) TO STDOUT (FORMAT CSV);
2014-11-05 01:16:36 UTC [63630]: [3-1] user=sekondquad,db=dbt3,client=[local] LOG:  statement: COPY (SELECT EXTRACT(EPOCH FROM TRANSACTION_TIMESTAMP()) AS ctime, datname, pid, usesysid, usename, application_name, client_addr, client_port, backend_start, xact_start, query_start, waiting, query , state, state_change FROM pg_stat_activity) TO STDOUT (FORMAT CSV);
2014-11-05 01:16:36 UTC [63629]: [1-1] user=[unknown],db=[unknown],client= LOG:  connection received: host=[local]
2014-11-05 01:16:36 UTC [63629]: [2-1] user=sekondquad,db=dbt3,client=[local] LOG:  connection authorized: user=sekondquad database=dbt3
2014-11-05 01:16:36 UTC [63629]: [3-1] user=sekondquad,db=dbt3,client=[local] LOG:  statement: COPY (SELECT EXTRACT(EPOCH FROM TRANSACTION_TIMESTAMP()) AS ctime, a.schemaname, a.relname, seq_scan, seq_tup_read, idx_scan, idx_tup_fetch, n_tup_ins, n_tup_upd, n_tup_del, n_tup_hot_upd, n_live_tup, n_dead_tup, heap_blks_read, heap_blks_hit, idx_blks_read, idx_blks_hit, toast_blks_read, toast_blks_hit, tidx_blks_read, tidx_blks_hit FROM pg_statio_all_tables a, pg_stat_all_tables b WHERE a.relid = b.relid) TO STDOUT (FORMAT CSV);
2014-11-05 01:16:36 UTC [63630]: [4-1] user=sekondquad,db=dbt3,client=[local] LOG:  duration: 3.024 ms
2014-11-05 01:16:36 UTC [63628]: [4-1] user=sekondquad,db=dbt3,client=[local] LOG:  duration: 3.662 ms
2014-11-05 01:16:36 UTC [63630]: [5-1] user=sekondquad,db=dbt3,client=[local] LOG:  disconnection: session time: 0:00:00.005 user=sekondquad database=dbt3 host=[local]
2014-11-05 01:16:36 UTC [63628]: [5-1] user=sekondquad,db=dbt3,client=[local] LOG:  disconnection: session time: 0:00:00.006 user=sekondquad database=dbt3 host=[local]
2014-11-05 01:16:36 UTC [63627]: [4-1] user=sekondquad,db=dbt3,client=[local] LOG:  duration: 14.736 ms
2014-11-05 01:16:36 UTC [63627]: [5-1] user=sekondquad,db=dbt3,client=[local] LOG:  disconnection: session time: 0:00:00.018 user=sekondquad database=dbt3 host=[local]
2014-11-05 01:16:36 UTC [63631]: [4-1] user=sekondquad,db=dbt3,client=[local] LOG:  duration: 16.226 ms
2014-11-05 01:16:36 UTC [63631]: [5-1] user=sekondquad,db=dbt3,client=[local] LOG:  disconnection: session time: 0:00:00.019 user=sekondquad database=dbt3 host=[local]
2014-11-05 01:16:36 UTC [63629]: [4-1] user=sekondquad,db=dbt3,client=[local] LOG:  duration: 13.853 ms
2014-11-05 01:16:36 UTC [63629]: [5-1] user=sekondquad,db=dbt3,client=[local] LOG:  disconnection: session time: 0:00:00.016 user=sekondquad database=dbt3 host=[local]
2014-11-05 01:16:42 UTC [63614]: [6-1] user=sekondquad,db=dbt3,client=[local] LOG:  duration: 25039.091 ms
2014-11-05 01:16:42 UTC [63614]: [7-1] user=sekondquad,db=dbt3,client=[local] LOG:  statement: COMMIT;
2014-11-05 01:16:42 UTC [63614]: [8-1] user=sekondquad,db=dbt3,client=[local] LOG:  duration: 0.137 ms
2014-11-05 01:16:42 UTC [63614]: [9-1] user=sekondquad,db=dbt3,client=[local] LOG:  disconnection: session time: 0:00:25.044 user=sekondquad database=dbt3 host=[local]
2014-11-05 01:16:42 UTC [63635]: [1-1] user=[unknown],db=[unknown],client= LOG:  connection received: host=[local]
2014-11-05 01:16:42 UTC [63635]: [2-1] user=sekondquad,db=dbt3,client=[local] LOG:  connection authorized: user=sekondquad database=dbt3
2014-11-05 01:16:42 UTC [63635]: [3-1] user=sekondquad,db=dbt3,client=[local] LOG:  statement: UPDATE time_statistics
	SET e_time = current_timestamp
	WHERE task_name = 'PERF.POWER.Q10';
2014-11-05 01:16:42 UTC [63635]: [4-1] user=sekondquad,db=dbt3,client=[local] LOG:  duration: 3.674 ms
2014-11-05 01:16:42 UTC [63635]: [5-1] user=sekondquad,db=dbt3,client=[local] LOG:  disconnection: session time: 0:00:00.008 user=sekondquad database=dbt3 host=[local]
2014-11-05 01:16:42 UTC [63642]: [1-1] user=[unknown],db=[unknown],client= LOG:  connection received: host=[local]
2014-11-05 01:16:42 UTC [63642]: [2-1] user=sekondquad,db=dbt3,client=[local] LOG:  connection authorized: user=sekondquad database=dbt3
2014-11-05 01:16:42 UTC [63642]: [3-1] user=sekondquad,db=dbt3,client=[local] LOG:  statement: INSERT INTO time_statistics (task_name, s_time)
	VALUES ('PERF.POWER.Q19', CURRENT_TIMESTAMP);
2014-11-05 01:16:42 UTC [63642]: [4-1] user=sekondquad,db=dbt3,client=[local] LOG:  duration: 1.597 ms
2014-11-05 01:16:42 UTC [63642]: [5-1] user=sekondquad,db=dbt3,client=[local] LOG:  disconnection: session time: 0:00:00.004 user=sekondquad database=dbt3 host=[local]
2014-11-05 01:16:42 UTC [63644]: [1-1] user=[unknown],db=[unknown],client= LOG:  connection received: host=[local]
2014-11-05 01:16:42 UTC [63644]: [2-1] user=sekondquad,db=dbt3,client=[local] LOG:  connection authorized: user=sekondquad database=dbt3
2014-11-05 01:16:42 UTC [63644]: [3-1] user=sekondquad,db=dbt3,client=[local] LOG:  statement: BEGIN;
2014-11-05 01:16:42 UTC [63644]: [4-1] user=sekondquad,db=dbt3,client=[local] LOG:  duration: 0.196 ms
2014-11-05 01:16:42 UTC [63644]: [5-1] user=sekondquad,db=dbt3,client=[local] LOG:  statement: EXPLAIN (ANALYZE, BUFFERS)
	select
		sum(l_extendedprice* (1 - l_discount)) as revenue
	from
		lineitem,
		part
	where
		(
			p_partkey = l_partkey
			and p_brand = 'Brand#35'
			and p_container in ('SM CASE', 'SM BOX', 'SM PACK', 'SM PKG')
			and l_quantity >= 6 and l_quantity <= 6+10
			and p_size between 1 and 5
			and l_shipmode in ('AIR', 'AIR REG')
			and l_shipinstruct = 'DELIVER IN PERSON'
		)
		or
		(
			p_partkey = l_partkey
			and p_brand = 'Brand#42'
			and p_container in ('MED BAG', 'MED BOX', 'MED PKG', 'MED PACK')
			and l_quantity >= 14 and l_quantity <= 14+10
			and p_size between 1 and 10
			and l_shipmode in ('AIR', 'AIR REG')
			and l_shipinstruct = 'DELIVER IN PERSON'
		)
		or
		(
			p_partkey = l_partkey
			and p_brand = 'Brand#52'
			and p_container in ('LG CASE', 'LG BOX', 'LG PACK', 'LG PKG')
			and l_quantity >= 26 and l_quantity <= 26+10
			and p_size between 1 and 15
			and l_shipmode in ('AIR', 'AIR REG')
			and l_shipinstruct = 'DELIVER IN PERSON'
		);
2014-11-05 01:16:43 UTC [63644]: [6-1] user=sekondquad,db=dbt3,client=[local] LOG:  duration: 621.114 ms
2014-11-05 01:16:43 UTC [63644]: [7-1] user=sekondquad,db=dbt3,client=[local] LOG:  statement: COMMIT;
2014-11-05 01:16:43 UTC [63644]: [8-1] user=sekondquad,db=dbt3,client=[local] LOG:  duration: 0.119 ms
2014-11-05 01:16:43 UTC [63644]: [9-1] user=sekondquad,db=dbt3,client=[local] LOG:  disconnection: session time: 0:00:00.627 user=sekondquad database=dbt3 host=[local]
2014-11-05 01:16:43 UTC [63646]: [1-1] user=[unknown],db=[unknown],client= LOG:  connection received: host=[local]
2014-11-05 01:16:43 UTC [63646]: [2-1] user=sekondquad,db=dbt3,client=[local] LOG:  connection authorized: user=sekondquad database=dbt3
2014-11-05 01:16:43 UTC [63646]: [3-1] user=sekondquad,db=dbt3,client=[local] LOG:  statement: UPDATE time_statistics
	SET e_time = current_timestamp
	WHERE task_name = 'PERF.POWER.Q19';
2014-11-05 01:16:43 UTC [63646]: [4-1] user=sekondquad,db=dbt3,client=[local] LOG:  duration: 4.240 ms
2014-11-05 01:16:43 UTC [63646]: [5-1] user=sekondquad,db=dbt3,client=[local] LOG:  disconnection: session time: 0:00:00.008 user=sekondquad database=dbt3 host=[local]
2014-11-05 01:16:43 UTC [63652]: [1-1] user=[unknown],db=[unknown],client= LOG:  connection received: host=[local]
2014-11-05 01:16:43 UTC [63652]: [2-1] user=sekondquad,db=dbt3,client=[local] LOG:  connection authorized: user=sekondquad database=dbt3
2014-11-05 01:16:43 UTC [63652]: [3-1] user=sekondquad,db=dbt3,client=[local] LOG:  statement: INSERT INTO time_statistics (task_name, s_time)
	VALUES ('PERF.POWER.Q5', CURRENT_TIMESTAMP);
2014-11-05 01:16:43 UTC [63652]: [4-1] user=sekondquad,db=dbt3,client=[local] LOG:  duration: 0.953 ms
2014-11-05 01:16:43 UTC [63652]: [5-1] user=sekondquad,db=dbt3,client=[local] LOG:  disconnection: session time: 0:00:00.003 user=sekondquad database=dbt3 host=[local]
2014-11-05 01:16:43 UTC [63654]: [1-1] user=[unknown],db=[unknown],client= LOG:  connection received: host=[local]
2014-11-05 01:16:43 UTC [63654]: [2-1] user=sekondquad,db=dbt3,client=[local] LOG:  connection authorized: user=sekondquad database=dbt3
2014-11-05 01:16:43 UTC [63654]: [3-1] user=sekondquad,db=dbt3,client=[local] LOG:  statement: BEGIN;
2014-11-05 01:16:43 UTC [63654]: [4-1] user=sekondquad,db=dbt3,client=[local] LOG:  duration: 0.196 ms
2014-11-05 01:16:43 UTC [63654]: [5-1] user=sekondquad,db=dbt3,client=[local] LOG:  statement: EXPLAIN (ANALYZE, BUFFERS)
	select
		n_name,
		sum(l_extendedprice * (1 - l_discount)) as revenue
	from
		customer,
		orders,
		lineitem,
		supplier,
		nation,
		region
	where
		c_custkey = o_custkey
		and l_orderkey = o_orderkey
		and l_suppkey = s_suppkey
		and c_nationkey = s_nationkey
		and s_nationkey = n_nationkey
		and n_regionkey = r_regionkey
		and r_name = 'MIDDLE EAST'
		and o_orderdate >= date '1995-01-01'
		and o_orderdate < date '1995-01-01' + interval '1 year'
	group by
		n_name
	order by
		revenue desc;
2014-11-05 01:16:55 UTC [63654]: [6-1] user=sekondquad,db=dbt3,client=[local] LOG:  duration: 11976.240 ms
2014-11-05 01:16:55 UTC [63654]: [7-1] user=sekondquad,db=dbt3,client=[local] LOG:  statement: COMMIT;
2014-11-05 01:16:55 UTC [63654]: [8-1] user=sekondquad,db=dbt3,client=[local] LOG:  duration: 0.118 ms
2014-11-05 01:16:55 UTC [63654]: [9-1] user=sekondquad,db=dbt3,client=[local] LOG:  disconnection: session time: 0:00:11.981 user=sekondquad database=dbt3 host=[local]
2014-11-05 01:16:55 UTC [63658]: [1-1] user=[unknown],db=[unknown],client= LOG:  connection received: host=[local]
2014-11-05 01:16:55 UTC [63658]: [2-1] user=sekondquad,db=dbt3,client=[local] LOG:  connection authorized: user=sekondquad database=dbt3
2014-11-05 01:16:55 UTC [63658]: [3-1] user=sekondquad,db=dbt3,client=[local] LOG:  statement: UPDATE time_statistics
	SET e_time = current_timestamp
	WHERE task_name = 'PERF.POWER.Q5';
2014-11-05 01:16:55 UTC [63658]: [4-1] user=sekondquad,db=dbt3,client=[local] LOG:  duration: 3.698 ms
2014-11-05 01:16:55 UTC [63658]: [5-1] user=sekondquad,db=dbt3,client=[local] LOG:  disconnection: session time: 0:00:00.008 user=sekondquad database=dbt3 host=[local]
2014-11-05 01:16:55 UTC [63664]: [1-1] user=[unknown],db=[unknown],client= LOG:  connection received: host=[local]
2014-11-05 01:16:55 UTC [63664]: [2-1] user=sekondquad,db=dbt3,client=[local] LOG:  connection authorized: user=sekondquad database=dbt3
2014-11-05 01:16:55 UTC [63664]: [3-1] user=sekondquad,db=dbt3,client=[local] LOG:  statement: INSERT INTO time_statistics (task_name, s_time)
	VALUES ('PERF.POWER.Q7', CURRENT_TIMESTAMP);
2014-11-05 01:16:55 UTC [63664]: [4-1] user=sekondquad,db=dbt3,client=[local] LOG:  duration: 2.298 ms
2014-11-05 01:16:55 UTC [63664]: [5-1] user=sekondquad,db=dbt3,client=[local] LOG:  disconnection: session time: 0:00:00.006 user=sekondquad database=dbt3 host=[local]
2014-11-05 01:16:55 UTC [63666]: [1-1] user=[unknown],db=[unknown],client= LOG:  connection received: host=[local]
2014-11-05 01:16:55 UTC [63666]: [2-1] user=sekondquad,db=dbt3,client=[local] LOG:  connection authorized: user=sekondquad database=dbt3
2014-11-05 01:16:55 UTC [63666]: [3-1] user=sekondquad,db=dbt3,client=[local] LOG:  statement: BEGIN;
2014-11-05 01:16:55 UTC [63666]: [4-1] user=sekondquad,db=dbt3,client=[local] LOG:  duration: 0.199 ms
2014-11-05 01:16:55 UTC [63666]: [5-1] user=sekondquad,db=dbt3,client=[local] LOG:  statement: EXPLAIN (ANALYZE, BUFFERS)
	select
		supp_nation,
		cust_nation,
		l_year,
		sum(volume) as revenue
	from
		(
			select
				n1.n_name as supp_nation,
				n2.n_name as cust_nation,
				extract(year from l_shipdate) as l_year,
				l_extendedprice * (1 - l_discount) as volume
			from
				supplier,
				lineitem,
				orders,
				customer,
				nation n1,
				nation n2
			where
				s_suppkey = l_suppkey
				and o_orderkey = l_orderkey
				and c_custkey = o_custkey
				and s_nationkey = n1.n_nationkey
				and c_nationkey = n2.n_nationkey
				and (
					(n1.n_name = 'INDONESIA' and n2.n_name = 'EGYPT')
					or (n1.n_name = 'EGYPT' and n2.n_name = 'INDONESIA')
				)
				and l_shipdate between date '1995-01-01' and date '1996-12-31'
		) as shipping
	group by
		supp_nation,
		cust_nation,
		l_year
	order by
		supp_nation,
		cust_nation,
		l_year;
2014-11-05 01:17:13 UTC [63666]: [6-1] user=sekondquad,db=dbt3,client=[local] LOG:  duration: 17565.159 ms
2014-11-05 01:17:13 UTC [63666]: [7-1] user=sekondquad,db=dbt3,client=[local] LOG:  statement: COMMIT;
2014-11-05 01:17:13 UTC [63666]: [8-1] user=sekondquad,db=dbt3,client=[local] LOG:  duration: 0.121 ms
2014-11-05 01:17:13 UTC [63666]: [9-1] user=sekondquad,db=dbt3,client=[local] LOG:  disconnection: session time: 0:00:17.570 user=sekondquad database=dbt3 host=[local]
2014-11-05 01:17:13 UTC [63677]: [1-1] user=[unknown],db=[unknown],client= LOG:  connection received: host=[local]
2014-11-05 01:17:13 UTC [63677]: [2-1] user=sekondquad,db=dbt3,client=[local] LOG:  connection authorized: user=sekondquad database=dbt3
2014-11-05 01:17:13 UTC [63677]: [3-1] user=sekondquad,db=dbt3,client=[local] LOG:  statement: UPDATE time_statistics
	SET e_time = current_timestamp
	WHERE task_name = 'PERF.POWER.Q7';
2014-11-05 01:17:13 UTC [63677]: [4-1] user=sekondquad,db=dbt3,client=[local] LOG:  duration: 3.867 ms
2014-11-05 01:17:13 UTC [63677]: [5-1] user=sekondquad,db=dbt3,client=[local] LOG:  disconnection: session time: 0:00:00.008 user=sekondquad database=dbt3 host=[local]
2014-11-05 01:17:13 UTC [63683]: [1-1] user=[unknown],db=[unknown],client= LOG:  connection received: host=[local]
2014-11-05 01:17:13 UTC [63683]: [2-1] user=sekondquad,db=dbt3,client=[local] LOG:  connection authorized: user=sekondquad database=dbt3
2014-11-05 01:17:13 UTC [63683]: [3-1] user=sekondquad,db=dbt3,client=[local] LOG:  statement: INSERT INTO time_statistics (task_name, s_time)
	VALUES ('PERF.POWER.Q12', CURRENT_TIMESTAMP);
2014-11-05 01:17:13 UTC [63683]: [4-1] user=sekondquad,db=dbt3,client=[local] LOG:  duration: 2.087 ms
2014-11-05 01:17:13 UTC [63683]: [5-1] user=sekondquad,db=dbt3,client=[local] LOG:  disconnection: session time: 0:00:00.006 user=sekondquad database=dbt3 host=[local]
2014-11-05 01:17:13 UTC [63685]: [1-1] user=[unknown],db=[unknown],client= LOG:  connection received: host=[local]
2014-11-05 01:17:13 UTC [63685]: [2-1] user=sekondquad,db=dbt3,client=[local] LOG:  connection authorized: user=sekondquad database=dbt3
2014-11-05 01:17:13 UTC [63685]: [3-1] user=sekondquad,db=dbt3,client=[local] LOG:  statement: BEGIN;
2014-11-05 01:17:13 UTC [63685]: [4-1] user=sekondquad,db=dbt3,client=[local] LOG:  duration: 0.182 ms
2014-11-05 01:17:13 UTC [63685]: [5-1] user=sekondquad,db=dbt3,client=[local] LOG:  statement: EXPLAIN (ANALYZE, BUFFERS)
	select
		l_shipmode,
		sum(case
			when o_orderpriority = '1-URGENT'
				or o_orderpriority = '2-HIGH'
				then 1
			else 0
		end) as high_line_count,
		sum(case
			when o_orderpriority <> '1-URGENT'
				and o_orderpriority <> '2-HIGH'
				then 1
			else 0
		end) as low_line_count
	from
		orders,
		lineitem
	where
		o_orderkey = l_orderkey
		and l_shipmode in ('TRUCK', 'RAIL')
		and l_commitdate < l_receiptdate
		and l_shipdate < l_commitdate
		and l_receiptdate >= date '1993-01-01'
		and l_receiptdate < date '1993-01-01' + interval '1 year'
	group by
		l_shipmode
	order by
		l_shipmode;
2014-11-05 01:17:36 UTC [63698]: [1-1] user=[unknown],db=[unknown],client= LOG:  connection received: host=[local]
2014-11-05 01:17:36 UTC [63699]: [1-1] user=[unknown],db=[unknown],client= LOG:  connection received: host=[local]
2014-11-05 01:17:36 UTC [63698]: [2-1] user=sekondquad,db=dbt3,client=[local] LOG:  connection authorized: user=sekondquad database=dbt3
2014-11-05 01:17:36 UTC [63699]: [2-1] user=sekondquad,db=dbt3,client=[local] LOG:  connection authorized: user=sekondquad database=dbt3
2014-11-05 01:17:36 UTC [63700]: [1-1] user=[unknown],db=[unknown],client= LOG:  connection received: host=[local]
2014-11-05 01:17:36 UTC [63700]: [2-1] user=sekondquad,db=dbt3,client=[local] LOG:  connection authorized: user=sekondquad database=dbt3
2014-11-05 01:17:36 UTC [63701]: [1-1] user=[unknown],db=[unknown],client= LOG:  connection received: host=[local]
2014-11-05 01:17:36 UTC [63698]: [3-1] user=sekondquad,db=dbt3,client=[local] LOG:  statement: COPY (SELECT EXTRACT(EPOCH FROM TRANSACTION_TIMESTAMP()) AS ctime, a.schemaname, a.relname, a.indexrelname, idx_scan, idx_tup_read, idx_tup_fetch, idx_blks_read, idx_blks_hit FROM pg_stat_all_indexes a, pg_statio_all_indexes b WHERE a.indexrelid = b.indexrelid) TO STDOUT (FORMAT CSV);
2014-11-05 01:17:36 UTC [63699]: [3-1] user=sekondquad,db=dbt3,client=[local] LOG:  statement: COPY (SELECT EXTRACT(EPOCH FROM TRANSACTION_TIMESTAMP()) AS ctime, datname, numbackends, xact_commit, xact_rollback, blks_read, blks_hit, tup_returned, tup_fetched, tup_inserted, tup_updated, tup_deleted FROM pg_stat_database) TO STDOUT (FORMAT CSV);
2014-11-05 01:17:36 UTC [63702]: [1-1] user=[unknown],db=[unknown],client= LOG:  connection received: host=[local]
2014-11-05 01:17:36 UTC [63701]: [2-1] user=sekondquad,db=dbt3,client=[local] LOG:  connection authorized: user=sekondquad database=dbt3
2014-11-05 01:17:36 UTC [63700]: [3-1] user=sekondquad,db=dbt3,client=[local] LOG:  statement: COPY (SELECT EXTRACT(EPOCH FROM TRANSACTION_TIMESTAMP()) AS ctime, datname, pid, usesysid, usename, application_name, client_addr, client_port, backend_start, xact_start, query_start, waiting, query , state, state_change FROM pg_stat_activity) TO STDOUT (FORMAT CSV);
2014-11-05 01:17:36 UTC [63702]: [2-1] user=sekondquad,db=dbt3,client=[local] LOG:  connection authorized: user=sekondquad database=dbt3
2014-11-05 01:17:36 UTC [63701]: [3-1] user=sekondquad,db=dbt3,client=[local] LOG:  statement: COPY (SELECT EXTRACT(EPOCH FROM TRANSACTION_TIMESTAMP()) AS ctime, a.schemaname, a.relname, seq_scan, seq_tup_read, idx_scan, idx_tup_fetch, n_tup_ins, n_tup_upd, n_tup_del, n_tup_hot_upd, n_live_tup, n_dead_tup, heap_blks_read, heap_blks_hit, idx_blks_read, idx_blks_hit, toast_blks_read, toast_blks_hit, tidx_blks_read, tidx_blks_hit FROM pg_statio_all_tables a, pg_stat_all_tables b WHERE a.relid = b.relid) TO STDOUT (FORMAT CSV);
2014-11-05 01:17:36 UTC [63702]: [3-1] user=sekondquad,db=dbt3,client=[local] LOG:  statement: COPY (SELECT EXTRACT(EPOCH FROM TRANSACTION_TIMESTAMP()) AS ctime, relname, pid, mode, granted FROM pg_locks, pg_class WHERE relfilenode = relation ORDER BY relname) TO STDOUT (FORMAT CSV);
2014-11-05 01:17:36 UTC [63700]: [4-1] user=sekondquad,db=dbt3,client=[local] LOG:  duration: 5.521 ms
2014-11-05 01:17:36 UTC [63700]: [5-1] user=sekondquad,db=dbt3,client=[local] LOG:  disconnection: session time: 0:00:00.008 user=sekondquad database=dbt3 host=[local]
2014-11-05 01:17:36 UTC [63702]: [4-1] user=sekondquad,db=dbt3,client=[local] LOG:  duration: 5.475 ms
2014-11-05 01:17:36 UTC [63702]: [5-1] user=sekondquad,db=dbt3,client=[local] LOG:  disconnection: session time: 0:00:00.009 user=sekondquad database=dbt3 host=[local]
2014-11-05 01:17:36 UTC [63698]: [4-1] user=sekondquad,db=dbt3,client=[local] LOG:  duration: 10.367 ms
2014-11-05 01:17:36 UTC [63698]: [5-1] user=sekondquad,db=dbt3,client=[local] LOG:  disconnection: session time: 0:00:00.013 user=sekondquad database=dbt3 host=[local]
2014-11-05 01:17:36 UTC [63701]: [4-1] user=sekondquad,db=dbt3,client=[local] LOG:  duration: 8.730 ms
2014-11-05 01:17:36 UTC [63701]: [5-1] user=sekondquad,db=dbt3,client=[local] LOG:  disconnection: session time: 0:00:00.012 user=sekondquad database=dbt3 host=[local]
2014-11-05 01:17:36 UTC [63699]: [4-1] user=sekondquad,db=dbt3,client=[local] LOG:  duration: 13.784 ms
2014-11-05 01:17:36 UTC [63699]: [5-1] user=sekondquad,db=dbt3,client=[local] LOG:  disconnection: session time: 0:00:00.016 user=sekondquad database=dbt3 host=[local]
2014-11-05 01:17:38 UTC [63685]: [6-1] user=sekondquad,db=dbt3,client=[local] LOG:  duration: 25051.456 ms
2014-11-05 01:17:38 UTC [63685]: [7-1] user=sekondquad,db=dbt3,client=[local] LOG:  statement: COMMIT;
2014-11-05 01:17:38 UTC [63685]: [8-1] user=sekondquad,db=dbt3,client=[local] LOG:  duration: 0.150 ms
2014-11-05 01:17:38 UTC [63685]: [9-1] user=sekondquad,db=dbt3,client=[local] LOG:  disconnection: session time: 0:00:25.056 user=sekondquad database=dbt3 host=[local]
2014-11-05 01:17:38 UTC [63704]: [1-1] user=[unknown],db=[unknown],client= LOG:  connection received: host=[local]
2014-11-05 01:17:38 UTC [63704]: [2-1] user=sekondquad,db=dbt3,client=[local] LOG:  connection authorized: user=sekondquad database=dbt3
2014-11-05 01:17:38 UTC [63704]: [3-1] user=sekondquad,db=dbt3,client=[local] LOG:  statement: UPDATE time_statistics
	SET e_time = current_timestamp
	WHERE task_name = 'PERF.POWER.Q12';
2014-11-05 01:17:38 UTC [63704]: [4-1] user=sekondquad,db=dbt3,client=[local] LOG:  duration: 3.540 ms
2014-11-05 01:17:38 UTC [63704]: [5-1] user=sekondquad,db=dbt3,client=[local] LOG:  disconnection: session time: 0:00:00.007 user=sekondquad database=dbt3 host=[local]
2014-11-05 01:17:38 UTC [63708]: [1-1] user=[unknown],db=[unknown],client= LOG:  connection received: host=[local]
2014-11-05 01:17:38 UTC [63708]: [2-1] user=sekondquad,db=dbt3,client=[local] LOG:  connection authorized: user=sekondquad database=dbt3
2014-11-05 01:17:38 UTC [63708]: [3-1] user=sekondquad,db=dbt3,client=[local] LOG:  statement: INSERT INTO time_statistics (task_name, s_time)
	VALUES ('PERF.POWER.RF2', CURRENT_TIMESTAMP);
2014-11-05 01:17:38 UTC [63708]: [4-1] user=sekondquad,db=dbt3,client=[local] LOG:  duration: 1.788 ms
2014-11-05 01:17:38 UTC [63708]: [5-1] user=sekondquad,db=dbt3,client=[local] LOG:  disconnection: session time: 0:00:00.006 user=sekondquad database=dbt3 host=[local]
2014-11-05 01:17:38 UTC [63713]: [1-1] user=[unknown],db=[unknown],client= LOG:  connection received: host=[local]
2014-11-05 01:17:38 UTC [63713]: [2-1] user=sekondquad,db=dbt3,client=[local] LOG:  connection authorized: user=sekondquad database=dbt3
2014-11-05 01:17:38 UTC [63713]: [3-1] user=sekondquad,db=dbt3,client=[local] LOG:  statement: BEGIN;
2014-11-05 01:17:38 UTC [63713]: [4-1] user=sekondquad,db=dbt3,client=[local] LOG:  duration: 0.221 ms
2014-11-05 01:17:38 UTC [63713]: [5-1] user=sekondquad,db=dbt3,client=[local] LOG:  statement: CREATE TEMPORARY TABLE tmp_orderkey2 (orderkey numeric(10));
2014-11-05 01:17:38 UTC [63713]: [6-1] user=sekondquad,db=dbt3,client=[local] LOG:  duration: 4.061 ms
2014-11-05 01:17:38 UTC [63713]: [7-1] user=sekondquad,db=dbt3,client=[local] LOG:  statement: COPY tmp_orderkey2
	FROM '/home/sekondquad/dbt3/dss/delete.2' USING DELIMITERS '|';
2014-11-05 01:17:38 UTC [63713]: [8-1] user=sekondquad,db=dbt3,client=[local] LOG:  duration: 14.557 ms
2014-11-05 01:17:38 UTC [63713]: [9-1] user=sekondquad,db=dbt3,client=[local] LOG:  statement: CREATE INDEX
	ON tmp_orderkey2 (orderkey);
2014-11-05 01:17:38 UTC [63713]: [10-1] user=sekondquad,db=dbt3,client=[local] LOG:  duration: 7.246 ms
2014-11-05 01:17:38 UTC [63713]: [11-1] user=sekondquad,db=dbt3,client=[local] LOG:  statement: ANALYZE tmp_orderkey2;
2014-11-05 01:17:38 UTC [63713]: [12-1] user=sekondquad,db=dbt3,client=[local] LOG:  duration: 4.652 ms
2014-11-05 01:17:38 UTC [63713]: [13-1] user=sekondquad,db=dbt3,client=[local] LOG:  statement: DELETE FROM lineitem
	USING tmp_orderkey2
	WHERE l_orderkey = orderkey;
2014-11-05 01:18:01 UTC [63713]: [14-1] user=sekondquad,db=dbt3,client=[local] LOG:  duration: 22870.804 ms
2014-11-05 01:18:01 UTC [63713]: [15-1] user=sekondquad,db=dbt3,client=[local] LOG:  statement: DELETE FROM orders
	USING tmp_orderkey2
	WHERE o_orderkey = orderkey;
2014-11-05 01:18:08 UTC [63713]: [16-1] user=sekondquad,db=dbt3,client=[local] LOG:  duration: 7000.100 ms
2014-11-05 01:18:08 UTC [63713]: [17-1] user=sekondquad,db=dbt3,client=[local] LOG:  statement: COMMIT;
2014-11-05 01:18:08 UTC [63713]: [18-1] user=sekondquad,db=dbt3,client=[local] LOG:  duration: 0.552 ms
2014-11-05 01:18:08 UTC [63713]: [19-1] user=sekondquad,db=dbt3,client=[local] LOG:  disconnection: session time: 0:00:29.909 user=sekondquad database=dbt3 host=[local]
2014-11-05 01:18:08 UTC [63725]: [1-1] user=[unknown],db=[unknown],client= LOG:  connection received: host=[local]
2014-11-05 01:18:08 UTC [63725]: [2-1] user=sekondquad,db=dbt3,client=[local] LOG:  connection authorized: user=sekondquad database=dbt3
2014-11-05 01:18:08 UTC [63725]: [3-1] user=sekondquad,db=dbt3,client=[local] LOG:  statement: UPDATE time_statistics
	SET e_time = current_timestamp
	WHERE task_name = 'PERF.POWER.RF2';
2014-11-05 01:18:08 UTC [63725]: [4-1] user=sekondquad,db=dbt3,client=[local] LOG:  duration: 3.537 ms
2014-11-05 01:18:08 UTC [63725]: [5-1] user=sekondquad,db=dbt3,client=[local] LOG:  disconnection: session time: 0:00:00.008 user=sekondquad database=dbt3 host=[local]
2014-11-05 01:18:08 UTC [63729]: [1-1] user=[unknown],db=[unknown],client= LOG:  connection received: host=[local]
2014-11-05 01:18:08 UTC [63729]: [2-1] user=sekondquad,db=dbt3,client=[local] LOG:  connection authorized: user=sekondquad database=dbt3
2014-11-05 01:18:08 UTC [63729]: [3-1] user=sekondquad,db=dbt3,client=[local] LOG:  statement: UPDATE time_statistics
	SET e_time = current_timestamp
	WHERE task_name = 'PERF.POWER';
2014-11-05 01:18:08 UTC [63729]: [4-1] user=sekondquad,db=dbt3,client=[local] LOG:  duration: 3.034 ms
2014-11-05 01:18:08 UTC [63729]: [5-1] user=sekondquad,db=dbt3,client=[local] LOG:  disconnection: session time: 0:00:00.006 user=sekondquad database=dbt3 host=[local]
2014-11-05 01:18:08 UTC [63161]: [2-1] user=,db=,client= LOG:  received smart shutdown request
2014-11-05 01:18:08 UTC [63166]: [2-1] user=,db=,client= LOG:  autovacuum launcher shutting down
2014-11-05 01:18:08 UTC [63163]: [1-1] user=,db=,client= LOG:  shutting down
2014-11-05 01:18:08 UTC [63163]: [2-1] user=,db=,client= LOG:  checkpoint starting: shutdown immediate
2014-11-05 01:18:08 UTC [63163]: [3-1] user=,db=,client= LOG:  checkpoint complete: wrote 1355 buffers (0.1%); 0 transaction log file(s) added, 0 removed, 648 recycled; write=0.052 s, sync=0.006 s, total=0.073 s; sync files=49, longest=0.002 s, average=0.000 s
2014-11-05 01:18:08 UTC [63163]: [4-1] user=,db=,client= LOG:  database system is shut down