explain.depesz.com

PostgreSQL's explain analyze made readable

Result: fHvy

Settings
# exclusive inclusive rows x rows loops node
1. 0.000 0.000 ↓ 0.0

Update on jbpm_token t (cost=2.33..758,065.05 rows=42,028 width=248) (actual rows= loops=)

2. 0.000 0.000 ↓ 0.0

Nested Loop (cost=2.33..758,065.05 rows=42,028 width=248) (actual rows= loops=)

3. 0.000 0.000 ↓ 0.0

Nested Loop (cost=1.76..72.64 rows=420 width=50) (actual rows= loops=)

4. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on jbpm_processdefinition pd2 (cost=1.48..10.82 rows=13 width=14) (actual rows= loops=)

  • Recheck Cond: ((name_)::text = 'Controle de Prazos'::text)
5. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on idx_procdef_name (cost=0.00..1.47 rows=13 width=0) (actual rows= loops=)

  • Index Cond: ((name_)::text = 'Controle de Prazos'::text)
6. 0.000 0.000 ↓ 0.0

Index Scan using idx_node_procdef on jbpm_node n1 (cost=0.29..4.43 rows=33 width=52) (actual rows= loops=)

  • Index Cond: (processdefinition_ = pd2.id_)
7. 0.000 0.000 ↓ 0.0

Index Scan using idx_token_node on jbpm_token t (cost=0.56..1,054.73 rows=5,379 width=236) (actual rows= loops=)

  • Index Cond: (node_ = n1.id_)
  • Filter: (end_ IS NULL)
8.          

SubPlan (for Nested Loop)

9. 0.000 0.000 ↓ 0.0

Nested Loop (cost=0.56..6.96 rows=1 width=8) (actual rows= loops=)

10. 0.000 0.000 ↓ 0.0

Index Scan using idx_node_procdef on jbpm_node n (cost=0.29..4.46 rows=1 width=16) (actual rows= loops=)

  • Index Cond: (processdefinition_ = '628097176'::bigint)
  • Filter: (((name_)::text = (n1.name_)::text) AND (class_ = n1.class_))
11. 0.000 0.000 ↓ 0.0

Index Only Scan using jbpm_processdefinition_pkey on jbpm_processdefinition pd (cost=0.28..2.49 rows=1 width=8) (actual rows= loops=)

  • Index Cond: (id_ = '628097176'::bigint)(19 registros)