explain.depesz.com

PostgreSQL's explain analyze made readable

Result: F8Qe : WITH

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

Limit (cost=0.60..366.17 rows=1 width=8) (actual time=0.037..0.037 rows=0 loops=1)

2.          

CTE final_status

3. 0.001 0.001 ↑ 3.0 1 1

Values Scan on "*VALUES*" (cost=0.00..0.04 rows=3 width=32) (actual time=0.001..0.001 rows=1 loops=1)

4. 0.002 0.036 ↓ 0.0 0 1

Nested Loop Anti Join (cost=0.56..366.13 rows=1 width=8) (actual time=0.036..0.036 rows=0 loops=1)

  • Join Filter: ((sa.import_status)::text = fs.import_status)
5. 0.031 0.031 ↑ 1.0 1 1

Index Scan using stream_ad_partner_ad_ref_stream_ad_id_idx on stream_ad sa (cost=0.56..366.02 rows=1 width=12) (actual time=0.030..0.031 rows=1 loops=1)

  • Index Cond: (partner_ad_ref = '2234842'::text)
  • Filter: (client_contract_broadcast_id = 4654)
6. 0.003 0.003 ↑ 3.0 1 1

CTE Scan on final_status fs (cost=0.00..0.06 rows=3 width=32) (actual time=0.003..0.003 rows=1 loops=1)

Planning time : 0.182 ms
Execution time : 0.063 ms