explain.depesz.com

PostgreSQL's explain analyze made readable

Result: BQwk : 34

Settings
# exclusive inclusive rows x rows loops node
1. 0.444 0.444 ↓ 224.0 224 1

Index Scan using uzgps_routing_route_id_status_idx on uzgps_routing_route rr (cost=0.27..13.37 rows=1 width=32) (actual time=0.139..0.444 rows=224 loops=1)

  • Index Cond: ((id > 100) AND (status = 'A'::bpchar))