explain.depesz.com

PostgreSQL's explain analyze made readable

Result: Lwtk

Settings
# exclusive inclusive rows x rows loops node
1. 0.000 0.003 ↓ 0.0 0 1

Nested Loop (cost=1.42..33.25 rows=1 width=104) (actual time=0.003..0.003 rows=0 loops=1)

2. 0.000 0.003 ↓ 0.0 0 1

Nested Loop (cost=1.14..16.93 rows=1 width=112) (actual time=0.003..0.003 rows=0 loops=1)

3. 0.000 0.003 ↓ 0.0 0 1

Nested Loop (cost=0.85..12.92 rows=1 width=24) (actual time=0.003..0.003 rows=0 loops=1)

4. 0.003 0.003 ↓ 0.0 0 1

Index Scan using spcd_match__quotation on spcd_match (cost=0.42..8.44 rows=1 width=16) (actual time=0.003..0.003 rows=0 loops=1)

  • Index Cond: (quotation_id IS NULL)
5. 0.000 0.000 ↓ 0.0 0

Index Only Scan using alert_match_pkey on alert_match (cost=0.43..4.45 rows=1 width=8) (never executed)

  • Index Cond: ((alert_id = 217782) AND (quotation_id = spcd_match.quotation_id))
  • Heap Fetches: 0
6. 0.000 0.000 ↓ 0.0 0

Index Scan using quotation_pkey on quotation (cost=0.29..4.01 rows=1 width=104) (never executed)

  • Index Cond: (id = alert_match.quotation_id)
  • Filter: (published_at > '2018-11-28 00:00:00+00'::timestamp with time zone)
7. 0.000 0.000 ↓ 0.0 0

Index Scan using spcd_pkey on spcd (cost=0.29..8.30 rows=1 width=8) (never executed)

  • Index Cond: (root_id = spcd_match.spcd_root_id)
  • Filter: (user_id = 1934165)