explain.depesz.com

PostgreSQL's explain analyze made readable

Result: SDXy

Settings
# exclusive inclusive rows x rows loops node
1. 0.035 7.653 ↓ 1.5 3 1

Nested Loop Left Join (cost=1.14..1,040.42 rows=2 width=165) (actual time=7.585..7.653 rows=3 loops=1)

2. 7.522 7.522 ↓ 1.5 3 1

Seq Scan on act_re_procdef proc_def (cost=0.00..681.11 rows=2 width=124) (actual time=7.508..7.522 rows=3 loops=1)

  • Filter: ((id_)::text ~~ 'a10082TestRelation%'::text)
  • Rows Removed by Filter: 15738
3. 0.012 0.096 ↓ 0.0 0 3

Nested Loop (cost=1.14..179.64 rows=1 width=506) (actual time=0.031..0.032 rows=0 loops=3)

4. 0.009 0.084 ↓ 0.0 0 3

Nested Loop (cost=0.84..77.66 rows=1 width=510) (actual time=0.028..0.028 rows=0 loops=3)

5. 0.012 0.075 ↓ 0.0 0 3

Nested Loop (cost=0.57..74.54 rows=1 width=498) (actual time=0.024..0.025 rows=0 loops=3)

  • Join Filter: ((runtime_app.app_definition)::jsonb @? ((('$.models[*].id ? (@ == '::text || (model_history.model_id)::text) || ')'::text))::jsonpath)
6. 0.015 0.063 ↓ 0.0 0 3

Nested Loop (cost=0.28..24.66 rows=1 width=925) (actual time=0.021..0.021 rows=0 loops=3)

  • Join Filter: ((runtime_app.deployment_id)::text = (proc_def.deployment_id_)::text)
7. 0.048 0.048 ↓ 0.0 0 3

Index Scan using idx_model_editor_json_process_id on model (cost=0.28..8.31 rows=1 width=468) (actual time=0.015..0.016 rows=0 loops=3)

  • Index Cond: (((model_editor_json)::json #>> '{properties,process_id}'::text[]) = (proc_def.key_)::text)
  • Filter: (model_type = 0)
8. 0.000 0.000 ↓ 0.0 0

Seq Scan on runtime_app_def runtime_app (cost=0.00..14.49 rows=149 width=457) (never executed)

9. 0.000 0.000 ↓ 0.0 0

Index Scan using idx_proc_mod_history_proc on model_history (cost=0.29..49.84 rows=1 width=20) (never executed)

  • Index Cond: (model_id = model.id)
  • Filter: ((model.version - 1) = version)
10. 0.000 0.000 ↓ 0.0 0

Index Scan using pk_model on model app_model (cost=0.28..3.09 rows=1 width=12) (never executed)

  • Index Cond: (id = runtime_app.model_id)
  • Filter: (model_type = 3)
11. 0.000 0.000 ↓ 0.0 0

Index Scan using idx_proc_mod_history_proc on model_history app_model_history (cost=0.29..101.97 rows=1 width=20) (never executed)

  • Index Cond: (model_id = app_model.id)
  • Filter: ((app_model.version - 1) = version)
Planning time : 8.075 ms
Execution time : 7.860 ms