explain.depesz.com

PostgreSQL's explain analyze made readable

Result: AWsn

Settings
# exclusive inclusive rows x rows loops node
1. 0.001 0.020 ↓ 0.0 0 1

Nested Loop (cost=45.15..84.22 rows=6 width=1,017) (actual time=0.020..0.020 rows=0 loops=1)

2. 0.000 0.019 ↓ 0.0 0 1

Hash Join (cost=44.88..81.74 rows=8 width=967) (actual time=0.019..0.019 rows=0 loops=1)

  • Hash Cond: ((pathsectio7_.prodsection_id)::text = (machinelis9_.prodsection_id)::text)
3. 0.000 0.019 ↓ 0.0 0 1

Nested Loop (cost=11.71..48.02 rows=123 width=930) (actual time=0.019..0.019 rows=0 loops=1)

  • Join Filter: ((path0_.id)::text = (pathsectio2_.path_id)::text)
4. 0.001 0.019 ↓ 0.0 0 1

Nested Loop (cost=11.43..39.26 rows=14 width=834) (actual time=0.019..0.019 rows=0 loops=1)

  • Join Filter: ((path0_.id)::text = (pathsectio7_.path_id)::text)
5. 0.001 0.018 ↓ 0.0 0 1

Nested Loop (cost=11.15..37.29 rows=2 width=760) (actual time=0.018..0.018 rows=0 loops=1)

6. 0.000 0.017 ↓ 0.0 0 1

Nested Loop (cost=10.88..36.63 rows=1 width=581) (actual time=0.017..0.017 rows=0 loops=1)

7. 0.000 0.017 ↓ 0.0 0 1

Nested Loop (cost=10.74..36.29 rows=1 width=448) (actual time=0.017..0.017 rows=0 loops=1)

8. 0.000 0.017 ↓ 0.0 0 1

Hash Join (cost=10.60..36.04 rows=1 width=313) (actual time=0.017..0.017 rows=0 loops=1)

  • Hash Cond: ((milltransp5_.to_id)::text = (path0_.id)::text)
9. 0.017 0.017 ↓ 0.0 0 1

Index Scan using mill_transport_path_from_fidx on mill_transport milltransp5_ (cost=0.28..25.68 rows=7 width=37) (actual time=0.017..0.017 rows=0 loops=1)

  • Index Cond: ((from_id)::text = '12'::text)
10. 0.000 0.000 ↓ 0.0 0

Hash (cost=9.93..9.93 rows=31 width=276) (never executed)

11. 0.000 0.000 ↓ 0.0 0

Hash Join (cost=1.09..9.93 rows=31 width=276) (never executed)

  • Hash Cond: ((path0_.planningrestr_id)::text = (planningre6_.id)::text)
12. 0.000 0.000 ↓ 0.0 0

Seq Scan on path path0_ (cost=0.00..7.84 rows=184 width=178) (never executed)

13. 0.000 0.000 ↓ 0.0 0

Hash (cost=1.07..1.07 rows=1 width=98) (never executed)

14. 0.000 0.000 ↓ 0.0 0

Seq Scan on planning_restrictions planningre6_ (cost=0.00..1.07 rows=1 width=98) (never executed)

  • Filter: ((name)::text = 'L1'::text)
15. 0.000 0.000 ↓ 0.0 0

Index Scan using production_line_pkey on production_line production3_ (cost=0.14..0.25 rows=1 width=135) (never executed)

  • Index Cond: ((id)::text = (path0_.productionline_id)::text)
16. 0.000 0.000 ↓ 0.0 0

Index Scan using organisation_pkey on organisation organisati4_ (cost=0.14..0.33 rows=1 width=133) (never executed)

  • Index Cond: ((id)::text = (production3_.organisation_id)::text)
17. 0.000 0.000 ↓ 0.0 0

Index Scan using pathi18n_path_fidx on pathi18n pathi18nli1_ (cost=0.27..0.63 rows=2 width=179) (never executed)

  • Index Cond: ((path_id)::text = (path0_.id)::text)
18. 0.000 0.000 ↓ 0.0 0

Index Scan using path_section_path_fidx on path_section pathsectio7_ (cost=0.28..0.90 rows=7 width=74) (never executed)

  • Index Cond: ((path_id)::text = (pathi18nli1_.path_id)::text)
19. 0.000 0.000 ↓ 0.0 0

Index Scan using path_section_path_fidx on path_section pathsectio2_ (cost=0.28..0.54 rows=7 width=170) (never executed)

  • Index Cond: ((path_id)::text = (pathsectio7_.path_id)::text)
20. 0.000 0.000 ↓ 0.0 0

Hash (cost=33.05..33.05 rows=10 width=37) (never executed)

21. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=5.30..33.05 rows=10 width=37) (never executed)

22. 0.000 0.000 ↓ 0.0 0

Hash Join (cost=5.03..22.87 rows=10 width=37) (never executed)

  • Hash Cond: ((machineope10_.operation_id)::text = (operation11_.id)::text)
23. 0.000 0.000 ↓ 0.0 0

Seq Scan on machine_operation machineope10_ (cost=0.00..16.18 rows=418 width=74) (never executed)

24. 0.000 0.000 ↓ 0.0 0

Hash (cost=5.00..5.00 rows=2 width=37) (never executed)

25. 0.000 0.000 ↓ 0.0 0

Seq Scan on operation operation11_ (cost=0.00..5.00 rows=2 width=37) (never executed)

  • Filter: ((name)::text = ANY ('{1,2}'::text[]))
26. 0.000 0.000 ↓ 0.0 0

Index Scan using machine_pkey on machine machinelis9_ (cost=0.27..1.01 rows=1 width=74) (never executed)

  • Index Cond: ((id)::text = (machineope10_.machine_id)::text)
27. 0.000 0.000 ↓ 0.0 0

Index Only Scan using production_section_pkey on production_section production8_ (cost=0.27..0.30 rows=1 width=37) (never executed)

  • Index Cond: (id = (pathsectio7_.prodsection_id)::text)
  • Heap Fetches: 0