explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 69WS : with index

Settings
# exclusive inclusive rows x rows loops node
1. 125.398 193,123.508 ↑ 4.9 26,216 1

HashAggregate (cost=174,317.03..175,601.18 rows=128,415 width=28) (actual time=193,117.243..193,123.508 rows=26,216 loops=1)

  • Group Key: person_id
  • Buffers: shared read=118372
2. 192,998.110 192,998.110 ↑ 1.0 169,608 1

Index Scan using max_test_click_2018_3_ix on max_test_click_2018_3 o (cost=0.56..173,456.72 rows=172,062 width=24) (actual time=6.496..192,998.110 rows=169,608 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=118372
Planning time : 5.576 ms
Execution time : 193,128.096 ms