explain.depesz.com

PostgreSQL's explain analyze made readable

Result: rDbd : max_test_2018_3 no index - seq scan

Settings
# exclusive inclusive rows x rows loops node
1. 8.142 8,612.184 ↑ 2.4 30,119 1

Finalize GroupAggregate (cost=1,633,690.02..1,644,332.21 rows=70,879 width=28) (actual time=8,582.326..8,612.184 rows=30,119 loops=1)

  • Group Key: person_id
  • Buffers: shared hit=29326 read=209593
2. 0.000 8,604.042 ↑ 1.9 39,741 1

Gather Merge (cost=1,633,690.02..1,643,236.86 rows=77,312 width=24) (actual time=8,582.317..8,604.042 rows=39,741 loops=1)

  • Workers Planned: 4
  • Workers Launched: 4
  • Buffers: shared hit=145184 read=1037100
3. 16.920 42,486.710 ↑ 2.4 7,948 5

Partial GroupAggregate (cost=1,632,689.96..1,633,028.20 rows=19,328 width=24) (actual time=8,492.253..8,497.342 rows=7,948 loops=5)

  • Group Key: person_id
  • Buffers: shared hit=145184 read=1037100
4. 82.930 42,469.790 ↑ 1.3 15,232 5

Sort (cost=1,632,689.96..1,632,738.28 rows=19,328 width=24) (actual time=8,492.246..8,493.958 rows=15,232 loops=5)

  • Sort Key: person_id
  • Sort Method: quicksort Memory: 1589kB
  • Buffers: shared hit=145184 read=1037100
5. 42,386.860 42,386.860 ↑ 1.3 15,232 5

Parallel Seq Scan on max_test_2018_3 o (cost=0.00..1,631,313.96 rows=19,328 width=24) (actual time=8.530..8,477.372 rows=15,232 loops=5)

  • Filter: ((timestamp_ >= '2018-01-01 07:00:00'::timestamp without time zone) AND (timestamp_ <= '2018-05-01 05:59:59.999'::timestamp without time zone) AND ((location_path)::text ~~ '/tax-calculator%'::text))
  • Rows Removed by Filter: 3545552
  • Buffers: shared hit=144972 read=1037100
Planning time : 0.828 ms
Execution time : 8,614.227 ms