explain.depesz.com

PostgreSQL's explain analyze made readable

Result: lo8n

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

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

2. 0.107 0.107 ↓ 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.107..0.107 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.147 ms