explain.depesz.com

A tool for finding a real cause for slow queries.

Result: XJZ

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