explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 3TtI

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

Limit (cost=0.56..366.36 rows=1 width=8) (actual time=0.057..0.057 rows=0 loops=1)

2. 0.055 0.055 ↓ 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=8) (actual time=0.055..0.055 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.274 ms
Execution time : 0.098 ms