explain.depesz.com

PostgreSQL's explain analyze made readable

Result: cCy

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

Nested Loop (cost=0.98..17.56 rows=1 width=12) (actual rows= loops=)

  • Output: v.smw_id, v.smw_touched
2. 0.000 0.000 ↓ 0.0

Nested Loop (cost=0.70..16.83 rows=1 width=4) (actual rows= loops=)

  • Output: smw_fpt_ask.o_id
3. 0.000 0.000 ↓ 0.0

Index Scan using smw_object_ids_idx_hash_id on mediawiki.smw_object_ids p (cost=0.41..8.43 rows=1 width=4) (actual rows= loops=)

  • Output: p.smw_id
  • Index Cond: (p.smw_hash = 'df94fef3f6d137414c22d639569e458c8f54e879'::text)
  • Filter: ((p.smw_iw <> ':smw'::text) AND (p.smw_iw <> ':smw-delete'::text))
4. 0.000 0.000 ↓ 0.0

Index Scan using smw_fpt_ask_idx_sid on mediawiki.smw_fpt_ask (cost=0.29..8.37 rows=3 width=8) (actual rows= loops=)

  • Output: smw_fpt_ask.s_id, smw_fpt_ask.o_id
  • Index Cond: (smw_fpt_ask.s_id = p.smw_id)
5. 0.000 0.000 ↓ 0.0

Index Scan using smw_object_ids_idx_id on mediawiki.smw_object_ids v (cost=0.29..0.72 rows=1 width=12) (actual rows= loops=)

  • Output: v.smw_id, v.smw_touched
  • Index Cond: (v.smw_id = smw_fpt_ask.o_id)