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. 1,390.168 1,390.168 ↓ 1.1 4,676 1

CTE Scan on prefixos (cost=77,032.61..77,115.45 rows=4,142 width=136) (actual time=1,378.245..1,390.168 rows=4,676 loops=1)

2.          

CTE prefixos

3. 491.446 1,384.771 ↓ 1.1 4,676 1

HashAggregate (cost=76,804.80..77,032.61 rows=4,142 width=88) (actual time=1,378.238..1,384.771 rows=4,676 loops=1)

4. 73.676 893.325 ↑ 2.3 159,275 1

Hash Left Join (cost=16,134.60..63,829.56 rows=370,721 width=88) (actual time=129.208..893.325 rows=159,275 loops=1)

  • Hash Cond: ((a.mci)::bpchar = (f.qnv_ct_mci)::bpchar)
5. 120.148 818.570 ↑ 2.3 159,275 1

Hash Left Join (cost=15,442.36..61,743.46 rows=370,721 width=90) (actual time=128.113..818.570 rows=159,275 loops=1)

  • Hash Cond: ((a.mci)::bpchar = (d.mci)::bpchar)
6. 154.343 694.941 ↑ 2.3 159,275 1

Hash Left Join (cost=15,137.47..56,248.32 rows=370,721 width=74) (actual time=124.606..694.941 rows=159,275 loops=1)

  • Hash Cond: (a.cnpj_txt = (b.cnpj)::bpchar)
7. 336.576 531.596 ↑ 2.3 159,275 1

Hash Left Join (cost=12,859.33..49,724.84 rows=370,721 width=67) (actual time=115.574..531.596 rows=159,275 loops=1)

  • Hash Cond: ((a.mci)::bpchar = (c.mci)::bpchar)
8. 80.134 80.134 ↑ 2.3 159,275 1

Seq Scan on gps_qualificacao_negocios a (cost=0.00..18,699.21 rows=370,721 width=51) (actual time=0.014..80.134 rows=159,275 loops=1)

9. 68.178 114.886 ↑ 2.0 159,274 1

Hash (cost=6,699.48..6,699.48 rows=318,548 width=26) (actual time=114.886..114.886 rows=159,274 loops=1)

  • Buckets: 8192 Batches: 4 Memory Usage: 2275kB
10. 46.708 46.708 ↑ 2.0 159,274 1

Seq Scan on gps_qualificacao_obs_diaria c (cost=0.00..6,699.48 rows=318,548 width=26) (actual time=0.498..46.708 rows=159,274 loops=1)

11. 4.096 9.002 ↓ 1.0 7,665 1

Hash (cost=2,184.73..2,184.73 rows=7,473 width=49) (actual time=9.002..9.002 rows=7,665 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 637kB
12. 4.906 4.906 ↓ 1.0 7,665 1

Seq Scan on gps_qualificacao_resultado b (cost=0.00..2,184.73 rows=7,473 width=49) (actual time=0.007..4.906 rows=7,665 loops=1)

13. 1.888 3.481 ↑ 2.0 4,642 1

Hash (cost=188.84..188.84 rows=9,284 width=26) (actual time=3.481..3.481 rows=4,642 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 263kB
14. 1.593 1.593 ↑ 2.0 4,642 1

Seq Scan on gps_qualificacao_obs_mensal d (cost=0.00..188.84 rows=9,284 width=26) (actual time=0.061..1.593 rows=4,642 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)