#	rows x	node
1.	↓ 0.0	→ Hash Left Join (cost=42648.38..259191.44 rows=78221 width=750) (actual time=.. rows= loops=) Hash Cond: (wors.productionbatch_id = pb.id)
2.	↓ 0.0	→ Hash Join (cost=42582.46..61171.68 rows=78221 width=741) (actual time=.. rows= loops=) Hash Cond: (public.product.id = public.product.id)
3.	↓ 0.0	→ Hash Join (cost=42543.02..60056.70 rows=78221 width=789) (actual time=.. rows= loops=) Hash Cond: (wod.quantitygroupmeasure_id = groupmeasure.id)
4.	↓ 0.0	→ Hash Join (cost=42442.64..58783.01 rows=78221 width=251) (actual time=.. rows= loops=) Hash Cond: (wod.inventoryproduct_id = public.product.id)
5.	↓ 0.0	→ Hash Join (cost=42364.30..57629.13 rows=78221 width=174) (actual time=.. rows= loops=) Hash Cond: (wod.workorderroutingstep_id = wors.id)
6.	↓ 0.0	→ Seq Scan on workorderdetail wod (cost=0.00..12333.08 rows=429908 width=101) (actual time=.. rows= loops=)
7.	↓ 0.0	→ Hash (cost=42031.21..42031.21 rows=26647 width=105) (actual time=.. rows= loops=)
8.	↓ 0.0	→ Hash Join (cost=36399.73..42031.21 rows=26647 width=105) (actual time=.. rows= loops=) Hash Cond: (wors.workorder_id = parentwo.id)
9.	↓ 0.0	→ Seq Scan on workorderroutingstep wors (cost=0.00..4083.54 rows=146454 width=48) (actual time=.. rows= loops=)
10.	↓ 0.0	→ Hash (cost=36139.61..36139.61 rows=20810 width=73) (actual time=.. rows= loops=)
11.	↓ 0.0	→ Hash Join (cost=22479.10..36139.61 rows=20810 width=73) (actual time=.. rows= loops=) Hash Cond: (parentwo.fabricationproduct_id = public.product.id)
12.	↓ 0.0	→ Hash Join (cost=22400.76..35775.13 rows=20810 width=78) (actual time=.. rows= loops=) Hash Cond: (exploditem.productquicklibrary_id = productqcode.id)
13.	↓ 0.0	→ Hash Join (cost=22396.15..35477.42 rows=22666 width=84) (actual time=.. rows= loops=) Hash Cond: (parentwo.explodableitem_id = std.id)
14.	↓ 0.0	→ Seq Scan on workorder parentwo (cost=0.00..12282.74 rows=114374 width=48) (actual time=.. rows= loops=)
15.	↓ 0.0	→ Hash (cost=22085.89..22085.89 rows=24821 width=100) (actual time=.. rows= loops=)
16.	↓ 0.0	→ Hash Join (cost=15803.96..22085.89 rows=24821 width=100) (actual time=.. rows= loops=) Hash Cond: (exploditem.id = std.id)
17.	↓ 0.0	→ Seq Scan on explodableitem exploditem (cost=0.00..5407.48 rows=125248 width=32) (actual time=.. rows= loops=)
18.	↓ 0.0	→ Hash (cost=15493.70..15493.70 rows=24821 width=68) (actual time=.. rows= loops=)
19.	↓ 0.0	→ Hash Join (cost=9676.77..15493.70 rows=24821 width=68) (actual time=.. rows= loops=) Hash Cond: (td.id = std.id)
20.	↓ 0.0	→ Seq Scan on transactiondetail td (cost=0.00..4942.48 rows=125248 width=23) (actual time=.. rows= loops=)
21.	↓ 0.0	→ Hash (cost=9366.51..9366.51 rows=24821 width=45) (actual time=.. rows= loops=)
22.	↓ 0.0	→ Hash Join (cost=6352.15..9366.51 rows=24821 width=45) (actual time=.. rows= loops=) Hash Cond: (std.saletransaction_id = document.id)
23.	↓ 0.0	→ Seq Scan on saletransactiondetail std (cost=0.00..2296.47 rows=125247 width=36) (actual time=.. rows= loops=)
24.	↓ 0.0	→ Hash (cost=6236.56..6236.56 rows=9247 width=73) (actual time=.. rows= loops=)
25.	↓ 0.0	→ Hash Join (cost=4855.15..6236.56 rows=9247 width=73) (actual time=.. rows= loops=) Hash Cond: (st.customer_id = commercialentity.id)
26.	↓ 0.0	→ Hash Join (cost=4783.20..6025.91 rows=9247 width=72) (actual time=.. rows= loops=) Hash Cond: (st.id = document.id)
27.	↓ 0.0	→ Seq Scan on saletransaction st (cost=0.00..977.49 rows=34549 width=32) (actual time=.. rows= loops=)
28.	↓ 0.0	→ Hash (cost=4627.09..4627.09 rows=12489 width=40) (actual time=.. rows= loops=)
29.	↓ 0.0	→ Hash Join (cost=431.00..4627.09 rows=12489 width=40) (actual time=.. rows= loops=) Hash Cond: (document.id = orders.id)
30.	↓ 0.0	→ Seq Scan on document (cost=0.00..3604.60 rows=46660 width=24) (actual time=.. rows= loops=)
31.	↓ 0.0	→ Hash (cost=274.89..274.89 rows=12489 width=16) (actual time=.. rows= loops=)
32.	↓ 0.0	→ Seq Scan on orders (cost=0.00..274.89 rows=12489 width=16) (actual time=.. rows= loops=)
33.	↓ 0.0	→ Hash (cost=50.31..50.31 rows=1731 width=33) (actual time=.. rows= loops=)
34.	↓ 0.0	→ Seq Scan on commercialentity (cost=0.00..50.31 rows=1731 width=33) (actual time=.. rows= loops=)
35.	↓ 0.0	→ Hash (cost=3.16..3.16 rows=116 width=26) (actual time=.. rows= loops=)
36.	↓ 0.0	→ Seq Scan on productquicklibrary productqcode (cost=0.00..3.16 rows=116 width=26) (actual time=.. rows= loops=)
37.	↓ 0.0	→ Hash (cost=71.43..71.43 rows=553 width=43) (actual time=.. rows= loops=)
38.	↓ 0.0	→ Hash Join (cost=30.60..71.43 rows=553 width=43) (actual time=.. rows= loops=) Hash Cond: (public.product.id = public.productdescription.product_id)
39.	↓ 0.0	→ Seq Scan on product (cost=0.00..32.53 rows=553 width=27) (actual time=.. rows= loops=)
40.	↓ 0.0	→ Hash (cost=23.69..23.69 rows=553 width=16) (actual time=.. rows= loops=)
41.	↓ 0.0	→ Seq Scan on productdescription (cost=0.00..23.69 rows=553 width=16) (actual time=.. rows= loops=) Filter: ((languagecode)::text = 'en'::text)
42.	↓ 0.0	→ Hash (cost=71.43..71.43 rows=553 width=77) (actual time=.. rows= loops=)
43.	↓ 0.0	→ Hash Join (cost=30.60..71.43 rows=553 width=77) (actual time=.. rows= loops=) Hash Cond: (public.product.id = public.productdescription.product_id)
44.	↓ 0.0	→ Seq Scan on product (cost=0.00..32.53 rows=553 width=27) (actual time=.. rows= loops=)
45.	↓ 0.0	→ Hash (cost=23.69..23.69 rows=553 width=50) (actual time=.. rows= loops=)
46.	↓ 0.0	→ Seq Scan on productdescription (cost=0.00..23.69 rows=553 width=50) (actual time=.. rows= loops=) Filter: ((languagecode)::text = 'en'::text)
47.	↓ 0.0	→ Hash (cost=75.52..75.52 rows=1989 width=570) (actual time=.. rows= loops=)
48.	↓ 0.0	→ Hash Left Join (cost=3.82..75.52 rows=1989 width=570) (actual time=.. rows= loops=) Hash Cond: (groupmeasure.measureunitmultiplier_id = measureunitmultiplier.id)
49.	↓ 0.0	→ Hash Left Join (cost=2.53..51.91 rows=1989 width=548) (actual time=.. rows= loops=) Hash Cond: (groupmeasure.regroupingunit_id = regroupingunit.id)
50.	↓ 0.0	→ Seq Scan on groupmeasure (cost=0.00..36.89 rows=1989 width=48) (actual time=.. rows= loops=)
51.	↓ 0.0	→ Hash (cost=2.36..2.36 rows=13 width=532) (actual time=.. rows= loops=)
52.	↓ 0.0	→ Hash Left Join (cost=1.18..2.36 rows=13 width=532) (actual time=.. rows= loops=) Hash Cond: (regroupingunit.id = regroupingunitdescription.regroupingunit_id)
53.	↓ 0.0	→ Seq Scan on regroupingunit (cost=0.00..1.13 rows=13 width=16) (actual time=.. rows= loops=)
54.	↓ 0.0	→ Hash (cost=1.16..1.16 rows=1 width=532) (actual time=.. rows= loops=)
55.	↓ 0.0	→ Seq Scan on regroupingunitdescription (cost=0.00..1.16 rows=1 width=532) (actual time=.. rows= loops=) Filter: ((languagecode)::text = 'en'::text)
56.	↓ 0.0	→ Hash (cost=1.13..1.13 rows=13 width=54) (actual time=.. rows= loops=)
57.	↓ 0.0	→ Seq Scan on measureunitmultiplier (cost=0.00..1.13 rows=13 width=54) (actual time=.. rows= loops=)
58.	↓ 0.0	→ Hash (cost=32.53..32.53 rows=553 width=16) (actual time=.. rows= loops=)
59.	↓ 0.0	→ Seq Scan on product (cost=0.00..32.53 rows=553 width=16) (actual time=.. rows= loops=)
60.	↓ 0.0	→ Hash (cost=43.74..43.74 rows=1774 width=25) (actual time=.. rows= loops=)
61.	↓ 0.0	→ Seq Scan on productionbatch pb (cost=0.00..43.74 rows=1774 width=25) (actual time=.. rows= loops=)

"Hash Left Join  (cost=42648.38..259191.44 rows=78221 width=750)"
"  Hash Cond: (wors.productionbatch_id = pb.id)"
"  ->  Hash Join  (cost=42582.46..61171.68 rows=78221 width=741)"
"        Hash Cond: (public.product.id = public.product.id)"
"        ->  Hash Join  (cost=42543.02..60056.70 rows=78221 width=789)"
"              Hash Cond: (wod.quantitygroupmeasure_id = groupmeasure.id)"
"              ->  Hash Join  (cost=42442.64..58783.01 rows=78221 width=251)"
"                    Hash Cond: (wod.inventoryproduct_id = public.product.id)"
"                    ->  Hash Join  (cost=42364.30..57629.13 rows=78221 width=174)"
"                          Hash Cond: (wod.workorderroutingstep_id = wors.id)"
"                          ->  Seq Scan on workorderdetail wod  (cost=0.00..12333.08 rows=429908 width=101)"
"                          ->  Hash  (cost=42031.21..42031.21 rows=26647 width=105)"
"                                ->  Hash Join  (cost=36399.73..42031.21 rows=26647 width=105)"
"                                      Hash Cond: (wors.workorder_id = parentwo.id)"
"                                      ->  Seq Scan on workorderroutingstep wors  (cost=0.00..4083.54 rows=146454 width=48)"
"                                      ->  Hash  (cost=36139.61..36139.61 rows=20810 width=73)"
"                                            ->  Hash Join  (cost=22479.10..36139.61 rows=20810 width=73)"
"                                                  Hash Cond: (parentwo.fabricationproduct_id = public.product.id)"
"                                                  ->  Hash Join  (cost=22400.76..35775.13 rows=20810 width=78)"
"                                                        Hash Cond: (exploditem.productquicklibrary_id = productqcode.id)"
"                                                        ->  Hash Join  (cost=22396.15..35477.42 rows=22666 width=84)"
"                                                              Hash Cond: (parentwo.explodableitem_id = std.id)"
"                                                              ->  Seq Scan on workorder parentwo  (cost=0.00..12282.74 rows=114374 width=48)"
"                                                              ->  Hash  (cost=22085.89..22085.89 rows=24821 width=100)"
"                                                                    ->  Hash Join  (cost=15803.96..22085.89 rows=24821 width=100)"
"                                                                          Hash Cond: (exploditem.id = std.id)"
"                                                                          ->  Seq Scan on explodableitem exploditem  (cost=0.00..5407.48 rows=125248 width=32)"
"                                                                          ->  Hash  (cost=15493.70..15493.70 rows=24821 width=68)"
"                                                                                ->  Hash Join  (cost=9676.77..15493.70 rows=24821 width=68)"
"                                                                                      Hash Cond: (td.id = std.id)"
"                                                                                      ->  Seq Scan on transactiondetail td  (cost=0.00..4942.48 rows=125248 width=23)"
"                                                                                      ->  Hash  (cost=9366.51..9366.51 rows=24821 width=45)"
"                                                                                            ->  Hash Join  (cost=6352.15..9366.51 rows=24821 width=45)"
"                                                                                                  Hash Cond: (std.saletransaction_id = document.id)"
"                                                                                                  ->  Seq Scan on saletransactiondetail std  (cost=0.00..2296.47 rows=125247 width=36)"
"                                                                                                  ->  Hash  (cost=6236.56..6236.56 rows=9247 width=73)"
"                                                                                                        ->  Hash Join  (cost=4855.15..6236.56 rows=9247 width=73)"
"                                                                                                              Hash Cond: (st.customer_id = commercialentity.id)"
"                                                                                                              ->  Hash Join  (cost=4783.20..6025.91 rows=9247 width=72)"
"                                                                                                                    Hash Cond: (st.id = document.id)"
"                                                                                                                    ->  Seq Scan on saletransaction st  (cost=0.00..977.49 rows=34549 width=32)"
"                                                                                                                    ->  Hash  (cost=4627.09..4627.09 rows=12489 width=40)"
"                                                                                                                          ->  Hash Join  (cost=431.00..4627.09 rows=12489 width=40)"
"                                                                                                                                Hash Cond: (document.id = orders.id)"
"                                                                                                                                ->  Seq Scan on document  (cost=0.00..3604.60 rows=46660 width=24)"
"                                                                                                                                ->  Hash  (cost=274.89..274.89 rows=12489 width=16)"
"                                                                                                                                      ->  Seq Scan on orders  (cost=0.00..274.89 rows=12489 width=16)"
"                                                                                                              ->  Hash  (cost=50.31..50.31 rows=1731 width=33)"
"                                                                                                                    ->  Seq Scan on commercialentity  (cost=0.00..50.31 rows=1731 width=33)"
"                                                        ->  Hash  (cost=3.16..3.16 rows=116 width=26)"
"                                                              ->  Seq Scan on productquicklibrary productqcode  (cost=0.00..3.16 rows=116 width=26)"
"                                                  ->  Hash  (cost=71.43..71.43 rows=553 width=43)"
"                                                        ->  Hash Join  (cost=30.60..71.43 rows=553 width=43)"
"                                                              Hash Cond: (public.product.id = public.productdescription.product_id)"
"                                                              ->  Seq Scan on product  (cost=0.00..32.53 rows=553 width=27)"
"                                                              ->  Hash  (cost=23.69..23.69 rows=553 width=16)"
"                                                                    ->  Seq Scan on productdescription  (cost=0.00..23.69 rows=553 width=16)"
"                                                                          Filter: ((languagecode)::text = 'en'::text)"
"                    ->  Hash  (cost=71.43..71.43 rows=553 width=77)"
"                          ->  Hash Join  (cost=30.60..71.43 rows=553 width=77)"
"                                Hash Cond: (public.product.id = public.productdescription.product_id)"
"                                ->  Seq Scan on product  (cost=0.00..32.53 rows=553 width=27)"
"                                ->  Hash  (cost=23.69..23.69 rows=553 width=50)"
"                                      ->  Seq Scan on productdescription  (cost=0.00..23.69 rows=553 width=50)"
"                                            Filter: ((languagecode)::text = 'en'::text)"
"              ->  Hash  (cost=75.52..75.52 rows=1989 width=570)"
"                    ->  Hash Left Join  (cost=3.82..75.52 rows=1989 width=570)"
"                          Hash Cond: (groupmeasure.measureunitmultiplier_id = measureunitmultiplier.id)"
"                          ->  Hash Left Join  (cost=2.53..51.91 rows=1989 width=548)"
"                                Hash Cond: (groupmeasure.regroupingunit_id = regroupingunit.id)"
"                                ->  Seq Scan on groupmeasure  (cost=0.00..36.89 rows=1989 width=48)"
"                                ->  Hash  (cost=2.36..2.36 rows=13 width=532)"
"                                      ->  Hash Left Join  (cost=1.18..2.36 rows=13 width=532)"
"                                            Hash Cond: (regroupingunit.id = regroupingunitdescription.regroupingunit_id)"
"                                            ->  Seq Scan on regroupingunit  (cost=0.00..1.13 rows=13 width=16)"
"                                            ->  Hash  (cost=1.16..1.16 rows=1 width=532)"
"                                                  ->  Seq Scan on regroupingunitdescription  (cost=0.00..1.16 rows=1 width=532)"
"                                                        Filter: ((languagecode)::text = 'en'::text)"
"                          ->  Hash  (cost=1.13..1.13 rows=13 width=54)"
"                                ->  Seq Scan on measureunitmultiplier  (cost=0.00..1.13 rows=13 width=54)"
"        ->  Hash  (cost=32.53..32.53 rows=553 width=16)"
"              ->  Seq Scan on product  (cost=0.00..32.53 rows=553 width=16)"
"  ->  Hash  (cost=43.74..43.74 rows=1774 width=25)"
"        ->  Seq Scan on productionbatch pb  (cost=0.00..43.74 rows=1774 width=25)"

Per node type stats

node type	count	sum of times	% of query
Hash	20	0.000 ms	0.0 %
Hash Join	16	0.000 ms	0.0 %
Hash Left Join	4	0.000 ms	0.0 %
Seq Scan	21	0.000 ms	0.0 %

Per table stats

Table name	Scan count	Total time	% of query
scan type	count	sum of times	% of table
commercialentity	1	0.000 ms	0.0 %
Seq Scan	1	0.000 ms	0.0 %
document	1	0.000 ms	0.0 %
Seq Scan	1	0.000 ms	0.0 %
explodableitem	1	0.000 ms	0.0 %
Seq Scan	1	0.000 ms	0.0 %
groupmeasure	1	0.000 ms	0.0 %
Seq Scan	1	0.000 ms	0.0 %
measureunitmultiplier	1	0.000 ms	0.0 %
Seq Scan	1	0.000 ms	0.0 %
orders	1	0.000 ms	0.0 %
Seq Scan	1	0.000 ms	0.0 %
product	3	0.000 ms	0.0 %
Seq Scan	3	0.000 ms	0.0 %
productdescription	2	0.000 ms	0.0 %
Seq Scan	2	0.000 ms	0.0 %
productionbatch	1	0.000 ms	0.0 %
Seq Scan	1	0.000 ms	0.0 %
productquicklibrary	1	0.000 ms	0.0 %
Seq Scan	1	0.000 ms	0.0 %
regroupingunit	1	0.000 ms	0.0 %
Seq Scan	1	0.000 ms	0.0 %
regroupingunitdescription	1	0.000 ms	0.0 %
Seq Scan	1	0.000 ms	0.0 %
saletransaction	1	0.000 ms	0.0 %
Seq Scan	1	0.000 ms	0.0 %
saletransactiondetail	1	0.000 ms	0.0 %
Seq Scan	1	0.000 ms	0.0 %
transactiondetail	1	0.000 ms	0.0 %
Seq Scan	1	0.000 ms	0.0 %
workorder	1	0.000 ms	0.0 %
Seq Scan	1	0.000 ms	0.0 %
workorderdetail	1	0.000 ms	0.0 %
Seq Scan	1	0.000 ms	0.0 %
workorderroutingstep	1	0.000 ms	0.0 %
Seq Scan	1	0.000 ms	0.0 %

explain.depesz.com

A tool for finding a real cause for slow queries.

Result: Q3W

Colorize:

Columns visibility:

Per node type stats

Per table stats