explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 8uzex

Settings
# exclusive inclusive rows x rows loops node
1. 0.001 913.761 ↓ 0.0 0 1

Update on search_hit (cost=0.84..6,996.34 rows=1 width=68) (actual time=913.761..913.761 rows=0 loops=1)

2. 684.544 913.760 ↓ 0.0 0 1

Nested Loop (cost=0.84..6,996.34 rows=1 width=68) (actual time=913.760..913.760 rows=0 loops=1)

  • Join Filter: (n.abspk_sid = search_hit.abspk_sid)
3. 16.749 229.216 ↓ 116,859.0 116,859 1

Nested Loop (cost=0.84..6,960.91 rows=1 width=30) (actual time=0.116..229.216 rows=116,859 loops=1)

4. 0.020 0.182 ↑ 1.0 5 1

Nested Loop (cost=0.42..43.31 rows=5 width=24) (actual time=0.046..0.182 rows=5 loops=1)

5. 0.022 0.022 ↑ 1.0 5 1

Seq Scan on label_weight w (cost=0.00..1.05 rows=5 width=18) (actual time=0.013..0.022 rows=5 loops=1)

6. 0.140 0.140 ↑ 1.0 1 5

Index Scan using idx_u_svalue on interned_string s (cost=0.42..8.44 rows=1 width=38) (actual time=0.027..0.028 rows=1 loops=5)

  • Index Cond: (string_value = w.label)
7. 212.285 212.285 ↓ 2.4 23,372 5

Index Scan using idx_node_lbl on node n (cost=0.42..1,284.73 rows=9,879 width=22) (actual time=0.077..42.457 rows=23,372 loops=5)

  • Index Cond: ((graph_sid = 69) AND (label_sid = s.string_id))
8. 0.000 0.000 ↓ 0.0 0 116,859

Seq Scan on search_hit (cost=0.00..21.30 rows=1,130 width=50) (actual time=0.000..0.000 rows=0 loops=116,859)