explain.depesz.com

PostgreSQL's explain analyze made readable

Result: DpaC : prueba 2

Settings
# exclusive inclusive rows x rows loops node
1. 304.309 5,225.312 ↑ 1.1 438,760 1

GroupAggregate (cost=443,086.01..466,269.61 rows=463,672 width=646) (actual time=4,132.246..5,225.312 rows=438,760 loops=1)

  • Group Key: cups_contratos_atributos.fk_cups, cups_contratos_atributos.fk_tarifa_acceso, cups_contratos_atributos.telegestion_integrada, cups_contratos.cod_simel, cups_contratos_atributos.potencia_p1, cups_contratos_atributos.potencia_p2, cups_contratos_atributos.potencia_p3, cups_contratos_atributos.potencia_p4, cups_contratos_atributos.potencia_p5, cups_contratos_atributos.potencia_p6, cups_contratos_atributos.fk_codigo_puntomedida, ne_upr_seie_sistema_aislado.sistema_aislado
2. 3,407.758 4,921.003 ↓ 1.0 463,866 1

Sort (cost=443,086.01..444,245.19 rows=463,672 width=614) (actual time=4,132.232..4,921.003 rows=463,866 loops=1)

  • Sort Key: cups_contratos_atributos.fk_cups, cups_contratos_atributos.fk_tarifa_acceso, cups_contratos_atributos.telegestion_integrada, cups_contratos.cod_simel, cups_contratos_atributos.potencia_p1, cups_contratos_atributos.potencia_p2, cups_contratos_atributos.potencia_p3, cups_contratos_atributos.potencia_p4, cups_contratos_atributos.potencia_p5, cups_contratos_atributos.potencia_p6, cups_contratos_atributos.fk_codigo_puntomedida, ne_upr_seie_sistema_aislado.sistema_aislado
  • Sort Method: external merge Disk: 44,248kB
3. 70.759 1,513.245 ↓ 1.0 463,866 1

Hash Left Join (cost=212,402.67..272,660.61 rows=463,672 width=614) (actual time=527.416..1,513.245 rows=463,866 loops=1)

  • Hash Cond: (cups.fk_upr_seie_sistema_aislado = ne_upr_seie_sistema_aislado.codigo)
4. 445.191 1,442.471 ↑ 1.0 463,670 1

Hash Join (cost=212,401.38..270,752.08 rows=463,672 width=102) (actual time=527.371..1,442.471 rows=463,670 loops=1)

  • Hash Cond: ((cups_contratos_atributos.fk_cups)::text = (cups.cups)::text)
5. 356.290 633.792 ↑ 1.0 463,671 1

Hash Join (cost=14,387.75..47,444.96 rows=463,672 width=98) (actual time=162.321..633.792 rows=463,671 loops=1)

  • Hash Cond: (cups_contratos_atributos.fk_contratos = cups_contratos.id_contrato)
6. 118.739 118.739 ↑ 1.0 463,672 1

Seq Scan on cups_contratos_atributos (cost=0.00..11,018.72 rows=463,672 width=93) (actual time=0.017..118.739 rows=463,672 loops=1)

7. 86.169 158.763 ↑ 1.0 425,157 1

Hash (cost=6,994.22..6,994.22 rows=425,322 width=13) (actual time=158.763..158.763 rows=425,157 loops=1)

  • Buckets: 262,144 Batches: 2 Memory Usage: 12,027kB
8. 72.594 72.594 ↑ 1.0 425,157 1

Seq Scan on cups_contratos (cost=0.00..6,994.22 rows=425,322 width=13) (actual time=0.017..72.594 rows=425,157 loops=1)

9. 84.763 363.488 ↑ 1.7 372,890 1

Hash (cost=185,490.28..185,490.28 rows=647,628 width=25) (actual time=363.488..363.488 rows=372,890 loops=1)

  • Buckets: 262,144 Batches: 4 Memory Usage: 6,900kB
10. 278.725 278.725 ↑ 1.7 372,890 1

Seq Scan on cups (cost=0.00..185,490.28 rows=647,628 width=25) (actual time=0.012..278.725 rows=372,890 loops=1)

11. 0.007 0.015 ↑ 1.0 13 1

Hash (cost=1.13..1.13 rows=13 width=520) (actual time=0.015..0.015 rows=13 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 9kB
12. 0.008 0.008 ↑ 1.0 13 1

Seq Scan on ne_upr_seie_sistema_aislado (cost=0.00..1.13 rows=13 width=520) (actual time=0.006..0.008 rows=13 loops=1)

Planning time : 3.518 ms
Execution time : 5,262.660 ms