2014-11-03 23:27:52 UTC [2351]: [1-1] user=,db=,client= LOG:  database system was shut down at 2014-11-03 23:27:50 UTC
2014-11-03 23:27:52 UTC [2349]: [1-1] user=,db=,client= LOG:  database system is ready to accept connections
2014-11-03 23:27:52 UTC [2360]: [1-1] user=,db=,client= LOG:  autovacuum launcher started
2014-11-03 23:27:53 UTC [2362]: [1-1] user=[unknown],db=[unknown],client= LOG:  connection received: host=[local]
2014-11-03 23:27:53 UTC [2362]: [2-1] user=sekondquad,db=postgres,client=[local] LOG:  connection authorized: user=sekondquad database=postgres
2014-11-03 23:27:53 UTC [2362]: [3-1] user=sekondquad,db=postgres,client=[local] LOG:  disconnection: session time: 0:00:00.009 user=sekondquad database=postgres host=[local]
2014-11-03 23:27:53 UTC [2375]: [1-1] user=[unknown],db=[unknown],client= LOG:  connection received: host=[local]
2014-11-03 23:27:53 UTC [2376]: [1-1] user=[unknown],db=[unknown],client= LOG:  connection received: host=[local]
2014-11-03 23:27:53 UTC [2375]: [2-1] user=sekondquad,db=dbt3,client=[local] LOG:  connection authorized: user=sekondquad database=dbt3
2014-11-03 23:27:53 UTC [2376]: [2-1] user=sekondquad,db=dbt3,client=[local] LOG:  connection authorized: user=sekondquad database=dbt3
2014-11-03 23:27:53 UTC [2375]: [3-1] user=sekondquad,db=dbt3,client=[local] LOG:  statement: SHOW server_version_num;
2014-11-03 23:27:53 UTC [2376]: [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-03 23:27:53 UTC [2375]: [4-1] user=sekondquad,db=dbt3,client=[local] LOG:  duration: 0.385 ms
2014-11-03 23:27:53 UTC [2375]: [5-1] user=sekondquad,db=dbt3,client=[local] LOG:  disconnection: session time: 0:00:00.007 user=sekondquad database=dbt3 host=[local]
2014-11-03 23:27:53 UTC [2376]: [4-1] user=sekondquad,db=dbt3,client=[local] LOG:  duration: 1.448 ms
2014-11-03 23:27:53 UTC [2376]: [5-1] user=sekondquad,db=dbt3,client=[local] LOG:  disconnection: session time: 0:00:00.008 user=sekondquad database=dbt3 host=[local]
2014-11-03 23:27:53 UTC [2379]: [1-1] user=[unknown],db=[unknown],client= LOG:  connection received: host=[local]
2014-11-03 23:27:53 UTC [2379]: [2-1] user=sekondquad,db=dbt3,client=[local] LOG:  connection authorized: user=sekondquad database=dbt3
2014-11-03 23:27:53 UTC [2379]: [3-1] user=sekondquad,db=dbt3,client=[local] LOG:  statement: SELECT version();
2014-11-03 23:27:53 UTC [2379]: [4-1] user=sekondquad,db=dbt3,client=[local] LOG:  duration: 1.111 ms
2014-11-03 23:27:53 UTC [2379]: [5-1] user=sekondquad,db=dbt3,client=[local] LOG:  disconnection: session time: 0:00:00.004 user=sekondquad database=dbt3 host=[local]
2014-11-03 23:27:53 UTC [2382]: [1-1] user=[unknown],db=[unknown],client= LOG:  connection received: host=[local]
2014-11-03 23:27:53 UTC [2382]: [2-1] user=sekondquad,db=dbt3,client=[local] LOG:  connection authorized: user=sekondquad database=dbt3
2014-11-03 23:27:53 UTC [2382]: [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-03 23:27:53 UTC [2382]: [4-1] user=sekondquad,db=dbt3,client=[local] LOG:  duration: 0.876 ms
2014-11-03 23:27:53 UTC [2382]: [5-1] user=sekondquad,db=dbt3,client=[local] LOG:  disconnection: session time: 0:00:00.003 user=sekondquad database=dbt3 host=[local]
2014-11-03 23:27:53 UTC [2385]: [1-1] user=[unknown],db=[unknown],client= LOG:  connection received: host=[local]
2014-11-03 23:27:53 UTC [2385]: [2-1] user=sekondquad,db=dbt3,client=[local] LOG:  connection authorized: user=sekondquad database=dbt3
2014-11-03 23:27:53 UTC [2385]: [3-1] user=sekondquad,db=dbt3,client=[local] LOG:  statement: SHOW ALL
2014-11-03 23:27:53 UTC [2385]: [4-1] user=sekondquad,db=dbt3,client=[local] LOG:  duration: 0.725 ms
2014-11-03 23:27:53 UTC [2385]: [5-1] user=sekondquad,db=dbt3,client=[local] LOG:  disconnection: session time: 0:00:00.003 user=sekondquad database=dbt3 host=[local]
2014-11-03 23:27:53 UTC [2388]: [1-1] user=[unknown],db=[unknown],client= LOG:  connection received: host=[local]
2014-11-03 23:27:53 UTC [2388]: [2-1] user=sekondquad,db=dbt3,client=[local] LOG:  connection authorized: user=sekondquad database=dbt3
2014-11-03 23:27:53 UTC [2388]: [3-1] user=sekondquad,db=dbt3,client=[local] LOG:  statement: SELECT nextval('dataset');
2014-11-03 23:27:53 UTC [2390]: [1-1] user=[unknown],db=[unknown],client= LOG:  connection received: host=[local]
2014-11-03 23:27:53 UTC [2388]: [4-1] user=sekondquad,db=dbt3,client=[local] LOG:  duration: 0.971 ms
2014-11-03 23:27:53 UTC [2388]: [5-1] user=sekondquad,db=dbt3,client=[local] LOG:  disconnection: session time: 0:00:00.003 user=sekondquad database=dbt3 host=[local]
2014-11-03 23:27:53 UTC [2390]: [2-1] user=sekondquad,db=dbt3,client=[local] LOG:  connection authorized: user=sekondquad database=dbt3
2014-11-03 23:27:53 UTC [2390]: [3-1] user=sekondquad,db=dbt3,client=[local] LOG:  statement: SELECT tablename FROM pg_tables WHERE schemaname = 'public'ORDER BY tablename;
2014-11-03 23:27:53 UTC [2390]: [4-1] user=sekondquad,db=dbt3,client=[local] LOG:  duration: 6.658 ms
2014-11-03 23:27:53 UTC [2390]: [5-1] user=sekondquad,db=dbt3,client=[local] LOG:  disconnection: session time: 0:00:00.010 user=sekondquad database=dbt3 host=[local]
2014-11-03 23:27:53 UTC [2393]: [1-1] user=[unknown],db=[unknown],client= LOG:  connection received: host=[local]
2014-11-03 23:27:53 UTC [2393]: [2-1] user=sekondquad,db=dbt3,client=[local] LOG:  connection authorized: user=sekondquad database=dbt3
2014-11-03 23:27:53 UTC [2393]: [3-1] user=sekondquad,db=dbt3,client=[local] LOG:  statement: SELECT indexname FROM pg_indexes WHERE schemaname = 'public' ORDER BY indexname;
2014-11-03 23:27:53 UTC [2393]: [4-1] user=sekondquad,db=dbt3,client=[local] LOG:  duration: 3.717 ms
2014-11-03 23:27:53 UTC [2393]: [5-1] user=sekondquad,db=dbt3,client=[local] LOG:  disconnection: session time: 0:00:00.005 user=sekondquad database=dbt3 host=[local]
2014-11-03 23:27:53 UTC [2466]: [1-1] user=[unknown],db=[unknown],client= LOG:  connection received: host=[local]
2014-11-03 23:27:53 UTC [2467]: [1-1] user=[unknown],db=[unknown],client= LOG:  connection received: host=[local]
2014-11-03 23:27:53 UTC [2466]: [2-1] user=sekondquad,db=dbt3,client=[local] LOG:  connection authorized: user=sekondquad database=dbt3
2014-11-03 23:27:53 UTC [2467]: [2-1] user=sekondquad,db=dbt3,client=[local] LOG:  connection authorized: user=sekondquad database=dbt3
2014-11-03 23:27:53 UTC [2468]: [1-1] user=[unknown],db=[unknown],client= LOG:  connection received: host=[local]
2014-11-03 23:27:53 UTC [2469]: [1-1] user=[unknown],db=[unknown],client= LOG:  connection received: host=[local]
2014-11-03 23:27:53 UTC [2470]: [1-1] user=[unknown],db=[unknown],client= LOG:  connection received: host=[local]
2014-11-03 23:27:53 UTC [2468]: [2-1] user=sekondquad,db=dbt3,client=[local] LOG:  connection authorized: user=sekondquad database=dbt3
2014-11-03 23:27:53 UTC [2469]: [2-1] user=sekondquad,db=dbt3,client=[local] LOG:  connection authorized: user=sekondquad database=dbt3
2014-11-03 23:27:53 UTC [2470]: [2-1] user=sekondquad,db=dbt3,client=[local] LOG:  connection authorized: user=sekondquad database=dbt3
2014-11-03 23:27:53 UTC [2466]: [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-03 23:27:53 UTC [2467]: [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-03 23:27:53 UTC [2468]: [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-03 23:27:53 UTC [2469]: [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-03 23:27:53 UTC [2470]: [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-03 23:27:53 UTC [2467]: [4-1] user=sekondquad,db=dbt3,client=[local] LOG:  duration: 3.053 ms
2014-11-03 23:27:53 UTC [2466]: [4-1] user=sekondquad,db=dbt3,client=[local] LOG:  duration: 3.319 ms
2014-11-03 23:27:53 UTC [2467]: [5-1] user=sekondquad,db=dbt3,client=[local] LOG:  disconnection: session time: 0:00:00.005 user=sekondquad database=dbt3 host=[local]
2014-11-03 23:27:53 UTC [2466]: [5-1] user=sekondquad,db=dbt3,client=[local] LOG:  disconnection: session time: 0:00:00.006 user=sekondquad database=dbt3 host=[local]
2014-11-03 23:27:53 UTC [2468]: [4-1] user=sekondquad,db=dbt3,client=[local] LOG:  duration: 8.846 ms
2014-11-03 23:27:53 UTC [2468]: [5-1] user=sekondquad,db=dbt3,client=[local] LOG:  disconnection: session time: 0:00:00.011 user=sekondquad database=dbt3 host=[local]
2014-11-03 23:27:53 UTC [2469]: [4-1] user=sekondquad,db=dbt3,client=[local] LOG:  duration: 10.218 ms
2014-11-03 23:27:53 UTC [2469]: [5-1] user=sekondquad,db=dbt3,client=[local] LOG:  disconnection: session time: 0:00:00.012 user=sekondquad database=dbt3 host=[local]
2014-11-03 23:27:53 UTC [2470]: [4-1] user=sekondquad,db=dbt3,client=[local] LOG:  duration: 12.587 ms
2014-11-03 23:27:53 UTC [2470]: [5-1] user=sekondquad,db=dbt3,client=[local] LOG:  disconnection: session time: 0:00:00.015 user=sekondquad database=dbt3 host=[local]
2014-11-03 23:27:59 UTC [2474]: [1-1] user=[unknown],db=[unknown],client= LOG:  connection received: host=[local]
2014-11-03 23:27:59 UTC [2474]: [2-1] user=sekondquad,db=dbt3,client=[local] LOG:  connection authorized: user=sekondquad database=dbt3
2014-11-03 23:27:59 UTC [2474]: [3-1] user=sekondquad,db=dbt3,client=[local] LOG:  statement: BEGIN;
2014-11-03 23:27:59 UTC [2474]: [4-1] user=sekondquad,db=dbt3,client=[local] LOG:  duration: 0.238 ms
2014-11-03 23:27:59 UTC [2474]: [5-1] user=sekondquad,db=dbt3,client=[local] LOG:  statement: COPY lineitem
	FROM '/home/sekondquad/dbt3/dss/lineitem.tbl.u2'
	USING DELIMITERS '|';
2014-11-03 23:28:09 UTC [2474]: [6-1] user=sekondquad,db=dbt3,client=[local] LOG:  duration: 9252.172 ms
2014-11-03 23:28:09 UTC [2474]: [7-1] user=sekondquad,db=dbt3,client=[local] LOG:  statement: COPY orders
	FROM '/home/sekondquad/dbt3/dss/orders.tbl.u2'
	USING DELIMITERS '|';
2014-11-03 23:28:09 UTC [2474]: [8-1] user=sekondquad,db=dbt3,client=[local] LOG:  duration: 361.838 ms
2014-11-03 23:28:09 UTC [2474]: [9-1] user=sekondquad,db=dbt3,client=[local] LOG:  statement: COMMIT;
2014-11-03 23:28:09 UTC [2474]: [10-1] user=sekondquad,db=dbt3,client=[local] LOG:  duration: 31.130 ms
2014-11-03 23:28:09 UTC [2474]: [11-1] user=sekondquad,db=dbt3,client=[local] LOG:  disconnection: session time: 0:00:09.650 user=sekondquad database=dbt3 host=[local]
2014-11-03 23:28:09 UTC [2482]: [1-1] user=[unknown],db=[unknown],client= LOG:  connection received: host=[local]
2014-11-03 23:28:09 UTC [2482]: [2-1] user=sekondquad,db=dbt3,client=[local] LOG:  connection authorized: user=sekondquad database=dbt3
2014-11-03 23:28:09 UTC [2482]: [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-03 23:28:09 UTC [2482]: [4-1] user=sekondquad,db=dbt3,client=[local] LOG:  duration: 3.705 ms
2014-11-03 23:28:09 UTC [2482]: [5-1] user=sekondquad,db=dbt3,client=[local] LOG:  disconnection: session time: 0:00:00.007 user=sekondquad database=dbt3 host=[local]
2014-11-03 23:28:09 UTC [2492]: [1-1] user=[unknown],db=[unknown],client= LOG:  connection received: host=[local]
2014-11-03 23:28:09 UTC [2492]: [2-1] user=sekondquad,db=dbt3,client=[local] LOG:  connection authorized: user=sekondquad database=dbt3
2014-11-03 23:28:09 UTC [2492]: [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-03 23:28:09 UTC [2492]: [4-1] user=sekondquad,db=dbt3,client=[local] LOG:  duration: 1.374 ms
2014-11-03 23:28:09 UTC [2492]: [5-1] user=sekondquad,db=dbt3,client=[local] LOG:  disconnection: session time: 0:00:00.004 user=sekondquad database=dbt3 host=[local]
2014-11-03 23:28:09 UTC [2494]: [1-1] user=[unknown],db=[unknown],client= LOG:  connection received: host=[local]
2014-11-03 23:28:09 UTC [2494]: [2-1] user=sekondquad,db=dbt3,client=[local] LOG:  connection authorized: user=sekondquad database=dbt3
2014-11-03 23:28:09 UTC [2494]: [3-1] user=sekondquad,db=dbt3,client=[local] LOG:  statement: BEGIN;
2014-11-03 23:28:09 UTC [2494]: [4-1] user=sekondquad,db=dbt3,client=[local] LOG:  duration: 0.167 ms
2014-11-03 23:28:09 UTC [2494]: [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-09-01'
		and l_shipdate < cast(date '1993-09-01' + interval '1 month' as date);
2014-11-03 23:28:17 UTC [2494]: [6-1] user=sekondquad,db=dbt3,client=[local] LOG:  duration: 8281.788 ms
2014-11-03 23:28:17 UTC [2494]: [7-1] user=sekondquad,db=dbt3,client=[local] LOG:  statement: COMMIT;
2014-11-03 23:28:17 UTC [2494]: [8-1] user=sekondquad,db=dbt3,client=[local] LOG:  duration: 0.127 ms
2014-11-03 23:28:17 UTC [2494]: [9-1] user=sekondquad,db=dbt3,client=[local] LOG:  disconnection: session time: 0:00:08.286 user=sekondquad database=dbt3 host=[local]
2014-11-03 23:28:17 UTC [2499]: [1-1] user=[unknown],db=[unknown],client= LOG:  connection received: host=[local]
2014-11-03 23:28:17 UTC [2499]: [2-1] user=sekondquad,db=dbt3,client=[local] LOG:  connection authorized: user=sekondquad database=dbt3
2014-11-03 23:28:17 UTC [2499]: [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-03 23:28:17 UTC [2499]: [4-1] user=sekondquad,db=dbt3,client=[local] LOG:  duration: 3.507 ms
2014-11-03 23:28:17 UTC [2499]: [5-1] user=sekondquad,db=dbt3,client=[local] LOG:  disconnection: session time: 0:00:00.006 user=sekondquad database=dbt3 host=[local]
2014-11-03 23:28:17 UTC [2505]: [1-1] user=[unknown],db=[unknown],client= LOG:  connection received: host=[local]
2014-11-03 23:28:17 UTC [2505]: [2-1] user=sekondquad,db=dbt3,client=[local] LOG:  connection authorized: user=sekondquad database=dbt3
2014-11-03 23:28:17 UTC [2505]: [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-03 23:28:17 UTC [2505]: [4-1] user=sekondquad,db=dbt3,client=[local] LOG:  duration: 1.380 ms
2014-11-03 23:28:17 UTC [2505]: [5-1] user=sekondquad,db=dbt3,client=[local] LOG:  disconnection: session time: 0:00:00.005 user=sekondquad database=dbt3 host=[local]
2014-11-03 23:28:17 UTC [2507]: [1-1] user=[unknown],db=[unknown],client= LOG:  connection received: host=[local]
2014-11-03 23:28:17 UTC [2507]: [2-1] user=sekondquad,db=dbt3,client=[local] LOG:  connection authorized: user=sekondquad database=dbt3
2014-11-03 23:28:17 UTC [2507]: [3-1] user=sekondquad,db=dbt3,client=[local] LOG:  statement: BEGIN;
2014-11-03 23:28:17 UTC [2507]: [4-1] user=sekondquad,db=dbt3,client=[local] LOG:  duration: 0.170 ms
2014-11-03 23:28:17 UTC [2507]: [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 = 28
		and p_type like '%TIN'
		and s_nationkey = n_nationkey
		and n_regionkey = r_regionkey
		and r_name = 'EUROPE'
		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 = 'EUROPE'
		)
	order by
		s_acctbal desc,
		n_name,
		s_name,
		p_partkey
	LIMIT 100;
2014-11-03 23:28:27 UTC [2507]: [6-1] user=sekondquad,db=dbt3,client=[local] LOG:  duration: 9684.443 ms
2014-11-03 23:28:27 UTC [2507]: [7-1] user=sekondquad,db=dbt3,client=[local] LOG:  statement: COMMIT;
2014-11-03 23:28:27 UTC [2507]: [8-1] user=sekondquad,db=dbt3,client=[local] LOG:  duration: 0.120 ms
2014-11-03 23:28:27 UTC [2507]: [9-1] user=sekondquad,db=dbt3,client=[local] LOG:  disconnection: session time: 0:00:09.689 user=sekondquad database=dbt3 host=[local]
2014-11-03 23:28:27 UTC [2512]: [1-1] user=[unknown],db=[unknown],client= LOG:  connection received: host=[local]
2014-11-03 23:28:27 UTC [2512]: [2-1] user=sekondquad,db=dbt3,client=[local] LOG:  connection authorized: user=sekondquad database=dbt3
2014-11-03 23:28:27 UTC [2512]: [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-03 23:28:27 UTC [2512]: [4-1] user=sekondquad,db=dbt3,client=[local] LOG:  duration: 3.409 ms
2014-11-03 23:28:27 UTC [2512]: [5-1] user=sekondquad,db=dbt3,client=[local] LOG:  disconnection: session time: 0:00:00.007 user=sekondquad database=dbt3 host=[local]
2014-11-03 23:28:27 UTC [2518]: [1-1] user=[unknown],db=[unknown],client= LOG:  connection received: host=[local]
2014-11-03 23:28:27 UTC [2518]: [2-1] user=sekondquad,db=dbt3,client=[local] LOG:  connection authorized: user=sekondquad database=dbt3
2014-11-03 23:28:27 UTC [2518]: [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-03 23:28:27 UTC [2518]: [4-1] user=sekondquad,db=dbt3,client=[local] LOG:  duration: 1.453 ms
2014-11-03 23:28:27 UTC [2518]: [5-1] user=sekondquad,db=dbt3,client=[local] LOG:  disconnection: session time: 0:00:00.004 user=sekondquad database=dbt3 host=[local]
2014-11-03 23:28:27 UTC [2520]: [1-1] user=[unknown],db=[unknown],client= LOG:  connection received: host=[local]
2014-11-03 23:28:27 UTC [2520]: [2-1] user=sekondquad,db=dbt3,client=[local] LOG:  connection authorized: user=sekondquad database=dbt3
2014-11-03 23:28:27 UTC [2520]: [3-1] user=sekondquad,db=dbt3,client=[local] LOG:  statement: BEGIN;
2014-11-03 23:28:27 UTC [2520]: [4-1] user=sekondquad,db=dbt3,client=[local] LOG:  duration: 0.171 ms
2014-11-03 23:28:27 UTC [2520]: [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 '%dark%'
		) as profit
	group by
		nation,
		o_year
	order by
		nation,
		o_year desc;
2014-11-03 23:28:53 UTC [2536]: [1-1] user=[unknown],db=[unknown],client= LOG:  connection received: host=[local]
2014-11-03 23:28:53 UTC [2537]: [1-1] user=[unknown],db=[unknown],client= LOG:  connection received: host=[local]
2014-11-03 23:28:53 UTC [2538]: [1-1] user=[unknown],db=[unknown],client= LOG:  connection received: host=[local]
2014-11-03 23:28:53 UTC [2536]: [2-1] user=sekondquad,db=dbt3,client=[local] LOG:  connection authorized: user=sekondquad database=dbt3
2014-11-03 23:28:53 UTC [2537]: [2-1] user=sekondquad,db=dbt3,client=[local] LOG:  connection authorized: user=sekondquad database=dbt3
2014-11-03 23:28:53 UTC [2540]: [1-1] user=[unknown],db=[unknown],client= LOG:  connection received: host=[local]
2014-11-03 23:28:53 UTC [2538]: [2-1] user=sekondquad,db=dbt3,client=[local] LOG:  connection authorized: user=sekondquad database=dbt3
2014-11-03 23:28:53 UTC [2540]: [2-1] user=sekondquad,db=dbt3,client=[local] LOG:  connection authorized: user=sekondquad database=dbt3
2014-11-03 23:28:53 UTC [2539]: [1-1] user=[unknown],db=[unknown],client= LOG:  connection received: host=[local]
2014-11-03 23:28:53 UTC [2539]: [2-1] user=sekondquad,db=dbt3,client=[local] LOG:  connection authorized: user=sekondquad database=dbt3
2014-11-03 23:28:53 UTC [2536]: [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-03 23:28:53 UTC [2540]: [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-03 23:28:53 UTC [2537]: [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-03 23:28:53 UTC [2538]: [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-03 23:28:53 UTC [2539]: [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-03 23:28:53 UTC [2537]: [4-1] user=sekondquad,db=dbt3,client=[local] LOG:  duration: 3.406 ms
2014-11-03 23:28:53 UTC [2537]: [5-1] user=sekondquad,db=dbt3,client=[local] LOG:  disconnection: session time: 0:00:00.008 user=sekondquad database=dbt3 host=[local]
2014-11-03 23:28:53 UTC [2536]: [4-1] user=sekondquad,db=dbt3,client=[local] LOG:  duration: 5.970 ms
2014-11-03 23:28:53 UTC [2536]: [5-1] user=sekondquad,db=dbt3,client=[local] LOG:  disconnection: session time: 0:00:00.010 user=sekondquad database=dbt3 host=[local]
2014-11-03 23:28:53 UTC [2540]: [4-1] user=sekondquad,db=dbt3,client=[local] LOG:  duration: 8.421 ms
2014-11-03 23:28:53 UTC [2540]: [5-1] user=sekondquad,db=dbt3,client=[local] LOG:  disconnection: session time: 0:00:00.012 user=sekondquad database=dbt3 host=[local]
2014-11-03 23:28:53 UTC [2538]: [4-1] user=sekondquad,db=dbt3,client=[local] LOG:  duration: 9.598 ms
2014-11-03 23:28:53 UTC [2538]: [5-1] user=sekondquad,db=dbt3,client=[local] LOG:  disconnection: session time: 0:00:00.014 user=sekondquad database=dbt3 host=[local]
2014-11-03 23:28:53 UTC [2539]: [4-1] user=sekondquad,db=dbt3,client=[local] LOG:  duration: 13.903 ms
2014-11-03 23:28:53 UTC [2539]: [5-1] user=sekondquad,db=dbt3,client=[local] LOG:  disconnection: session time: 0:00:00.017 user=sekondquad database=dbt3 host=[local]
2014-11-03 23:29:53 UTC [2633]: [1-1] user=[unknown],db=[unknown],client= LOG:  connection received: host=[local]
2014-11-03 23:29:53 UTC [2634]: [1-1] user=[unknown],db=[unknown],client= LOG:  connection received: host=[local]
2014-11-03 23:29:53 UTC [2633]: [2-1] user=sekondquad,db=dbt3,client=[local] LOG:  connection authorized: user=sekondquad database=dbt3
2014-11-03 23:29:53 UTC [2635]: [1-1] user=[unknown],db=[unknown],client= LOG:  connection received: host=[local]
2014-11-03 23:29:53 UTC [2634]: [2-1] user=sekondquad,db=dbt3,client=[local] LOG:  connection authorized: user=sekondquad database=dbt3
2014-11-03 23:29:53 UTC [2636]: [1-1] user=[unknown],db=[unknown],client= LOG:  connection received: host=[local]
2014-11-03 23:29:53 UTC [2637]: [1-1] user=[unknown],db=[unknown],client= LOG:  connection received: host=[local]
2014-11-03 23:29:53 UTC [2635]: [2-1] user=sekondquad,db=dbt3,client=[local] LOG:  connection authorized: user=sekondquad database=dbt3
2014-11-03 23:29:53 UTC [2636]: [2-1] user=sekondquad,db=dbt3,client=[local] LOG:  connection authorized: user=sekondquad database=dbt3
2014-11-03 23:29:53 UTC [2637]: [2-1] user=sekondquad,db=dbt3,client=[local] LOG:  connection authorized: user=sekondquad database=dbt3
2014-11-03 23:29:53 UTC [2633]: [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-03 23:29:53 UTC [2634]: [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-03 23:29:53 UTC [2635]: [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-03 23:29:53 UTC [2636]: [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-03 23:29:53 UTC [2637]: [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-03 23:29:53 UTC [2634]: [4-1] user=sekondquad,db=dbt3,client=[local] LOG:  duration: 6.459 ms
2014-11-03 23:29:53 UTC [2634]: [5-1] user=sekondquad,db=dbt3,client=[local] LOG:  disconnection: session time: 0:00:00.011 user=sekondquad database=dbt3 host=[local]
2014-11-03 23:29:53 UTC [2633]: [4-1] user=sekondquad,db=dbt3,client=[local] LOG:  duration: 7.329 ms
2014-11-03 23:29:53 UTC [2633]: [5-1] user=sekondquad,db=dbt3,client=[local] LOG:  disconnection: session time: 0:00:00.012 user=sekondquad database=dbt3 host=[local]
2014-11-03 23:29:53 UTC [2635]: [4-1] user=sekondquad,db=dbt3,client=[local] LOG:  duration: 11.506 ms
2014-11-03 23:29:53 UTC [2635]: [5-1] user=sekondquad,db=dbt3,client=[local] LOG:  disconnection: session time: 0:00:00.015 user=sekondquad database=dbt3 host=[local]
2014-11-03 23:29:53 UTC [2636]: [4-1] user=sekondquad,db=dbt3,client=[local] LOG:  duration: 12.465 ms
2014-11-03 23:29:53 UTC [2636]: [5-1] user=sekondquad,db=dbt3,client=[local] LOG:  disconnection: session time: 0:00:00.016 user=sekondquad database=dbt3 host=[local]
2014-11-03 23:29:53 UTC [2637]: [4-1] user=sekondquad,db=dbt3,client=[local] LOG:  duration: 15.347 ms
2014-11-03 23:29:53 UTC [2637]: [5-1] user=sekondquad,db=dbt3,client=[local] LOG:  disconnection: session time: 0:00:00.018 user=sekondquad database=dbt3 host=[local]
2014-11-03 23:30:00 UTC [2520]: [6-1] user=sekondquad,db=dbt3,client=[local] LOG:  duration: 93356.266 ms
2014-11-03 23:30:00 UTC [2520]: [7-1] user=sekondquad,db=dbt3,client=[local] LOG:  statement: COMMIT;
2014-11-03 23:30:00 UTC [2520]: [8-1] user=sekondquad,db=dbt3,client=[local] LOG:  duration: 0.622 ms
2014-11-03 23:30:00 UTC [2520]: [9-1] user=sekondquad,db=dbt3,client=[local] LOG:  disconnection: session time: 0:01:33.362 user=sekondquad database=dbt3 host=[local]
2014-11-03 23:30:00 UTC [2639]: [1-1] user=[unknown],db=[unknown],client= LOG:  connection received: host=[local]
2014-11-03 23:30:00 UTC [2639]: [2-1] user=sekondquad,db=dbt3,client=[local] LOG:  connection authorized: user=sekondquad database=dbt3
2014-11-03 23:30:00 UTC [2639]: [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-03 23:30:00 UTC [2639]: [4-1] user=sekondquad,db=dbt3,client=[local] LOG:  duration: 2.671 ms
2014-11-03 23:30:00 UTC [2639]: [5-1] user=sekondquad,db=dbt3,client=[local] LOG:  disconnection: session time: 0:00:00.006 user=sekondquad database=dbt3 host=[local]
2014-11-03 23:30:00 UTC [2645]: [1-1] user=[unknown],db=[unknown],client= LOG:  connection received: host=[local]
2014-11-03 23:30:00 UTC [2645]: [2-1] user=sekondquad,db=dbt3,client=[local] LOG:  connection authorized: user=sekondquad database=dbt3
2014-11-03 23:30:00 UTC [2645]: [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-03 23:30:00 UTC [2645]: [4-1] user=sekondquad,db=dbt3,client=[local] LOG:  duration: 1.134 ms
2014-11-03 23:30:00 UTC [2645]: [5-1] user=sekondquad,db=dbt3,client=[local] LOG:  disconnection: session time: 0:00:00.003 user=sekondquad database=dbt3 host=[local]
2014-11-03 23:30:00 UTC [2647]: [1-1] user=[unknown],db=[unknown],client= LOG:  connection received: host=[local]
2014-11-03 23:30:00 UTC [2647]: [2-1] user=sekondquad,db=dbt3,client=[local] LOG:  connection authorized: user=sekondquad database=dbt3
2014-11-03 23:30:01 UTC [2647]: [3-1] user=sekondquad,db=dbt3,client=[local] LOG:  statement: BEGIN;
2014-11-03 23:30:01 UTC [2647]: [4-1] user=sekondquad,db=dbt3,client=[local] LOG:  duration: 0.097 ms
2014-11-03 23:30:01 UTC [2647]: [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 'gainsboro%'
				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 = 'PERU'
	order by
		s_name;
2014-11-03 23:30:08 UTC [2647]: [6-1] user=sekondquad,db=dbt3,client=[local] LOG:  duration: 7702.386 ms
2014-11-03 23:30:08 UTC [2647]: [7-1] user=sekondquad,db=dbt3,client=[local] LOG:  statement: COMMIT;
2014-11-03 23:30:08 UTC [2647]: [8-1] user=sekondquad,db=dbt3,client=[local] LOG:  duration: 0.131 ms
2014-11-03 23:30:08 UTC [2647]: [9-1] user=sekondquad,db=dbt3,client=[local] LOG:  disconnection: session time: 0:00:07.706 user=sekondquad database=dbt3 host=[local]
2014-11-03 23:30:08 UTC [2656]: [1-1] user=[unknown],db=[unknown],client= LOG:  connection received: host=[local]
2014-11-03 23:30:08 UTC [2656]: [2-1] user=sekondquad,db=dbt3,client=[local] LOG:  connection authorized: user=sekondquad database=dbt3
2014-11-03 23:30:08 UTC [2656]: [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-03 23:30:08 UTC [2656]: [4-1] user=sekondquad,db=dbt3,client=[local] LOG:  duration: 3.914 ms
2014-11-03 23:30:08 UTC [2656]: [5-1] user=sekondquad,db=dbt3,client=[local] LOG:  disconnection: session time: 0:00:00.008 user=sekondquad database=dbt3 host=[local]
2014-11-03 23:30:08 UTC [2662]: [1-1] user=[unknown],db=[unknown],client= LOG:  connection received: host=[local]
2014-11-03 23:30:08 UTC [2662]: [2-1] user=sekondquad,db=dbt3,client=[local] LOG:  connection authorized: user=sekondquad database=dbt3
2014-11-03 23:30:08 UTC [2662]: [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-03 23:30:08 UTC [2662]: [4-1] user=sekondquad,db=dbt3,client=[local] LOG:  duration: 1.555 ms
2014-11-03 23:30:08 UTC [2662]: [5-1] user=sekondquad,db=dbt3,client=[local] LOG:  disconnection: session time: 0:00:00.005 user=sekondquad database=dbt3 host=[local]
2014-11-03 23:30:08 UTC [2664]: [1-1] user=[unknown],db=[unknown],client= LOG:  connection received: host=[local]
2014-11-03 23:30:08 UTC [2664]: [2-1] user=sekondquad,db=dbt3,client=[local] LOG:  connection authorized: user=sekondquad database=dbt3
2014-11-03 23:30:08 UTC [2664]: [3-1] user=sekondquad,db=dbt3,client=[local] LOG:  statement: BEGIN;
2014-11-03 23:30:08 UTC [2664]: [4-1] user=sekondquad,db=dbt3,client=[local] LOG:  duration: 0.168 ms
2014-11-03 23:30:08 UTC [2664]: [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 '1996-01-01'
		and l_shipdate < cast(date '1996-01-01' + interval '1 year' as date)
		and l_discount between 0.09 - 0.01 and 0.09 + 0.01
		and l_quantity < 25;
2014-11-03 23:30:22 UTC [2664]: [6-1] user=sekondquad,db=dbt3,client=[local] LOG:  duration: 14134.472 ms
2014-11-03 23:30:22 UTC [2664]: [7-1] user=sekondquad,db=dbt3,client=[local] LOG:  statement: COMMIT;
2014-11-03 23:30:22 UTC [2664]: [8-1] user=sekondquad,db=dbt3,client=[local] LOG:  duration: 0.113 ms
2014-11-03 23:30:22 UTC [2664]: [9-1] user=sekondquad,db=dbt3,client=[local] LOG:  disconnection: session time: 0:00:14.139 user=sekondquad database=dbt3 host=[local]
2014-11-03 23:30:22 UTC [2672]: [1-1] user=[unknown],db=[unknown],client= LOG:  connection received: host=[local]
2014-11-03 23:30:22 UTC [2672]: [2-1] user=sekondquad,db=dbt3,client=[local] LOG:  connection authorized: user=sekondquad database=dbt3
2014-11-03 23:30:22 UTC [2672]: [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-03 23:30:22 UTC [2672]: [4-1] user=sekondquad,db=dbt3,client=[local] LOG:  duration: 3.850 ms
2014-11-03 23:30:22 UTC [2672]: [5-1] user=sekondquad,db=dbt3,client=[local] LOG:  disconnection: session time: 0:00:00.007 user=sekondquad database=dbt3 host=[local]
2014-11-03 23:30:22 UTC [2678]: [1-1] user=[unknown],db=[unknown],client= LOG:  connection received: host=[local]
2014-11-03 23:30:22 UTC [2678]: [2-1] user=sekondquad,db=dbt3,client=[local] LOG:  connection authorized: user=sekondquad database=dbt3
2014-11-03 23:30:22 UTC [2678]: [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-03 23:30:22 UTC [2678]: [4-1] user=sekondquad,db=dbt3,client=[local] LOG:  duration: 2.070 ms
2014-11-03 23:30:22 UTC [2678]: [5-1] user=sekondquad,db=dbt3,client=[local] LOG:  disconnection: session time: 0:00:00.005 user=sekondquad database=dbt3 host=[local]
2014-11-03 23:30:22 UTC [2680]: [1-1] user=[unknown],db=[unknown],client= LOG:  connection received: host=[local]
2014-11-03 23:30:22 UTC [2680]: [2-1] user=sekondquad,db=dbt3,client=[local] LOG:  connection authorized: user=sekondquad database=dbt3
2014-11-03 23:30:22 UTC [2680]: [3-1] user=sekondquad,db=dbt3,client=[local] LOG:  statement: BEGIN;
2014-11-03 23:30:22 UTC [2680]: [4-1] user=sekondquad,db=dbt3,client=[local] LOG:  duration: 0.167 ms
2014-11-03 23:30:22 UTC [2680]: [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#35'
		and p_container = 'LG CAN'
		and l_quantity < (
			select
				0.2 * avg(l_quantity)
			from
				lineitem
			where
				l_partkey = p_partkey
		);
2014-11-03 23:30:23 UTC [2680]: [6-1] user=sekondquad,db=dbt3,client=[local] LOG:  duration: 446.601 ms
2014-11-03 23:30:23 UTC [2680]: [7-1] user=sekondquad,db=dbt3,client=[local] LOG:  statement: COMMIT;
2014-11-03 23:30:23 UTC [2680]: [8-1] user=sekondquad,db=dbt3,client=[local] LOG:  duration: 0.100 ms
2014-11-03 23:30:23 UTC [2680]: [9-1] user=sekondquad,db=dbt3,client=[local] LOG:  disconnection: session time: 0:00:00.451 user=sekondquad database=dbt3 host=[local]
2014-11-03 23:30:23 UTC [2682]: [1-1] user=[unknown],db=[unknown],client= LOG:  connection received: host=[local]
2014-11-03 23:30:23 UTC [2682]: [2-1] user=sekondquad,db=dbt3,client=[local] LOG:  connection authorized: user=sekondquad database=dbt3
2014-11-03 23:30:23 UTC [2682]: [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-03 23:30:23 UTC [2682]: [4-1] user=sekondquad,db=dbt3,client=[local] LOG:  duration: 1.947 ms
2014-11-03 23:30:23 UTC [2682]: [5-1] user=sekondquad,db=dbt3,client=[local] LOG:  disconnection: session time: 0:00:00.004 user=sekondquad database=dbt3 host=[local]
2014-11-03 23:30:23 UTC [2688]: [1-1] user=[unknown],db=[unknown],client= LOG:  connection received: host=[local]
2014-11-03 23:30:23 UTC [2688]: [2-1] user=sekondquad,db=dbt3,client=[local] LOG:  connection authorized: user=sekondquad database=dbt3
2014-11-03 23:30:23 UTC [2688]: [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-03 23:30:23 UTC [2688]: [4-1] user=sekondquad,db=dbt3,client=[local] LOG:  duration: 1.330 ms
2014-11-03 23:30:23 UTC [2688]: [5-1] user=sekondquad,db=dbt3,client=[local] LOG:  disconnection: session time: 0:00:00.004 user=sekondquad database=dbt3 host=[local]
2014-11-03 23:30:23 UTC [2690]: [1-1] user=[unknown],db=[unknown],client= LOG:  connection received: host=[local]
2014-11-03 23:30:23 UTC [2690]: [2-1] user=sekondquad,db=dbt3,client=[local] LOG:  connection authorized: user=sekondquad database=dbt3
2014-11-03 23:30:23 UTC [2690]: [3-1] user=sekondquad,db=dbt3,client=[local] LOG:  statement: BEGIN;
2014-11-03 23:30:23 UTC [2690]: [4-1] user=sekondquad,db=dbt3,client=[local] LOG:  duration: 0.092 ms
2014-11-03 23:30:23 UTC [2690]: [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-03 23:30:53 UTC [2705]: [1-1] user=[unknown],db=[unknown],client= LOG:  connection received: host=[local]
2014-11-03 23:30:53 UTC [2706]: [1-1] user=[unknown],db=[unknown],client= LOG:  connection received: host=[local]
2014-11-03 23:30:53 UTC [2707]: [1-1] user=[unknown],db=[unknown],client= LOG:  connection received: host=[local]
2014-11-03 23:30:53 UTC [2705]: [2-1] user=sekondquad,db=dbt3,client=[local] LOG:  connection authorized: user=sekondquad database=dbt3
2014-11-03 23:30:53 UTC [2708]: [1-1] user=[unknown],db=[unknown],client= LOG:  connection received: host=[local]
2014-11-03 23:30:53 UTC [2706]: [2-1] user=sekondquad,db=dbt3,client=[local] LOG:  connection authorized: user=sekondquad database=dbt3
2014-11-03 23:30:53 UTC [2707]: [2-1] user=sekondquad,db=dbt3,client=[local] LOG:  connection authorized: user=sekondquad database=dbt3
2014-11-03 23:30:53 UTC [2709]: [1-1] user=[unknown],db=[unknown],client= LOG:  connection received: host=[local]
2014-11-03 23:30:53 UTC [2708]: [2-1] user=sekondquad,db=dbt3,client=[local] LOG:  connection authorized: user=sekondquad database=dbt3
2014-11-03 23:30:53 UTC [2709]: [2-1] user=sekondquad,db=dbt3,client=[local] LOG:  connection authorized: user=sekondquad database=dbt3
2014-11-03 23:30:53 UTC [2705]: [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-03 23:30:53 UTC [2707]: [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-03 23:30:53 UTC [2706]: [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-03 23:30:53 UTC [2709]: [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-03 23:30:53 UTC [2708]: [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-03 23:30:53 UTC [2705]: [4-1] user=sekondquad,db=dbt3,client=[local] LOG:  duration: 6.207 ms
2014-11-03 23:30:53 UTC [2705]: [5-1] user=sekondquad,db=dbt3,client=[local] LOG:  disconnection: session time: 0:00:00.011 user=sekondquad database=dbt3 host=[local]
2014-11-03 23:30:53 UTC [2709]: [4-1] user=sekondquad,db=dbt3,client=[local] LOG:  duration: 5.131 ms
2014-11-03 23:30:53 UTC [2709]: [5-1] user=sekondquad,db=dbt3,client=[local] LOG:  disconnection: session time: 0:00:00.009 user=sekondquad database=dbt3 host=[local]
2014-11-03 23:30:53 UTC [2706]: [4-1] user=sekondquad,db=dbt3,client=[local] LOG:  duration: 13.757 ms
2014-11-03 23:30:53 UTC [2706]: [5-1] user=sekondquad,db=dbt3,client=[local] LOG:  disconnection: session time: 0:00:00.019 user=sekondquad database=dbt3 host=[local]
2014-11-03 23:30:53 UTC [2707]: [4-1] user=sekondquad,db=dbt3,client=[local] LOG:  duration: 16.000 ms
2014-11-03 23:30:53 UTC [2707]: [5-1] user=sekondquad,db=dbt3,client=[local] LOG:  disconnection: session time: 0:00:00.020 user=sekondquad database=dbt3 host=[local]
2014-11-03 23:30:53 UTC [2708]: [4-1] user=sekondquad,db=dbt3,client=[local] LOG:  duration: 14.730 ms
2014-11-03 23:30:53 UTC [2708]: [5-1] user=sekondquad,db=dbt3,client=[local] LOG:  disconnection: session time: 0:00:00.019 user=sekondquad database=dbt3 host=[local]
2014-11-03 23:31:32 UTC [2690]: [6-1] user=sekondquad,db=dbt3,client=[local] LOG:  duration: 68754.244 ms
2014-11-03 23:31:32 UTC [2690]: [7-1] user=sekondquad,db=dbt3,client=[local] LOG:  statement: COMMIT;
2014-11-03 23:31:32 UTC [2690]: [8-1] user=sekondquad,db=dbt3,client=[local] LOG:  duration: 0.119 ms
2014-11-03 23:31:32 UTC [2690]: [9-1] user=sekondquad,db=dbt3,client=[local] LOG:  disconnection: session time: 0:01:08.757 user=sekondquad database=dbt3 host=[local]
2014-11-03 23:31:32 UTC [2719]: [1-1] user=[unknown],db=[unknown],client= LOG:  connection received: host=[local]
2014-11-03 23:31:32 UTC [2719]: [2-1] user=sekondquad,db=dbt3,client=[local] LOG:  connection authorized: user=sekondquad database=dbt3
2014-11-03 23:31:32 UTC [2719]: [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-03 23:31:32 UTC [2719]: [4-1] user=sekondquad,db=dbt3,client=[local] LOG:  duration: 2.130 ms
2014-11-03 23:31:32 UTC [2719]: [5-1] user=sekondquad,db=dbt3,client=[local] LOG:  disconnection: session time: 0:00:00.004 user=sekondquad database=dbt3 host=[local]
2014-11-03 23:31:32 UTC [2725]: [1-1] user=[unknown],db=[unknown],client= LOG:  connection received: host=[local]
2014-11-03 23:31:32 UTC [2725]: [2-1] user=sekondquad,db=dbt3,client=[local] LOG:  connection authorized: user=sekondquad database=dbt3
2014-11-03 23:31:32 UTC [2725]: [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-03 23:31:32 UTC [2725]: [4-1] user=sekondquad,db=dbt3,client=[local] LOG:  duration: 2.149 ms
2014-11-03 23:31:32 UTC [2725]: [5-1] user=sekondquad,db=dbt3,client=[local] LOG:  disconnection: session time: 0:00:00.006 user=sekondquad database=dbt3 host=[local]
2014-11-03 23:31:32 UTC [2727]: [1-1] user=[unknown],db=[unknown],client= LOG:  connection received: host=[local]
2014-11-03 23:31:32 UTC [2727]: [2-1] user=sekondquad,db=dbt3,client=[local] LOG:  connection authorized: user=sekondquad database=dbt3
2014-11-03 23:31:32 UTC [2727]: [3-1] user=sekondquad,db=dbt3,client=[local] LOG:  statement: BEGIN;
2014-11-03 23:31:32 UTC [2727]: [4-1] user=sekondquad,db=dbt3,client=[local] LOG:  duration: 0.164 ms
2014-11-03 23:31:32 UTC [2727]: [5-1] user=sekondquad,db=dbt3,client=[local] LOG:  statement: EXPLAIN (ANALYZE, BUFFERS)
	select
		o_year,
		sum(case
			when nation = 'SAUDI ARABIA' 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 = 'SMALL PLATED TIN'
		) as all_nations
	group by
		o_year
	order by
		o_year;
2014-11-03 23:31:40 UTC [2727]: [6-1] user=sekondquad,db=dbt3,client=[local] LOG:  duration: 7842.130 ms
2014-11-03 23:31:40 UTC [2727]: [7-1] user=sekondquad,db=dbt3,client=[local] LOG:  statement: COMMIT;
2014-11-03 23:31:40 UTC [2727]: [8-1] user=sekondquad,db=dbt3,client=[local] LOG:  duration: 0.127 ms
2014-11-03 23:31:40 UTC [2727]: [9-1] user=sekondquad,db=dbt3,client=[local] LOG:  disconnection: session time: 0:00:07.847 user=sekondquad database=dbt3 host=[local]
2014-11-03 23:31:40 UTC [2731]: [1-1] user=[unknown],db=[unknown],client= LOG:  connection received: host=[local]
2014-11-03 23:31:40 UTC [2731]: [2-1] user=sekondquad,db=dbt3,client=[local] LOG:  connection authorized: user=sekondquad database=dbt3
2014-11-03 23:31:40 UTC [2731]: [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-03 23:31:40 UTC [2731]: [4-1] user=sekondquad,db=dbt3,client=[local] LOG:  duration: 2.119 ms
2014-11-03 23:31:40 UTC [2731]: [5-1] user=sekondquad,db=dbt3,client=[local] LOG:  disconnection: session time: 0:00:00.004 user=sekondquad database=dbt3 host=[local]
2014-11-03 23:31:40 UTC [2737]: [1-1] user=[unknown],db=[unknown],client= LOG:  connection received: host=[local]
2014-11-03 23:31:40 UTC [2737]: [2-1] user=sekondquad,db=dbt3,client=[local] LOG:  connection authorized: user=sekondquad database=dbt3
2014-11-03 23:31:40 UTC [2737]: [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-03 23:31:40 UTC [2737]: [4-1] user=sekondquad,db=dbt3,client=[local] LOG:  duration: 1.956 ms
2014-11-03 23:31:40 UTC [2737]: [5-1] user=sekondquad,db=dbt3,client=[local] LOG:  disconnection: session time: 0:00:00.006 user=sekondquad database=dbt3 host=[local]
2014-11-03 23:31:40 UTC [2739]: [1-1] user=[unknown],db=[unknown],client= LOG:  connection received: host=[local]
2014-11-03 23:31:40 UTC [2739]: [2-1] user=sekondquad,db=dbt3,client=[local] LOG:  connection authorized: user=sekondquad database=dbt3
2014-11-03 23:31:40 UTC [2739]: [3-1] user=sekondquad,db=dbt3,client=[local] LOG:  statement: BEGIN;
2014-11-03 23:31:40 UTC [2739]: [4-1] user=sekondquad,db=dbt3,client=[local] LOG:  duration: 0.164 ms
2014-11-03 23:31:40 UTC [2739]: [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-03 23:31:53 UTC [2752]: [1-1] user=[unknown],db=[unknown],client= LOG:  connection received: host=[local]
2014-11-03 23:31:53 UTC [2753]: [1-1] user=[unknown],db=[unknown],client= LOG:  connection received: host=[local]
2014-11-03 23:31:53 UTC [2754]: [1-1] user=[unknown],db=[unknown],client= LOG:  connection received: host=[local]
2014-11-03 23:31:53 UTC [2752]: [2-1] user=sekondquad,db=dbt3,client=[local] LOG:  connection authorized: user=sekondquad database=dbt3
2014-11-03 23:31:53 UTC [2753]: [2-1] user=sekondquad,db=dbt3,client=[local] LOG:  connection authorized: user=sekondquad database=dbt3
2014-11-03 23:31:53 UTC [2754]: [2-1] user=sekondquad,db=dbt3,client=[local] LOG:  connection authorized: user=sekondquad database=dbt3
2014-11-03 23:31:53 UTC [2755]: [1-1] user=[unknown],db=[unknown],client= LOG:  connection received: host=[local]
2014-11-03 23:31:53 UTC [2756]: [1-1] user=[unknown],db=[unknown],client= LOG:  connection received: host=[local]
2014-11-03 23:31:53 UTC [2753]: [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-03 23:31:53 UTC [2755]: [2-1] user=sekondquad,db=dbt3,client=[local] LOG:  connection authorized: user=sekondquad database=dbt3
2014-11-03 23:31:53 UTC [2752]: [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-03 23:31:53 UTC [2756]: [2-1] user=sekondquad,db=dbt3,client=[local] LOG:  connection authorized: user=sekondquad database=dbt3
2014-11-03 23:31:53 UTC [2754]: [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-03 23:31:53 UTC [2755]: [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-03 23:31:53 UTC [2756]: [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-03 23:31:53 UTC [2752]: [4-1] user=sekondquad,db=dbt3,client=[local] LOG:  duration: 6.270 ms
2014-11-03 23:31:53 UTC [2752]: [5-1] user=sekondquad,db=dbt3,client=[local] LOG:  disconnection: session time: 0:00:00.010 user=sekondquad database=dbt3 host=[local]
2014-11-03 23:31:53 UTC [2755]: [4-1] user=sekondquad,db=dbt3,client=[local] LOG:  duration: 4.850 ms
2014-11-03 23:31:53 UTC [2755]: [5-1] user=sekondquad,db=dbt3,client=[local] LOG:  disconnection: session time: 0:00:00.008 user=sekondquad database=dbt3 host=[local]
2014-11-03 23:31:53 UTC [2756]: [4-1] user=sekondquad,db=dbt3,client=[local] LOG:  duration: 13.909 ms
2014-11-03 23:31:53 UTC [2756]: [5-1] user=sekondquad,db=dbt3,client=[local] LOG:  disconnection: session time: 0:00:00.017 user=sekondquad database=dbt3 host=[local]
2014-11-03 23:31:53 UTC [2754]: [4-1] user=sekondquad,db=dbt3,client=[local] LOG:  duration: 16.740 ms
2014-11-03 23:31:53 UTC [2754]: [5-1] user=sekondquad,db=dbt3,client=[local] LOG:  disconnection: session time: 0:00:00.020 user=sekondquad database=dbt3 host=[local]
2014-11-03 23:31:53 UTC [2753]: [4-1] user=sekondquad,db=dbt3,client=[local] LOG:  duration: 19.112 ms
2014-11-03 23:31:53 UTC [2753]: [5-1] user=sekondquad,db=dbt3,client=[local] LOG:  disconnection: session time: 0:00:00.022 user=sekondquad database=dbt3 host=[local]
2014-11-03 23:32:20 UTC [2739]: [6-1] user=sekondquad,db=dbt3,client=[local] LOG:  duration: 40255.638 ms
2014-11-03 23:32:20 UTC [2739]: [7-1] user=sekondquad,db=dbt3,client=[local] LOG:  statement: COMMIT;
2014-11-03 23:32:20 UTC [2739]: [8-1] user=sekondquad,db=dbt3,client=[local] LOG:  duration: 0.108 ms
2014-11-03 23:32:20 UTC [2739]: [9-1] user=sekondquad,db=dbt3,client=[local] LOG:  disconnection: session time: 0:00:40.260 user=sekondquad database=dbt3 host=[local]
2014-11-03 23:32:20 UTC [2763]: [1-1] user=[unknown],db=[unknown],client= LOG:  connection received: host=[local]
2014-11-03 23:32:20 UTC [2763]: [2-1] user=sekondquad,db=dbt3,client=[local] LOG:  connection authorized: user=sekondquad database=dbt3
2014-11-03 23:32:20 UTC [2763]: [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-03 23:32:20 UTC [2763]: [4-1] user=sekondquad,db=dbt3,client=[local] LOG:  duration: 2.258 ms
2014-11-03 23:32:20 UTC [2763]: [5-1] user=sekondquad,db=dbt3,client=[local] LOG:  disconnection: session time: 0:00:00.004 user=sekondquad database=dbt3 host=[local]
2014-11-03 23:32:20 UTC [2769]: [1-1] user=[unknown],db=[unknown],client= LOG:  connection received: host=[local]
2014-11-03 23:32:20 UTC [2769]: [2-1] user=sekondquad,db=dbt3,client=[local] LOG:  connection authorized: user=sekondquad database=dbt3
2014-11-03 23:32:20 UTC [2769]: [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-03 23:32:20 UTC [2769]: [4-1] user=sekondquad,db=dbt3,client=[local] LOG:  duration: 2.155 ms
2014-11-03 23:32:20 UTC [2769]: [5-1] user=sekondquad,db=dbt3,client=[local] LOG:  disconnection: session time: 0:00:00.006 user=sekondquad database=dbt3 host=[local]
2014-11-03 23:32:20 UTC [2771]: [1-1] user=[unknown],db=[unknown],client= LOG:  connection received: host=[local]
2014-11-03 23:32:20 UTC [2771]: [2-1] user=sekondquad,db=dbt3,client=[local] LOG:  connection authorized: user=sekondquad database=dbt3
2014-11-03 23:32:20 UTC [2771]: [3-1] user=sekondquad,db=dbt3,client=[local] LOG:  statement: BEGIN;
2014-11-03 23:32:20 UTC [2771]: [4-1] user=sekondquad,db=dbt3,client=[local] LOG:  duration: 0.165 ms
2014-11-03 23:32:20 UTC [2771]: [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 '%unusual%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-03 23:32:53 UTC [2789]: [1-1] user=[unknown],db=[unknown],client= LOG:  connection received: host=[local]
2014-11-03 23:32:53 UTC [2789]: [2-1] user=sekondquad,db=dbt3,client=[local] LOG:  connection authorized: user=sekondquad database=dbt3
2014-11-03 23:32:53 UTC [2790]: [1-1] user=[unknown],db=[unknown],client= LOG:  connection received: host=[local]
2014-11-03 23:32:53 UTC [2790]: [2-1] user=sekondquad,db=dbt3,client=[local] LOG:  connection authorized: user=sekondquad database=dbt3
2014-11-03 23:32:53 UTC [2791]: [1-1] user=[unknown],db=[unknown],client= LOG:  connection received: host=[local]
2014-11-03 23:32:53 UTC [2792]: [1-1] user=[unknown],db=[unknown],client= LOG:  connection received: host=[local]
2014-11-03 23:32:53 UTC [2791]: [2-1] user=sekondquad,db=dbt3,client=[local] LOG:  connection authorized: user=sekondquad database=dbt3
2014-11-03 23:32:53 UTC [2789]: [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-03 23:32:53 UTC [2793]: [1-1] user=[unknown],db=[unknown],client= LOG:  connection received: host=[local]
2014-11-03 23:32:53 UTC [2792]: [2-1] user=sekondquad,db=dbt3,client=[local] LOG:  connection authorized: user=sekondquad database=dbt3
2014-11-03 23:32:53 UTC [2790]: [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-03 23:32:53 UTC [2793]: [2-1] user=sekondquad,db=dbt3,client=[local] LOG:  connection authorized: user=sekondquad database=dbt3
2014-11-03 23:32:53 UTC [2791]: [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-03 23:32:53 UTC [2792]: [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-03 23:32:53 UTC [2793]: [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-03 23:32:53 UTC [2790]: [4-1] user=sekondquad,db=dbt3,client=[local] LOG:  duration: 3.641 ms
2014-11-03 23:32:53 UTC [2790]: [5-1] user=sekondquad,db=dbt3,client=[local] LOG:  disconnection: session time: 0:00:00.006 user=sekondquad database=dbt3 host=[local]
2014-11-03 23:32:53 UTC [2789]: [4-1] user=sekondquad,db=dbt3,client=[local] LOG:  duration: 6.213 ms
2014-11-03 23:32:53 UTC [2789]: [5-1] user=sekondquad,db=dbt3,client=[local] LOG:  disconnection: session time: 0:00:00.010 user=sekondquad database=dbt3 host=[local]
2014-11-03 23:32:53 UTC [2793]: [4-1] user=sekondquad,db=dbt3,client=[local] LOG:  duration: 8.458 ms
2014-11-03 23:32:53 UTC [2793]: [5-1] user=sekondquad,db=dbt3,client=[local] LOG:  disconnection: session time: 0:00:00.011 user=sekondquad database=dbt3 host=[local]
2014-11-03 23:32:53 UTC [2791]: [4-1] user=sekondquad,db=dbt3,client=[local] LOG:  duration: 10.202 ms
2014-11-03 23:32:53 UTC [2791]: [5-1] user=sekondquad,db=dbt3,client=[local] LOG:  disconnection: session time: 0:00:00.013 user=sekondquad database=dbt3 host=[local]
2014-11-03 23:32:53 UTC [2792]: [4-1] user=sekondquad,db=dbt3,client=[local] LOG:  duration: 12.270 ms
2014-11-03 23:32:53 UTC [2792]: [5-1] user=sekondquad,db=dbt3,client=[local] LOG:  disconnection: session time: 0:00:00.015 user=sekondquad database=dbt3 host=[local]
2014-11-03 23:32:54 UTC [2771]: [6-1] user=sekondquad,db=dbt3,client=[local] LOG:  duration: 34383.393 ms
2014-11-03 23:32:54 UTC [2771]: [7-1] user=sekondquad,db=dbt3,client=[local] LOG:  statement: COMMIT;
2014-11-03 23:32:54 UTC [2771]: [8-1] user=sekondquad,db=dbt3,client=[local] LOG:  duration: 0.127 ms
2014-11-03 23:32:54 UTC [2771]: [9-1] user=sekondquad,db=dbt3,client=[local] LOG:  disconnection: session time: 0:00:34.388 user=sekondquad database=dbt3 host=[local]
2014-11-03 23:32:54 UTC [2795]: [1-1] user=[unknown],db=[unknown],client= LOG:  connection received: host=[local]
2014-11-03 23:32:54 UTC [2795]: [2-1] user=sekondquad,db=dbt3,client=[local] LOG:  connection authorized: user=sekondquad database=dbt3
2014-11-03 23:32:54 UTC [2795]: [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-03 23:32:54 UTC [2795]: [4-1] user=sekondquad,db=dbt3,client=[local] LOG:  duration: 2.210 ms
2014-11-03 23:32:54 UTC [2795]: [5-1] user=sekondquad,db=dbt3,client=[local] LOG:  disconnection: session time: 0:00:00.004 user=sekondquad database=dbt3 host=[local]
2014-11-03 23:32:54 UTC [2801]: [1-1] user=[unknown],db=[unknown],client= LOG:  connection received: host=[local]
2014-11-03 23:32:54 UTC [2801]: [2-1] user=sekondquad,db=dbt3,client=[local] LOG:  connection authorized: user=sekondquad database=dbt3
2014-11-03 23:32:54 UTC [2801]: [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-03 23:32:54 UTC [2801]: [4-1] user=sekondquad,db=dbt3,client=[local] LOG:  duration: 1.890 ms
2014-11-03 23:32:54 UTC [2801]: [5-1] user=sekondquad,db=dbt3,client=[local] LOG:  disconnection: session time: 0:00:00.005 user=sekondquad database=dbt3 host=[local]
2014-11-03 23:32:54 UTC [2803]: [1-1] user=[unknown],db=[unknown],client= LOG:  connection received: host=[local]
2014-11-03 23:32:54 UTC [2803]: [2-1] user=sekondquad,db=dbt3,client=[local] LOG:  connection authorized: user=sekondquad database=dbt3
2014-11-03 23:32:54 UTC [2803]: [3-1] user=sekondquad,db=dbt3,client=[local] LOG:  statement: BEGIN;
2014-11-03 23:32:54 UTC [2803]: [4-1] user=sekondquad,db=dbt3,client=[local] LOG:  duration: 0.164 ms
2014-11-03 23:32:54 UTC [2803]: [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-22'
		and l_shipdate > date '1995-03-22'
	group by
		l_orderkey,
		o_orderdate,
		o_shippriority
	order by
		revenue desc,
		o_orderdate
	LIMIT 10;
2014-11-03 23:33:23 UTC [2803]: [6-1] user=sekondquad,db=dbt3,client=[local] LOG:  duration: 28648.558 ms
2014-11-03 23:33:23 UTC [2803]: [7-1] user=sekondquad,db=dbt3,client=[local] LOG:  statement: COMMIT;
2014-11-03 23:33:23 UTC [2803]: [8-1] user=sekondquad,db=dbt3,client=[local] LOG:  duration: 0.099 ms
2014-11-03 23:33:23 UTC [2803]: [9-1] user=sekondquad,db=dbt3,client=[local] LOG:  disconnection: session time: 0:00:28.653 user=sekondquad database=dbt3 host=[local]
2014-11-03 23:33:23 UTC [2813]: [1-1] user=[unknown],db=[unknown],client= LOG:  connection received: host=[local]
2014-11-03 23:33:23 UTC [2813]: [2-1] user=sekondquad,db=dbt3,client=[local] LOG:  connection authorized: user=sekondquad database=dbt3
2014-11-03 23:33:23 UTC [2813]: [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-03 23:33:23 UTC [2813]: [4-1] user=sekondquad,db=dbt3,client=[local] LOG:  duration: 2.097 ms
2014-11-03 23:33:23 UTC [2813]: [5-1] user=sekondquad,db=dbt3,client=[local] LOG:  disconnection: session time: 0:00:00.004 user=sekondquad database=dbt3 host=[local]
2014-11-03 23:33:23 UTC [2819]: [1-1] user=[unknown],db=[unknown],client= LOG:  connection received: host=[local]
2014-11-03 23:33:23 UTC [2819]: [2-1] user=sekondquad,db=dbt3,client=[local] LOG:  connection authorized: user=sekondquad database=dbt3
2014-11-03 23:33:23 UTC [2819]: [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-03 23:33:23 UTC [2819]: [4-1] user=sekondquad,db=dbt3,client=[local] LOG:  duration: 1.958 ms
2014-11-03 23:33:23 UTC [2819]: [5-1] user=sekondquad,db=dbt3,client=[local] LOG:  disconnection: session time: 0:00:00.006 user=sekondquad database=dbt3 host=[local]
2014-11-03 23:33:23 UTC [2821]: [1-1] user=[unknown],db=[unknown],client= LOG:  connection received: host=[local]
2014-11-03 23:33:23 UTC [2821]: [2-1] user=sekondquad,db=dbt3,client=[local] LOG:  connection authorized: user=sekondquad database=dbt3
2014-11-03 23:33:23 UTC [2821]: [3-1] user=sekondquad,db=dbt3,client=[local] LOG:  statement: BEGIN;
2014-11-03 23:33:23 UTC [2821]: [4-1] user=sekondquad,db=dbt3,client=[local] LOG:  duration: 0.166 ms
2014-11-03 23:33:23 UTC [2821]: [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
					('27', '18', '33', '31', '12', '26', '34')
				and c_acctbal > (
					select
						avg(c_acctbal)
					from
						customer
					where
						c_acctbal > 0.00
						and substr(c_phone, 1, 2) in
							('27', '18', '33', '31', '12', '26', '34')
				)
				and not exists (
					select
						*
					from
						orders
					where
						o_custkey = c_custkey
				)
		) as vip
	group by
		cntrycode
	order by
		cntrycode;
2014-11-03 23:33:34 UTC [2821]: [6-1] user=sekondquad,db=dbt3,client=[local] LOG:  duration: 10981.188 ms
2014-11-03 23:33:34 UTC [2821]: [7-1] user=sekondquad,db=dbt3,client=[local] LOG:  statement: COMMIT;
2014-11-03 23:33:34 UTC [2821]: [8-1] user=sekondquad,db=dbt3,client=[local] LOG:  duration: 0.143 ms
2014-11-03 23:33:34 UTC [2821]: [9-1] user=sekondquad,db=dbt3,client=[local] LOG:  disconnection: session time: 0:00:10.986 user=sekondquad database=dbt3 host=[local]
2014-11-03 23:33:34 UTC [2825]: [1-1] user=[unknown],db=[unknown],client= LOG:  connection received: host=[local]
2014-11-03 23:33:34 UTC [2825]: [2-1] user=sekondquad,db=dbt3,client=[local] LOG:  connection authorized: user=sekondquad database=dbt3
2014-11-03 23:33:34 UTC [2825]: [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-03 23:33:34 UTC [2825]: [4-1] user=sekondquad,db=dbt3,client=[local] LOG:  duration: 2.230 ms
2014-11-03 23:33:34 UTC [2825]: [5-1] user=sekondquad,db=dbt3,client=[local] LOG:  disconnection: session time: 0:00:00.004 user=sekondquad database=dbt3 host=[local]
2014-11-03 23:33:34 UTC [2831]: [1-1] user=[unknown],db=[unknown],client= LOG:  connection received: host=[local]
2014-11-03 23:33:34 UTC [2831]: [2-1] user=sekondquad,db=dbt3,client=[local] LOG:  connection authorized: user=sekondquad database=dbt3
2014-11-03 23:33:34 UTC [2831]: [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-03 23:33:34 UTC [2831]: [4-1] user=sekondquad,db=dbt3,client=[local] LOG:  duration: 1.983 ms
2014-11-03 23:33:34 UTC [2831]: [5-1] user=sekondquad,db=dbt3,client=[local] LOG:  disconnection: session time: 0:00:00.006 user=sekondquad database=dbt3 host=[local]
2014-11-03 23:33:34 UTC [2833]: [1-1] user=[unknown],db=[unknown],client= LOG:  connection received: host=[local]
2014-11-03 23:33:34 UTC [2833]: [2-1] user=sekondquad,db=dbt3,client=[local] LOG:  connection authorized: user=sekondquad database=dbt3
2014-11-03 23:33:34 UTC [2833]: [3-1] user=sekondquad,db=dbt3,client=[local] LOG:  statement: BEGIN;
2014-11-03 23:33:34 UTC [2833]: [4-1] user=sekondquad,db=dbt3,client=[local] LOG:  duration: 0.165 ms
2014-11-03 23:33:34 UTC [2833]: [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#43'
		and p_type not like 'ECONOMY BRUSHED%'
		and p_size in (19, 18, 38, 36, 1, 48, 44, 47)
		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-03 23:33:43 UTC [2833]: [6-1] user=sekondquad,db=dbt3,client=[local] LOG:  duration: 8954.580 ms
2014-11-03 23:33:43 UTC [2833]: [7-1] user=sekondquad,db=dbt3,client=[local] LOG:  statement: COMMIT;
2014-11-03 23:33:43 UTC [2833]: [8-1] user=sekondquad,db=dbt3,client=[local] LOG:  duration: 0.099 ms
2014-11-03 23:33:43 UTC [2833]: [9-1] user=sekondquad,db=dbt3,client=[local] LOG:  disconnection: session time: 0:00:08.959 user=sekondquad database=dbt3 host=[local]
2014-11-03 23:33:43 UTC [2844]: [1-1] user=[unknown],db=[unknown],client= LOG:  connection received: host=[local]
2014-11-03 23:33:43 UTC [2844]: [2-1] user=sekondquad,db=dbt3,client=[local] LOG:  connection authorized: user=sekondquad database=dbt3
2014-11-03 23:33:43 UTC [2844]: [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-03 23:33:43 UTC [2844]: [4-1] user=sekondquad,db=dbt3,client=[local] LOG:  duration: 2.108 ms
2014-11-03 23:33:43 UTC [2844]: [5-1] user=sekondquad,db=dbt3,client=[local] LOG:  disconnection: session time: 0:00:00.004 user=sekondquad database=dbt3 host=[local]
2014-11-03 23:33:43 UTC [2850]: [1-1] user=[unknown],db=[unknown],client= LOG:  connection received: host=[local]
2014-11-03 23:33:43 UTC [2850]: [2-1] user=sekondquad,db=dbt3,client=[local] LOG:  connection authorized: user=sekondquad database=dbt3
2014-11-03 23:33:43 UTC [2850]: [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-03 23:33:43 UTC [2850]: [4-1] user=sekondquad,db=dbt3,client=[local] LOG:  duration: 1.876 ms
2014-11-03 23:33:43 UTC [2850]: [5-1] user=sekondquad,db=dbt3,client=[local] LOG:  disconnection: session time: 0:00:00.006 user=sekondquad database=dbt3 host=[local]
2014-11-03 23:33:43 UTC [2852]: [1-1] user=[unknown],db=[unknown],client= LOG:  connection received: host=[local]
2014-11-03 23:33:43 UTC [2852]: [2-1] user=sekondquad,db=dbt3,client=[local] LOG:  connection authorized: user=sekondquad database=dbt3
2014-11-03 23:33:43 UTC [2852]: [3-1] user=sekondquad,db=dbt3,client=[local] LOG:  statement: BEGIN;
2014-11-03 23:33:43 UTC [2852]: [4-1] user=sekondquad,db=dbt3,client=[local] LOG:  duration: 0.165 ms
2014-11-03 23:33:43 UTC [2852]: [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 '1996-04-01'
		and o_orderdate < cast(date '1996-04-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-03 23:33:52 UTC [2852]: [6-1] user=sekondquad,db=dbt3,client=[local] LOG:  duration: 9088.998 ms
2014-11-03 23:33:52 UTC [2852]: [7-1] user=sekondquad,db=dbt3,client=[local] LOG:  statement: COMMIT;
2014-11-03 23:33:52 UTC [2852]: [8-1] user=sekondquad,db=dbt3,client=[local] LOG:  duration: 0.117 ms
2014-11-03 23:33:52 UTC [2852]: [9-1] user=sekondquad,db=dbt3,client=[local] LOG:  disconnection: session time: 0:00:09.093 user=sekondquad database=dbt3 host=[local]
2014-11-03 23:33:52 UTC [2856]: [1-1] user=[unknown],db=[unknown],client= LOG:  connection received: host=[local]
2014-11-03 23:33:52 UTC [2856]: [2-1] user=sekondquad,db=dbt3,client=[local] LOG:  connection authorized: user=sekondquad database=dbt3
2014-11-03 23:33:52 UTC [2856]: [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-03 23:33:52 UTC [2856]: [4-1] user=sekondquad,db=dbt3,client=[local] LOG:  duration: 2.083 ms
2014-11-03 23:33:52 UTC [2856]: [5-1] user=sekondquad,db=dbt3,client=[local] LOG:  disconnection: session time: 0:00:00.004 user=sekondquad database=dbt3 host=[local]
2014-11-03 23:33:52 UTC [2865]: [1-1] user=[unknown],db=[unknown],client= LOG:  connection received: host=[local]
2014-11-03 23:33:52 UTC [2865]: [2-1] user=sekondquad,db=dbt3,client=[local] LOG:  connection authorized: user=sekondquad database=dbt3
2014-11-03 23:33:52 UTC [2865]: [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-03 23:33:52 UTC [2865]: [4-1] user=sekondquad,db=dbt3,client=[local] LOG:  duration: 2.002 ms
2014-11-03 23:33:52 UTC [2865]: [5-1] user=sekondquad,db=dbt3,client=[local] LOG:  disconnection: session time: 0:00:00.006 user=sekondquad database=dbt3 host=[local]
2014-11-03 23:33:52 UTC [2867]: [1-1] user=[unknown],db=[unknown],client= LOG:  connection received: host=[local]
2014-11-03 23:33:52 UTC [2867]: [2-1] user=sekondquad,db=dbt3,client=[local] LOG:  connection authorized: user=sekondquad database=dbt3
2014-11-03 23:33:52 UTC [2867]: [3-1] user=sekondquad,db=dbt3,client=[local] LOG:  statement: BEGIN;
2014-11-03 23:33:52 UTC [2867]: [4-1] user=sekondquad,db=dbt3,client=[local] LOG:  duration: 0.167 ms
2014-11-03 23:33:52 UTC [2867]: [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 = 'INDONESIA'
	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 = 'INDONESIA'
			)
	order by
		value desc;
2014-11-03 23:33:53 UTC [2877]: [1-1] user=[unknown],db=[unknown],client= LOG:  connection received: host=[local]
2014-11-03 23:33:53 UTC [2878]: [1-1] user=[unknown],db=[unknown],client= LOG:  connection received: host=[local]
2014-11-03 23:33:53 UTC [2877]: [2-1] user=sekondquad,db=dbt3,client=[local] LOG:  connection authorized: user=sekondquad database=dbt3
2014-11-03 23:33:53 UTC [2879]: [1-1] user=[unknown],db=[unknown],client= LOG:  connection received: host=[local]
2014-11-03 23:33:53 UTC [2878]: [2-1] user=sekondquad,db=dbt3,client=[local] LOG:  connection authorized: user=sekondquad database=dbt3
2014-11-03 23:33:53 UTC [2880]: [1-1] user=[unknown],db=[unknown],client= LOG:  connection received: host=[local]
2014-11-03 23:33:53 UTC [2879]: [2-1] user=sekondquad,db=dbt3,client=[local] LOG:  connection authorized: user=sekondquad database=dbt3
2014-11-03 23:33:53 UTC [2880]: [2-1] user=sekondquad,db=dbt3,client=[local] LOG:  connection authorized: user=sekondquad database=dbt3
2014-11-03 23:33:53 UTC [2877]: [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-03 23:33:53 UTC [2881]: [1-1] user=[unknown],db=[unknown],client= LOG:  connection received: host=[local]
2014-11-03 23:33:53 UTC [2878]: [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-03 23:33:53 UTC [2881]: [2-1] user=sekondquad,db=dbt3,client=[local] LOG:  connection authorized: user=sekondquad database=dbt3
2014-11-03 23:33:53 UTC [2880]: [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-03 23:33:53 UTC [2879]: [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-03 23:33:53 UTC [2881]: [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-03 23:33:53 UTC [2879]: [4-1] user=sekondquad,db=dbt3,client=[local] LOG:  duration: 3.324 ms
2014-11-03 23:33:53 UTC [2879]: [5-1] user=sekondquad,db=dbt3,client=[local] LOG:  disconnection: session time: 0:00:00.008 user=sekondquad database=dbt3 host=[local]
2014-11-03 23:33:53 UTC [2877]: [4-1] user=sekondquad,db=dbt3,client=[local] LOG:  duration: 6.134 ms
2014-11-03 23:33:53 UTC [2877]: [5-1] user=sekondquad,db=dbt3,client=[local] LOG:  disconnection: session time: 0:00:00.010 user=sekondquad database=dbt3 host=[local]
2014-11-03 23:33:53 UTC [2878]: [4-1] user=sekondquad,db=dbt3,client=[local] LOG:  duration: 15.516 ms
2014-11-03 23:33:53 UTC [2881]: [4-1] user=sekondquad,db=dbt3,client=[local] LOG:  duration: 13.888 ms
2014-11-03 23:33:53 UTC [2878]: [5-1] user=sekondquad,db=dbt3,client=[local] LOG:  disconnection: session time: 0:00:00.020 user=sekondquad database=dbt3 host=[local]
2014-11-03 23:33:53 UTC [2881]: [5-1] user=sekondquad,db=dbt3,client=[local] LOG:  disconnection: session time: 0:00:00.017 user=sekondquad database=dbt3 host=[local]
2014-11-03 23:33:53 UTC [2880]: [4-1] user=sekondquad,db=dbt3,client=[local] LOG:  duration: 18.406 ms
2014-11-03 23:33:53 UTC [2880]: [5-1] user=sekondquad,db=dbt3,client=[local] LOG:  disconnection: session time: 0:00:00.021 user=sekondquad database=dbt3 host=[local]
2014-11-03 23:33:54 UTC [2867]: [6-1] user=sekondquad,db=dbt3,client=[local] LOG:  duration: 2359.158 ms
2014-11-03 23:33:54 UTC [2867]: [7-1] user=sekondquad,db=dbt3,client=[local] LOG:  statement: COMMIT;
2014-11-03 23:33:54 UTC [2867]: [8-1] user=sekondquad,db=dbt3,client=[local] LOG:  duration: 0.107 ms
2014-11-03 23:33:54 UTC [2867]: [9-1] user=sekondquad,db=dbt3,client=[local] LOG:  disconnection: session time: 0:00:02.364 user=sekondquad database=dbt3 host=[local]
2014-11-03 23:33:54 UTC [2883]: [1-1] user=[unknown],db=[unknown],client= LOG:  connection received: host=[local]
2014-11-03 23:33:54 UTC [2883]: [2-1] user=sekondquad,db=dbt3,client=[local] LOG:  connection authorized: user=sekondquad database=dbt3
2014-11-03 23:33:54 UTC [2883]: [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-03 23:33:54 UTC [2883]: [4-1] user=sekondquad,db=dbt3,client=[local] LOG:  duration: 2.175 ms
2014-11-03 23:33:54 UTC [2883]: [5-1] user=sekondquad,db=dbt3,client=[local] LOG:  disconnection: session time: 0:00:00.004 user=sekondquad database=dbt3 host=[local]
2014-11-03 23:33:54 UTC [2889]: [1-1] user=[unknown],db=[unknown],client= LOG:  connection received: host=[local]
2014-11-03 23:33:54 UTC [2889]: [2-1] user=sekondquad,db=dbt3,client=[local] LOG:  connection authorized: user=sekondquad database=dbt3
2014-11-03 23:33:54 UTC [2889]: [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-03 23:33:54 UTC [2889]: [4-1] user=sekondquad,db=dbt3,client=[local] LOG:  duration: 2.024 ms
2014-11-03 23:33:54 UTC [2889]: [5-1] user=sekondquad,db=dbt3,client=[local] LOG:  disconnection: session time: 0:00:00.006 user=sekondquad database=dbt3 host=[local]
2014-11-03 23:33:54 UTC [2891]: [1-1] user=[unknown],db=[unknown],client= LOG:  connection received: host=[local]
2014-11-03 23:33:54 UTC [2891]: [2-1] user=sekondquad,db=dbt3,client=[local] LOG:  connection authorized: user=sekondquad database=dbt3
2014-11-03 23:33:54 UTC [2891]: [3-1] user=sekondquad,db=dbt3,client=[local] LOG:  statement: BEGIN;
2014-11-03 23:33:54 UTC [2891]: [4-1] user=sekondquad,db=dbt3,client=[local] LOG:  duration: 0.165 ms
2014-11-03 23:33:54 UTC [2891]: [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 >= '1993-02-01'
			and l_shipdate < date'1993-02-01' + interval '90 days'
		group by
			l_suppkey;
2014-11-03 23:33:55 UTC [2891]: [6-1] user=sekondquad,db=dbt3,client=[local] LOG:  duration: 9.437 ms
2014-11-03 23:33:55 UTC [2891]: [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-03 23:34:12 UTC [2891]: [8-1] user=sekondquad,db=dbt3,client=[local] LOG:  duration: 17248.502 ms
2014-11-03 23:34:12 UTC [2891]: [9-1] user=sekondquad,db=dbt3,client=[local] LOG:  statement: drop view revenue0;
2014-11-03 23:34:12 UTC [2891]: [10-1] user=sekondquad,db=dbt3,client=[local] LOG:  duration: 0.899 ms
2014-11-03 23:34:12 UTC [2891]: [11-1] user=sekondquad,db=dbt3,client=[local] LOG:  statement: COMMIT;
2014-11-03 23:34:12 UTC [2891]: [12-1] user=sekondquad,db=dbt3,client=[local] LOG:  duration: 0.469 ms
2014-11-03 23:34:12 UTC [2891]: [13-1] user=sekondquad,db=dbt3,client=[local] LOG:  disconnection: session time: 0:00:17.264 user=sekondquad database=dbt3 host=[local]
2014-11-03 23:34:12 UTC [2905]: [1-1] user=[unknown],db=[unknown],client= LOG:  connection received: host=[local]
2014-11-03 23:34:12 UTC [2905]: [2-1] user=sekondquad,db=dbt3,client=[local] LOG:  connection authorized: user=sekondquad database=dbt3
2014-11-03 23:34:12 UTC [2905]: [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-03 23:34:12 UTC [2905]: [4-1] user=sekondquad,db=dbt3,client=[local] LOG:  duration: 1.967 ms
2014-11-03 23:34:12 UTC [2905]: [5-1] user=sekondquad,db=dbt3,client=[local] LOG:  disconnection: session time: 0:00:00.004 user=sekondquad database=dbt3 host=[local]
2014-11-03 23:34:12 UTC [2911]: [1-1] user=[unknown],db=[unknown],client= LOG:  connection received: host=[local]
2014-11-03 23:34:12 UTC [2911]: [2-1] user=sekondquad,db=dbt3,client=[local] LOG:  connection authorized: user=sekondquad database=dbt3
2014-11-03 23:34:12 UTC [2911]: [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-03 23:34:12 UTC [2911]: [4-1] user=sekondquad,db=dbt3,client=[local] LOG:  duration: 2.067 ms
2014-11-03 23:34:12 UTC [2911]: [5-1] user=sekondquad,db=dbt3,client=[local] LOG:  disconnection: session time: 0:00:00.006 user=sekondquad database=dbt3 host=[local]
2014-11-03 23:34:12 UTC [2913]: [1-1] user=[unknown],db=[unknown],client= LOG:  connection received: host=[local]
2014-11-03 23:34:12 UTC [2913]: [2-1] user=sekondquad,db=dbt3,client=[local] LOG:  connection authorized: user=sekondquad database=dbt3
2014-11-03 23:34:12 UTC [2913]: [3-1] user=sekondquad,db=dbt3,client=[local] LOG:  statement: BEGIN;
2014-11-03 23:34:12 UTC [2913]: [4-1] user=sekondquad,db=dbt3,client=[local] LOG:  duration: 0.164 ms
2014-11-03 23:34:12 UTC [2913]: [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 '66 days'
	group by
		l_returnflag,
		l_linestatus
	order by
		l_returnflag,
		l_linestatus;
2014-11-03 23:34:53 UTC [3015]: [1-1] user=[unknown],db=[unknown],client= LOG:  connection received: host=[local]
2014-11-03 23:34:53 UTC [3016]: [1-1] user=[unknown],db=[unknown],client= LOG:  connection received: host=[local]
2014-11-03 23:34:53 UTC [3015]: [2-1] user=sekondquad,db=dbt3,client=[local] LOG:  connection authorized: user=sekondquad database=dbt3
2014-11-03 23:34:53 UTC [3016]: [2-1] user=sekondquad,db=dbt3,client=[local] LOG:  connection authorized: user=sekondquad database=dbt3
2014-11-03 23:34:53 UTC [3017]: [1-1] user=[unknown],db=[unknown],client= LOG:  connection received: host=[local]
2014-11-03 23:34:53 UTC [3018]: [1-1] user=[unknown],db=[unknown],client= LOG:  connection received: host=[local]
2014-11-03 23:34:53 UTC [3017]: [2-1] user=sekondquad,db=dbt3,client=[local] LOG:  connection authorized: user=sekondquad database=dbt3
2014-11-03 23:34:53 UTC [3016]: [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-03 23:34:53 UTC [3015]: [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-03 23:34:53 UTC [3018]: [2-1] user=sekondquad,db=dbt3,client=[local] LOG:  connection authorized: user=sekondquad database=dbt3
2014-11-03 23:34:53 UTC [3019]: [1-1] user=[unknown],db=[unknown],client= LOG:  connection received: host=[local]
2014-11-03 23:34:53 UTC [3017]: [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-03 23:34:53 UTC [3019]: [2-1] user=sekondquad,db=dbt3,client=[local] LOG:  connection authorized: user=sekondquad database=dbt3
2014-11-03 23:34:53 UTC [3018]: [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-03 23:34:53 UTC [3019]: [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-03 23:34:53 UTC [3017]: [4-1] user=sekondquad,db=dbt3,client=[local] LOG:  duration: 3.178 ms
2014-11-03 23:34:53 UTC [3017]: [5-1] user=sekondquad,db=dbt3,client=[local] LOG:  disconnection: session time: 0:00:00.006 user=sekondquad database=dbt3 host=[local]
2014-11-03 23:34:53 UTC [3015]: [4-1] user=sekondquad,db=dbt3,client=[local] LOG:  duration: 5.137 ms
2014-11-03 23:34:53 UTC [3015]: [5-1] user=sekondquad,db=dbt3,client=[local] LOG:  disconnection: session time: 0:00:00.009 user=sekondquad database=dbt3 host=[local]
2014-11-03 23:34:53 UTC [3019]: [4-1] user=sekondquad,db=dbt3,client=[local] LOG:  duration: 8.209 ms
2014-11-03 23:34:53 UTC [3019]: [5-1] user=sekondquad,db=dbt3,client=[local] LOG:  disconnection: session time: 0:00:00.010 user=sekondquad database=dbt3 host=[local]
2014-11-03 23:34:53 UTC [3016]: [4-1] user=sekondquad,db=dbt3,client=[local] LOG:  duration: 11.698 ms
2014-11-03 23:34:53 UTC [3016]: [5-1] user=sekondquad,db=dbt3,client=[local] LOG:  disconnection: session time: 0:00:00.015 user=sekondquad database=dbt3 host=[local]
2014-11-03 23:34:53 UTC [3018]: [4-1] user=sekondquad,db=dbt3,client=[local] LOG:  duration: 12.860 ms
2014-11-03 23:34:53 UTC [3018]: [5-1] user=sekondquad,db=dbt3,client=[local] LOG:  disconnection: session time: 0:00:00.016 user=sekondquad database=dbt3 host=[local]
2014-11-03 23:35:31 UTC [2913]: [6-1] user=sekondquad,db=dbt3,client=[local] LOG:  duration: 78977.639 ms
2014-11-03 23:35:31 UTC [2913]: [7-1] user=sekondquad,db=dbt3,client=[local] LOG:  statement: COMMIT;
2014-11-03 23:35:31 UTC [2913]: [8-1] user=sekondquad,db=dbt3,client=[local] LOG:  duration: 0.108 ms
2014-11-03 23:35:31 UTC [2913]: [9-1] user=sekondquad,db=dbt3,client=[local] LOG:  disconnection: session time: 0:01:18.982 user=sekondquad database=dbt3 host=[local]
2014-11-03 23:35:31 UTC [3036]: [1-1] user=[unknown],db=[unknown],client= LOG:  connection received: host=[local]
2014-11-03 23:35:31 UTC [3036]: [2-1] user=sekondquad,db=dbt3,client=[local] LOG:  connection authorized: user=sekondquad database=dbt3
2014-11-03 23:35:31 UTC [3036]: [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-03 23:35:31 UTC [3036]: [4-1] user=sekondquad,db=dbt3,client=[local] LOG:  duration: 2.194 ms
2014-11-03 23:35:31 UTC [3036]: [5-1] user=sekondquad,db=dbt3,client=[local] LOG:  disconnection: session time: 0:00:00.004 user=sekondquad database=dbt3 host=[local]
2014-11-03 23:35:31 UTC [3042]: [1-1] user=[unknown],db=[unknown],client= LOG:  connection received: host=[local]
2014-11-03 23:35:31 UTC [3042]: [2-1] user=sekondquad,db=dbt3,client=[local] LOG:  connection authorized: user=sekondquad database=dbt3
2014-11-03 23:35:31 UTC [3042]: [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-03 23:35:31 UTC [3042]: [4-1] user=sekondquad,db=dbt3,client=[local] LOG:  duration: 2.001 ms
2014-11-03 23:35:31 UTC [3042]: [5-1] user=sekondquad,db=dbt3,client=[local] LOG:  disconnection: session time: 0:00:00.005 user=sekondquad database=dbt3 host=[local]
2014-11-03 23:35:31 UTC [3044]: [1-1] user=[unknown],db=[unknown],client= LOG:  connection received: host=[local]
2014-11-03 23:35:31 UTC [3044]: [2-1] user=sekondquad,db=dbt3,client=[local] LOG:  connection authorized: user=sekondquad database=dbt3
2014-11-03 23:35:31 UTC [3044]: [3-1] user=sekondquad,db=dbt3,client=[local] LOG:  statement: BEGIN;
2014-11-03 23:35:31 UTC [3044]: [4-1] user=sekondquad,db=dbt3,client=[local] LOG:  duration: 0.166 ms
2014-11-03 23:35:31 UTC [3044]: [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-02-01'
		and o_orderdate < cast(date '1994-02-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-03 23:35:53 UTC [3059]: [1-1] user=[unknown],db=[unknown],client= LOG:  connection received: host=[local]
2014-11-03 23:35:53 UTC [3059]: [2-1] user=sekondquad,db=dbt3,client=[local] LOG:  connection authorized: user=sekondquad database=dbt3
2014-11-03 23:35:53 UTC [3060]: [1-1] user=[unknown],db=[unknown],client= LOG:  connection received: host=[local]
2014-11-03 23:35:53 UTC [3061]: [1-1] user=[unknown],db=[unknown],client= LOG:  connection received: host=[local]
2014-11-03 23:35:53 UTC [3060]: [2-1] user=sekondquad,db=dbt3,client=[local] LOG:  connection authorized: user=sekondquad database=dbt3
2014-11-03 23:35:53 UTC [3061]: [2-1] user=sekondquad,db=dbt3,client=[local] LOG:  connection authorized: user=sekondquad database=dbt3
2014-11-03 23:35:53 UTC [3059]: [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-03 23:35:53 UTC [3060]: [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-03 23:35:53 UTC [3062]: [1-1] user=[unknown],db=[unknown],client= LOG:  connection received: host=[local]
2014-11-03 23:35:53 UTC [3061]: [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-03 23:35:53 UTC [3062]: [2-1] user=sekondquad,db=dbt3,client=[local] LOG:  connection authorized: user=sekondquad database=dbt3
2014-11-03 23:35:53 UTC [3064]: [1-1] user=[unknown],db=[unknown],client= LOG:  connection received: host=[local]
2014-11-03 23:35:53 UTC [3064]: [2-1] user=sekondquad,db=dbt3,client=[local] LOG:  connection authorized: user=sekondquad database=dbt3
2014-11-03 23:35:53 UTC [3059]: [4-1] user=sekondquad,db=dbt3,client=[local] LOG:  duration: 4.515 ms
2014-11-03 23:35:53 UTC [3059]: [5-1] user=sekondquad,db=dbt3,client=[local] LOG:  disconnection: session time: 0:00:00.008 user=sekondquad database=dbt3 host=[local]
2014-11-03 23:35:53 UTC [3062]: [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-03 23:35:53 UTC [3061]: [4-1] user=sekondquad,db=dbt3,client=[local] LOG:  duration: 3.215 ms
2014-11-03 23:35:53 UTC [3061]: [5-1] user=sekondquad,db=dbt3,client=[local] LOG:  disconnection: session time: 0:00:00.007 user=sekondquad database=dbt3 host=[local]
2014-11-03 23:35:53 UTC [3064]: [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-03 23:35:53 UTC [3062]: [4-1] user=sekondquad,db=dbt3,client=[local] LOG:  duration: 9.189 ms
2014-11-03 23:35:53 UTC [3062]: [5-1] user=sekondquad,db=dbt3,client=[local] LOG:  disconnection: session time: 0:00:00.012 user=sekondquad database=dbt3 host=[local]
2014-11-03 23:35:53 UTC [3060]: [4-1] user=sekondquad,db=dbt3,client=[local] LOG:  duration: 14.242 ms
2014-11-03 23:35:53 UTC [3060]: [5-1] user=sekondquad,db=dbt3,client=[local] LOG:  disconnection: session time: 0:00:00.018 user=sekondquad database=dbt3 host=[local]
2014-11-03 23:35:53 UTC [3064]: [4-1] user=sekondquad,db=dbt3,client=[local] LOG:  duration: 14.027 ms
2014-11-03 23:35:53 UTC [3064]: [5-1] user=sekondquad,db=dbt3,client=[local] LOG:  disconnection: session time: 0:00:00.018 user=sekondquad database=dbt3 host=[local]
2014-11-03 23:35:57 UTC [3044]: [6-1] user=sekondquad,db=dbt3,client=[local] LOG:  duration: 26417.815 ms
2014-11-03 23:35:57 UTC [3044]: [7-1] user=sekondquad,db=dbt3,client=[local] LOG:  statement: COMMIT;
2014-11-03 23:35:57 UTC [3044]: [8-1] user=sekondquad,db=dbt3,client=[local] LOG:  duration: 0.141 ms
2014-11-03 23:35:57 UTC [3044]: [9-1] user=sekondquad,db=dbt3,client=[local] LOG:  disconnection: session time: 0:00:26.423 user=sekondquad database=dbt3 host=[local]
2014-11-03 23:35:57 UTC [3067]: [1-1] user=[unknown],db=[unknown],client= LOG:  connection received: host=[local]
2014-11-03 23:35:57 UTC [3067]: [2-1] user=sekondquad,db=dbt3,client=[local] LOG:  connection authorized: user=sekondquad database=dbt3
2014-11-03 23:35:57 UTC [3067]: [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-03 23:35:57 UTC [3067]: [4-1] user=sekondquad,db=dbt3,client=[local] LOG:  duration: 2.208 ms
2014-11-03 23:35:57 UTC [3067]: [5-1] user=sekondquad,db=dbt3,client=[local] LOG:  disconnection: session time: 0:00:00.004 user=sekondquad database=dbt3 host=[local]
2014-11-03 23:35:57 UTC [3073]: [1-1] user=[unknown],db=[unknown],client= LOG:  connection received: host=[local]
2014-11-03 23:35:57 UTC [3073]: [2-1] user=sekondquad,db=dbt3,client=[local] LOG:  connection authorized: user=sekondquad database=dbt3
2014-11-03 23:35:57 UTC [3073]: [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-03 23:35:57 UTC [3073]: [4-1] user=sekondquad,db=dbt3,client=[local] LOG:  duration: 1.860 ms
2014-11-03 23:35:57 UTC [3073]: [5-1] user=sekondquad,db=dbt3,client=[local] LOG:  disconnection: session time: 0:00:00.006 user=sekondquad database=dbt3 host=[local]
2014-11-03 23:35:57 UTC [3075]: [1-1] user=[unknown],db=[unknown],client= LOG:  connection received: host=[local]
2014-11-03 23:35:57 UTC [3075]: [2-1] user=sekondquad,db=dbt3,client=[local] LOG:  connection authorized: user=sekondquad database=dbt3
2014-11-03 23:35:57 UTC [3075]: [3-1] user=sekondquad,db=dbt3,client=[local] LOG:  statement: BEGIN;
2014-11-03 23:35:57 UTC [3075]: [4-1] user=sekondquad,db=dbt3,client=[local] LOG:  duration: 0.165 ms
2014-11-03 23:35:57 UTC [3075]: [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#22'
			and p_container in ('SM CASE', 'SM BOX', 'SM PACK', 'SM PKG')
			and l_quantity >= 9 and l_quantity <= 9+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#44'
			and p_container in ('MED BAG', 'MED BOX', 'MED PKG', 'MED PACK')
			and l_quantity >= 20 and l_quantity <= 20+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#25'
			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-03 23:35:58 UTC [3075]: [6-1] user=sekondquad,db=dbt3,client=[local] LOG:  duration: 592.085 ms
2014-11-03 23:35:58 UTC [3075]: [7-1] user=sekondquad,db=dbt3,client=[local] LOG:  statement: COMMIT;
2014-11-03 23:35:58 UTC [3075]: [8-1] user=sekondquad,db=dbt3,client=[local] LOG:  duration: 0.099 ms
2014-11-03 23:35:58 UTC [3075]: [9-1] user=sekondquad,db=dbt3,client=[local] LOG:  disconnection: session time: 0:00:00.597 user=sekondquad database=dbt3 host=[local]
2014-11-03 23:35:58 UTC [3077]: [1-1] user=[unknown],db=[unknown],client= LOG:  connection received: host=[local]
2014-11-03 23:35:58 UTC [3077]: [2-1] user=sekondquad,db=dbt3,client=[local] LOG:  connection authorized: user=sekondquad database=dbt3
2014-11-03 23:35:58 UTC [3077]: [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-03 23:35:58 UTC [3077]: [4-1] user=sekondquad,db=dbt3,client=[local] LOG:  duration: 2.029 ms
2014-11-03 23:35:58 UTC [3077]: [5-1] user=sekondquad,db=dbt3,client=[local] LOG:  disconnection: session time: 0:00:00.004 user=sekondquad database=dbt3 host=[local]
2014-11-03 23:35:58 UTC [3083]: [1-1] user=[unknown],db=[unknown],client= LOG:  connection received: host=[local]
2014-11-03 23:35:58 UTC [3083]: [2-1] user=sekondquad,db=dbt3,client=[local] LOG:  connection authorized: user=sekondquad database=dbt3
2014-11-03 23:35:58 UTC [3083]: [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-03 23:35:58 UTC [3083]: [4-1] user=sekondquad,db=dbt3,client=[local] LOG:  duration: 0.871 ms
2014-11-03 23:35:58 UTC [3083]: [5-1] user=sekondquad,db=dbt3,client=[local] LOG:  disconnection: session time: 0:00:00.002 user=sekondquad database=dbt3 host=[local]
2014-11-03 23:35:58 UTC [3085]: [1-1] user=[unknown],db=[unknown],client= LOG:  connection received: host=[local]
2014-11-03 23:35:58 UTC [3085]: [2-1] user=sekondquad,db=dbt3,client=[local] LOG:  connection authorized: user=sekondquad database=dbt3
2014-11-03 23:35:58 UTC [3085]: [3-1] user=sekondquad,db=dbt3,client=[local] LOG:  statement: BEGIN;
2014-11-03 23:35:58 UTC [3085]: [4-1] user=sekondquad,db=dbt3,client=[local] LOG:  duration: 0.141 ms
2014-11-03 23:35:58 UTC [3085]: [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 '1996-01-01'
		and o_orderdate < date '1996-01-01' + interval '1 year'
	group by
		n_name
	order by
		revenue desc;
2014-11-03 23:36:12 UTC [3085]: [6-1] user=sekondquad,db=dbt3,client=[local] LOG:  duration: 14417.834 ms
2014-11-03 23:36:12 UTC [3085]: [7-1] user=sekondquad,db=dbt3,client=[local] LOG:  statement: COMMIT;
2014-11-03 23:36:12 UTC [3085]: [8-1] user=sekondquad,db=dbt3,client=[local] LOG:  duration: 0.126 ms
2014-11-03 23:36:12 UTC [3085]: [9-1] user=sekondquad,db=dbt3,client=[local] LOG:  disconnection: session time: 0:00:14.422 user=sekondquad database=dbt3 host=[local]
2014-11-03 23:36:12 UTC [3091]: [1-1] user=[unknown],db=[unknown],client= LOG:  connection received: host=[local]
2014-11-03 23:36:12 UTC [3091]: [2-1] user=sekondquad,db=dbt3,client=[local] LOG:  connection authorized: user=sekondquad database=dbt3
2014-11-03 23:36:12 UTC [3091]: [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-03 23:36:12 UTC [3091]: [4-1] user=sekondquad,db=dbt3,client=[local] LOG:  duration: 3.724 ms
2014-11-03 23:36:12 UTC [3091]: [5-1] user=sekondquad,db=dbt3,client=[local] LOG:  disconnection: session time: 0:00:00.008 user=sekondquad database=dbt3 host=[local]
2014-11-03 23:36:12 UTC [3097]: [1-1] user=[unknown],db=[unknown],client= LOG:  connection received: host=[local]
2014-11-03 23:36:12 UTC [3097]: [2-1] user=sekondquad,db=dbt3,client=[local] LOG:  connection authorized: user=sekondquad database=dbt3
2014-11-03 23:36:12 UTC [3097]: [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-03 23:36:12 UTC [3097]: [4-1] user=sekondquad,db=dbt3,client=[local] LOG:  duration: 1.560 ms
2014-11-03 23:36:12 UTC [3097]: [5-1] user=sekondquad,db=dbt3,client=[local] LOG:  disconnection: session time: 0:00:00.004 user=sekondquad database=dbt3 host=[local]
2014-11-03 23:36:12 UTC [3099]: [1-1] user=[unknown],db=[unknown],client= LOG:  connection received: host=[local]
2014-11-03 23:36:12 UTC [3099]: [2-1] user=sekondquad,db=dbt3,client=[local] LOG:  connection authorized: user=sekondquad database=dbt3
2014-11-03 23:36:12 UTC [3099]: [3-1] user=sekondquad,db=dbt3,client=[local] LOG:  statement: BEGIN;
2014-11-03 23:36:12 UTC [3099]: [4-1] user=sekondquad,db=dbt3,client=[local] LOG:  duration: 0.169 ms
2014-11-03 23:36:12 UTC [3099]: [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 = 'UNITED STATES' and n2.n_name = 'SAUDI ARABIA')
					or (n1.n_name = 'SAUDI ARABIA' and n2.n_name = 'UNITED STATES')
				)
				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-03 23:36:30 UTC [3099]: [6-1] user=sekondquad,db=dbt3,client=[local] LOG:  duration: 17437.240 ms
2014-11-03 23:36:30 UTC [3099]: [7-1] user=sekondquad,db=dbt3,client=[local] LOG:  statement: COMMIT;
2014-11-03 23:36:30 UTC [3099]: [8-1] user=sekondquad,db=dbt3,client=[local] LOG:  duration: 0.096 ms
2014-11-03 23:36:30 UTC [3099]: [9-1] user=sekondquad,db=dbt3,client=[local] LOG:  disconnection: session time: 0:00:17.442 user=sekondquad database=dbt3 host=[local]
2014-11-03 23:36:30 UTC [3105]: [1-1] user=[unknown],db=[unknown],client= LOG:  connection received: host=[local]
2014-11-03 23:36:30 UTC [3105]: [2-1] user=sekondquad,db=dbt3,client=[local] LOG:  connection authorized: user=sekondquad database=dbt3
2014-11-03 23:36:30 UTC [3105]: [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-03 23:36:30 UTC [3105]: [4-1] user=sekondquad,db=dbt3,client=[local] LOG:  duration: 3.851 ms
2014-11-03 23:36:30 UTC [3105]: [5-1] user=sekondquad,db=dbt3,client=[local] LOG:  disconnection: session time: 0:00:00.008 user=sekondquad database=dbt3 host=[local]
2014-11-03 23:36:30 UTC [3111]: [1-1] user=[unknown],db=[unknown],client= LOG:  connection received: host=[local]
2014-11-03 23:36:30 UTC [3111]: [2-1] user=sekondquad,db=dbt3,client=[local] LOG:  connection authorized: user=sekondquad database=dbt3
2014-11-03 23:36:30 UTC [3111]: [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-03 23:36:30 UTC [3111]: [4-1] user=sekondquad,db=dbt3,client=[local] LOG:  duration: 1.536 ms
2014-11-03 23:36:30 UTC [3111]: [5-1] user=sekondquad,db=dbt3,client=[local] LOG:  disconnection: session time: 0:00:00.005 user=sekondquad database=dbt3 host=[local]
2014-11-03 23:36:30 UTC [3113]: [1-1] user=[unknown],db=[unknown],client= LOG:  connection received: host=[local]
2014-11-03 23:36:30 UTC [3113]: [2-1] user=sekondquad,db=dbt3,client=[local] LOG:  connection authorized: user=sekondquad database=dbt3
2014-11-03 23:36:30 UTC [3113]: [3-1] user=sekondquad,db=dbt3,client=[local] LOG:  statement: BEGIN;
2014-11-03 23:36:30 UTC [3113]: [4-1] user=sekondquad,db=dbt3,client=[local] LOG:  duration: 0.168 ms
2014-11-03 23:36:30 UTC [3113]: [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 ('AIR', 'TRUCK')
		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-03 23:36:53 UTC [3129]: [1-1] user=[unknown],db=[unknown],client= LOG:  connection received: host=[local]
2014-11-03 23:36:53 UTC [3128]: [1-1] user=[unknown],db=[unknown],client= LOG:  connection received: host=[local]
2014-11-03 23:36:53 UTC [3128]: [2-1] user=sekondquad,db=dbt3,client=[local] LOG:  connection authorized: user=sekondquad database=dbt3
2014-11-03 23:36:53 UTC [3129]: [2-1] user=sekondquad,db=dbt3,client=[local] LOG:  connection authorized: user=sekondquad database=dbt3
2014-11-03 23:36:53 UTC [3130]: [1-1] user=[unknown],db=[unknown],client= LOG:  connection received: host=[local]
2014-11-03 23:36:53 UTC [3132]: [1-1] user=[unknown],db=[unknown],client= LOG:  connection received: host=[local]
2014-11-03 23:36:53 UTC [3130]: [2-1] user=sekondquad,db=dbt3,client=[local] LOG:  connection authorized: user=sekondquad database=dbt3
2014-11-03 23:36:53 UTC [3132]: [2-1] user=sekondquad,db=dbt3,client=[local] LOG:  connection authorized: user=sekondquad database=dbt3
2014-11-03 23:36:53 UTC [3128]: [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-03 23:36:53 UTC [3130]: [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-03 23:36:53 UTC [3129]: [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-03 23:36:53 UTC [3131]: [1-1] user=[unknown],db=[unknown],client= LOG:  connection received: host=[local]
2014-11-03 23:36:53 UTC [3132]: [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-03 23:36:53 UTC [3131]: [2-1] user=sekondquad,db=dbt3,client=[local] LOG:  connection authorized: user=sekondquad database=dbt3
2014-11-03 23:36:53 UTC [3131]: [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-03 23:36:53 UTC [3128]: [4-1] user=sekondquad,db=dbt3,client=[local] LOG:  duration: 4.238 ms
2014-11-03 23:36:53 UTC [3128]: [5-1] user=sekondquad,db=dbt3,client=[local] LOG:  disconnection: session time: 0:00:00.008 user=sekondquad database=dbt3 host=[local]
2014-11-03 23:36:53 UTC [3131]: [4-1] user=sekondquad,db=dbt3,client=[local] LOG:  duration: 2.765 ms
2014-11-03 23:36:53 UTC [3131]: [5-1] user=sekondquad,db=dbt3,client=[local] LOG:  disconnection: session time: 0:00:00.005 user=sekondquad database=dbt3 host=[local]
2014-11-03 23:36:53 UTC [3130]: [4-1] user=sekondquad,db=dbt3,client=[local] LOG:  duration: 9.079 ms
2014-11-03 23:36:53 UTC [3130]: [5-1] user=sekondquad,db=dbt3,client=[local] LOG:  disconnection: session time: 0:00:00.011 user=sekondquad database=dbt3 host=[local]
2014-11-03 23:36:53 UTC [3129]: [4-1] user=sekondquad,db=dbt3,client=[local] LOG:  duration: 10.408 ms
2014-11-03 23:36:53 UTC [3129]: [5-1] user=sekondquad,db=dbt3,client=[local] LOG:  disconnection: session time: 0:00:00.014 user=sekondquad database=dbt3 host=[local]
2014-11-03 23:36:53 UTC [3132]: [4-1] user=sekondquad,db=dbt3,client=[local] LOG:  duration: 12.776 ms
2014-11-03 23:36:53 UTC [3132]: [5-1] user=sekondquad,db=dbt3,client=[local] LOG:  disconnection: session time: 0:00:00.015 user=sekondquad database=dbt3 host=[local]
2014-11-03 23:36:54 UTC [3113]: [6-1] user=sekondquad,db=dbt3,client=[local] LOG:  duration: 24141.405 ms
2014-11-03 23:36:54 UTC [3113]: [7-1] user=sekondquad,db=dbt3,client=[local] LOG:  statement: COMMIT;
2014-11-03 23:36:54 UTC [3113]: [8-1] user=sekondquad,db=dbt3,client=[local] LOG:  duration: 0.137 ms
2014-11-03 23:36:54 UTC [3113]: [9-1] user=sekondquad,db=dbt3,client=[local] LOG:  disconnection: session time: 0:00:24.146 user=sekondquad database=dbt3 host=[local]
2014-11-03 23:36:54 UTC [3134]: [1-1] user=[unknown],db=[unknown],client= LOG:  connection received: host=[local]
2014-11-03 23:36:54 UTC [3134]: [2-1] user=sekondquad,db=dbt3,client=[local] LOG:  connection authorized: user=sekondquad database=dbt3
2014-11-03 23:36:54 UTC [3134]: [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-03 23:36:54 UTC [3134]: [4-1] user=sekondquad,db=dbt3,client=[local] LOG:  duration: 3.876 ms
2014-11-03 23:36:54 UTC [3134]: [5-1] user=sekondquad,db=dbt3,client=[local] LOG:  disconnection: session time: 0:00:00.008 user=sekondquad database=dbt3 host=[local]
2014-11-03 23:36:54 UTC [3138]: [1-1] user=[unknown],db=[unknown],client= LOG:  connection received: host=[local]
2014-11-03 23:36:54 UTC [3138]: [2-1] user=sekondquad,db=dbt3,client=[local] LOG:  connection authorized: user=sekondquad database=dbt3
2014-11-03 23:36:54 UTC [3138]: [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-03 23:36:54 UTC [3138]: [4-1] user=sekondquad,db=dbt3,client=[local] LOG:  duration: 1.501 ms
2014-11-03 23:36:54 UTC [3138]: [5-1] user=sekondquad,db=dbt3,client=[local] LOG:  disconnection: session time: 0:00:00.005 user=sekondquad database=dbt3 host=[local]
2014-11-03 23:36:54 UTC [3143]: [1-1] user=[unknown],db=[unknown],client= LOG:  connection received: host=[local]
2014-11-03 23:36:54 UTC [3143]: [2-1] user=sekondquad,db=dbt3,client=[local] LOG:  connection authorized: user=sekondquad database=dbt3
2014-11-03 23:36:54 UTC [3143]: [3-1] user=sekondquad,db=dbt3,client=[local] LOG:  statement: BEGIN;
2014-11-03 23:36:54 UTC [3143]: [4-1] user=sekondquad,db=dbt3,client=[local] LOG:  duration: 0.168 ms
2014-11-03 23:36:54 UTC [3143]: [5-1] user=sekondquad,db=dbt3,client=[local] LOG:  statement: CREATE TEMPORARY TABLE tmp_orderkey2 (orderkey numeric(10));
2014-11-03 23:36:54 UTC [3143]: [6-1] user=sekondquad,db=dbt3,client=[local] LOG:  duration: 4.208 ms
2014-11-03 23:36:54 UTC [3143]: [7-1] user=sekondquad,db=dbt3,client=[local] LOG:  statement: COPY tmp_orderkey2
	FROM '/home/sekondquad/dbt3/dss/delete.2' USING DELIMITERS '|';
2014-11-03 23:36:54 UTC [3143]: [8-1] user=sekondquad,db=dbt3,client=[local] LOG:  duration: 13.605 ms
2014-11-03 23:36:54 UTC [3143]: [9-1] user=sekondquad,db=dbt3,client=[local] LOG:  statement: CREATE INDEX
	ON tmp_orderkey2 (orderkey);
2014-11-03 23:36:54 UTC [3143]: [10-1] user=sekondquad,db=dbt3,client=[local] LOG:  duration: 6.880 ms
2014-11-03 23:36:54 UTC [3143]: [11-1] user=sekondquad,db=dbt3,client=[local] LOG:  statement: ANALYZE tmp_orderkey2;
2014-11-03 23:36:54 UTC [3143]: [12-1] user=sekondquad,db=dbt3,client=[local] LOG:  duration: 4.840 ms
2014-11-03 23:36:54 UTC [3143]: [13-1] user=sekondquad,db=dbt3,client=[local] LOG:  statement: DELETE FROM lineitem
	USING tmp_orderkey2
	WHERE l_orderkey = orderkey;
2014-11-03 23:37:17 UTC [3143]: [14-1] user=sekondquad,db=dbt3,client=[local] LOG:  duration: 22678.728 ms
2014-11-03 23:37:17 UTC [3143]: [15-1] user=sekondquad,db=dbt3,client=[local] LOG:  statement: DELETE FROM orders
	USING tmp_orderkey2
	WHERE o_orderkey = orderkey;
2014-11-03 23:37:23 UTC [3143]: [16-1] user=sekondquad,db=dbt3,client=[local] LOG:  duration: 6464.121 ms
2014-11-03 23:37:23 UTC [3143]: [17-1] user=sekondquad,db=dbt3,client=[local] LOG:  statement: COMMIT;
2014-11-03 23:37:23 UTC [3143]: [18-1] user=sekondquad,db=dbt3,client=[local] LOG:  duration: 0.534 ms
2014-11-03 23:37:23 UTC [3143]: [19-1] user=sekondquad,db=dbt3,client=[local] LOG:  disconnection: session time: 0:00:29.179 user=sekondquad database=dbt3 host=[local]
2014-11-03 23:37:23 UTC [3155]: [1-1] user=[unknown],db=[unknown],client= LOG:  connection received: host=[local]
2014-11-03 23:37:23 UTC [3155]: [2-1] user=sekondquad,db=dbt3,client=[local] LOG:  connection authorized: user=sekondquad database=dbt3
2014-11-03 23:37:23 UTC [3155]: [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-03 23:37:23 UTC [3155]: [4-1] user=sekondquad,db=dbt3,client=[local] LOG:  duration: 3.685 ms
2014-11-03 23:37:23 UTC [3155]: [5-1] user=sekondquad,db=dbt3,client=[local] LOG:  disconnection: session time: 0:00:00.008 user=sekondquad database=dbt3 host=[local]
2014-11-03 23:37:23 UTC [3159]: [1-1] user=[unknown],db=[unknown],client= LOG:  connection received: host=[local]
2014-11-03 23:37:23 UTC [3159]: [2-1] user=sekondquad,db=dbt3,client=[local] LOG:  connection authorized: user=sekondquad database=dbt3
2014-11-03 23:37:23 UTC [3159]: [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-03 23:37:23 UTC [3159]: [4-1] user=sekondquad,db=dbt3,client=[local] LOG:  duration: 2.903 ms
2014-11-03 23:37:23 UTC [3159]: [5-1] user=sekondquad,db=dbt3,client=[local] LOG:  disconnection: session time: 0:00:00.006 user=sekondquad database=dbt3 host=[local]
2014-11-03 23:37:23 UTC [2349]: [2-1] user=,db=,client= LOG:  received smart shutdown request
2014-11-03 23:37:23 UTC [2360]: [2-1] user=,db=,client= LOG:  autovacuum launcher shutting down
2014-11-03 23:37:24 UTC [2352]: [1-1] user=,db=,client= LOG:  shutting down
2014-11-03 23:37:24 UTC [2352]: [2-1] user=,db=,client= LOG:  checkpoint starting: shutdown immediate
2014-11-03 23:37:24 UTC [2352]: [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.056 s, sync=0.006 s, total=0.080 s; sync files=51, longest=0.002 s, average=0.000 s
2014-11-03 23:37:24 UTC [2352]: [4-1] user=,db=,client= LOG:  database system is shut down