explain.depesz.com

PostgreSQL's explain analyze made readable

Result: EYA

Settings
# exclusive inclusive rows x rows loops node
1. 0.004 53,441.640 ↓ 0.0 0 1

Sort (cost=516,563.70..516,564.16 rows=187 width=84) (actual time=53,441.640..53,441.640 rows=0 loops=1)

  • Sort Key: (CASE WHEN ((SubPlan 4) = 1) THEN ((SubPlan 5))::text ELSE (SubPlan 6) END)
  • Sort Method: quicksort Memory: 25kB
2. 133.565 53,441.636 ↓ 0.0 0 1

Hash Right Join (cost=148.23..516,556.64 rows=187 width=84) (actual time=53,441.635..53,441.636 rows=0 loops=1)

  • 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))
  • Rows Removed by Filter: 12,549
3. 7.913 11.302 ↑ 1.0 12,471 1

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

  • Hash Cond: (rules1_.manufacturing_entity = manufactur2_.id)
4. 3.320 3.320 ↑ 1.0 12,471 1

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

5. 0.040 0.069 ↑ 1.0 198 1

Hash (cost=4.98..4.98 rows=198 width=29) (actual time=0.068..0.069 rows=198 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 20kB
6. 0.029 0.029 ↑ 1.0 198 1

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

7. 0.637 1.166 ↑ 1.1 4,298 1

Hash (cost=82.01..82.01 rows=4,701 width=20) (actual time=1.166..1.166 rows=4,298 loops=1)

  • Buckets: 8,192 Batches: 1 Memory Usage: 283kB
8. 0.529 0.529 ↑ 1.1 4,298 1

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

9.          

SubPlan (for Hash Right Join)

10. 0.000 0.000 ↓ 0.0 0

Aggregate (cost=463.41..463.42 rows=1 width=8) (never executed)

11. 0.000 0.000 ↓ 0.0 0

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

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

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

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

Aggregate (cost=431.18..431.19 rows=1 width=32) (never executed)

14. 0.000 0.000 ↓ 0.0 0

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

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

Aggregate (cost=463.41..463.42 rows=1 width=8) (never executed)

16. 0.000 0.000 ↓ 0.0 0

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

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

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

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

Aggregate (cost=431.18..431.19 rows=1 width=32) (never executed)

19. 0.000 0.000 ↓ 0.0 0

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

  • Filter: (event_definition_id = eventdefin0_.id)
20. 25.098 13,816.449 ↑ 1.0 1 12,549

Aggregate (cost=463.41..463.42 rows=1 width=8) (actual time=1.101..1.101 rows=1 loops=12,549)

21. 13,791.351 13,791.351 ↑ 1.0 1 12,549

Seq Scan on "EventDefinitionTranslation" eventdefin6_ (cost=0.00..463.41 rows=1 width=45) (actual time=0.500..1.099 rows=1 loops=12,549)

  • Filter: ((event_definition_id = eventdefin0_.id) AND (language_id = 'c56290fd-b7d6-41a4-acd9-f3e42a561a1d'::uuid))
  • Rows Removed by Filter: 12,893
22. 13,088.607 13,088.607 ↑ 1.0 1 12,549

Seq Scan on "EventDefinitionTranslation" eventdefin7_ (cost=0.00..463.41 rows=1 width=45) (actual time=0.476..1.043 rows=1 loops=12,549)

  • Filter: ((event_definition_id = eventdefin0_.id) AND (language_id = 'c56290fd-b7d6-41a4-acd9-f3e42a561a1d'::uuid))
  • Rows Removed by Filter: 12,893
23. 0.000 0.000 ↓ 0.0 0

Aggregate (cost=431.18..431.19 rows=1 width=32) (never executed)

24. 0.000 0.000 ↓ 0.0 0

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

  • Filter: (event_definition_id = eventdefin0_.id)
25. 25.098 13,389.783 ↑ 1.0 1 12,549

Aggregate (cost=463.41..463.42 rows=1 width=8) (actual time=1.067..1.067 rows=1 loops=12,549)

26. 13,364.685 13,364.685 ↑ 1.0 1 12,549

Seq Scan on "EventDefinitionTranslation" eventdefin9_ (cost=0.00..463.41 rows=1 width=45) (actual time=0.485..1.065 rows=1 loops=12,549)

  • Filter: ((event_definition_id = eventdefin0_.id) AND (language_id = 'c56290fd-b7d6-41a4-acd9-f3e42a561a1d'::uuid))
  • Rows Removed by Filter: 12,893
27. 13,000.764 13,000.764 ↑ 1.0 1 12,549

Seq Scan on "EventDefinitionTranslation" eventdefin10_ (cost=0.00..463.41 rows=1 width=45) (actual time=0.473..1.036 rows=1 loops=12,549)

  • Filter: ((event_definition_id = eventdefin0_.id) AND (language_id = 'c56290fd-b7d6-41a4-acd9-f3e42a561a1d'::uuid))
  • Rows Removed by Filter: 12,893
28. 0.000 0.000 ↓ 0.0 0

Aggregate (cost=431.18..431.19 rows=1 width=32) (never executed)

29. 0.000 0.000 ↓ 0.0 0

Seq Scan on "EventDefinitionTranslation" eventdefin11_ (cost=0.00..431.18 rows=3 width=45) (never executed)

  • Filter: (event_definition_id = eventdefin0_.id)