explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 4cI1

Settings
# exclusive inclusive rows x rows loops node
1. 0.000 600.637 ↑ 1.0 206,405 1

Gather Merge (cost=128,861.86..152,965.01 rows=206,584 width=556) (actual time=495.012..600.637 rows=206,405 loops=1)

  • Output: tagid, intvalue, floatvalue, stringvalue, datevalue, t_stamp, dataintegrity
  • Workers Planned: 2
  • Workers Launched: 2
  • Buffers: shared hit=40537
2. 137.292 1,268.505 ↑ 1.5 68,802 3

Sort (cost=127,861.83..128,120.06 rows=103,292 width=556) (actual time=420.157..422.835 rows=68,802 loops=3)

  • Output: tagid, intvalue, floatvalue, stringvalue, datevalue, t_stamp, dataintegrity
  • Sort Key: sqlt_data_1_2019_01.t_stamp, sqlt_data_1_2019_01.tagid
  • Sort Method: quicksort Memory: 9222kB
  • Worker 0: Sort Method: quicksort Memory: 6305kB
  • Worker 1: Sort Method: quicksort Memory: 8280kB
  • Buffers: shared hit=40537
  • Worker 0: actual time=355.782..358.193 rows=61035 loops=1
  • Buffers: shared hit=11953
  • Worker 1: actual time=411.028..413.742 rows=66658 loops=1
  • Buffers: shared hit=13210
3. 1,131.213 1,131.213 ↑ 1.5 68,802 3

Parallel Index Scan using sqlt_data_1_2019_01t_stampndx on public.sqlt_data_1_2019_01 (cost=0.44..119,259.48 rows=103,292 width=556) (actual time=0.085..377.071 rows=68,802 loops=3)

  • Output: tagid, intvalue, floatvalue, stringvalue, datevalue, t_stamp, dataintegrity
  • Index Cond: ((sqlt_data_1_2019_01.t_stamp >= '1548194400000'::bigint) AND (sqlt_data_1_2019_01.t_stamp <= '1548280800000'::bigint))
  • Filter: ((sqlt_data_1_2019_01.tagid = 2) OR (sqlt_data_1_2019_01.tagid = 73) OR (sqlt_data_1_2019_01.tagid = 138))
  • Rows Removed by Filter: 975467
  • Buffers: shared hit=40509
  • Worker 0: actual time=0.103..319.231 rows=61035 loops=1
  • Buffers: shared hit=11939
  • Worker 1: actual time=0.096..368.946 rows=66658 loops=1
  • Buffers: shared hit=13196