explain.depesz.com

PostgreSQL's explain analyze made readable

Result: L34C

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

Limit (cost=0.56..366.36 rows=1 width=12) (actual time=0.048..0.049 rows=0 loops=1)

2. 0.047 0.047 ↓ 0.0 0 1

Index Scan using stream_ad_partner_ad_ref_stream_ad_id_idx on stream_ad sa (cost=0.56..366.36 rows=1 width=12) (actual time=0.047..0.047 rows=0 loops=1)

  • Index Cond: (partner_ad_ref = '2234842'::text)
  • Filter: ((client_contract_broadcast_id = 4654) AND (import_status <> ALL ('{done,done_with_error,aborted}'::enum_stream_ad_status[])))
  • Rows Removed by Filter: 1
Planning time : 0.293 ms
Execution time : 0.090 ms