#	exclusive	inclusive	rows x	node
1.	0.000	0.000	↓ 0.0	→ Sort (cost=8141882.12..8142089.69 rows=83028 width=181) (actual time=.. rows= loops=) Sort Key: stock.part, stock.company, stock.depot
2.	0.000	0.000	↓ 0.0	→ Hash Join (cost=120017.72..8135098.19 rows=83028 width=181) (actual time=.. rows= loops=) Hash Cond: (stprice.stockid = stock.stockid)
3.	0.000	0.000	↓ 0.0	→ Seq Scan on stprice (cost=0.00..203621.42 rows=5608242 width=13) (actual time=.. rows= loops=)
4.	0.000	0.000	↓ 0.0	→ Hash (cost=118979.87..118979.87 rows=83028 width=172) (actual time=.. rows= loops=)
5.	0.000	0.000	↓ 0.0	→ Merge Left Join (cost=112411.09..118979.87 rows=83028 width=172) (actual time=.. rows= loops=) Merge Cond: (((stock.product_group)::text = (grpdesc.id)::text) AND (stock.company = grpdesc.company))
6.	0.000	0.000	↓ 0.0	→ Sort (cost=10525.60..10733.13 rows=83014 width=150) (actual time=.. rows= loops=) Sort Key: stock.product_group, stock.company
7.	0.000	0.000	↓ 0.0	→ Nested Loop (cost=23.34..3742.91 rows=83014 width=150) (actual time=.. rows= loops=) Join Filter: ((stock.part)::text = fn_stksrch_grep_perl.fn_stksrch_grep_perl)
8.	0.000	0.000	↓ 0.0	→ HashAggregate (cost=12.75..14.75 rows=200 width=32) (actual time=.. rows= loops=)
9.	0.000	0.000	↓ 0.0	→ Function Scan on fn_stksrch_grep_perl (cost=0.25..10.25 rows=1000 width=32) (actual time=.. rows= loops=)
10.	0.000	0.000	↓ 0.0	→ Bitmap Heap Scan on stock (cost=10.59..18.62 rows=2 width=150) (actual time=.. rows= loops=) Recheck Cond: (((company = 1) AND ((depot)::text = 01::text) AND ((part)::text = fn_stksrch_grep_perl.fn_stksrch_grep_perl)) OR ((company = 81) AND ((depot)::text = 81::text) AND ((part)::text = fn_stksrch_grep_perl.fn_stksrch_grep_perl)))
11.	0.000	0.000	↓ 0.0	→ BitmapOr (cost=10.59..10.59 rows=2 width=0) (actual time=.. rows= loops=)
12.	0.000	0.000	↓ 0.0	→ Bitmap Index Scan on stock_idx1 (cost=0.00..5.29 rows=1 width=0) (actual time=.. rows= loops=) Index Cond: ((company = 1) AND ((depot)::text = 01::text) AND ((part)::text = fn_stksrch_grep_perl.fn_stksrch_grep_perl))
13.	0.000	0.000	↓ 0.0	→ Bitmap Index Scan on stock_idx1 (cost=0.00..5.29 rows=2 width=0) (actual time=.. rows= loops=) Index Cond: ((company = 81) AND ((depot)::text = 81::text) AND ((part)::text = fn_stksrch_grep_perl.fn_stksrch_grep_perl))
14.	0.000	0.000	↓ 0.0	→ Sort (cost=101778.57..103535.01 rows=702575 width=30) (actual time=.. rows= loops=) Sort Key: grpdesc.id, grpdesc.company
15.	0.000	0.000	↓ 0.0	→ Seq Scan on grpdesc (cost=0.00..33550.49 rows=702575 width=30) (actual time=.. rows= loops=) Filter: ((record_type)::text = G::text)
16.				SubPlan (forHash Join)
17.	0.000	0.000	↓ 0.0	→ Aggregate (cost=13.37..13.38 rows=1 width=8) (actual time=.. rows= loops=)
18.	0.000	0.000	↓ 0.0	→ Index Scan using stock_idx1 on stock a (cost=0.00..13.36 rows=2 width=8) (actual time=.. rows= loops=) Index Cond: ((company = 81) AND ((depot)::text = 81::text) AND ((part)::text = (stock.part)::text))
19.	0.000	0.000	↓ 0.0	→ Aggregate (cost=13.37..13.38 rows=1 width=8) (actual time=.. rows= loops=)
20.	0.000	0.000	↓ 0.0	→ Index Scan using stock_idx1 on stock a (cost=0.00..13.36 rows=2 width=8) (actual time=.. rows= loops=) Index Cond: ((company = 81) AND ((depot)::text = 81::text) AND ((part)::text = (stock.part)::text))
21.	0.000	0.000	↓ 0.0	→ Aggregate (cost=13.37..13.38 rows=1 width=8) (actual time=.. rows= loops=)
22.	0.000	0.000	↓ 0.0	→ Index Scan using stock_idx1 on stock a (cost=0.00..13.36 rows=2 width=8) (actual time=.. rows= loops=) Index Cond: ((company = 81) AND ((depot)::text = 81::text) AND ((part)::text = (stock.part)::text))
23.	0.000	0.000	↓ 0.0	→ Aggregate (cost=13.37..13.38 rows=1 width=8) (actual time=.. rows= loops=)
24.	0.000	0.000	↓ 0.0	→ Index Scan using stock_idx1 on stock a (cost=0.00..13.36 rows=2 width=8) (actual time=.. rows= loops=) Index Cond: ((company = 81) AND ((depot)::text = 81::text) AND ((part)::text = (stock.part)::text))
25.	0.000	0.000	↓ 0.0	→ Aggregate (cost=13.37..13.38 rows=1 width=8) (actual time=.. rows= loops=)
26.	0.000	0.000	↓ 0.0	→ Index Scan using stock_idx1 on stock a (cost=0.00..13.36 rows=2 width=8) (actual time=.. rows= loops=) Index Cond: ((company = 81) AND ((depot)::text = 81::text) AND ((part)::text = (stock.part)::text))
27.	0.000	0.000	↓ 0.0	→ Aggregate (cost=13.37..13.38 rows=1 width=8) (actual time=.. rows= loops=)
28.	0.000	0.000	↓ 0.0	→ Index Scan using stock_idx1 on stock a (cost=0.00..13.36 rows=2 width=8) (actual time=.. rows= loops=) Index Cond: ((company = 81) AND ((depot)::text = 81::text) AND ((part)::text = (stock.part)::text))
29.	0.000	0.000	↓ 0.0	→ Aggregate (cost=13.37..13.38 rows=1 width=8) (actual time=.. rows= loops=)
30.	0.000	0.000	↓ 0.0	→ Index Scan using stock_idx1 on stock a (cost=0.00..13.36 rows=2 width=8) (actual time=.. rows= loops=) Index Cond: ((company = 81) AND ((depot)::text = 81::text) AND ((part)::text = (stock.part)::text))

Sort  (cost=8141882.12..8142089.69 rows=83028 width=181)
  Sort Key: stock.part, stock.company, stock.depot
  ->  Hash Join  (cost=120017.72..8135098.19 rows=83028 width=181)
        Hash Cond: (stprice.stockid = stock.stockid)
        ->  Seq Scan on stprice  (cost=0.00..203621.42 rows=5608242 width=13)
        ->  Hash  (cost=118979.87..118979.87 rows=83028 width=172)
              ->  Merge Left Join  (cost=112411.09..118979.87 rows=83028 width=172)
                    Merge Cond: (((stock.product_group)::text = (grpdesc.id)::text) AND (stock.company = grpdesc.company))
                    ->  Sort  (cost=10525.60..10733.13 rows=83014 width=150)
                          Sort Key: stock.product_group, stock.company
                          ->  Nested Loop  (cost=23.34..3742.91 rows=83014 width=150)
                                Join Filter: ((stock.part)::text = fn_stksrch_grep_perl.fn_stksrch_grep_perl)
                                ->  HashAggregate  (cost=12.75..14.75 rows=200 width=32)
                                      ->  Function Scan on fn_stksrch_grep_perl  (cost=0.25..10.25 rows=1000 width=32)
                                ->  Bitmap Heap Scan on stock  (cost=10.59..18.62 rows=2 width=150)
                                      Recheck Cond: (((company = 1) AND ((depot)::text = 01::text) AND ((part)::text = fn_stksrch_grep_perl.fn_stksrch_grep_perl)) OR ((company = 81) AND ((depot)::text = 81::text) AND ((part)::text = fn_stksrch_grep_perl.fn_stksrch_grep_perl)))
                                      ->  BitmapOr  (cost=10.59..10.59 rows=2 width=0)
                                            ->  Bitmap Index Scan on stock_idx1  (cost=0.00..5.29 rows=1 width=0)
                                                  Index Cond: ((company = 1) AND ((depot)::text = 01::text) AND ((part)::text = fn_stksrch_grep_perl.fn_stksrch_grep_perl))
                                            ->  Bitmap Index Scan on stock_idx1  (cost=0.00..5.29 rows=2 width=0)
                                                  Index Cond: ((company = 81) AND ((depot)::text = 81::text) AND ((part)::text = fn_stksrch_grep_perl.fn_stksrch_grep_perl))
                    ->  Sort  (cost=101778.57..103535.01 rows=702575 width=30)
                          Sort Key: grpdesc.id, grpdesc.company
                          ->  Seq Scan on grpdesc  (cost=0.00..33550.49 rows=702575 width=30)
                                Filter: ((record_type)::text = G::text)
        SubPlan 1
          ->  Aggregate  (cost=13.37..13.38 rows=1 width=8)
                ->  Index Scan using stock_idx1 on stock a  (cost=0.00..13.36 rows=2 width=8)
                      Index Cond: ((company = 81) AND ((depot)::text = 81::text) AND ((part)::text = (stock.part)::text))
        SubPlan 2
          ->  Aggregate  (cost=13.37..13.38 rows=1 width=8)
                ->  Index Scan using stock_idx1 on stock a  (cost=0.00..13.36 rows=2 width=8)
                      Index Cond: ((company = 81) AND ((depot)::text = 81::text) AND ((part)::text = (stock.part)::text))
        SubPlan 3
          ->  Aggregate  (cost=13.37..13.38 rows=1 width=8)
                ->  Index Scan using stock_idx1 on stock a  (cost=0.00..13.36 rows=2 width=8)
                      Index Cond: ((company = 81) AND ((depot)::text = 81::text) AND ((part)::text = (stock.part)::text))
        SubPlan 4
          ->  Aggregate  (cost=13.37..13.38 rows=1 width=8)
                ->  Index Scan using stock_idx1 on stock a  (cost=0.00..13.36 rows=2 width=8)
                      Index Cond: ((company = 81) AND ((depot)::text = 81::text) AND ((part)::text = (stock.part)::text))
        SubPlan 5
          ->  Aggregate  (cost=13.37..13.38 rows=1 width=8)
                ->  Index Scan using stock_idx1 on stock a  (cost=0.00..13.36 rows=2 width=8)
                      Index Cond: ((company = 81) AND ((depot)::text = 81::text) AND ((part)::text = (stock.part)::text))
        SubPlan 6
          ->  Aggregate  (cost=13.37..13.38 rows=1 width=8)
                ->  Index Scan using stock_idx1 on stock a  (cost=0.00..13.36 rows=2 width=8)
                      Index Cond: ((company = 81) AND ((depot)::text = 81::text) AND ((part)::text = (stock.part)::text))
        SubPlan 7
          ->  Aggregate  (cost=13.37..13.38 rows=1 width=8)
                ->  Index Scan using stock_idx1 on stock a  (cost=0.00..13.36 rows=2 width=8)
                      Index Cond: ((company = 81) AND ((depot)::text = 81::text) AND ((part)::text = (stock.part)::text))

Per node type stats

node type	count	sum of times	% of query
Aggregate	7	0.000 ms	0.0 %
Bitmap Heap Scan	1	0.000 ms	0.0 %
Bitmap Index Scan	2	0.000 ms	0.0 %
BitmapOr	1	0.000 ms	0.0 %
Function Scan	1	0.000 ms	0.0 %
Hash	1	0.000 ms	0.0 %
Hash Join	1	0.000 ms	0.0 %
HashAggregate	1	0.000 ms	0.0 %
Index Scan	7	0.000 ms	0.0 %
Merge Left Join	1	0.000 ms	0.0 %
Nested Loop	1	0.000 ms	0.0 %
Seq Scan	2	0.000 ms	0.0 %
Sort	3	0.000 ms	0.0 %

Per table stats

Table name	Scan count	Total time	% of query
scan type	count	sum of times	% of table
grpdesc	1	0.000 ms	0.0 %
Seq Scan	1	0.000 ms	0.0 %
stock	8	0.000 ms	0.0 %
Bitmap Heap Scan	1	0.000 ms	0.0 %
Index Scan	7	0.000 ms	0.0 %
stprice	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: AEK

Colorize:

Columns visibility:

Per node type stats

Per table stats