explain.depesz.com

PostgreSQL's explain analyze made readable

Result: g6JU : no index - 2 - parallel seq scan

Settings
# exclusive inclusive rows x rows loops node
1. 11.135 14,010.554 ↑ 2.3 30,119 1

Finalize GroupAggregate (cost=1,167,582.60..1,178,101.06 rows=70,120 width=28) (actual time=13,973.307..14,010.554 rows=30,119 loops=1)

  • Group Key: person_id
  • Buffers: shared read=219904
2. 230.446 13,999.419 ↑ 1.9 39,746 1

Gather Merge (cost=1,167,582.60..1,177,017.82 rows=76,408 width=24) (actual time=13,973.301..13,999.419 rows=39,746 loops=1)

  • Workers Planned: 4
  • Workers Launched: 4
  • Buffers: shared hit=212 read=1109587
3. 3.832 13,768.973 ↑ 2.4 7,949 5 / 5

Partial GroupAggregate (cost=1,166,582.55..1,166,916.83 rows=19,102 width=24) (actual time=13,763.346..13,768.973 rows=7,949 loops=5)

  • Group Key: person_id
  • Buffers: shared hit=212 read=1109587
4. 15.514 13,765.141 ↑ 1.3 15,232 5 / 5

Sort (cost=1,166,582.55..1,166,630.30 rows=19,102 width=24) (actual time=13,763.341..13,765.141 rows=15,232 loops=5)

  • Sort Key: person_id
  • Sort Method: quicksort Memory: 1547kB
  • Buffers: shared hit=212 read=1109587
5. 13,749.627 13,749.627 ↑ 1.3 15,232 5 / 5

Parallel Seq Scan on max_test_2018_3 o (cost=0.00..1,165,224.26 rows=19,102 width=24) (actual time=17.267..13,749.627 rows=15,232 loops=5)

  • Filter: ((location_path)::text ~~ '/tax-calculator%'::text)
  • Rows Removed by Filter: 3545552
  • Buffers: shared read=1109587
Planning time : 7.365 ms
Execution time : 14,012.602 ms