explain.depesz.com

PostgreSQL's explain analyze made readable

Result: Xx08 : 123

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

Index Scan using uzgps_routing_station_contract_id_status_idx on uzgps_routing_station (cost=0.28..8.30 rows=1 width=8) (actual time=0.017..0.017 rows=0 loops=1)

  • Index Cond: ((contract_id = 9) AND (status = 'A'::bpchar))
  • Filter: (upper((name)::text) ~~ '%11%'::text)