explain.depesz.com

PostgreSQL's explain analyze made readable

Result: btpY : Optimization for: Optimization for: plan #ppSW; plan #MSUg

Settings

Optimization path:

# exclusive inclusive rows x rows loops node
1. 0.002 0.115 ↑ 1.0 1 1

Nested Loop (cost=0.00..78.58 rows=1 width=250) (actual time=0.107..0.115 rows=1 loops=1)

2. 0.000 0.105 ↑ 1.0 1 1

Nested Loop (cost=0.00..67.92 rows=1 width=266) (actual time=0.098..0.105 rows=1 loops=1)

3. 0.001 0.101 ↑ 1.0 1 1

Nested Loop (cost=0.00..67.64 rows=1 width=298) (actual time=0.094..0.101 rows=1 loops=1)

4. 0.018 0.084 ↑ 1.0 1 1

Nested Loop Left Join (cost=0.00..59.11 rows=1 width=290) (actual time=0.077..0.084 rows=1 loops=1)

  • Join Filter: (m31sts.status = upper(m.status))
  • Rows Removed by Join Filter: 29
5. 0.001 0.062 ↑ 1.0 1 1

Nested Loop (cost=0.00..57.36 rows=1 width=305) (actual time=0.061..0.062 rows=1 loops=1)

6. 0.002 0.048 ↑ 2.0 1 1

Nested Loop (cost=0.00..36.40 rows=2 width=315) (actual time=0.047..0.048 rows=1 loops=1)

7. 0.000 0.043 ↑ 2.0 1 1

Append (cost=0.00..19.60 rows=2 width=310) (actual time=0.042..0.043 rows=1 loops=1)

8. 0.000 0.000 ↓ 0.0 0 1

Seq Scan on measurement m (cost=0.00..0.00 rows=1 width=400) (actual time=0.000..0.000 rows=0 loops=1)

  • Filter: ((activity_key = 12) AND (line_id = 41))
9. 0.043 0.043 ↑ 1.0 1 1

Index Scan using measurement_old_line_id_idx on measurement_old m (cost=0.00..19.60 rows=1 width=220) (actual time=0.042..0.043 rows=1 loops=1)

  • Index Cond: (line_id = 41)
  • Filter: (activity_key = 12)
10. 0.003 0.003 ↑ 1.0 1 1

Index Scan using migration_recipe_tmp_pkey on migration_recipe_tmp mrt (cost=0.00..8.39 rows=1 width=12) (actual time=0.003..0.003 rows=1 loops=1)

  • Index Cond: (test_type_key = m.test_type_key)
11. 0.013 0.013 ↑ 1.0 1 1

Index Scan using pk_migration_test_step_tmp on migration_test_step_tmp tst (cost=0.00..10.47 rows=1 width=46) (actual time=0.013..0.013 rows=1 loops=1)

  • Index Cond: ((test_type_key = mrt.recipe_key) AND (sub_pm = m.sub_pm) AND (pm_group_code_key = m.pm_group_code_key))
12. 0.004 0.004 ↑ 1.0 30 1

Seq Scan on status m31sts (cost=0.00..1.30 rows=30 width=10) (actual time=0.002..0.004 rows=30 loops=1)

13. 0.016 0.016 ↑ 1.0 1 1

Index Scan using activity_activity_key_idx on activity act (cost=0.00..8.52 rows=1 width=16) (actual time=0.016..0.016 rows=1 loops=1)

  • Index Cond: (activity_key = 12)
14. 0.004 0.004 ↑ 1.0 1 1

Index Scan using test_group_name_idx on test_group tg (cost=0.00..0.27 rows=1 width=17) (actual time=0.004..0.004 rows=1 loops=1)

  • Index Cond: (name = tst.pm_group_code_key)
15. 0.008 0.008 ↑ 1.0 1 1

Index Scan using test_step_recipe_ak on test_step_recipe tsr (cost=0.00..10.66 rows=1 width=32) (actual time=0.008..0.008 rows=1 loops=1)

  • Index Cond: ((test_step_key = tst.test_step_key) AND (test_group_key = tg.test_group_key) AND (recipe_key = act.recipe_key))"Total runtime: 0.214 ms