explain.depesz.com

PostgreSQL's explain analyze made readable

Result: aaQ6

Settings
# exclusive inclusive rows x rows loops node
1. 1,811.828 13,681.150 ↑ 1.2 5,001,627 1

Gather (cost=191,129.14..905,849.28 rows=5,853,848 width=347) (actual time=3,247.104..13,681.150 rows=5,001,627 loops=1)

  • Output: ids_portos.codigo_entidade, eg.codigo_entidade, eg.estado_administrativo, eg.nome, eg.versao, eg.versao_firmware, (to_date((eg.data_instalacao)::text, 'dd-MM-yyyy'::text)), eg.numero_serie, ieg.tipo_entida
  • Workers Planned: 2
  • Workers Launched: 2
  • Buffers: shared hit=768231
2. 1,333.026 11,869.322 ↑ 1.5 1,667,209 3

Hash Join (cost=191,029.14..830,137.08 rows=2,439,103 width=347) (actual time=3,790.480..11,869.322 rows=1,667,209 loops=3)

  • Output: ids_portos.codigo_entidade, eg.codigo_entidade, eg.estado_administrativo, eg.nome, eg.versao, eg.versao_firmware, to_date((eg.data_instalacao)::text, 'dd-MM-yyyy'::text), eg.numero_serie, ieg.tipo_en
  • Inner Unique: true
  • Hash Cond: (eg.codigo_entidade = ieg.codigo_entidade)
  • Buffers: shared hit=2186294
  • Worker 0: actual time=4313.630..12533.704 rows=1501711 loops=1
  • Buffers: shared hit=704135
  • Worker 1: actual time=3811.705..12332.394 rows=1782521 loops=1
  • Buffers: shared hit=713928
3. 916.175 10,004.139 ↑ 1.3 1,667,209 3

Hash Join (cost=160,504.02..761,104.72 rows=2,084,098 width=322) (actual time=3,253.153..10,004.139 rows=1,667,209 loops=3)

  • Output: eg.codigo_entidade, eg.estado_administrativo, eg.nome, eg.versao, eg.versao_firmware, eg.data_instalacao, eg.numero_serie, eg.id_dominio_gerido, eg.id_area_central, eg.bastidor, eg.sub_bastidor
  • Hash Cond: (idp.codigo_elem_gerido = eg.codigo_entidade)
  • Buffers: shared hit=2151637
  • Worker 0: actual time=3570.443..10538.574 rows=1501711 loops=1
  • Buffers: shared hit=692569
  • Worker 1: actual time=3351.210..10477.987 rows=1782521 loops=1
  • Buffers: shared hit=702362
4. 703.533 7,359.339 ↑ 1.3 1,667,209 3

Hash Join (cost=70,336.51..642,280.87 rows=2,084,098 width=178) (actual time=1,518.842..7,359.339 rows=1,667,209 loops=3)

  • Output: idp.codigo_entidade, idp.id_externo, idp.tipo_entidade, idp.object_id, idp.codigo_elem_gerido, placas.versao_firmware, placas.estado_administrativo, ids_portos.codigo_entidade, ids_portos
  • Hash Cond: (ids_portos.codigo_placa = placas.codigo_entidade)
  • Buffers: shared hit=2042275
  • Worker 0: actual time=1877.669..7991.840 rows=1501711 loops=1
  • Buffers: shared hit=656115
  • Worker 1: actual time=1397.562..7558.661 rows=1782521 loops=1
  • Buffers: shared hit=665908
5. 1,019.108 5,143.284 ↑ 1.3 1,667,209 3

Merge Join (cost=1,041.48..544,327.72 rows=2,084,227 width=100) (actual time=0.615..5,143.284 rows=1,667,209 loops=3)

  • Output: ids_portos.codigo_entidade, ids_portos.id_externo, ids_portos.tipo_entidade, ids_portos.object_id, ids_portos.codigo_placa, portos.estado_administrativo, portos.nome_porto, portos.d
  • Inner Unique: true
  • Merge Cond: (portos.codigo_entidade = ids_portos.codigo_entidade)
  • Buffers: shared hit=1980553
  • Worker 0: actual time=1.295..5471.253 rows=1501711 loops=1
  • Buffers: shared hit=635541
  • Worker 1: actual time=0.500..5416.848 rows=1782521 loops=1
  • Buffers: shared hit=645334
6. 1,104.508 2,736.534 ↑ 1.3 1,667,209 3

Merge Join (cost=27.65..321,371.13 rows=2,084,227 width=29) (actual time=0.377..2,736.534 rows=1,667,209 loops=3)

  • Output: portos.estado_administrativo, portos.nome_porto, portos.descricao, portos.codigo_entidade, recursos_portos.tipo_interface, recursos_portos.codigo_entidade
  • Inner Unique: true
  • Merge Cond: (portos.codigo_entidade = recursos_portos.codigo_entidade)
  • Buffers: shared hit=673585
  • Worker 0: actual time=0.778..2904.334 rows=1501711 loops=1
  • Buffers: shared hit=199880
  • Worker 1: actual time=0.320..2880.876 rows=1782521 loops=1
  • Buffers: shared hit=209684
7. 509.301 509.301 ↑ 1.3 1,667,209 3

Parallel Index Scan using portos_pkey on agorangmanager.portos (cost=0.43..126,033.27 rows=2,122,992 width=19) (actual time=0.026..509.301 rows=1,667,209 loops=3)

  • Output: portos.codigo_entidade, portos.nome_porto, portos.estado_administrativo, portos.id_dominio_sca, portos.descricao
  • Buffers: shared hit=194176
  • Worker 0: actual time=0.033..507.029 rows=1501711 loops=1
  • Buffers: shared hit=40073
  • Worker 1: actual time=0.029..571.863 rows=1782521 loops=1
  • Buffers: shared hit=49886
8. 1,122.725 1,122.725 ↑ 1.0 5,001,446 3

Index Scan using recursos_portos_pkey on agorangmanager.recursos_portos (cost=0.43..162,136.03 rows=5,002,144 width=10) (actual time=0.034..1,122.725 rows=5,001,446 loops=3)

  • Output: recursos_portos.codigo_entidade, recursos_portos.tipo_interface, recursos_portos.canais_disponiveis, recursos_portos.tipo_reserva, recursos_portos.lb_emissao, recursos_p
  • Buffers: shared hit=479409
  • Worker 0: actual time=0.047..1266.317 rows=5001627 loops=1
  • Buffers: shared hit=159807
  • Worker 1: actual time=0.039..1189.777 rows=5001174 loops=1
  • Buffers: shared hit=159798
9. 1,387.642 1,387.642 ↑ 1.0 5,001,447 3

Index Scan using ids_portos_pkey on agorangmanager.ids_portos (cost=0.43..191,268.05 rows=5,003,059 width=87) (actual time=0.025..1,387.642 rows=5,001,447 loops=3)

  • Output: ids_portos.codigo_entidade, ids_portos.tipo_entidade, ids_portos.object_id, ids_portos.codigo_placa, ids_portos.id_externo
  • Buffers: shared hit=1306968
  • Worker 0: actual time=0.035..1546.112 rows=5001628 loops=1
  • Buffers: shared hit=435661
  • Worker 1: actual time=0.028..1497.169 rows=5001175 loops=1
  • Buffers: shared hit=435650
10. 411.117 1,512.522 ↑ 1.0 845,442 3

Hash (cost=58,726.73..58,726.73 rows=845,464 width=94) (actual time=1,512.522..1,512.522 rows=845,442 loops=3)

  • Output: idp.codigo_entidade, idp.id_externo, idp.tipo_entidade, idp.object_id, idp.codigo_elem_gerido, placas.versao_firmware, placas.estado_administrativo, placas.codigo_entidade
  • Buckets: 1048576 Batches: 1 Memory Usage: 120895kB
  • Buffers: shared hit=61722
  • Worker 0: actual time=1869.790..1869.790 rows=845442 loops=1
  • Buffers: shared hit=20574
  • Worker 1: actual time=1391.841..1391.841 rows=845442 loops=1
  • Buffers: shared hit=20574
11. 473.256 1,101.405 ↑ 1.0 845,442 3

Hash Join (cost=26,270.94..58,726.73 rows=845,464 width=94) (actual time=483.351..1,101.405 rows=845,442 loops=3)

  • Output: idp.codigo_entidade, idp.id_externo, idp.tipo_entidade, idp.object_id, idp.codigo_elem_gerido, placas.versao_firmware, placas.estado_administrativo, placas.codigo_entidade
  • Inner Unique: true
  • Hash Cond: (idp.codigo_entidade = placas.codigo_entidade)
  • Buffers: shared hit=61722
  • Worker 0: actual time=661.953..1394.357 rows=845442 loops=1
  • Buffers: shared hit=20574
  • Worker 1: actual time=409.997..1008.936 rows=845442 loops=1
  • Buffers: shared hit=20574
12. 150.524 150.524 ↑ 1.0 845,443 3

Seq Scan on agorangmanager.ids_placas idp (cost=0.00..21,781.16 rows=845,516 width=83) (actual time=0.037..150.524 rows=845,443 loops=3)

  • Output: idp.codigo_entidade, idp.tipo_entidade, idp.object_id, idp.codigo_elem_gerido, idp.id_externo
  • Buffers: shared hit=39978
  • Worker 0: actual time=0.053..191.236 rows=845443 loops=1
  • Buffers: shared hit=13326
  • Worker 1: actual time=0.045..157.644 rows=845443 loops=1
  • Buffers: shared hit=13326
13. 280.444 477.625 ↑ 1.0 845,442 3

Hash (cost=15,702.64..15,702.64 rows=845,464 width=11) (actual time=477.625..477.625 rows=845,442 loops=3)

  • Output: placas.versao_firmware, placas.estado_administrativo, placas.codigo_entidade
  • Buckets: 1048576 Batches: 1 Memory Usage: 47837kB
  • Buffers: shared hit=21744
  • Worker 0: actual time=655.374..655.374 rows=845442 loops=1
  • Buffers: shared hit=7248
  • Worker 1: actual time=404.705..404.705 rows=845442 loops=1
  • Buffers: shared hit=7248
14. 197.181 197.181 ↑ 1.0 845,442 3

Seq Scan on agorangmanager.placas (cost=0.00..15,702.64 rows=845,464 width=11) (actual time=0.030..197.181 rows=845,442 loops=3)

  • Output: placas.versao_firmware, placas.estado_administrativo, placas.codigo_entidade
  • Buffers: shared hit=21744
  • Worker 0: actual time=0.044..286.445 rows=845442 loops=1
  • Buffers: shared hit=7248
  • Worker 1: actual time=0.034..164.820 rows=845442 loops=1
  • Buffers: shared hit=7248
15. 533.070 1,728.625 ↑ 1.2 844,424 3

Hash (cost=77,813.84..77,813.84 rows=988,293 width=144) (actual time=1,728.625..1,728.625 rows=844,424 loops=3)

  • Output: eg.codigo_entidade, eg.estado_administrativo, eg.nome, eg.versao, eg.versao_firmware, eg.data_instalacao, eg.numero_serie, eg.id_dominio_gerido, eg.id_area_central, eg.bastidor, eg.sub_ba
  • Buckets: 1048576 Batches: 1 Memory Usage: 157502kB
  • Buffers: shared hit=109362
  • Worker 0: actual time=1686.365..1686.365 rows=844424 loops=1
  • Buffers: shared hit=36454
  • Worker 1: actual time=1948.382..1948.382 rows=844424 loops=1
  • Buffers: shared hit=36454
16. 679.324 1,195.555 ↑ 1.2 844,424 3

Hash Left Join (cost=27,135.72..77,813.84 rows=988,293 width=144) (actual time=408.397..1,195.555 rows=844,424 loops=3)

  • Output: eg.codigo_entidade, eg.estado_administrativo, eg.nome, eg.versao, eg.versao_firmware, eg.data_instalacao, eg.numero_serie, eg.id_dominio_gerido, eg.id_area_central, eg.bastidor, eg.
  • Inner Unique: true
  • Hash Cond: (eg.codigo_entidade = dei.codigo_entidade)
  • Buffers: shared hit=109362
  • Worker 0: actual time=424.254..1182.494 rows=844424 loops=1
  • Buffers: shared hit=36454
  • Worker 1: actual time=425.383..1348.439 rows=844424 loops=1
  • Buffers: shared hit=36454
17. 113.158 113.158 ↑ 1.2 844,424 3

Seq Scan on agorangmanager.elementos_geridos eg (cost=0.00..38,200.93 rows=988,293 width=121) (actual time=0.036..113.158 rows=844,424 loops=3)

  • Output: eg.codigo_entidade, eg.id_dominio_gerido, eg.id_area_central, eg.id_modelo_equipamento, eg.nome, eg.data_instalacao, eg.localizacao, eg.versao, eg.numero_serie, eg.versao_firm
  • Buffers: shared hit=84954
  • Worker 0: actual time=0.048..111.100 rows=844424 loops=1
  • Buffers: shared hit=28318
  • Worker 1: actual time=0.044..133.405 rows=844424 loops=1
  • Buffers: shared hit=28318
18. 250.514 403.073 ↑ 1.0 844,370 3

Hash (cost=16,580.32..16,580.32 rows=844,432 width=31) (actual time=403.073..403.073 rows=844,370 loops=3)

  • Output: dei.caminho, dei.end_multiponto, dei.codigo_entidade
  • Buckets: 1048576 Batches: 1 Memory Usage: 61330kB
  • Buffers: shared hit=24408
  • Worker 0: actual time=418.839..418.839 rows=844370 loops=1
  • Buffers: shared hit=8136
  • Worker 1: actual time=420.094..420.094 rows=844370 loops=1
  • Buffers: shared hit=8136
19. 152.559 152.559 ↑ 1.0 844,370 3

Seq Scan on agorangmanager.dados_equip_inserido dei (cost=0.00..16,580.32 rows=844,432 width=31) (actual time=0.028..152.559 rows=844,370 loops=3)

  • Output: dei.caminho, dei.end_multiponto, dei.codigo_entidade
  • Buffers: shared hit=24408
  • Worker 0: actual time=0.042..157.583 rows=844370 loops=1
  • Buffers: shared hit=8136
  • Worker 1: actual time=0.032..166.443 rows=844370 loops=1
  • Buffers: shared hit=8136
20. 312.253 532.157 ↑ 1.0 844,425 3

Hash (cost=19,969.50..19,969.50 rows=844,450 width=40) (actual time=532.157..532.157 rows=844,425 loops=3)

  • Output: ieg.tipo_entidade, ieg.object_id, ieg.manager_code, ieg.codigo_entidade
  • Buckets: 1048576 Batches: 1 Memory Usage: 71245kB
  • Buffers: shared hit=34575
  • Worker 0: actual time=736.142..736.142 rows=844425 loops=1
  • Buffers: shared hit=11525
  • Worker 1: actual time=454.859..454.859 rows=844425 loops=1
  • Buffers: shared hit=11525
21. 219.904 219.904 ↑ 1.0 844,425 3

Seq Scan on agorangmanager.ids_elementos_geridos ieg (cost=0.00..19,969.50 rows=844,450 width=40) (actual time=0.041..219.904 rows=844,425 loops=3)

  • Output: ieg.tipo_entidade, ieg.object_id, ieg.manager_code, ieg.codigo_entidade
  • Buffers: shared hit=34575
  • Worker 0: actual time=0.050..319.244 rows=844425 loops=1
  • Buffers: shared hit=11525
  • Worker 1: actual time=0.060..189.833 rows=844425 loops=1
  • Buffers: shared hit=11525
Planning time : 4.678 ms
Execution time : 14,049.077 ms