explain.depesz.com

PostgreSQL's explain analyze made readable

Result: aSvD

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

Limit (cost=0.56..366.11 rows=1 width=8) (actual time=0.038..0.038 rows=0 loops=1)

2. 0.007 0.037 ↓ 0.0 0 1

Nested Loop Left Join (cost=0.56..366.11 rows=1 width=8) (actual time=0.037..0.037 rows=0 loops=1)

  • Join Filter: ("*VALUES*".column1 = (sa.import_status)::text)
  • Rows Removed by Join Filter: 2
  • Filter: ((ROW("*VALUES*".column1)) IS NULL)
  • Rows Removed by Filter: 1
3. 0.026 0.026 ↑ 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.023..0.026 rows=1 loops=1)

  • Index Cond: (partner_ad_ref = '2234842'::text)
  • Filter: (client_contract_broadcast_id = 4654)
4. 0.004 0.004 ↑ 1.0 3 1

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

Planning time : 0.182 ms
Execution time : 0.073 ms