explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 9Nnz

Settings
# exclusive inclusive rows x rows loops node
1. 2,671.356 2,671.356 ↓ 1.1 49,413 1

Index Scan using history_place_stops_history_place_id_idx on history_place_stops (cost=0.42..70,786.89 rows=43,266 width=32) (actual time=0.329..2,671.356 rows=49,413 loops=1)

  • Index Cond: (history_place_id = 168436)
  • Filter: (ellipse_95 IS NOT NULL)
  • Rows Removed by Filter: 28271
Planning time : 0.197 ms
Execution time : 2,676.086 ms