#	exclusive	inclusive	rows x	rows	loops	node
1.	11.475	7306.533	↓ 1.1	5500	1	→ HashAggregate (cost=421612.07..421663.16 rows=5109 width=88) (actual time=7303.699..7306.533 rows=5500 loops=1)
2.	1.150	7295.058	↓ 1.1	5501	1	→ Append (cost=76804.80..421433.26 rows=5109 width=88) (actual time=1332.613..7295.058 rows=5501 loops=1)
3.	1.577	1340.295	↓ 1.1	4676	1	→ Subquery Scan on "SELECT 1" (cost=76804.80..77074.03 rows=4142 width=88) (actual time=1332.612..1340.295 rows=4676 loops=1)
4.	469.567	1338.718	↓ 1.1	4676	1	→ HashAggregate (cost=76804.80..77032.61 rows=4142 width=88) (actual time=1332.608..1338.718 rows=4676 loops=1)
5.	73.263	869.151	↑ 2.3	159275	1	→ Hash Left Join (cost=16134.60..63829.56 rows=370721 width=88) (actual time=129.288..869.151 rows=159275 loops=1) Hash Cond: ((a.mci)::bpchar = (f.qnv_ct_mci)::bpchar)
6.	105.605	794.735	↑ 2.3	159275	1	→ Hash Left Join (cost=15442.36..61743.46 rows=370721 width=90) (actual time=128.122..794.735 rows=159275 loops=1) Hash Cond: ((a.mci)::bpchar = (d.mci)::bpchar)
7.	137.098	685.765	↑ 2.3	159275	1	→ Hash Left Join (cost=15137.47..56248.32 rows=370721 width=74) (actual time=124.736..685.765 rows=159275 loops=1) Hash Cond: (a.cnpj_txt = (b.cnpj)::bpchar)
8.	346.395	540.351	↑ 2.3	159275	1	→ Hash Left Join (cost=12859.33..49724.84 rows=370721 width=67) (actual time=116.253..540.351 rows=159275 loops=1) Hash Cond: ((a.mci)::bpchar = (c.mci)::bpchar)
9.	78.438	78.438	↑ 2.3	159275	1	→ Seq Scan on gps_qualificacao_negocios a (cost=0.00..18699.21 rows=370721 width=51) (actual time=0.012..78.438 rows=159275 loops=1)
10.	69.064	115.518	↑ 2.0	159274	1	→ Hash (cost=6699.48..6699.48 rows=318548 width=26) (actual time=115.518..115.518 rows=159274 loops=1) Buckets: 8192 Batches: 4 Memory Usage: 2275kB
11.	46.454	46.454	↑ 2.0	159274	1	→ Seq Scan on gps_qualificacao_obs_diaria c (cost=0.00..6699.48 rows=318548 width=26) (actual time=0.558..46.454 rows=159274 loops=1)
12.	3.595	8.316	↓ 1.0	7665	1	→ Hash (cost=2184.73..2184.73 rows=7473 width=49) (actual time=8.316..8.316 rows=7665 loops=1) Buckets: 1024 Batches: 1 Memory Usage: 637kB
13.	4.721	4.721	↓ 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.721 rows=7665 loops=1)
14.	1.835	3.365	↑ 2.0	4642	1	→ Hash (cost=188.84..188.84 rows=9284 width=26) (actual time=3.365..3.365 rows=4642 loops=1) Buckets: 1024 Batches: 1 Memory Usage: 263kB
15.	1.530	1.530	↑ 2.0	4642	1	→ Seq Scan on gps_qualificacao_obs_mensal d (cost=0.00..188.84 rows=9284 width=26) (actual time=0.059..1.530 rows=4642 loops=1)
16.	0.237	1.153	↑ 1.0	366	1	→ Hash (cost=687.66..687.66 rows=366 width=18) (actual time=1.153..1.153 rows=366 loops=1) Buckets: 1024 Batches: 1 Memory Usage: 18kB
17.	0.916	0.916	↑ 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.916 rows=366 loops=1)
18.	0.230	1492.192	↑ 1.0	658	1	→ Subquery Scan on "SELECT 2" (cost=86074.09..86118.29 rows=680 width=88) (actual time=1491.179..1492.192 rows=658 loops=1)
19.	433.128	1491.962	↑ 1.0	658	1	→ HashAggregate (cost=86074.09..86111.49 rows=680 width=88) (actual time=1491.176..1491.962 rows=658 loops=1)
20.	114.512	1058.834	↑ 2.3	159275	1	→ Hash Left Join (cost=17062.67..73098.86 rows=370721 width=88) (actual time=140.505..1058.834 rows=159275 loops=1) Hash Cond: ((a.mci)::bpchar = (d.mci)::bpchar)
21.	143.076	940.602	↑ 2.3	159275	1	→ Hash Left Join (cost=16757.78..67603.71 rows=370721 width=82) (actual time=136.748..940.602 rows=159275 loops=1) Hash Cond: (a.cnpj_txt = (b.cnpj)::bpchar)
22.	74.601	789.074	↑ 2.3	159275	1	→ Hash Left Join (cost=14479.64..61080.23 rows=370721 width=75) (actual time=128.279..789.074 rows=159275 loops=1) Hash Cond: ((a.mci)::bpchar = (f.qnv_ct_mci)::bpchar)
23.	337.559	713.394	↑ 2.3	159275	1	→ Hash Left Join (cost=13787.40..58994.13 rows=370721 width=67) (actual time=127.160..713.394 rows=159275 loops=1) Hash Cond: ((a.mci)::bpchar = (e.mci)::bpchar)
24.	191.856	259.576	↑ 2.3	159275	1	→ Hash Join (cost=928.08..27968.51 rows=370721 width=51) (actual time=10.117..259.576 rows=159275 loops=1) Hash Cond: ((a.vs_prefixo)::bpchar = (c.prefdep)::bpchar)
25.	57.723	57.723	↑ 2.3	159275	1	→ Seq Scan on gps_qualificacao_negocios a (cost=0.00..18699.21 rows=370721 width=51) (actual time=0.012..57.723 rows=159275 loops=1)
26.	3.368	9.997	↑ 1.0	7870	1	→ Hash (cost=829.70..829.70 rows=7870 width=10) (actual time=9.997..9.997 rows=7870 loops=1) Buckets: 1024 Batches: 1 Memory Usage: 323kB
27.	6.629	6.629	↑ 1.0	7870	1	→ Seq Scan on tbldependenciasbr c (cost=0.00..829.70 rows=7870 width=10) (actual time=0.012..6.629 rows=7870 loops=1)
28.	69.712	116.259	↑ 2.0	159274	1	→ Hash (cost=6699.48..6699.48 rows=318548 width=26) (actual time=116.259..116.259 rows=159274 loops=1) Buckets: 8192 Batches: 4 Memory Usage: 2275kB
29.	46.547	46.547	↑ 2.0	159274	1	→ Seq Scan on gps_qualificacao_obs_diaria e (cost=0.00..6699.48 rows=318548 width=26) (actual time=0.371..46.547 rows=159274 loops=1)
30.	0.171	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
31.	0.908	0.908	↑ 1.0	366	1	→ Seq Scan on gps_qualificacao_contas f (cost=0.00..687.66 rows=366 width=18) (actual time=0.009..0.908 rows=366 loops=1)
32.	3.711	8.452	↓ 1.0	7665	1	→ Hash (cost=2184.73..2184.73 rows=7473 width=49) (actual time=8.452..8.452 rows=7665 loops=1) Buckets: 1024 Batches: 1 Memory Usage: 637kB
33.	4.741	4.741	↓ 1.0	7665	1	→ Seq Scan on gps_qualificacao_resultado b (cost=0.00..2184.73 rows=7473 width=49) (actual time=0.006..4.741 rows=7665 loops=1)
34.	2.118	3.720	↑ 2.0	4642	1	→ Hash (cost=188.84..188.84 rows=9284 width=26) (actual time=3.720..3.720 rows=4642 loops=1) Buckets: 1024 Batches: 1 Memory Usage: 263kB
35.	1.602	1.602	↑ 2.0	4642	1	→ Seq Scan on gps_qualificacao_obs_mensal d (cost=0.00..188.84 rows=9284 width=26) (actual time=0.064..1.602 rows=4642 loops=1)
36.	0.049	1606.120	↑ 1.3	132	1	→ Subquery Scan on "SELECT 3" (cost=86074.09..86085.40 rows=174 width=88) (actual time=1605.921..1606.120 rows=132 loops=1)
37.	418.752	1606.071	↑ 1.3	132	1	→ HashAggregate (cost=86074.09..86083.66 rows=174 width=88) (actual time=1605.918..1606.071 rows=132 loops=1)
38.	105.359	1187.319	↑ 2.3	159275	1	→ Hash Left Join (cost=17062.67..73098.86 rows=370721 width=88) (actual time=140.100..1187.319 rows=159275 loops=1) Hash Cond: ((a.mci)::bpchar = (d.mci)::bpchar)
39.	129.040	1078.802	↑ 2.3	159275	1	→ Hash Left Join (cost=16757.78..67603.71 rows=370721 width=82) (actual time=136.908..1078.802 rows=159275 loops=1) Hash Cond: (a.cnpj_txt = (b.cnpj)::bpchar)
40.	74.422	940.853	↑ 2.3	159275	1	→ Hash Left Join (cost=14479.64..61080.23 rows=370721 width=75) (actual time=127.988..940.853 rows=159275 loops=1) Hash Cond: ((a.mci)::bpchar = (f.qnv_ct_mci)::bpchar)
41.	510.710	865.376	↑ 2.3	159275	1	→ Hash Left Join (cost=13787.40..58994.13 rows=370721 width=67) (actual time=126.914..865.376 rows=159275 loops=1) Hash Cond: ((a.mci)::bpchar = (e.mci)::bpchar)
42.	174.505	237.420	↑ 2.3	159275	1	→ Hash Join (cost=928.08..27968.51 rows=370721 width=51) (actual time=8.997..237.420 rows=159275 loops=1) Hash Cond: ((a.vs_prefixo)::bpchar = (c.prefdep)::bpchar)
43.	53.958	53.958	↑ 2.3	159275	1	→ Seq Scan on gps_qualificacao_negocios a (cost=0.00..18699.21 rows=370721 width=51) (actual time=0.011..53.958 rows=159275 loops=1)
44.	2.532	8.957	↑ 1.0	7870	1	→ Hash (cost=829.70..829.70 rows=7870 width=10) (actual time=8.957..8.957 rows=7870 loops=1) Buckets: 1024 Batches: 1 Memory Usage: 323kB
45.	6.425	6.425	↑ 1.0	7870	1	→ Seq Scan on tbldependenciasbr c (cost=0.00..829.70 rows=7870 width=10) (actual time=0.013..6.425 rows=7870 loops=1)
46.	70.579	117.246	↑ 2.0	159274	1	→ Hash (cost=6699.48..6699.48 rows=318548 width=26) (actual time=117.246..117.246 rows=159274 loops=1) Buckets: 8192 Batches: 4 Memory Usage: 2275kB
47.	46.667	46.667	↑ 2.0	159274	1	→ Seq Scan on gps_qualificacao_obs_diaria e (cost=0.00..6699.48 rows=318548 width=26) (actual time=0.370..46.667 rows=159274 loops=1)
48.	0.157	1.055	↑ 1.0	366	1	→ Hash (cost=687.66..687.66 rows=366 width=18) (actual time=1.055..1.055 rows=366 loops=1) Buckets: 1024 Batches: 1 Memory Usage: 18kB
49.	0.898	0.898	↑ 1.0	366	1	→ Seq Scan on gps_qualificacao_contas f (cost=0.00..687.66 rows=366 width=18) (actual time=0.008..0.898 rows=366 loops=1)
50.	4.206	8.909	↓ 1.0	7665	1	→ Hash (cost=2184.73..2184.73 rows=7473 width=49) (actual time=8.909..8.909 rows=7665 loops=1) Buckets: 1024 Batches: 1 Memory Usage: 637kB
51.	4.703	4.703	↓ 1.0	7665	1	→ Seq Scan on gps_qualificacao_resultado b (cost=0.00..2184.73 rows=7473 width=49) (actual time=0.006..4.703 rows=7665 loops=1)
52.	1.629	3.158	↑ 2.0	4642	1	→ Hash (cost=188.84..188.84 rows=9284 width=26) (actual time=3.158..3.158 rows=4642 loops=1) Buckets: 1024 Batches: 1 Memory Usage: 263kB
53.	1.529	1.529	↑ 2.0	4642	1	→ Seq Scan on gps_qualificacao_obs_mensal d (cost=0.00..188.84 rows=9284 width=26) (actual time=0.058..1.529 rows=4642 loops=1)
54.	0.014	1437.331	↑ 1.6	31	1	→ Subquery Scan on "SELECT 4" (cost=86074.09..86077.41 rows=51 width=88) (actual time=1437.281..1437.331 rows=31 loops=1)
55.	411.482	1437.317	↑ 1.6	31	1	→ HashAggregate (cost=86074.09..86076.90 rows=51 width=88) (actual time=1437.278..1437.317 rows=31 loops=1)
56.	108.872	1025.835	↑ 2.3	159275	1	→ Hash Left Join (cost=17062.67..73098.86 rows=370721 width=88) (actual time=140.625..1025.835 rows=159275 loops=1) Hash Cond: ((a.mci)::bpchar = (d.mci)::bpchar)
57.	132.777	913.708	↑ 2.3	159275	1	→ Hash Left Join (cost=16757.78..67603.71 rows=370721 width=82) (actual time=137.339..913.708 rows=159275 loops=1) Hash Cond: (a.cnpj_txt = (b.cnpj)::bpchar)
58.	73.685	772.454	↑ 2.3	159275	1	→ Hash Left Join (cost=14479.64..61080.23 rows=370721 width=75) (actual time=128.844..772.454 rows=159275 loops=1) Hash Cond: ((a.mci)::bpchar = (f.qnv_ct_mci)::bpchar)
59.	333.999	697.576	↑ 2.3	159275	1	→ Hash Left Join (cost=13787.40..58994.13 rows=370721 width=67) (actual time=127.616..697.576 rows=159275 loops=1) Hash Cond: ((a.mci)::bpchar = (e.mci)::bpchar)
60.	178.986	246.637	↑ 2.3	159275	1	→ Hash Join (cost=928.08..27968.51 rows=370721 width=51) (actual time=9.987..246.637 rows=159275 loops=1) Hash Cond: ((a.vs_prefixo)::bpchar = (c.prefdep)::bpchar)
61.	57.706	57.706	↑ 2.3	159275	1	→ Seq Scan on gps_qualificacao_negocios a (cost=0.00..18699.21 rows=370721 width=51) (actual time=0.012..57.706 rows=159275 loops=1)
62.	3.584	9.945	↑ 1.0	7870	1	→ Hash (cost=829.70..829.70 rows=7870 width=10) (actual time=9.945..9.945 rows=7870 loops=1) Buckets: 1024 Batches: 1 Memory Usage: 323kB
63.	6.361	6.361	↑ 1.0	7870	1	→ Seq Scan on tbldependenciasbr c (cost=0.00..829.70 rows=7870 width=10) (actual time=0.010..6.361 rows=7870 loops=1)
64.	69.859	116.940	↑ 2.0	159274	1	→ Hash (cost=6699.48..6699.48 rows=318548 width=26) (actual time=116.940..116.940 rows=159274 loops=1) Buckets: 8192 Batches: 4 Memory Usage: 2275kB
65.	47.081	47.081	↑ 2.0	159274	1	→ Seq Scan on gps_qualificacao_obs_diaria e (cost=0.00..6699.48 rows=318548 width=26) (actual time=0.374..47.081 rows=159274 loops=1)
66.	0.174	1.193	↑ 1.0	366	1	→ Hash (cost=687.66..687.66 rows=366 width=18) (actual time=1.193..1.193 rows=366 loops=1) Buckets: 1024 Batches: 1 Memory Usage: 18kB
67.	1.019	1.019	↑ 1.0	366	1	→ Seq Scan on gps_qualificacao_contas f (cost=0.00..687.66 rows=366 width=18) (actual time=0.009..1.019 rows=366 loops=1)
68.	3.367	8.477	↓ 1.0	7665	1	→ Hash (cost=2184.73..2184.73 rows=7473 width=49) (actual time=8.477..8.477 rows=7665 loops=1) Buckets: 1024 Batches: 1 Memory Usage: 637kB
69.	5.110	5.110	↓ 1.0	7665	1	→ Seq Scan on gps_qualificacao_resultado b (cost=0.00..2184.73 rows=7473 width=49) (actual time=0.008..5.110 rows=7665 loops=1)
70.	1.665	3.255	↑ 2.0	4642	1	→ Hash (cost=188.84..188.84 rows=9284 width=26) (actual time=3.255..3.255 rows=4642 loops=1) Buckets: 1024 Batches: 1 Memory Usage: 263kB
71.	1.590	1.590	↑ 2.0	4642	1	→ Seq Scan on gps_qualificacao_obs_mensal d (cost=0.00..188.84 rows=9284 width=26) (actual time=0.065..1.590 rows=4642 loops=1)
72.	0.005	1417.970	↑ 15.5	4	1	→ Subquery Scan on "SELECT 5" (cost=86074.09..86078.12 rows=62 width=88) (actual time=1417.963..1417.970 rows=4 loops=1)
73.	395.689	1417.965	↑ 15.5	4	1	→ HashAggregate (cost=86074.09..86077.50 rows=62 width=88) (actual time=1417.961..1417.965 rows=4 loops=1)
74.	109.709	1022.276	↑ 2.3	159275	1	→ Hash Left Join (cost=17062.67..73098.86 rows=370721 width=88) (actual time=143.788..1022.276 rows=159275 loops=1) Hash Cond: ((a.mci)::bpchar = (d.mci)::bpchar)
75.	135.584	909.167	↑ 2.3	159275	1	→ Hash Left Join (cost=16757.78..67603.71 rows=370721 width=82) (actual time=140.255..909.167 rows=159275 loops=1) Hash Cond: (a.cnpj_txt = (b.cnpj)::bpchar)
76.	73.795	765.381	↑ 2.3	159275	1	→ Hash Left Join (cost=14479.64..61080.23 rows=370721 width=75) (actual time=132.034..765.381 rows=159275 loops=1) Hash Cond: ((a.mci)::bpchar = (f.qnv_ct_mci)::bpchar)
77.	327.720	690.511	↑ 2.3	159275	1	→ Hash Left Join (cost=13787.40..58994.13 rows=370721 width=67) (actual time=130.923..690.511 rows=159275 loops=1) Hash Cond: ((a.mci)::bpchar = (e.mci)::bpchar)
78.	178.293	242.433	↑ 2.3	159275	1	→ Hash Join (cost=928.08..27968.51 rows=370721 width=51) (actual time=9.927..242.433 rows=159275 loops=1) Hash Cond: ((a.vs_prefixo)::bpchar = (c.prefdep)::bpchar)
79.	54.254	54.254	↑ 2.3	159275	1	→ Seq Scan on gps_qualificacao_negocios a (cost=0.00..18699.21 rows=370721 width=51) (actual time=0.011..54.254 rows=159275 loops=1)
80.	2.862	9.886	↑ 1.0	7870	1	→ Hash (cost=829.70..829.70 rows=7870 width=10) (actual time=9.886..9.886 rows=7870 loops=1) Buckets: 1024 Batches: 1 Memory Usage: 323kB
81.	7.024	7.024	↑ 1.0	7870	1	→ Seq Scan on tbldependenciasbr c (cost=0.00..829.70 rows=7870 width=10) (actual time=0.010..7.024 rows=7870 loops=1)
82.	73.341	120.358	↑ 2.0	159274	1	→ Hash (cost=6699.48..6699.48 rows=318548 width=26) (actual time=120.358..120.358 rows=159274 loops=1) Buckets: 8192 Batches: 4 Memory Usage: 2275kB
83.	47.017	47.017	↑ 2.0	159274	1	→ Seq Scan on gps_qualificacao_obs_diaria e (cost=0.00..6699.48 rows=318548 width=26) (actual time=0.371..47.017 rows=159274 loops=1)
84.	0.172	1.075	↑ 1.0	366	1	→ Hash (cost=687.66..687.66 rows=366 width=18) (actual time=1.075..1.075 rows=366 loops=1) Buckets: 1024 Batches: 1 Memory Usage: 18kB
85.	0.903	0.903	↑ 1.0	366	1	→ Seq Scan on gps_qualificacao_contas f (cost=0.00..687.66 rows=366 width=18) (actual time=0.008..0.903 rows=366 loops=1)
86.	3.511	8.202	↓ 1.0	7665	1	→ Hash (cost=2184.73..2184.73 rows=7473 width=49) (actual time=8.202..8.202 rows=7665 loops=1) Buckets: 1024 Batches: 1 Memory Usage: 637kB
87.	4.691	4.691	↓ 1.0	7665	1	→ Seq Scan on gps_qualificacao_resultado b (cost=0.00..2184.73 rows=7473 width=49) (actual time=0.006..4.691 rows=7665 loops=1)
88.	1.866	3.400	↑ 2.0	4642	1	→ Hash (cost=188.84..188.84 rows=9284 width=26) (actual time=3.400..3.400 rows=4642 loops=1) Buckets: 1024 Batches: 1 Memory Usage: 263kB
89.	1.534	1.534	↑ 2.0	4642	1	→ Seq Scan on gps_qualificacao_obs_mensal d (cost=0.00..188.84 rows=9284 width=26) (actual time=0.058..1.534 rows=4642 loops=1)

"HashAggregate  (cost=421612.07..421663.16 rows=5109 width=88) (actual time=7303.699..7306.533 rows=5500 loops=1)"
"  ->  Append  (cost=76804.80..421433.26 rows=5109 width=88) (actual time=1332.613..7295.058 rows=5501 loops=1)"
"        ->  Subquery Scan on "*SELECT* 1"  (cost=76804.80..77074.03 rows=4142 width=88) (actual time=1332.612..1340.295 rows=4676 loops=1)"
"              ->  HashAggregate  (cost=76804.80..77032.61 rows=4142 width=88) (actual time=1332.608..1338.718 rows=4676 loops=1)"
"                    ->  Hash Left Join  (cost=16134.60..63829.56 rows=370721 width=88) (actual time=129.288..869.151 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.122..794.735 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.736..685.765 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=116.253..540.351 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.012..78.438 rows=159275 loops=1)"
"                                            ->  Hash  (cost=6699.48..6699.48 rows=318548 width=26) (actual time=115.518..115.518 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.558..46.454 rows=159274 loops=1)"
"                                      ->  Hash  (cost=2184.73..2184.73 rows=7473 width=49) (actual time=8.316..8.316 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.721 rows=7665 loops=1)"
"                                ->  Hash  (cost=188.84..188.84 rows=9284 width=26) (actual time=3.365..3.365 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.059..1.530 rows=4642 loops=1)"
"                          ->  Hash  (cost=687.66..687.66 rows=366 width=18) (actual time=1.153..1.153 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.916 rows=366 loops=1)"
"        ->  Subquery Scan on "*SELECT* 2"  (cost=86074.09..86118.29 rows=680 width=88) (actual time=1491.179..1492.192 rows=658 loops=1)"
"              ->  HashAggregate  (cost=86074.09..86111.49 rows=680 width=88) (actual time=1491.176..1491.962 rows=658 loops=1)"
"                    ->  Hash Left Join  (cost=17062.67..73098.86 rows=370721 width=88) (actual time=140.505..1058.834 rows=159275 loops=1)"
"                          Hash Cond: ((a.mci)::bpchar = (d.mci)::bpchar)"
"                          ->  Hash Left Join  (cost=16757.78..67603.71 rows=370721 width=82) (actual time=136.748..940.602 rows=159275 loops=1)"
"                                Hash Cond: (a.cnpj_txt = (b.cnpj)::bpchar)"
"                                ->  Hash Left Join  (cost=14479.64..61080.23 rows=370721 width=75) (actual time=128.279..789.074 rows=159275 loops=1)"
"                                      Hash Cond: ((a.mci)::bpchar = (f.qnv_ct_mci)::bpchar)"
"                                      ->  Hash Left Join  (cost=13787.40..58994.13 rows=370721 width=67) (actual time=127.160..713.394 rows=159275 loops=1)"
"                                            Hash Cond: ((a.mci)::bpchar = (e.mci)::bpchar)"
"                                            ->  Hash Join  (cost=928.08..27968.51 rows=370721 width=51) (actual time=10.117..259.576 rows=159275 loops=1)"
"                                                  Hash Cond: ((a.vs_prefixo)::bpchar = (c.prefdep)::bpchar)"
"                                                  ->  Seq Scan on gps_qualificacao_negocios a  (cost=0.00..18699.21 rows=370721 width=51) (actual time=0.012..57.723 rows=159275 loops=1)"
"                                                  ->  Hash  (cost=829.70..829.70 rows=7870 width=10) (actual time=9.997..9.997 rows=7870 loops=1)"
"                                                        Buckets: 1024  Batches: 1  Memory Usage: 323kB"
"                                                        ->  Seq Scan on tbldependenciasbr c  (cost=0.00..829.70 rows=7870 width=10) (actual time=0.012..6.629 rows=7870 loops=1)"
"                                            ->  Hash  (cost=6699.48..6699.48 rows=318548 width=26) (actual time=116.259..116.259 rows=159274 loops=1)"
"                                                  Buckets: 8192  Batches: 4  Memory Usage: 2275kB"
"                                                  ->  Seq Scan on gps_qualificacao_obs_diaria e  (cost=0.00..6699.48 rows=318548 width=26) (actual time=0.371..46.547 rows=159274 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.009..0.908 rows=366 loops=1)"
"                                ->  Hash  (cost=2184.73..2184.73 rows=7473 width=49) (actual time=8.452..8.452 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.006..4.741 rows=7665 loops=1)"
"                          ->  Hash  (cost=188.84..188.84 rows=9284 width=26) (actual time=3.720..3.720 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.064..1.602 rows=4642 loops=1)"
"        ->  Subquery Scan on "*SELECT* 3"  (cost=86074.09..86085.40 rows=174 width=88) (actual time=1605.921..1606.120 rows=132 loops=1)"
"              ->  HashAggregate  (cost=86074.09..86083.66 rows=174 width=88) (actual time=1605.918..1606.071 rows=132 loops=1)"
"                    ->  Hash Left Join  (cost=17062.67..73098.86 rows=370721 width=88) (actual time=140.100..1187.319 rows=159275 loops=1)"
"                          Hash Cond: ((a.mci)::bpchar = (d.mci)::bpchar)"
"                          ->  Hash Left Join  (cost=16757.78..67603.71 rows=370721 width=82) (actual time=136.908..1078.802 rows=159275 loops=1)"
"                                Hash Cond: (a.cnpj_txt = (b.cnpj)::bpchar)"
"                                ->  Hash Left Join  (cost=14479.64..61080.23 rows=370721 width=75) (actual time=127.988..940.853 rows=159275 loops=1)"
"                                      Hash Cond: ((a.mci)::bpchar = (f.qnv_ct_mci)::bpchar)"
"                                      ->  Hash Left Join  (cost=13787.40..58994.13 rows=370721 width=67) (actual time=126.914..865.376 rows=159275 loops=1)"
"                                            Hash Cond: ((a.mci)::bpchar = (e.mci)::bpchar)"
"                                            ->  Hash Join  (cost=928.08..27968.51 rows=370721 width=51) (actual time=8.997..237.420 rows=159275 loops=1)"
"                                                  Hash Cond: ((a.vs_prefixo)::bpchar = (c.prefdep)::bpchar)"
"                                                  ->  Seq Scan on gps_qualificacao_negocios a  (cost=0.00..18699.21 rows=370721 width=51) (actual time=0.011..53.958 rows=159275 loops=1)"
"                                                  ->  Hash  (cost=829.70..829.70 rows=7870 width=10) (actual time=8.957..8.957 rows=7870 loops=1)"
"                                                        Buckets: 1024  Batches: 1  Memory Usage: 323kB"
"                                                        ->  Seq Scan on tbldependenciasbr c  (cost=0.00..829.70 rows=7870 width=10) (actual time=0.013..6.425 rows=7870 loops=1)"
"                                            ->  Hash  (cost=6699.48..6699.48 rows=318548 width=26) (actual time=117.246..117.246 rows=159274 loops=1)"
"                                                  Buckets: 8192  Batches: 4  Memory Usage: 2275kB"
"                                                  ->  Seq Scan on gps_qualificacao_obs_diaria e  (cost=0.00..6699.48 rows=318548 width=26) (actual time=0.370..46.667 rows=159274 loops=1)"
"                                      ->  Hash  (cost=687.66..687.66 rows=366 width=18) (actual time=1.055..1.055 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.008..0.898 rows=366 loops=1)"
"                                ->  Hash  (cost=2184.73..2184.73 rows=7473 width=49) (actual time=8.909..8.909 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.006..4.703 rows=7665 loops=1)"
"                          ->  Hash  (cost=188.84..188.84 rows=9284 width=26) (actual time=3.158..3.158 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.058..1.529 rows=4642 loops=1)"
"        ->  Subquery Scan on "*SELECT* 4"  (cost=86074.09..86077.41 rows=51 width=88) (actual time=1437.281..1437.331 rows=31 loops=1)"
"              ->  HashAggregate  (cost=86074.09..86076.90 rows=51 width=88) (actual time=1437.278..1437.317 rows=31 loops=1)"
"                    ->  Hash Left Join  (cost=17062.67..73098.86 rows=370721 width=88) (actual time=140.625..1025.835 rows=159275 loops=1)"
"                          Hash Cond: ((a.mci)::bpchar = (d.mci)::bpchar)"
"                          ->  Hash Left Join  (cost=16757.78..67603.71 rows=370721 width=82) (actual time=137.339..913.708 rows=159275 loops=1)"
"                                Hash Cond: (a.cnpj_txt = (b.cnpj)::bpchar)"
"                                ->  Hash Left Join  (cost=14479.64..61080.23 rows=370721 width=75) (actual time=128.844..772.454 rows=159275 loops=1)"
"                                      Hash Cond: ((a.mci)::bpchar = (f.qnv_ct_mci)::bpchar)"
"                                      ->  Hash Left Join  (cost=13787.40..58994.13 rows=370721 width=67) (actual time=127.616..697.576 rows=159275 loops=1)"
"                                            Hash Cond: ((a.mci)::bpchar = (e.mci)::bpchar)"
"                                            ->  Hash Join  (cost=928.08..27968.51 rows=370721 width=51) (actual time=9.987..246.637 rows=159275 loops=1)"
"                                                  Hash Cond: ((a.vs_prefixo)::bpchar = (c.prefdep)::bpchar)"
"                                                  ->  Seq Scan on gps_qualificacao_negocios a  (cost=0.00..18699.21 rows=370721 width=51) (actual time=0.012..57.706 rows=159275 loops=1)"
"                                                  ->  Hash  (cost=829.70..829.70 rows=7870 width=10) (actual time=9.945..9.945 rows=7870 loops=1)"
"                                                        Buckets: 1024  Batches: 1  Memory Usage: 323kB"
"                                                        ->  Seq Scan on tbldependenciasbr c  (cost=0.00..829.70 rows=7870 width=10) (actual time=0.010..6.361 rows=7870 loops=1)"
"                                            ->  Hash  (cost=6699.48..6699.48 rows=318548 width=26) (actual time=116.940..116.940 rows=159274 loops=1)"
"                                                  Buckets: 8192  Batches: 4  Memory Usage: 2275kB"
"                                                  ->  Seq Scan on gps_qualificacao_obs_diaria e  (cost=0.00..6699.48 rows=318548 width=26) (actual time=0.374..47.081 rows=159274 loops=1)"
"                                      ->  Hash  (cost=687.66..687.66 rows=366 width=18) (actual time=1.193..1.193 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.009..1.019 rows=366 loops=1)"
"                                ->  Hash  (cost=2184.73..2184.73 rows=7473 width=49) (actual time=8.477..8.477 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.008..5.110 rows=7665 loops=1)"
"                          ->  Hash  (cost=188.84..188.84 rows=9284 width=26) (actual time=3.255..3.255 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.065..1.590 rows=4642 loops=1)"
"        ->  Subquery Scan on "*SELECT* 5"  (cost=86074.09..86078.12 rows=62 width=88) (actual time=1417.963..1417.970 rows=4 loops=1)"
"              ->  HashAggregate  (cost=86074.09..86077.50 rows=62 width=88) (actual time=1417.961..1417.965 rows=4 loops=1)"
"                    ->  Hash Left Join  (cost=17062.67..73098.86 rows=370721 width=88) (actual time=143.788..1022.276 rows=159275 loops=1)"
"                          Hash Cond: ((a.mci)::bpchar = (d.mci)::bpchar)"
"                          ->  Hash Left Join  (cost=16757.78..67603.71 rows=370721 width=82) (actual time=140.255..909.167 rows=159275 loops=1)"
"                                Hash Cond: (a.cnpj_txt = (b.cnpj)::bpchar)"
"                                ->  Hash Left Join  (cost=14479.64..61080.23 rows=370721 width=75) (actual time=132.034..765.381 rows=159275 loops=1)"
"                                      Hash Cond: ((a.mci)::bpchar = (f.qnv_ct_mci)::bpchar)"
"                                      ->  Hash Left Join  (cost=13787.40..58994.13 rows=370721 width=67) (actual time=130.923..690.511 rows=159275 loops=1)"
"                                            Hash Cond: ((a.mci)::bpchar = (e.mci)::bpchar)"
"                                            ->  Hash Join  (cost=928.08..27968.51 rows=370721 width=51) (actual time=9.927..242.433 rows=159275 loops=1)"
"                                                  Hash Cond: ((a.vs_prefixo)::bpchar = (c.prefdep)::bpchar)"
"                                                  ->  Seq Scan on gps_qualificacao_negocios a  (cost=0.00..18699.21 rows=370721 width=51) (actual time=0.011..54.254 rows=159275 loops=1)"
"                                                  ->  Hash  (cost=829.70..829.70 rows=7870 width=10) (actual time=9.886..9.886 rows=7870 loops=1)"
"                                                        Buckets: 1024  Batches: 1  Memory Usage: 323kB"
"                                                        ->  Seq Scan on tbldependenciasbr c  (cost=0.00..829.70 rows=7870 width=10) (actual time=0.010..7.024 rows=7870 loops=1)"
"                                            ->  Hash  (cost=6699.48..6699.48 rows=318548 width=26) (actual time=120.358..120.358 rows=159274 loops=1)"
"                                                  Buckets: 8192  Batches: 4  Memory Usage: 2275kB"
"                                                  ->  Seq Scan on gps_qualificacao_obs_diaria e  (cost=0.00..6699.48 rows=318548 width=26) (actual time=0.371..47.017 rows=159274 loops=1)"
"                                      ->  Hash  (cost=687.66..687.66 rows=366 width=18) (actual time=1.075..1.075 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.008..0.903 rows=366 loops=1)"
"                                ->  Hash  (cost=2184.73..2184.73 rows=7473 width=49) (actual time=8.202..8.202 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.006..4.691 rows=7665 loops=1)"
"                          ->  Hash  (cost=188.84..188.84 rows=9284 width=26) (actual time=3.400..3.400 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.058..1.534 rows=4642 loops=1)"
"Total runtime: 7309.759 ms"

Per node type stats

node type	count	sum of times	% of query
Append	1	1.150 ms	0.0 %
Hash	24	393.315 ms	5.4 %
Hash Join	4	723.640 ms	9.9 %
Hash Left Join	20	3447.781 ms	47.2 %
HashAggregate	6	2140.093 ms	29.3 %
Seq Scan	29	598.679 ms	8.2 %
Subquery Scan on "SELECT 1"	1	1.577 ms	0.0 %
Subquery Scan on "SELECT 2"	1	0.230 ms	0.0 %
Subquery Scan on "SELECT 3"	1	0.049 ms	0.0 %
Subquery Scan on "SELECT 4"	1	0.014 ms	0.0 %
Subquery Scan on "SELECT 5"	1	0.005 ms	0.0 %

Per table stats

Table name	Scan count	Total time	% of query
scan type	count	sum of times	% of table
gps_qualificacao_contas	5	4.644 ms	0.1 %
Seq Scan	5	4.644 ms	100.0 %
gps_qualificacao_negocios	5	302.079 ms	4.1 %
Seq Scan	5	302.079 ms	100.0 %
gps_qualificacao_obs_diaria	5	233.766 ms	3.2 %
Seq Scan	5	233.766 ms	100.0 %
gps_qualificacao_obs_mensal	5	7.785 ms	0.1 %
Seq Scan	5	7.785 ms	100.0 %
gps_qualificacao_resultado	5	23.966 ms	0.3 %
Seq Scan	5	23.966 ms	100.0 %
tbldependenciasbr	4	26.439 ms	0.4 %
Seq Scan	4	26.439 ms	100.0 %

explain.depesz.com

A tool for finding a real cause for slow queries.

Result: ni6

Colorize:

Columns visibility:

Per node type stats

Per table stats