explain.depesz.com

PostgreSQL's explain analyze made readable

Result: ANxw

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=)

2. 0.000 0.000 ↓ 0.0

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

3. 0.000 0.000 ↓ 0.0

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

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

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

  • Index Cond: (s_id = p.smw_id)
5. 0.000 0.000 ↓ 0.0

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

  • Index Cond: (smw_id = smw_fpt_ask.o_id)