explain.depesz.com

PostgreSQL's explain analyze made readable

Result: L8kL

Settings
# exclusive inclusive rows x rows loops node
1. 0.035 0.446 ↑ 1.0 1 1

Nested Loop (cost=0.00..30.09 rows=1 width=282) (actual time=0.100..0.446 rows=1 loops=1)

2. 0.030 0.223 ↓ 188.0 188 1

Nested Loop (cost=0.00..28.77 rows=1 width=290) (actual time=0.095..0.223 rows=188 loops=1)

  • Join Filter: (tg.test_group_key = tsr.test_group_key)
3. 0.001 0.089 ↑ 3.0 1 1

Nested Loop (cost=0.00..25.60 rows=3 width=290) (actual time=0.088..0.089 rows=1 loops=1)

4. 0.004 0.083 ↑ 1.0 1 1

Nested Loop (cost=0.00..25.25 rows=1 width=314) (actual time=0.082..0.083 rows=1 loops=1)

5. 0.000 0.061 ↑ 1.0 1 1

Nested Loop (cost=0.00..24.89 rows=1 width=314) (actual time=0.060..0.061 rows=1 loops=1)

6. 0.010 0.056 ↑ 1.0 1 1

Nested Loop Left Join (cost=0.00..16.61 rows=1 width=310) (actual time=0.056..0.056 rows=1 loops=1)

7. 0.039 0.039 ↑ 1.0 1 1

Index Scan using measurement_line_id_idx on measurement m (cost=0.00..8.33 rows=1 width=313) (actual time=0.039..0.039 rows=1 loops=1)

  • Index Cond: (line_id = 3)
  • Filter: (activity_key = 1)
8. 0.007 0.007 ↑ 1.0 1 1

Index Scan using measurement_status_ak on status m31sts (cost=0.00..8.27 rows=1 width=36) (actual time=0.007..0.007 rows=1 loops=1)

  • Index Cond: (status = upper(m.status))
9. 0.005 0.005 ↑ 1.0 1 1

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

  • Index Cond: (test_type_key = m.test_type_key)
10. 0.018 0.018 ↑ 1.0 1 1

Index Scan using pk_migration_test_step_tmp on migration_test_step_tmp tst (cost=0.00..0.35 rows=1 width=45) (actual time=0.018..0.018 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))
11. 0.005 0.005 ↑ 3.0 1 1

Index Scan using test_group_name_idx on test_group tg (cost=0.00..0.31 rows=3 width=40) (actual time=0.005..0.005 rows=1 loops=1)

  • Index Cond: (name = tst.pm_group_code_key)
12. 0.104 0.104 ↓ 8.2 188 1

Index Scan using test_step_recipe_ak on test_step_recipe tsr (cost=0.00..0.77 rows=23 width=32) (actual time=0.006..0.104 rows=188 loops=1)

  • Index Cond: (test_step_key = tst.test_step_key)
13. 0.188 0.188 ↓ 0.0 0 188

Index Scan using activity_recipe_key_idx on activity act (cost=0.00..1.31 rows=1 width=16) (actual time=0.001..0.001 rows=0 loops=188)

  • Index Cond: (recipe_key = tsr.recipe_key)
  • Filter: (activity_key = 1)
  • Rows Removed by Filter: 1
Total runtime : 0.553 ms