explain.depesz.com

PostgreSQL's explain analyze made readable

Result: L7Uk : 234

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

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

  • Index Cond: (id = 1182)
  • Filter: (((COALESCE(mod_date, reg_date) > geometry_mod_date) OR (geometry_mod_date IS NULL)) AND (status = 'A'::bpchar))