explain.depesz.com

PostgreSQL's explain analyze made readable

Result: juq1

Settings
# exclusive inclusive rows x rows loops node
1. 0.495 3,035.348 ↓ 0.0 0 1

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

2. 1,238.173 3,034.853 ↓ 58.0 58 1

Nested Loop (cost=0.84..6,996.34 rows=1 width=68) (actual time=0.166..3,034.853 rows=58 loops=1)

  • Join Filter: (n.abspk_sid = search_hit.abspk_sid)
  • Rows Removed by Join Filter: 7011482
3. 19.288 160.654 ↓ 116,859.0 116,859 1

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

4. 0.030 0.176 ↑ 1.0 5 1

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

5. 0.026 0.026 ↑ 1.0 5 1

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

6. 0.120 0.120 ↑ 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.022..0.024 rows=1 loops=5)

  • Index Cond: (string_value = w.label)
7. 141.190 141.190 ↓ 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.087..28.238 rows=23,372 loops=5)

  • Index Cond: ((graph_sid = 69) AND (label_sid = s.string_id))
8. 1,636.026 1,636.026 ↑ 18.8 60 116,859

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