#	exclusive	inclusive	rows x	rows	loops	node
1.	11997.638	83369.948	↓ 143.6	267868	1	→ Nested Loop Left Join (cost=116.30..193897.70 rows=1865 width=351) (actual time=162.641..83369.948 rows=267868 loops=1)
2.	5330.901	48389.062	↓ 143.6	267868	1	→ Hash Join (cost=116.30..39104.80 rows=1865 width=347) (actual time=162.549..48389.062 rows=267868 loops=1) Hash Cond: (produto.cdgrupoproduto = grupoproduto.cdgrupoproduto)
3.	5505.025	43057.485	↓ 143.6	267868	1	→ Hash Join (cost=114.56..39077.42 rows=1865 width=129) (actual time=161.779..43057.485 rows=267868 loops=1) Hash Cond: (lancamento.cdproduto = produto.cdproduto)
4.	10575.619	37486.179	↓ 143.6	267868	1	→ Nested Loop (cost=0.00..38932.55 rows=1865 width=96) (actual time=95.415..37486.179 rows=267868 loops=1)
5.	9001.453	18096.864	↓ 141.6	275428	1	→ Nested Loop (cost=0.00..26579.45 rows=1945 width=68) (actual time=95.360..18096.864 rows=275428 loops=1)
6.	2413.571	2413.571	↓ 141.3	167046	1	→ Seq Scan on lanccaixa (cost=0.00..17796.89 rows=1182 width=16) (actual time=95.288..2413.571 rows=167046 loops=1) Filter: ((cdempresa = 1) AND (cdoperacaocaixa = 1) AND (flcancelado = 0) AND (date(dhlanccaixa) >= '2011-05-01'::date) AND (date(dhlanccaixa) < '2012-03-21'::date))
7.	6681.840	6681.840	↑ 1.5	2	167046	→ Index Scan using ixlctocdlanccaixa on lancamento (cost=0.00..7.39 rows=3 width=64) (actual time=0.021..0.040 rows=2 loops=167046) Index Cond: (cdlanccaixa = lanccaixa.cdlanccaixa) Filter: (cdempresa = 1)
8.	8813.696	8813.696	↑ 1.0	1	275428	→ Index Scan using pkdocfiscalitem on docfiscalitem (cost=0.00..6.34 rows=1 width=40) (actual time=0.021..0.032 rows=1 loops=275428) Index Cond: (cddocfiscalitem = lancamento.cddocfiscalitem) Filter: (cdempresa = 1)
9.	34.936	66.281	↑ 1.0	2647	1	→ Hash (cost=81.47..81.47 rows=2647 width=33) (actual time=66.281..66.281 rows=2647 loops=1) Buckets: 1024 Batches: 1 Memory Usage: 175kB
10.	31.345	31.345	↑ 1.0	2647	1	→ Seq Scan on produto (cost=0.00..81.47 rows=2647 width=33) (actual time=0.016..31.345 rows=2647 loops=1)
11.	0.337	0.676	↑ 1.0	33	1	→ Hash (cost=1.33..1.33 rows=33 width=222) (actual time=0.676..0.676 rows=33 loops=1) Buckets: 1024 Batches: 1 Memory Usage: 2kB
12.	0.339	0.339	↑ 1.0	33	1	→ Seq Scan on grupoproduto (cost=0.00..1.33 rows=33 width=222) (actual time=0.019..0.339 rows=33 loops=1)
13.	9643.248	9643.248	↑ 1.0	1	267868	→ Index Scan using ixcustocdempdtcdp on custo (cost=0.00..7.21 rows=1 width=24) (actual time=0.025..0.036 rows=1 loops=267868) Index Cond: ((date(lanccaixa.dhlanccaixa) = dtcusto) AND (lancamento.cdproduto = cdproduto) AND (cdempresa = 1) AND (cdempresa = lancamento.cdempresa))
14.						SubPlan (forNested Loop Left Join)
15.	1972.000	13340.000	↑ 1.0	1	29000	→ Aggregate (cost=75.74..75.75 rows=1 width=16) (actual time=0.451..0.460 rows=1 loops=29000)
16.	5377.035	11368.000	↑ 2.3	3	29000	→ Nested Loop (cost=0.00..75.71 rows=7 width=16) (actual time=0.080..0.392 rows=3 loops=29000)
17.	2059.000	2059.000	↑ 1.6	5	29000	→ Index Scan using ixlanccomposicaocdl on lanccomposicao (cost=0.00..8.41 rows=8 width=12) (actual time=0.019..0.071 rows=5 loops=29000) Index Cond: (cdlancamento = lancamento.cdlancamento)
18.	3931.965	3931.965	↑ 1.0	1	135585	→ Index Scan using ixcustocdempdtcdp on custo (cost=0.00..8.40 rows=1 width=12) (actual time=0.021..0.029 rows=1 loops=135585) Index Cond: ((dtcusto = date(lanccaixa.dhlanccaixa)) AND (cdproduto = lanccomposicao.cdproduto) AND (cdempresa = lancamento.cdempresa))

"Nested Loop Left Join  (cost=116.30..193897.70 rows=1865 width=351) (actual time=162.641..83369.948 rows=267868 loops=1)"
"  ->  Hash Join  (cost=116.30..39104.80 rows=1865 width=347) (actual time=162.549..48389.062 rows=267868 loops=1)"
"        Hash Cond: (produto.cdgrupoproduto = grupoproduto.cdgrupoproduto)"
"        ->  Hash Join  (cost=114.56..39077.42 rows=1865 width=129) (actual time=161.779..43057.485 rows=267868 loops=1)"
"              Hash Cond: (lancamento.cdproduto = produto.cdproduto)"
"              ->  Nested Loop  (cost=0.00..38932.55 rows=1865 width=96) (actual time=95.415..37486.179 rows=267868 loops=1)"
"                    ->  Nested Loop  (cost=0.00..26579.45 rows=1945 width=68) (actual time=95.360..18096.864 rows=275428 loops=1)"
"                          ->  Seq Scan on lanccaixa  (cost=0.00..17796.89 rows=1182 width=16) (actual time=95.288..2413.571 rows=167046 loops=1)"
"                                Filter: ((cdempresa = 1) AND (cdoperacaocaixa = 1) AND (flcancelado = 0) AND (date(dhlanccaixa) >= '2011-05-01'::date) AND (date(dhlanccaixa) < '2012-03-21'::date))"
"                          ->  Index Scan using ixlctocdlanccaixa on lancamento  (cost=0.00..7.39 rows=3 width=64) (actual time=0.021..0.040 rows=2 loops=167046)"
"                                Index Cond: (cdlanccaixa = lanccaixa.cdlanccaixa)"
"                                Filter: (cdempresa = 1)"
"                    ->  Index Scan using pkdocfiscalitem on docfiscalitem  (cost=0.00..6.34 rows=1 width=40) (actual time=0.021..0.032 rows=1 loops=275428)"
"                          Index Cond: (cddocfiscalitem = lancamento.cddocfiscalitem)"
"                          Filter: (cdempresa = 1)"
"              ->  Hash  (cost=81.47..81.47 rows=2647 width=33) (actual time=66.281..66.281 rows=2647 loops=1)"
"                    Buckets: 1024  Batches: 1  Memory Usage: 175kB"
"                    ->  Seq Scan on produto  (cost=0.00..81.47 rows=2647 width=33) (actual time=0.016..31.345 rows=2647 loops=1)"
"        ->  Hash  (cost=1.33..1.33 rows=33 width=222) (actual time=0.676..0.676 rows=33 loops=1)"
"              Buckets: 1024  Batches: 1  Memory Usage: 2kB"
"              ->  Seq Scan on grupoproduto  (cost=0.00..1.33 rows=33 width=222) (actual time=0.019..0.339 rows=33 loops=1)"
"  ->  Index Scan using ixcustocdempdtcdp on custo  (cost=0.00..7.21 rows=1 width=24) (actual time=0.025..0.036 rows=1 loops=267868)"
"        Index Cond: ((date(lanccaixa.dhlanccaixa) = dtcusto) AND (lancamento.cdproduto = cdproduto) AND (cdempresa = 1) AND (cdempresa = lancamento.cdempresa))"
"  SubPlan 1"
"    ->  Aggregate  (cost=75.74..75.75 rows=1 width=16) (actual time=0.451..0.460 rows=1 loops=29000)"
"          ->  Nested Loop  (cost=0.00..75.71 rows=7 width=16) (actual time=0.080..0.392 rows=3 loops=29000)"
"                ->  Index Scan using ixlanccomposicaocdl on lanccomposicao  (cost=0.00..8.41 rows=8 width=12) (actual time=0.019..0.071 rows=5 loops=29000)"
"                      Index Cond: (cdlancamento = lancamento.cdlancamento)"
"                ->  Index Scan using ixcustocdempdtcdp on custo  (cost=0.00..8.40 rows=1 width=12) (actual time=0.021..0.029 rows=1 loops=135585)"
"                      Index Cond: ((dtcusto = date(lanccaixa.dhlanccaixa)) AND (cdproduto = lanccomposicao.cdproduto) AND (cdempresa = lancamento.cdempresa))"
"Total runtime: 85772.626 ms"

Per node type stats

node type	count	sum of times	% of query
Aggregate	1	1972.000 ms	2.4 %
Hash	2	35.273 ms	0.0 %
Hash Join	2	10835.926 ms	13.0 %
Index Scan	5	31129.749 ms	37.3 %
Nested Loop	3	24954.107 ms	29.9 %
Nested Loop Left Join	1	11997.638 ms	14.4 %
Seq Scan	3	2445.255 ms	2.9 %

Per table stats

Table name	Scan count	Total time	% of query
scan type	count	sum of times	% of table
custo	2	13575.213 ms	16.3 %
Index Scan	2	13575.213 ms	100.0 %
docfiscalitem	1	8813.696 ms	10.6 %
Index Scan	1	8813.696 ms	100.0 %
grupoproduto	1	0.339 ms	0.0 %
Seq Scan	1	0.339 ms	100.0 %
lancamento	1	6681.840 ms	8.0 %
Index Scan	1	6681.840 ms	100.0 %
lanccaixa	1	2413.571 ms	2.9 %
Seq Scan	1	2413.571 ms	100.0 %
lanccomposicao	1	2059.000 ms	2.5 %
Index Scan	1	2059.000 ms	100.0 %
produto	1	31.345 ms	0.0 %
Seq Scan	1	31.345 ms	100.0 %

explain.depesz.com

A tool for finding a real cause for slow queries.

Result: raK

Colorize:

Columns visibility:

Per node type stats

Per table stats