explain.depesz.com

PostgreSQL's explain analyze made readable

Result: pd7H : 345345

Settings
# exclusive inclusive rows x rows loops node
1. 0.028 0.028 ↓ 0.0 0 1

Index Scan using uzgps_routing_route_pkey on uzgps_routing_route (cost=0.27..8.30 rows=1 width=846) (actual time=0.028..0.028 rows=0 loops=1)

  • Index Cond: (id = 49)
  • Filter: (((COALESCE(mod_date, reg_date) > geometry_mod_date) OR (geometry_mod_date IS NULL)) AND (status = 'A'::bpchar))
  • Rows Removed by Filter: 1