explain.depesz.com

PostgreSQL's explain analyze made readable

Result: fjGp

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

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

2. 0.048 0.048 ↓ 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.048..0.048 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.201 ms
Execution time : 0.074 ms