explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 84kE : with io timing 1 - with index

Settings
# exclusive inclusive rows x rows loops node
1. 70.378 108,851.847 ↑ 2.3 30,119 1

HashAggregate (cost=76,169.85..76,871.05 rows=70,120 width=28) (actual time=108,845.753..108,851.847 rows=30,119 loops=1)

  • Group Key: person_id
  • Buffers: shared read=72867
  • I/O Timings: read=108505.850
2. 108,781.469 108,781.469 ↑ 1.0 76,161 1

Index Scan using max_test_2018_3_ix on max_test_2018_3 o (cost=0.56..75,787.82 rows=76,406 width=24) (actual time=5.021..108,781.469 rows=76,161 loops=1)

  • Index Cond: (((location_path)::text ~>=~ '/tax-calculator'::text) AND ((location_path)::text ~<~ '/tax-calculatos'::text))
  • Filter: ((location_path)::text ~~ '/tax-calculator%'::text)
  • Buffers: shared read=72867
  • I/O Timings: read=108505.850
Planning time : 14.409 ms
Execution time : 108,856.219 ms