explain.depesz.com

PostgreSQL's explain analyze made readable

Result: EcV6 : 234234

Settings
# exclusive inclusive rows x rows loops node
1. 3.424 3.424 ↓ 6,278.0 6,278 1

Index Scan using uzgps_routing_trip_template_contract_id_status_idx on uzgps_routing_trip_template (cost=0.28..8.30 rows=1 width=128) (actual time=0.038..3.424 rows=6,278 loops=1)

  • Index Cond: ((contract_id = 4) AND (status = 'A'::bpchar))