explain.depesz.com

PostgreSQL's explain analyze made readable

Result: u2ng

Settings
# exclusive inclusive rows x rows loops node
1. 0.017 6.148 ↑ 1.0 1 1

Nested Loop (cost=32.15..36,751.10 rows=1 width=250) (actual time=0.892..6.148 rows=1 loops=1)

  • Join Filter: ((m.test_type_key = mrt.test_type_key) AND (tst.test_type_key = mrt.recipe_key))
  • -> Seq Scan on migration_recipe_test mrt (cost=0.00..27.70 rows=1770 width=16) (actual time=0.011..0.011 rows=1 loops=1)"Total runtime: 6.248 ms
2. 0.002 6.131 ↑ 1.0 1 1

Nested Loop (cost=32.15..36,696.85 rows=1 width=262) (actual time=0.876..6.131 rows=1 loops=1)

3. 0.001 0.133 ↑ 120.0 2 1

Nested Loop (cost=32.15..2,006.83 rows=240 width=270) (actual time=0.090..0.133 rows=2 loops=1)

4. 0.002 0.106 ↑ 1.0 1 1

Nested Loop (cost=0.00..64.95 rows=1 width=270) (actual time=0.073..0.106 rows=1 loops=1)

5. 0.029 0.097 ↑ 1.0 1 1

Nested Loop Left Join (cost=0.00..64.66 rows=1 width=318) (actual time=0.066..0.097 rows=1 loops=1)

  • Join Filter: (m31sts.status = upper(m.status))
  • Rows Removed by Join Filter: 29
6. 0.012 0.065 ↑ 1.0 1 1

Nested Loop (cost=0.00..62.91 rows=1 width=333) (actual time=0.051..0.065 rows=1 loops=1)

  • Join Filter: ((m.sub_pm = tst.sub_pm) AND (m.pm_group_code_key = tst.pm_group_code_key))
  • Rows Removed by Join Filter: 19
7. 0.033 0.033 ↑ 37.0 20 1

Seq Scan on migration_test_step_test tst (cost=0.00..17.40 rows=740 width=80) (actual time=0.029..0.033 rows=20 loops=1)

8. 0.004 0.020 ↑ 2.0 1 20

Materialize (cost=0.00..19.61 rows=2 width=310) (actual time=0.001..0.001 rows=1 loops=20)

9. 0.002 0.016 ↑ 2.0 1 1

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

10. 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))
11. 0.014 0.014 ↑ 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.013..0.014 rows=1 loops=1)

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

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

13. 0.007 0.007 ↑ 1.0 1 1

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

  • Index Cond: (name = tst.pm_group_code_key)
14. 0.014 0.026 ↑ 269.5 2 1

Bitmap Heap Scan on test_step_recipe tsr (cost=32.15..1,936.48 rows=539 width=32) (actual time=0.016..0.026 rows=2 loops=1)

  • Recheck Cond: ((test_step_key = tst.test_step_key) AND (test_group_key = tg.test_group_key))
15. 0.012 0.012 ↑ 269.5 2 1

Bitmap Index Scan on test_step_recipe_ak (cost=0.00..32.02 rows=539 width=0) (actual time=0.012..0.012 rows=2 loops=1)

  • Index Cond: ((test_step_key = tst.test_step_key) AND (test_group_key = tg.test_group_key))
16. 5.996 5.996 ↓ 0.0 0 2

Index Scan using activity_recipe_key_idx on activity act (cost=0.00..144.53 rows=1 width=16) (actual time=2.998..2.998 rows=0 loops=2)

  • Index Cond: (recipe_key = tsr.recipe_key)
  • Filter: (activity_key = 12)
  • Rows Removed by Filter: 6186