explain.depesz.com

A tool for finding a real cause for slow queries.

Result: 4UXL

options
# exclusive inclusive rows x rows loops node
1. 36.467 6919.671 ↓ 1.1 5491 1
→

HashAggregate (cost=407839.33..408209.73 rows=5109 width=131) (actual time=6898.677..6919.671 rows=5491 loops=1)

2. 3.310 6883.204 ↓ 1.1 5498 1
→

Hash Left Join (cost=407327.24..407571.11 rows=5109 width=131) (actual time=6869.627..6883.204 rows=5498 loops=1)

  • Hash Cond: ((d.prefdep)::text = (m.qm_prefdep)::text)
  • Join Filter: (COALESCE("*SELECT* 1".total, 0::bigint) <> 0)
3. 7.120 6878.523 ↓ 1.1 5498 1
→

Hash Join (cost=407293.25..407510.38 rows=5109 width=127) (actual time=6868.234..6878.523 rows=5498 loops=1)

  • Hash Cond: ((("*SELECT* 1".vs_prefixo)::bpchar) = (d.prefdep)::bpchar)
4. 10.364 6858.914 ↓ 1.1 5500 1
→

HashAggregate (cost=406448.17..406499.26 rows=5109 width=88) (actual time=6855.727..6858.914 rows=5500 loops=1)

5. 1.170 6848.550 ↓ 1.1 5501 1
→

Append (cost=73838.42..406269.36 rows=5109 width=88) (actual time=1294.559..6848.550 rows=5501 loops=1)

6. 1.574 1302.305 ↓ 1.1 4676 1
→

Subquery Scan on "*SELECT* 1" (cost=73838.42..74107.65 rows=4142 width=88) (actual time=1294.557..1302.305 rows=4676 loops=1)

7. 459.587 1300.731 ↓ 1.1 4676 1
→

HashAggregate (cost=73838.42..74066.23 rows=4142 width=88) (actual time=1294.553..1300.731 rows=4676 loops=1)

8. 74.312 841.144 ↑ 2.3 159275 1
→

Hash Left Join (cost=15109.52..60863.18 rows=370721 width=88) (actual time=125.071..841.144 rows=159275 loops=1)

  • Hash Cond: ((a.mci)::bpchar = (f.qnv_ct_mci)::bpchar)
9. 103.325 765.672 ↑ 2.3 159275 1
→

Hash Left Join (cost=14417.29..58777.08 rows=370721 width=90) (actual time=123.897..765.672 rows=159275 loops=1)

  • Hash Cond: ((a.mci)::bpchar = (d.mci)::bpchar)
10. 133.761 659.209 ↑ 2.3 159275 1
→

Hash Left Join (cost=14168.84..55238.41 rows=370721 width=74) (actual time=120.738..659.209 rows=159275 loops=1)

  • Hash Cond: (a.cnpj_txt = (b.cnpj)::bpchar)
11. 325.129 516.941 ↑ 2.3 159275 1
→

Hash Left Join (cost=11890.70..48714.93 rows=370721 width=67) (actual time=112.207..516.941 rows=159275 loops=1)

  • Hash Cond: ((a.mci)::bpchar = (c.mci)::bpchar)
12. 80.322 80.322 ↑ 2.3 159275 1
→

Seq Scan on gps_qualificacao_negocios a (cost=0.00..18699.21 rows=370721 width=51) (actual time=0.005..80.322 rows=159275 loops=1)

13. 65.245 111.490 ↑ 2.0 159274 1
→

Hash (cost=5778.20..5778.20 rows=316120 width=26) (actual time=111.490..111.490 rows=159274 loops=1)

  • Buckets: 8192 Batches: 4 Memory Usage: 2275kB
14. 46.245 46.245 ↑ 2.0 159274 1
→

Seq Scan on gps_qualificacao_obs_diaria c (cost=0.00..5778.20 rows=316120 width=26) (actual time=2.170..46.245 rows=159274 loops=1)

15. 3.404 8.507 ↓ 1.0 7664 1
→

Hash (cost=2184.73..2184.73 rows=7473 width=49) (actual time=8.507..8.507 rows=7664 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 637kB
16. 5.103 5.103 ↓ 1.0 7664 1
→

Seq Scan on gps_qualificacao_resultado b (cost=0.00..2184.73 rows=7473 width=49) (actual time=0.008..5.103 rows=7664 loops=1)

17. 1.617 3.138 ↑ 1.0 4642 1
→

Hash (cost=190.42..190.42 rows=4642 width=26) (actual time=3.138..3.138 rows=4642 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 263kB
18. 1.521 1.521 ↑ 1.0 4642 1
→

Seq Scan on gps_qualificacao_obs_mensal d (cost=0.00..190.42 rows=4642 width=26) (actual time=0.124..1.521 rows=4642 loops=1)

19. 0.166 1.160 ↑ 1.0 366 1
→

Hash (cost=687.66..687.66 rows=366 width=18) (actual time=1.160..1.160 rows=366 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 18kB
20. 0.994 0.994 ↑ 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.994 rows=366 loops=1)

21. 0.225 1426.460 ↑ 1.0 658 1
→

Subquery Scan on "*SELECT* 2" (cost=83024.71..83068.91 rows=680 width=88) (actual time=1425.219..1426.460 rows=658 loops=1)

22. 421.753 1426.235 ↑ 1.0 658 1
→

HashAggregate (cost=83024.71..83062.11 rows=680 width=88) (actual time=1425.215..1426.235 rows=658 loops=1)

23. 74.803 1004.482 ↑ 2.3 159275 1
→

Hash Left Join (cost=15954.60..70049.48 rows=370721 width=88) (actual time=135.517..1004.482 rows=159275 loops=1)

  • Hash Cond: ((a.mci)::bpchar = (f.qnv_ct_mci)::bpchar)
24. 102.038 928.590 ↑ 2.3 159275 1
→

Hash Left Join (cost=15262.36..67963.38 rows=370721 width=90) (actual time=134.414..928.590 rows=159275 loops=1)

  • Hash Cond: ((a.mci)::bpchar = (d.mci)::bpchar)
25. 132.525 823.405 ↑ 2.3 159275 1
→

Hash Left Join (cost=15013.92..64424.71 rows=370721 width=74) (actual time=131.231..823.405 rows=159275 loops=1)

  • Hash Cond: (a.cnpj_txt = (b.cnpj)::bpchar)
26. 324.093 682.479 ↑ 2.3 159275 1
→

Hash Left Join (cost=12735.78..57901.22 rows=370721 width=67) (actual time=122.792..682.479 rows=159275 loops=1)

  • Hash Cond: ((a.mci)::bpchar = (e.mci)::bpchar)
27. 180.509 245.695 ↑ 2.3 159275 1
→

Hash Join (cost=845.08..27885.51 rows=370721 width=51) (actual time=9.403..245.695 rows=159275 loops=1)

  • Hash Cond: ((a.vs_prefixo)::bpchar = (c.prefdep)::bpchar)
28. 55.832 55.832 ↑ 2.3 159275 1
→

Seq Scan on gps_qualificacao_negocios a (cost=0.00..18699.21 rows=370721 width=51) (actual time=0.015..55.832 rows=159275 loops=1)

29. 2.620 9.354 ↑ 1.0 7870 1
→

Hash (cost=746.70..746.70 rows=7870 width=10) (actual time=9.354..9.354 rows=7870 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 323kB
30. 6.734 6.734 ↑ 1.0 7870 1
→

Seq Scan on tbldependenciasbr c (cost=0.00..746.70 rows=7870 width=10) (actual time=0.007..6.734 rows=7870 loops=1)

31. 66.274 112.691 ↑ 2.0 159274 1
→

Hash (cost=5778.20..5778.20 rows=316120 width=26) (actual time=112.691..112.691 rows=159274 loops=1)

  • Buckets: 8192 Batches: 4 Memory Usage: 2275kB
32. 46.417 46.417 ↑ 2.0 159274 1
→

Seq Scan on gps_qualificacao_obs_diaria e (cost=0.00..5778.20 rows=316120 width=26) (actual time=2.170..46.417 rows=159274 loops=1)

33. 3.500 8.401 ↓ 1.0 7664 1
→

Hash (cost=2184.73..2184.73 rows=7473 width=49) (actual time=8.401..8.401 rows=7664 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 637kB
34. 4.901 4.901 ↓ 1.0 7664 1
→

Seq Scan on gps_qualificacao_resultado b (cost=0.00..2184.73 rows=7473 width=49) (actual time=0.009..4.901 rows=7664 loops=1)

35. 1.631 3.147 ↑ 1.0 4642 1
→

Hash (cost=190.42..190.42 rows=4642 width=26) (actual time=3.147..3.147 rows=4642 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 263kB
36. 1.516 1.516 ↑ 1.0 4642 1
→

Seq Scan on gps_qualificacao_obs_mensal d (cost=0.00..190.42 rows=4642 width=26) (actual time=0.117..1.516 rows=4642 loops=1)

37. 0.168 1.089 ↑ 1.0 366 1
→

Hash (cost=687.66..687.66 rows=366 width=18) (actual time=1.089..1.089 rows=366 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 18kB
38. 0.921 0.921 ↑ 1.0 366 1
→

Seq Scan on gps_qualificacao_contas f (cost=0.00..687.66 rows=366 width=18) (actual time=0.007..0.921 rows=366 loops=1)

39. 0.049 1382.478 ↑ 1.3 132 1
→

Subquery Scan on "*SELECT* 3" (cost=83024.71..83036.02 rows=174 width=88) (actual time=1382.246..1382.478 rows=132 loops=1)

40. 411.880 1382.429 ↑ 1.3 132 1
→

HashAggregate (cost=83024.71..83034.28 rows=174 width=88) (actual time=1382.243..1382.429 rows=132 loops=1)

41. 74.032 970.549 ↑ 2.3 159275 1
→

Hash Left Join (cost=15954.60..70049.48 rows=370721 width=88) (actual time=135.210..970.549 rows=159275 loops=1)

  • Hash Cond: ((a.mci)::bpchar = (f.qnv_ct_mci)::bpchar)
42. 98.020 895.364 ↑ 2.3 159275 1
→

Hash Left Join (cost=15262.36..67963.38 rows=370721 width=90) (actual time=134.043..895.364 rows=159275 loops=1)

  • Hash Cond: ((a.mci)::bpchar = (d.mci)::bpchar)
43. 125.553 794.069 ↑ 2.3 159275 1
→

Hash Left Join (cost=15013.92..64424.71 rows=370721 width=74) (actual time=130.730..794.069 rows=159275 loops=1)

  • Hash Cond: (a.cnpj_txt = (b.cnpj)::bpchar)
44. 308.272 660.077 ↑ 2.3 159275 1
→

Hash Left Join (cost=12735.78..57901.22 rows=370721 width=67) (actual time=122.249..660.077 rows=159275 loops=1)

  • Hash Cond: ((a.mci)::bpchar = (e.mci)::bpchar)
45. 173.773 239.464 ↑ 2.3 159275 1
→

Hash Join (cost=845.08..27885.51 rows=370721 width=51) (actual time=9.231..239.464 rows=159275 loops=1)

  • Hash Cond: ((a.vs_prefixo)::bpchar = (c.prefdep)::bpchar)
46. 56.506 56.506 ↑ 2.3 159275 1
→

Seq Scan on gps_qualificacao_negocios a (cost=0.00..18699.21 rows=370721 width=51) (actual time=0.014..56.506 rows=159275 loops=1)

47. 2.593 9.185 ↑ 1.0 7870 1
→

Hash (cost=746.70..746.70 rows=7870 width=10) (actual time=9.185..9.185 rows=7870 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 323kB
48. 6.592 6.592 ↑ 1.0 7870 1
→

Seq Scan on tbldependenciasbr c (cost=0.00..746.70 rows=7870 width=10) (actual time=0.007..6.592 rows=7870 loops=1)

49. 66.248 112.341 ↑ 2.0 159274 1
→

Hash (cost=5778.20..5778.20 rows=316120 width=26) (actual time=112.341..112.341 rows=159274 loops=1)

  • Buckets: 8192 Batches: 4 Memory Usage: 2275kB
50. 46.093 46.093 ↑ 2.0 159274 1
→

Seq Scan on gps_qualificacao_obs_diaria e (cost=0.00..5778.20 rows=316120 width=26) (actual time=2.131..46.093 rows=159274 loops=1)

51. 3.382 8.439 ↓ 1.0 7664 1
→

Hash (cost=2184.73..2184.73 rows=7473 width=49) (actual time=8.439..8.439 rows=7664 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 637kB
52. 5.057 5.057 ↓ 1.0 7664 1
→

Seq Scan on gps_qualificacao_resultado b (cost=0.00..2184.73 rows=7473 width=49) (actual time=0.008..5.057 rows=7664 loops=1)

53. 1.713 3.275 ↑ 1.0 4642 1
→

Hash (cost=190.42..190.42 rows=4642 width=26) (actual time=3.275..3.275 rows=4642 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 263kB
54. 1.562 1.562 ↑ 1.0 4642 1
→

Seq Scan on gps_qualificacao_obs_mensal d (cost=0.00..190.42 rows=4642 width=26) (actual time=0.120..1.562 rows=4642 loops=1)

55. 0.165 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
56. 0.988 0.988 ↑ 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.988 rows=366 loops=1)

57. 0.016 1374.449 ↑ 1.6 31 1
→

Subquery Scan on "*SELECT* 4" (cost=83024.71..83028.03 rows=51 width=88) (actual time=1374.401..1374.449 rows=31 loops=1)

58. 405.513 1374.433 ↑ 1.6 31 1
→

HashAggregate (cost=83024.71..83027.52 rows=51 width=88) (actual time=1374.397..1374.433 rows=31 loops=1)

59. 73.975 968.920 ↑ 2.3 159275 1
→

Hash Left Join (cost=15954.60..70049.48 rows=370721 width=88) (actual time=135.572..968.920 rows=159275 loops=1)

  • Hash Cond: ((a.mci)::bpchar = (f.qnv_ct_mci)::bpchar)
60. 98.390 893.801 ↑ 2.3 159275 1
→

Hash Left Join (cost=15262.36..67963.38 rows=370721 width=90) (actual time=134.415..893.801 rows=159275 loops=1)

  • Hash Cond: ((a.mci)::bpchar = (d.mci)::bpchar)
61. 124.646 792.187 ↑ 2.3 159275 1
→

Hash Left Join (cost=15013.92..64424.71 rows=370721 width=74) (actual time=131.167..792.187 rows=159275 loops=1)

  • Hash Cond: (a.cnpj_txt = (b.cnpj)::bpchar)
62. 309.814 659.105 ↑ 2.3 159275 1
→

Hash Left Join (cost=12735.78..57901.22 rows=370721 width=67) (actual time=122.703..659.105 rows=159275 loops=1)

  • Hash Cond: ((a.mci)::bpchar = (e.mci)::bpchar)
63. 170.730 236.535 ↑ 2.3 159275 1
→

Hash Join (cost=845.08..27885.51 rows=370721 width=51) (actual time=9.273..236.535 rows=159275 loops=1)

  • Hash Cond: ((a.vs_prefixo)::bpchar = (c.prefdep)::bpchar)
64. 56.565 56.565 ↑ 2.3 159275 1
→

Seq Scan on gps_qualificacao_negocios a (cost=0.00..18699.21 rows=370721 width=51) (actual time=0.012..56.565 rows=159275 loops=1)

65. 2.640 9.240 ↑ 1.0 7870 1
→

Hash (cost=746.70..746.70 rows=7870 width=10) (actual time=9.240..9.240 rows=7870 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 323kB
66. 6.600 6.600 ↑ 1.0 7870 1
→

Seq Scan on tbldependenciasbr c (cost=0.00..746.70 rows=7870 width=10) (actual time=0.007..6.600 rows=7870 loops=1)

67. 66.403 112.756 ↑ 2.0 159274 1
→

Hash (cost=5778.20..5778.20 rows=316120 width=26) (actual time=112.756..112.756 rows=159274 loops=1)

  • Buckets: 8192 Batches: 4 Memory Usage: 2275kB
68. 46.353 46.353 ↑ 2.0 159274 1
→

Seq Scan on gps_qualificacao_obs_diaria e (cost=0.00..5778.20 rows=316120 width=26) (actual time=2.182..46.353 rows=159274 loops=1)

69. 3.338 8.436 ↓ 1.0 7664 1
→

Hash (cost=2184.73..2184.73 rows=7473 width=49) (actual time=8.436..8.436 rows=7664 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 637kB
70. 5.098 5.098 ↓ 1.0 7664 1
→

Seq Scan on gps_qualificacao_resultado b (cost=0.00..2184.73 rows=7473 width=49) (actual time=0.008..5.098 rows=7664 loops=1)

71. 1.662 3.224 ↑ 1.0 4642 1
→

Hash (cost=190.42..190.42 rows=4642 width=26) (actual time=3.224..3.224 rows=4642 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 263kB
72. 1.562 1.562 ↑ 1.0 4642 1
→

Seq Scan on gps_qualificacao_obs_mensal d (cost=0.00..190.42 rows=4642 width=26) (actual time=0.123..1.562 rows=4642 loops=1)

73. 0.164 1.144 ↑ 1.0 366 1
→

Hash (cost=687.66..687.66 rows=366 width=18) (actual time=1.144..1.144 rows=366 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 18kB
74. 0.980 0.980 ↑ 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.980 rows=366 loops=1)

75. 0.006 1361.688 ↑ 15.5 4 1
→

Subquery Scan on "*SELECT* 5" (cost=83024.71..83028.74 rows=62 width=88) (actual time=1361.681..1361.688 rows=4 loops=1)

76. 398.379 1361.682 ↑ 15.5 4 1
→

HashAggregate (cost=83024.71..83028.12 rows=62 width=88) (actual time=1361.677..1361.682 rows=4 loops=1)

77. 73.450 963.303 ↑ 2.3 159275 1
→

Hash Left Join (cost=15954.60..70049.48 rows=370721 width=88) (actual time=137.046..963.303 rows=159275 loops=1)

  • Hash Cond: ((a.mci)::bpchar = (f.qnv_ct_mci)::bpchar)
78. 96.586 888.724 ↑ 2.3 159275 1
→

Hash Left Join (cost=15262.36..67963.38 rows=370721 width=90) (actual time=135.903..888.724 rows=159275 loops=1)

  • Hash Cond: ((a.mci)::bpchar = (d.mci)::bpchar)
79. 125.014 788.917 ↑ 2.3 159275 1
→

Hash Left Join (cost=15013.92..64424.71 rows=370721 width=74) (actual time=132.662..788.917 rows=159275 loops=1)

  • Hash Cond: (a.cnpj_txt = (b.cnpj)::bpchar)
80. 304.954 655.389 ↑ 2.3 159275 1
→

Hash Left Join (cost=12735.78..57901.22 rows=370721 width=67) (actual time=124.123..655.389 rows=159275 loops=1)

  • Hash Cond: ((a.mci)::bpchar = (e.mci)::bpchar)
81. 171.135 237.012 ↑ 2.3 159275 1
→

Hash Join (cost=845.08..27885.51 rows=370721 width=51) (actual time=10.023..237.012 rows=159275 loops=1)

  • Hash Cond: ((a.vs_prefixo)::bpchar = (c.prefdep)::bpchar)
82. 55.898 55.898 ↑ 2.3 159275 1
→

Seq Scan on gps_qualificacao_negocios a (cost=0.00..18699.21 rows=370721 width=51) (actual time=0.012..55.898 rows=159275 loops=1)

83. 2.730 9.979 ↑ 1.0 7870 1
→

Hash (cost=746.70..746.70 rows=7870 width=10) (actual time=9.979..9.979 rows=7870 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 323kB
84. 7.249 7.249 ↑ 1.0 7870 1
→

Seq Scan on tbldependenciasbr c (cost=0.00..746.70 rows=7870 width=10) (actual time=0.009..7.249 rows=7870 loops=1)

85. 67.140 113.423 ↑ 2.0 159274 1
→

Hash (cost=5778.20..5778.20 rows=316120 width=26) (actual time=113.423..113.423 rows=159274 loops=1)

  • Buckets: 8192 Batches: 4 Memory Usage: 2275kB
86. 46.283 46.283 ↑ 2.0 159274 1
→

Seq Scan on gps_qualificacao_obs_diaria e (cost=0.00..5778.20 rows=316120 width=26) (actual time=2.164..46.283 rows=159274 loops=1)

87. 3.444 8.514 ↓ 1.0 7664 1
→

Hash (cost=2184.73..2184.73 rows=7473 width=49) (actual time=8.514..8.514 rows=7664 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 637kB
88. 5.070 5.070 ↓ 1.0 7664 1
→

Seq Scan on gps_qualificacao_resultado b (cost=0.00..2184.73 rows=7473 width=49) (actual time=0.008..5.070 rows=7664 loops=1)

89. 1.664 3.221 ↑ 1.0 4642 1
→

Hash (cost=190.42..190.42 rows=4642 width=26) (actual time=3.221..3.221 rows=4642 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 263kB
90. 1.557 1.557 ↑ 1.0 4642 1
→

Seq Scan on gps_qualificacao_obs_mensal d (cost=0.00..190.42 rows=4642 width=26) (actual time=0.118..1.557 rows=4642 loops=1)

91. 0.164 1.129 ↑ 1.0 366 1
→

Hash (cost=687.66..687.66 rows=366 width=18) (actual time=1.129..1.129 rows=366 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 18kB
92. 0.965 0.965 ↑ 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.965 rows=366 loops=1)

93. 4.719 12.489 ↑ 1.0 7870 1
→

Hash (cost=746.70..746.70 rows=7870 width=47) (actual time=12.489..12.489 rows=7870 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 616kB
94. 7.770 7.770 ↑ 1.0 7870 1
→

Seq Scan on tbldependenciasbr d (cost=0.00..746.70 rows=7870 width=47) (actual time=0.012..7.770 rows=7870 loops=1)

95. 0.321 1.371 ↓ 1.0 948 1
→

Hash (cost=22.33..22.33 rows=933 width=9) (actual time=1.371..1.371 rows=948 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 38kB
96. 1.050 1.050 ↓ 1.0 948 1
→

Seq Scan on gps_qualificacao_meta m (cost=0.00..22.33 rows=933 width=9) (actual time=0.025..1.050 rows=948 loops=1)