explain.depesz.com

A tool for finding a real cause for slow queries.

Result: ni6

options
Did it help? Consider supporting us - Bitcoin address: 12v2hUztAk2LgzQ9H9LMwuU32urHMjZQnq
# 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)