explain.depesz.com

PostgreSQL's explain analyze made readable

Result: NDSH

Settings
# exclusive inclusive rows x rows loops node
1. 7.580 46,147.883 ↑ 4.9 26,216 1

Finalize GroupAggregate (cost=7,155,859.87..7,179,246.78 rows=128,396 width=28) (actual time=46,108.380..46,147.883 rows=26,216 loops=1)

  • Group Key: person_id
  • Buffers: shared hit=46906 read=972162
2. 0.000 46,140.303 ↑ 3.6 47,972 1

Gather Merge (cost=7,155,859.87..7,177,102.68 rows=172,028 width=24) (actual time=46,108.376..46,140.303 rows=47,972 loops=1)

  • Workers Planned: 4
  • Workers Launched: 4
  • Buffers: shared hit=235270 read=4850992
3. 32.260 230,511.420 ↑ 4.5 9,594 5

Partial GroupAggregate (cost=7,154,859.81..7,155,612.43 rows=43,007 width=24) (actual time=46,092.506..46,102.284 rows=9,594 loops=5)

  • Group Key: person_id
  • Buffers: shared hit=235270 read=4850992
4. 193.915 230,479.160 ↑ 1.3 33,922 5

Sort (cost=7,154,859.81..7,154,967.33 rows=43,007 width=24) (actual time=46,092.500..46,095.832 rows=33,922 loops=5)

  • Sort Key: person_id
  • Sort Method: quicksort Memory: 4173kB
  • Buffers: shared hit=235270 read=4850992
5. 230,285.245 230,285.245 ↑ 1.3 33,922 5

Parallel Seq Scan on max_test_click_2018_3 o (cost=0.00..7,151,549.93 rows=43,007 width=24) (actual time=10.837..46,057.049 rows=33,922 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: 8908475
  • Buffers: shared hit=235058 read=4850992
Planning time : 1.763 ms
Execution time : 46,151.138 ms