explain.depesz.com

PostgreSQL's explain analyze made readable

Result: cT17

Settings
# exclusive inclusive rows x rows loops node
1. 0.012 0.094 ↑ 1.0 1 1

Nested Loop (cost=0.98..17.19 rows=1 width=12) (actual time=0.090..0.094 rows=1 loops=1)

2. 0.003 0.069 ↑ 1.0 1 1

Nested Loop (cost=0.70..16.82 rows=1 width=4) (actual time=0.067..0.069 rows=1 loops=1)

3. 0.055 0.055 ↑ 1.0 1 1

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

  • Index Cond: (smw_hash = 'fb2bca05566eaa09f08c0eb154776fdb8210c75d'::text)
  • Filter: ((smw_iw <> ':smw'::text) AND (smw_iw <> ':smw-delete'::text))
4. 0.011 0.011 ↑ 3.0 1 1

Index Scan using smw_fpt_ask_idx_sid on smw_fpt_ask (cost=0.29..8.36 rows=3 width=8) (actual time=0.010..0.011 rows=1 loops=1)

  • Index Cond: (s_id = p.smw_id)
5. 0.013 0.013 ↑ 1.0 1 1

Index Only Scan using smw_object_ids_idx_id_touched on smw_object_ids v (cost=0.29..0.36 rows=1 width=12) (actual time=0.012..0.013 rows=1 loops=1)

  • Index Cond: (smw_id = smw_fpt_ask.o_id)
  • Heap Fetches: 0