explain.depesz.com

PostgreSQL's explain analyze made readable

Result: ERsCs : LEFT JOIN

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

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

2. 0.015 0.101 ↓ 0.0 0 1

Nested Loop Left Join (cost=0.56..366.11 rows=1 width=8) (actual time=0.100..0.101 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.074 0.074 ↑ 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.071..0.074 rows=1 loops=1)

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

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

Planning time : 0.624 ms
Execution time : 0.206 ms