explain.depesz.com

PostgreSQL's explain analyze made readable

Result: N4uo : big maxtest click - nonindex seq scan parallel

Settings
# exclusive inclusive rows x rows loops node
1. 8.178 42,102.222 ↑ 4.9 26,216 1

Finalize GroupAggregate (cost=5,112,560.65..5,135,952.38 rows=128,415 width=28) (actual time=42,061.185..42,102.222 rows=26,216 loops=1)

  • Group Key: person_id
  • Buffers: shared read=989268
2. 30.637 42,094.044 ↑ 3.6 47,957 1

Gather Merge (cost=5,112,560.65..5,133,807.91 rows=172,064 width=24) (actual time=42,061.179..42,094.044 rows=47,957 loops=1)

  • Workers Planned: 4
  • Workers Launched: 4
  • Buffers: shared hit=221 read=4968532
3. 6.324 42,063.407 ↑ 4.5 9,591 5 / 5

Partial GroupAggregate (cost=5,111,560.59..5,112,313.37 rows=43,016 width=24) (actual time=42,053.421..42,063.407 rows=9,591 loops=5)

  • Group Key: person_id
  • Buffers: shared hit=221 read=4968532
4. 40.219 42,057.083 ↑ 1.3 33,922 5 / 5

Sort (cost=5,111,560.59..5,111,668.13 rows=43,016 width=24) (actual time=42,053.414..42,057.083 rows=33,922 loops=5)

  • Sort Key: person_id
  • Sort Method: quicksort Memory: 4183kB
  • Buffers: shared hit=221 read=4968532
5. 42,016.864 42,016.864 ↑ 1.3 33,922 5 / 5

Parallel Seq Scan on max_test_click_2018_3 o (cost=0.00..5,108,249.95 rows=43,016 width=24) (actual time=11.471..42,016.864 rows=33,922 loops=5)

  • Filter: ((location_path)::text ~~ '/tax-calculator%'::text)
  • Rows Removed by Filter: 8908475
  • Buffers: shared hit=9 read=4968532
Planning time : 2.941 ms
Execution time : 42,105.166 ms