explain.depesz.com

PostgreSQL's explain analyze made readable

Result: vu11

Settings
# exclusive inclusive rows x rows loops node
1. 0.000 0.000 ↓ 0.0

Sort (cost=516,563.70..516,564.16 rows=187 width=84) (actual rows= loops=)

  • Sort Key: (CASE WHEN ((SubPlan 4) = 1) THEN ((SubPlan 5))::text ELSE (SubPlan 6) END)
2. 0.000 0.000 ↓ 0.0

Hash Right Join (cost=148.23..516,556.64 rows=187 width=84) (actual rows= loops=)

  • Hash Cond: (rules1_.event_definition_id = eventdefin0_.id)
  • Filter: ((lower(CASE WHEN ((SubPlan 7) = 1) THEN ((SubPlan 8))::text ELSE (SubPlan 9) END) ~~ ''::text) OR (lower(CASE WHEN ((SubPlan 10) = 1) THEN ((SubPlan 11))::text ELSE (SubPlan 12) END) ~~ ''::text) OR (lower((manufactur2_.name)::text) ~~ ''::text))
3. 0.000 0.000 ↓ 0.0

Hash Left Join (cost=7.46..332.60 rows=12,471 width=29) (actual rows= loops=)

  • Hash Cond: (rules1_.manufacturing_entity = manufactur2_.id)
4. 0.000 0.000 ↓ 0.0

Seq Scan on "EventRule" rules1_ (cost=0.00..291.71 rows=12,471 width=32) (actual rows= loops=)

5. 0.000 0.000 ↓ 0.0

Hash (cost=4.98..4.98 rows=198 width=29) (actual rows= loops=)

6. 0.000 0.000 ↓ 0.0

Seq Scan on "ManufacturingEntity" manufactur2_ (cost=0.00..4.98 rows=198 width=29) (actual rows= loops=)

7. 0.000 0.000 ↓ 0.0

Hash (cost=82.01..82.01 rows=4,701 width=20) (actual rows= loops=)

8. 0.000 0.000 ↓ 0.0

Seq Scan on "EventDefinition" eventdefin0_ (cost=0.00..82.01 rows=4,701 width=20) (actual rows= loops=)

9.          

SubPlan (for Hash Right Join)

10. 0.000 0.000 ↓ 0.0

Aggregate (cost=463.41..463.42 rows=1 width=8) (actual rows= loops=)

11. 0.000 0.000 ↓ 0.0

Seq Scan on "EventDefinitionTranslation" eventdefin3_ (cost=0.00..463.41 rows=1 width=45) (actual rows= loops=)

  • Filter: ((event_definition_id = eventdefin0_.id) AND (language_id = 'c56290fd-b7d6-41a4-acd9-f3e42a561a1d'::uuid))
12. 0.000 0.000 ↓ 0.0

Seq Scan on "EventDefinitionTranslation" eventdefin4_ (cost=0.00..463.41 rows=1 width=45) (actual rows= loops=)

  • Filter: ((event_definition_id = eventdefin0_.id) AND (language_id = 'c56290fd-b7d6-41a4-acd9-f3e42a561a1d'::uuid))
13. 0.000 0.000 ↓ 0.0

Aggregate (cost=431.18..431.19 rows=1 width=32) (actual rows= loops=)

14. 0.000 0.000 ↓ 0.0

Seq Scan on "EventDefinitionTranslation" eventdefin5_ (cost=0.00..431.18 rows=3 width=45) (actual rows= loops=)

  • Filter: (event_definition_id = eventdefin0_.id)
15. 0.000 0.000 ↓ 0.0

Aggregate (cost=463.41..463.42 rows=1 width=8) (actual rows= loops=)

16. 0.000 0.000 ↓ 0.0

Seq Scan on "EventDefinitionTranslation" eventdefin12_ (cost=0.00..463.41 rows=1 width=45) (actual rows= loops=)

  • Filter: ((event_definition_id = eventdefin0_.id) AND (language_id = 'c56290fd-b7d6-41a4-acd9-f3e42a561a1d'::uuid))
17. 0.000 0.000 ↓ 0.0

Seq Scan on "EventDefinitionTranslation" eventdefin13_ (cost=0.00..463.41 rows=1 width=45) (actual rows= loops=)

  • Filter: ((event_definition_id = eventdefin0_.id) AND (language_id = 'c56290fd-b7d6-41a4-acd9-f3e42a561a1d'::uuid))
18. 0.000 0.000 ↓ 0.0

Aggregate (cost=431.18..431.19 rows=1 width=32) (actual rows= loops=)

19. 0.000 0.000 ↓ 0.0

Seq Scan on "EventDefinitionTranslation" eventdefin14_ (cost=0.00..431.18 rows=3 width=45) (actual rows= loops=)

  • Filter: (event_definition_id = eventdefin0_.id)
20. 0.000 0.000 ↓ 0.0

Aggregate (cost=463.41..463.42 rows=1 width=8) (actual rows= loops=)

21. 0.000 0.000 ↓ 0.0

Seq Scan on "EventDefinitionTranslation" eventdefin6_ (cost=0.00..463.41 rows=1 width=45) (actual rows= loops=)

  • Filter: ((event_definition_id = eventdefin0_.id) AND (language_id = 'c56290fd-b7d6-41a4-acd9-f3e42a561a1d'::uuid))
22. 0.000 0.000 ↓ 0.0

Seq Scan on "EventDefinitionTranslation" eventdefin7_ (cost=0.00..463.41 rows=1 width=45) (actual rows= loops=)

  • Filter: ((event_definition_id = eventdefin0_.id) AND (language_id = 'c56290fd-b7d6-41a4-acd9-f3e42a561a1d'::uuid))
23. 0.000 0.000 ↓ 0.0

Aggregate (cost=431.18..431.19 rows=1 width=32) (actual rows= loops=)

24. 0.000 0.000 ↓ 0.0

Seq Scan on "EventDefinitionTranslation" eventdefin8_ (cost=0.00..431.18 rows=3 width=45) (actual rows= loops=)

  • Filter: (event_definition_id = eventdefin0_.id)
25. 0.000 0.000 ↓ 0.0

Aggregate (cost=463.41..463.42 rows=1 width=8) (actual rows= loops=)

26. 0.000 0.000 ↓ 0.0

Seq Scan on "EventDefinitionTranslation" eventdefin9_ (cost=0.00..463.41 rows=1 width=45) (actual rows= loops=)

  • Filter: ((event_definition_id = eventdefin0_.id) AND (language_id = 'c56290fd-b7d6-41a4-acd9-f3e42a561a1d'::uuid))
27. 0.000 0.000 ↓ 0.0

Seq Scan on "EventDefinitionTranslation" eventdefin10_ (cost=0.00..463.41 rows=1 width=45) (actual rows= loops=)

  • Filter: ((event_definition_id = eventdefin0_.id) AND (language_id = 'c56290fd-b7d6-41a4-acd9-f3e42a561a1d'::uuid))
28. 0.000 0.000 ↓ 0.0

Aggregate (cost=431.18..431.19 rows=1 width=32) (actual rows= loops=)

  • -> Seq Scan on "EventDefinitionTranslation" eventdefin11_ (cost=0.00..431.18 rows=3 width=45)" Filter: (event_definition_id = eventdefin0_.id)