explain.depesz.com

PostgreSQL's explain analyze made readable

Result: xmyl

Settings
# exclusive inclusive rows x rows loops node
1. 1,634.881 14,684.207 ↑ 1.2 5,001,627 1

Gather (cost=553,218.73..809,238.52 rows=5,853,847 width=347) (actual time=8,558.666..14,684.207 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: 3
  • Workers Launched: 3
  • Buffers: shared hit=213497
2. 971.435 13,049.326 ↑ 1.5 1,250,407 4

Hash Join (cost=552,718.73..730,372.51 rows=1,888,338 width=347) (actual time=9,187.712..13,049.326 rows=1,250,407 loops=4)

  • 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=870828
  • Worker 0: actual time=9394.766..13669.036 rows=1395720 loops=1
  • Buffers: shared hit=219216
  • Worker 1: actual time=9394.791..13672.357 rows=1391395 loops=1
  • Buffers: shared hit=219166
  • Worker 2: actual time=9403.604..13628.879 rows=1372949 loops=1
  • Buffers: shared hit=218949
3. 694.475 11,621.486 ↑ 1.3 1,250,407 4

Hash Join (cost=522,193.60..670,035.33 rows=1,613,495 width=322) (actual time=8,725.637..11,621.486 rows=1,250,407 loops=4)

  • 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=824479
  • Worker 0: actual time=8920.478..12127.684 rows=1395720 loops=1
  • Buffers: shared hit=207608
  • Worker 1: actual time=8922.055..12134.884 rows=1391395 loops=1
  • Buffers: shared hit=207558
  • Worker 2: actual time=8929.199..12092.384 rows=1372949 loops=1
  • Buffers: shared hit=207341
4. 531.082 9,251.565 ↑ 1.3 1,250,407 4

Hash Join (cost=432,026.10..557,682.28 rows=1,613,495 width=178) (actual time=7,044.833..9,251.565 rows=1,250,407 loops=4)

  • 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=678663
  • Worker 0: actual time=7198.359..9640.333 rows=1395720 loops=1
  • Buffers: shared hit=171154
  • Worker 1: actual time=7207.497..9654.765 rows=1391395 loops=1
  • Buffers: shared hit=171104
  • Worker 2: actual time=7215.173..9622.898 rows=1372949 loops=1
  • Buffers: shared hit=170887
5. 793.202 7,397.903 ↑ 1.3 1,250,407 4

Hash Join (cost=362,731.07..466,200.31 rows=1,613,595 width=100) (actual time=5,717.165..7,397.903 rows=1,250,407 loops=4)

  • Output: ids_portos.codigo_entidade, ids_portos.id_externo, ids_portos.tipo_entidade, ids_portos.object_id, ids_portos.codigo_placa, recursos_portos.tipo_interface, portos.estado_administrat
  • Inner Unique: true
  • Hash Cond: (recursos_portos.codigo_entidade = ids_portos.codigo_entidade)
  • Buffers: shared hit=596367
  • Worker 0: actual time=5856.354..7715.212 rows=1395720 loops=1
  • Buffers: shared hit=150580
  • Worker 1: actual time=5857.471..7722.391 rows=1391395 loops=1
  • Buffers: shared hit=150530
  • Worker 2: actual time=5866.178..7696.346 rows=1372949 loops=1
  • Buffers: shared hit=150313
6. 782.204 3,354.049 ↑ 1.3 1,250,407 4

Hash Join (cost=171,187.24..254,284.85 rows=1,613,595 width=29) (actual time=2,427.116..3,354.049 rows=1,250,407 loops=4)

  • Output: recursos_portos.tipo_interface, recursos_portos.codigo_entidade, portos.estado_administrativo, portos.nome_porto, portos.descricao, portos.codigo_entidade
  • Inner Unique: true
  • Hash Cond: (portos.codigo_entidade = recursos_portos.codigo_entidade)
  • Buffers: shared hit=280467
  • Worker 0: actual time=2495.881..3530.260 rows=1395720 loops=1
  • Buffers: shared hit=71605
  • Worker 1: actual time=2503.866..3537.934 rows=1391395 loops=1
  • Buffers: shared hit=71555
  • Worker 2: actual time=2463.324..3478.488 rows=1372949 loops=1
  • Buffers: shared hit=71338
7. 183.272 183.272 ↑ 1.3 1,250,407 4

Parallel Seq Scan on agorangmanager.portos (cost=0.00..62,347.07 rows=1,643,607 width=19) (actual time=0.006..183.272 rows=1,250,407 loops=4)

  • Output: portos.codigo_entidade, portos.nome_porto, portos.estado_administrativo, portos.id_dominio_sca, portos.descricao
  • Buffers: shared hit=45911
  • Worker 0: actual time=0.006..210.137 rows=1395720 loops=1
  • Buffers: shared hit=12966
  • Worker 1: actual time=0.008..211.431 rows=1391395 loops=1
  • Buffers: shared hit=12916
  • Worker 2: actual time=0.007..208.749 rows=1372949 loops=1
  • Buffers: shared hit=12699
8. 1,489.210 2,388.573 ↑ 1.0 5,001,627 4

Hash (cost=108,660.44..108,660.44 rows=5,002,144 width=10) (actual time=2,388.573..2,388.573 rows=5,001,627 loops=4)

  • Output: recursos_portos.tipo_interface, recursos_portos.codigo_entidade
  • Buckets: 8388608 Batches: 1 Memory Usage: 299988kB
  • Buffers: shared hit=234556
  • Worker 0: actual time=2457.073..2457.073 rows=5001627 loops=1
  • Buffers: shared hit=58639
  • Worker 1: actual time=2465.076..2465.076 rows=5001627 loops=1
  • Buffers: shared hit=58639
  • Worker 2: actual time=2425.398..2425.398 rows=5001627 loops=1
  • Buffers: shared hit=58639
9. 899.363 899.363 ↑ 1.0 5,001,627 4

Seq Scan on agorangmanager.recursos_portos (cost=0.00..108,660.44 rows=5,002,144 width=10) (actual time=0.035..899.363 rows=5,001,627 loops=4)

  • Output: recursos_portos.tipo_interface, recursos_portos.codigo_entidade
  • Buffers: shared hit=234556
  • Worker 0: actual time=0.036..962.299 rows=5001627 loops=1
  • Buffers: shared hit=58639
  • Worker 1: actual time=0.047..960.644 rows=5001627 loops=1
  • Buffers: shared hit=58639
  • Worker 2: actual time=0.035..932.081 rows=5001627 loops=1
  • Buffers: shared hit=58639
10. 2,061.010 3,250.652 ↑ 1.0 5,001,628 4

Hash (cost=129,005.59..129,005.59 rows=5,003,059 width=87) (actual time=3,250.652..3,250.652 rows=5,001,628 loops=4)

  • Output: ids_portos.codigo_entidade, ids_portos.id_externo, ids_portos.tipo_entidade, ids_portos.object_id, ids_portos.codigo_placa
  • Buckets: 8388608 Batches: 1 Memory Usage: 674509kB
  • Buffers: shared hit=315900
  • Worker 0: actual time=3320.650..3320.650 rows=5001628 loops=1
  • Buffers: shared hit=78975
  • Worker 1: actual time=3314.127..3314.127 rows=5001628 loops=1
  • Buffers: shared hit=78975
  • Worker 2: actual time=3363.266..3363.266 rows=5001628 loops=1
  • Buffers: shared hit=78975
11. 1,189.642 1,189.642 ↑ 1.0 5,001,628 4

Seq Scan on agorangmanager.ids_portos (cost=0.00..129,005.59 rows=5,003,059 width=87) (actual time=0.038..1,189.642 rows=5,001,628 loops=4)

  • Output: ids_portos.codigo_entidade, ids_portos.id_externo, ids_portos.tipo_entidade, ids_portos.object_id, ids_portos.codigo_placa
  • Buffers: shared hit=315900
  • Worker 0: actual time=0.033..1272.305 rows=5001628 loops=1
  • Buffers: shared hit=78975
  • Worker 1: actual time=0.052..1259.477 rows=5001628 loops=1
  • Buffers: shared hit=78975
  • Worker 2: actual time=0.053..1275.778 rows=5001628 loops=1
  • Buffers: shared hit=78975
12. 367.615 1,322.580 ↑ 1.0 845,442 4

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

  • 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=82296
  • Worker 0: actual time=1336.989..1336.989 rows=845442 loops=1
  • Buffers: shared hit=20574
  • Worker 1: actual time=1345.002..1345.002 rows=845442 loops=1
  • Buffers: shared hit=20574
  • Worker 2: actual time=1343.946..1343.946 rows=845442 loops=1
  • Buffers: shared hit=20574
13. 426.896 954.965 ↑ 1.0 845,442 4

Hash Join (cost=26,270.94..58,726.73 rows=845,464 width=94) (actual time=396.971..954.965 rows=845,442 loops=4)

  • 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=82296
  • Worker 0: actual time=397.472..965.930 rows=845442 loops=1
  • Buffers: shared hit=20574
  • Worker 1: actual time=406.621..976.867 rows=845442 loops=1
  • Buffers: shared hit=20574
  • Worker 2: actual time=405.565..974.589 rows=845442 loops=1
  • Buffers: shared hit=20574
14. 136.209 136.209 ↑ 1.0 845,443 4

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

  • Output: idp.codigo_entidade, idp.tipo_entidade, idp.object_id, idp.codigo_elem_gerido, idp.id_externo
  • Buffers: shared hit=53304
  • Worker 0: actual time=0.035..144.253 rows=845443 loops=1
  • Buffers: shared hit=13326
  • Worker 1: actual time=0.054..148.237 rows=845443 loops=1
  • Buffers: shared hit=13326
  • Worker 2: actual time=0.040..149.539 rows=845443 loops=1
  • Buffers: shared hit=13326
15. 239.419 391.860 ↑ 1.0 845,442 4

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

  • Output: placas.versao_firmware, placas.estado_administrativo, placas.codigo_entidade
  • Buckets: 1048576 Batches: 1 Memory Usage: 47837kB
  • Buffers: shared hit=28992
  • Worker 0: actual time=392.501..392.501 rows=845442 loops=1
  • Buffers: shared hit=7248
  • Worker 1: actual time=401.524..401.524 rows=845442 loops=1
  • Buffers: shared hit=7248
  • Worker 2: actual time=400.450..400.450 rows=845442 loops=1
  • Buffers: shared hit=7248
16. 152.441 152.441 ↑ 1.0 845,442 4

Seq Scan on agorangmanager.placas (cost=0.00..15,702.64 rows=845,464 width=11) (actual time=0.034..152.441 rows=845,442 loops=4)

  • Output: placas.versao_firmware, placas.estado_administrativo, placas.codigo_entidade
  • Buffers: shared hit=28992
  • Worker 0: actual time=0.035..151.141 rows=845442 loops=1
  • Buffers: shared hit=7248
  • Worker 1: actual time=0.049..160.546 rows=845442 loops=1
  • Buffers: shared hit=7248
  • Worker 2: actual time=0.041..160.424 rows=845442 loops=1
  • Buffers: shared hit=7248
17. 513.765 1,675.446 ↑ 1.2 844,424 4

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

  • 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=145816
  • Worker 0: actual time=1716.694..1716.694 rows=844424 loops=1
  • Buffers: shared hit=36454
  • Worker 1: actual time=1709.200..1709.200 rows=844424 loops=1
  • Buffers: shared hit=36454
  • Worker 2: actual time=1708.655..1708.655 rows=844424 loops=1
  • Buffers: shared hit=36454
18. 642.483 1,161.681 ↑ 1.2 844,424 4

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

  • 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=145816
  • Worker 0: actual time=417.145..1199.194 rows=844424 loops=1
  • Buffers: shared hit=36454
  • Worker 1: actual time=418.798..1197.420 rows=844424 loops=1
  • Buffers: shared hit=36454
  • Worker 2: actual time=416.104..1175.488 rows=844424 loops=1
  • Buffers: shared hit=36454
19. 113.133 113.133 ↑ 1.2 844,424 4

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

  • 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=113272
  • Worker 0: actual time=0.039..124.589 rows=844424 loops=1
  • Buffers: shared hit=28318
  • Worker 1: actual time=0.049..114.515 rows=844424 loops=1
  • Buffers: shared hit=28318
  • Worker 2: actual time=0.043..118.392 rows=844424 loops=1
  • Buffers: shared hit=28318
20. 255.634 406.065 ↑ 1.0 844,370 4

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

  • Output: dei.caminho, dei.end_multiponto, dei.codigo_entidade
  • Buckets: 1048576 Batches: 1 Memory Usage: 61330kB
  • Buffers: shared hit=32544
  • Worker 0: actual time=411.758..411.758 rows=844370 loops=1
  • Buffers: shared hit=8136
  • Worker 1: actual time=413.363..413.363 rows=844370 loops=1
  • Buffers: shared hit=8136
  • Worker 2: actual time=410.714..410.714 rows=844370 loops=1
  • Buffers: shared hit=8136
21. 150.431 150.431 ↑ 1.0 844,370 4

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

  • Output: dei.caminho, dei.end_multiponto, dei.codigo_entidade
  • Buffers: shared hit=32544
  • Worker 0: actual time=0.027..154.154 rows=844370 loops=1
  • Buffers: shared hit=8136
  • Worker 1: actual time=0.029..157.007 rows=844370 loops=1
  • Buffers: shared hit=8136
  • Worker 2: actual time=0.029..156.718 rows=844370 loops=1
  • Buffers: shared hit=8136
22. 275.297 456.405 ↑ 1.0 844,425 4

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

  • Output: ieg.tipo_entidade, ieg.object_id, ieg.manager_code, ieg.codigo_entidade
  • Buckets: 1048576 Batches: 1 Memory Usage: 71245kB
  • Buffers: shared hit=46100
  • Worker 0: actual time=468.597..468.597 rows=844425 loops=1
  • Buffers: shared hit=11525
  • Worker 1: actual time=466.909..466.909 rows=844425 loops=1
  • Buffers: shared hit=11525
  • Worker 2: actual time=468.647..468.647 rows=844425 loops=1
  • Buffers: shared hit=11525
23. 181.108 181.108 ↑ 1.0 844,425 4

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

  • Output: ieg.tipo_entidade, ieg.object_id, ieg.manager_code, ieg.codigo_entidade
  • Buffers: shared hit=46100
  • Worker 0: actual time=0.043..192.361 rows=844425 loops=1
  • Buffers: shared hit=11525
  • Worker 1: actual time=0.040..190.411 rows=844425 loops=1
  • Buffers: shared hit=11525
  • Worker 2: actual time=0.060..192.072 rows=844425 loops=1
  • Buffers: shared hit=11525
Planning time : 4.639 ms
Execution time : 15,169.839 ms