explain.depesz.com

PostgreSQL's explain analyze made readable

Result: jk7r

Settings
# exclusive inclusive rows x rows loops node
1. 0.005 0.301 ↑ 1.0 1 1

Nested Loop (cost=0.84..24.93 rows=1 width=112) (actual time=0.298..0.301 rows=1 loops=1)

2. 0.004 0.286 ↑ 1.0 1 1

Nested Loop (cost=0.56..16.62 rows=1 width=26) (actual time=0.284..0.286 rows=1 loops=1)

3. 0.262 0.262 ↑ 1.0 1 1

Index Only Scan using smw_di_wikipage_idx_sid_pid_oid on smw_di_wikipage (cost=0.28..8.30 rows=1 width=12) (actual time=0.261..0.262 rows=1 loops=1)

  • Index Cond: ((s_id = 5098) AND (p_id = 4108))
  • Heap Fetches: 1
4. 0.020 0.020 ↑ 1.0 1 1

Index Scan using smw_object_ids_idx_id_sortkey on smw_object_ids p (cost=0.28..8.30 rows=1 width=22) (actual time=0.020..0.020 rows=1 loops=1)

  • Index Cond: (smw_id = 4108)
  • Filter: ((smw_iw <> ':smw'::text) AND (smw_iw <> ':smw-delete'::text))
5. 0.010 0.010 ↑ 1.0 1 1

Index Scan using smw_object_ids_idx_id_sortkey on smw_object_ids o0 (cost=0.28..8.30 rows=1 width=90) (actual time=0.009..0.010 rows=1 loops=1)

  • Index Cond: (smw_id = smw_di_wikipage.o_id)