explain.depesz.com

PostgreSQL's explain analyze made readable

Result: w8zf : seq scan no index

Settings
# exclusive inclusive rows x rows loops node
1. 12.617 22,758.083 ↓ 150.6 30,119 1

GroupAggregate (cost=1,123,801.86..1,123,845.47 rows=200 width=28) (actual time=22,740.250..22,758.083 rows=30,119 loops=1)

  • Group Key: person_id
  • Buffers: shared hit=3 read=1109587
2. 51.801 22,745.466 ↓ 13.7 76,161 1

Sort (cost=1,123,801.86..1,123,815.73 rows=5,548 width=24) (actual time=22,740.243..22,745.466 rows=76,161 loops=1)

  • Sort Key: person_id
  • Sort Method: quicksort Memory: 9023kB
  • Buffers: shared hit=3 read=1109587
3. 22,693.665 22,693.665 ↓ 13.7 76,161 1

Seq Scan on max_test2_2018_3 o (cost=0.00..1,123,456.84 rows=5,548 width=24) (actual time=3.581..22,693.665 rows=76,161 loops=1)

  • Filter: ((location_path)::text ~~ '/tax-calculator%'::text)
  • Rows Removed by Filter: 17727761
  • Buffers: shared read=1109587
Planning time : 0.246 ms
Execution time : 22,759.999 ms