explain.depesz.com

PostgreSQL's explain analyze made readable

Result: Sw6Q

Settings
# exclusive inclusive rows x rows loops node
1. 55.335 81,822.367 ↑ 2.3 30,119 1

HashAggregate (cost=76,169.85..76,871.05 rows=70,120 width=28) (actual time=81,816.273..81,822.367 rows=30,119 loops=1)

  • Group Key: person_id
  • Buffers: shared hit=12965 read=59902
2. 81,767.032 81,767.032 ↑ 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=0.018..81,767.032 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 hit=12965 read=59902
Planning time : 1.799 ms
Execution time : 81,825.574 ms