explain.depesz.com

PostgreSQL's explain analyze made readable

Result: mx6H

Settings
# exclusive inclusive rows x rows loops node
1. 9.899 1,550.510 ↑ 2.4 30,119 1

Finalize GroupAggregate (cost=1,633,709.79..1,644,734.87 rows=71,742 width=60) (actual time=1,518.964..1,550.510 rows=30,119 loops=1)

  • Group Key: person_id, ('ALL'::text)
  • Buffers: shared hit=431146 read=6635
2. 0.000 1,540.611 ↑ 2.0 39,634 1

Gather Merge (cost=1,633,709.79..1,643,430.05 rows=78,320 width=56) (actual time=1,518.959..1,540.611 rows=39,634 loops=1)

  • Workers Planned: 4
  • Workers Launched: 4
  • Buffers: shared hit=2149631 read=34836
3. 18.020 7,591.865 ↑ 2.5 7,927 5

Partial GroupAggregate (cost=1,632,709.73..1,633,101.33 rows=19,580 width=56) (actual time=1,513.594..1,518.373 rows=7,927 loops=5)

  • Group Key: person_id, 'ALL'::text
  • Buffers: shared hit=2149631 read=34836
4. 43.300 7,573.845 ↑ 1.3 15,232 5

Sort (cost=1,632,709.73..1,632,758.68 rows=19,580 width=56) (actual time=1,513.588..1,514.769 rows=15,232 loops=5)

  • Sort Key: person_id
  • Sort Method: quicksort Memory: 1586kB
  • Buffers: shared hit=2149631 read=34836
5. 7,530.545 7,530.545 ↑ 1.3 15,232 5

Parallel Seq Scan on max_test_2018_3 o (cost=0.00..1,631,313.96 rows=19,580 width=56) (actual time=0.245..1,506.109 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=2149419 read=34836
Planning time : 0.604 ms
Execution time : 1,552.250 ms