#	exclusive	inclusive	rows x	rows	loops	node
1.	1390.168	1390.168	↓ 1.1	4676	1	→ CTE Scan on prefixos (cost=77032.61..77115.45 rows=4142 width=136) (actual time=1378.245..1390.168 rows=4676 loops=1)
2.						CTE prefixos
3.	491.446	1384.771	↓ 1.1	4676	1	→ HashAggregate (cost=76804.80..77032.61 rows=4142 width=88) (actual time=1378.238..1384.771 rows=4676 loops=1)
4.	73.676	893.325	↑ 2.3	159275	1	→ Hash Left Join (cost=16134.60..63829.56 rows=370721 width=88) (actual time=129.208..893.325 rows=159275 loops=1) Hash Cond: ((a.mci)::bpchar = (f.qnv_ct_mci)::bpchar)
5.	120.148	818.570	↑ 2.3	159275	1	→ Hash Left Join (cost=15442.36..61743.46 rows=370721 width=90) (actual time=128.113..818.570 rows=159275 loops=1) Hash Cond: ((a.mci)::bpchar = (d.mci)::bpchar)
6.	154.343	694.941	↑ 2.3	159275	1	→ Hash Left Join (cost=15137.47..56248.32 rows=370721 width=74) (actual time=124.606..694.941 rows=159275 loops=1) Hash Cond: (a.cnpj_txt = (b.cnpj)::bpchar)
7.	336.576	531.596	↑ 2.3	159275	1	→ Hash Left Join (cost=12859.33..49724.84 rows=370721 width=67) (actual time=115.574..531.596 rows=159275 loops=1) Hash Cond: ((a.mci)::bpchar = (c.mci)::bpchar)
8.	80.134	80.134	↑ 2.3	159275	1	→ Seq Scan on gps_qualificacao_negocios a (cost=0.00..18699.21 rows=370721 width=51) (actual time=0.014..80.134 rows=159275 loops=1)
9.	68.178	114.886	↑ 2.0	159274	1	→ Hash (cost=6699.48..6699.48 rows=318548 width=26) (actual time=114.886..114.886 rows=159274 loops=1) Buckets: 8192 Batches: 4 Memory Usage: 2275kB
10.	46.708	46.708	↑ 2.0	159274	1	→ Seq Scan on gps_qualificacao_obs_diaria c (cost=0.00..6699.48 rows=318548 width=26) (actual time=0.498..46.708 rows=159274 loops=1)
11.	4.096	9.002	↓ 1.0	7665	1	→ Hash (cost=2184.73..2184.73 rows=7473 width=49) (actual time=9.002..9.002 rows=7665 loops=1) Buckets: 1024 Batches: 1 Memory Usage: 637kB
12.	4.906	4.906	↓ 1.0	7665	1	→ Seq Scan on gps_qualificacao_resultado b (cost=0.00..2184.73 rows=7473 width=49) (actual time=0.007..4.906 rows=7665 loops=1)
13.	1.888	3.481	↑ 2.0	4642	1	→ Hash (cost=188.84..188.84 rows=9284 width=26) (actual time=3.481..3.481 rows=4642 loops=1) Buckets: 1024 Batches: 1 Memory Usage: 263kB
14.	1.593	1.593	↑ 2.0	4642	1	→ Seq Scan on gps_qualificacao_obs_mensal d (cost=0.00..188.84 rows=9284 width=26) (actual time=0.061..1.593 rows=4642 loops=1)
15.	0.160	1.079	↑ 1.0	366	1	→ Hash (cost=687.66..687.66 rows=366 width=18) (actual time=1.079..1.079 rows=366 loops=1) Buckets: 1024 Batches: 1 Memory Usage: 18kB
16.	0.919	0.919	↑ 1.0	366	1	→ Seq Scan on gps_qualificacao_contas f (cost=0.00..687.66 rows=366 width=18) (actual time=0.006..0.919 rows=366 loops=1)

"CTE Scan on prefixos  (cost=77032.61..77115.45 rows=4142 width=136) (actual time=1378.245..1390.168 rows=4676 loops=1)"
"  CTE prefixos"
"    ->  HashAggregate  (cost=76804.80..77032.61 rows=4142 width=88) (actual time=1378.238..1384.771 rows=4676 loops=1)"
"          ->  Hash Left Join  (cost=16134.60..63829.56 rows=370721 width=88) (actual time=129.208..893.325 rows=159275 loops=1)"
"                Hash Cond: ((a.mci)::bpchar = (f.qnv_ct_mci)::bpchar)"
"                ->  Hash Left Join  (cost=15442.36..61743.46 rows=370721 width=90) (actual time=128.113..818.570 rows=159275 loops=1)"
"                      Hash Cond: ((a.mci)::bpchar = (d.mci)::bpchar)"
"                      ->  Hash Left Join  (cost=15137.47..56248.32 rows=370721 width=74) (actual time=124.606..694.941 rows=159275 loops=1)"
"                            Hash Cond: (a.cnpj_txt = (b.cnpj)::bpchar)"
"                            ->  Hash Left Join  (cost=12859.33..49724.84 rows=370721 width=67) (actual time=115.574..531.596 rows=159275 loops=1)"
"                                  Hash Cond: ((a.mci)::bpchar = (c.mci)::bpchar)"
"                                  ->  Seq Scan on gps_qualificacao_negocios a  (cost=0.00..18699.21 rows=370721 width=51) (actual time=0.014..80.134 rows=159275 loops=1)"
"                                  ->  Hash  (cost=6699.48..6699.48 rows=318548 width=26) (actual time=114.886..114.886 rows=159274 loops=1)"
"                                        Buckets: 8192  Batches: 4  Memory Usage: 2275kB"
"                                        ->  Seq Scan on gps_qualificacao_obs_diaria c  (cost=0.00..6699.48 rows=318548 width=26) (actual time=0.498..46.708 rows=159274 loops=1)"
"                            ->  Hash  (cost=2184.73..2184.73 rows=7473 width=49) (actual time=9.002..9.002 rows=7665 loops=1)"
"                                  Buckets: 1024  Batches: 1  Memory Usage: 637kB"
"                                  ->  Seq Scan on gps_qualificacao_resultado b  (cost=0.00..2184.73 rows=7473 width=49) (actual time=0.007..4.906 rows=7665 loops=1)"
"                      ->  Hash  (cost=188.84..188.84 rows=9284 width=26) (actual time=3.481..3.481 rows=4642 loops=1)"
"                            Buckets: 1024  Batches: 1  Memory Usage: 263kB"
"                            ->  Seq Scan on gps_qualificacao_obs_mensal d  (cost=0.00..188.84 rows=9284 width=26) (actual time=0.061..1.593 rows=4642 loops=1)"
"                ->  Hash  (cost=687.66..687.66 rows=366 width=18) (actual time=1.079..1.079 rows=366 loops=1)"
"                      Buckets: 1024  Batches: 1  Memory Usage: 18kB"
"                      ->  Seq Scan on gps_qualificacao_contas f  (cost=0.00..687.66 rows=366 width=18) (actual time=0.006..0.919 rows=366 loops=1)"
"Total runtime: 1391.683 ms"

Per node type stats

node type	count	sum of times	% of query
CTE Scan	1	1390.168 ms	100.0 %
Hash	4	74.322 ms	5.3 %
Hash Left Join	4	684.743 ms	49.3 %
HashAggregate	1	491.446 ms	35.4 %
Seq Scan	5	134.260 ms	9.7 %

Per table stats

Table name	Scan count	Total time	% of query
scan type	count	sum of times	% of table
gps_qualificacao_contas	1	0.919 ms	0.1 %
Seq Scan	1	0.919 ms	100.0 %
gps_qualificacao_negocios	1	80.134 ms	5.8 %
Seq Scan	1	80.134 ms	100.0 %
gps_qualificacao_obs_diaria	1	46.708 ms	3.4 %
Seq Scan	1	46.708 ms	100.0 %
gps_qualificacao_obs_mensal	1	1.593 ms	0.1 %
Seq Scan	1	1.593 ms	100.0 %
gps_qualificacao_resultado	1	4.906 ms	0.4 %
Seq Scan	1	4.906 ms	100.0 %

explain.depesz.com

A tool for finding a real cause for slow queries.

Result: XJZ

Colorize:

Columns visibility:

Per node type stats

Per table stats