explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 3rTw

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

Nested Loop Left Join (cost=0.86..37.75 rows=5 width=1,011) (actual time=0.010..0.011 rows=0 loops=1)

2. 0.010 0.010 ↓ 0.0 0 1

Index Scan using scheduled_charges_quote_id_idx on scheduled_charges sc (cost=0.43..24.44 rows=5 width=1,007) (actual time=0.010..0.010 rows=0 loops=1)

  • Index Cond: (quote_id = ANY ('{421009,420518}'::integer[]))
  • Filter: ((deleted_by IS NULL) AND (cid = 5,222) AND (ar_trigger_id = ANY ('{202,206,102,101,103,104,105,108,307}'::integer[])))
3. 0.000 0.000 ↓ 0.0 0

Index Scan using uk_quote_lease_term_lease_start_window_id on quote_lease_terms qlt (cost=0.43..2.65 rows=1 width=16) (never executed)

  • Index Cond: ((cid = sc.cid) AND (cid = 5,222) AND (quote_id = sc.quote_id) AND (lease_term_id = sc.lease_term_id))
Planning time : 0.632 ms
Execution time : 0.062 ms