explain.depesz.com

PostgreSQL's explain analyze made readable

Result: oacY

Settings

Optimization(s) for this plan:

# exclusive inclusive rows x rows loops node
1. 83.123 512.374 ↑ 1.0 80,111 1

Unique (cost=47,393.21..63,415.41 rows=80,111 width=879) (actual time=400.778..512.374 rows=80,111 loops=1)

2. 146.821 429.251 ↑ 1.0 80,111 1

Sort (cost=47,393.21..47,593.49 rows=80,111 width=879) (actual time=400.776..429.251 rows=80,111 loops=1)

  • Sort Key: usuario0_.id, cargousuar1_.id, funcao2_.id, centrocust3_.id, usuario4_.id, usuario0_.last_update, usuario0_.nick_name, usuario0_.id_position, usuario0_.chefia_imediata, usuario0_.codigo_desbloqueio_impressao, usuario0_.cpf_cnpj, usuario0_.termination_date, usuario0_.data_exercicio, usuario0_.data_posse, usuario0_.email, usuario0_.address, usuario0_.fatura_modo_classico, usuario0_.id_function, usuario0_.imagem_perfil, usuario0_.ldap, usuario0_.login, usuario0_.id_cc_operation, usuario0_.id_cc_gratification, usuario0_.id_cc_appointment, usuario0_.matricula, usuario0_.name, usuario0_.extension_number, usuario0_.extension_number_pes, usuario0_.initial_page, usuario0_.password, usuario0_.senha_expirada, usuario0_.status, cargousuar1_.last_update, cargousuar1_.cod_pes, cargousuar1_.description, cargousuar1_.tem_limit, cargousuar1_.no_limit, funcao2_.last_update, funcao2_.cod_pes, funcao2_.description, funcao2_.no_limit, centrocust3_.last_update, centrocust3_.id_father_cost_center, centrocust3_.final_structural_code, centrocust3_.initial_structural_code, centrocust3_.cod_pes, centrocust3_.description, centrocust3_.id_manager_cost_center, centrocust3_.id_sub_manager_cost_center, centrocust3_.name, centrocust3_.seq_hierarchical, centrocust3_.status, usuario4_.last_update, usuario4_.nick_name, usuario4_.id_position, usuario4_.chefia_imediata, usuario4_.codigo_desbloqueio_impressao, usuario4_.cpf_cnpj, usuario4_.termination_date, usuario4_.data_exercicio, usuario4_.data_posse, usuario4_.email, usuario4_.address, usuario4_.fatura_modo_classico, usuario4_.id_function, usuario4_.imagem_perfil, usuario4_.ldap, usuario4_.login, usuario4_.id_cc_operation, usuario4_.id_cc_gratification, usuario4_.id_cc_appointment, usuario4_.matricula, usuario4_.name, usuario4_.extension_number, usuario4_.extension_number_pes, usuario4_.initial_page, usuario4_.password, usuario4_.senha_expirada, usuario4_.status
  • Sort Method: external merge Disk: 29,264kB
3. 45.362 282.430 ↑ 1.0 80,111 1

Hash Left Join (cost=6,888.68..22,744.24 rows=80,111 width=879) (actual time=75.507..282.430 rows=80,111 loops=1)

  • Hash Cond: (usuario0_.id_cc_operation = centrocust3_.id)
4. 32.590 235.818 ↑ 1.0 80,111 1

Hash Left Join (cost=6,798.10..21,357.00 rows=80,111 width=797) (actual time=74.248..235.818 rows=80,111 loops=1)

  • Hash Cond: (usuario0_.id_function = funcao2_.id)
5. 32.141 203.222 ↑ 1.0 80,111 1

Hash Left Join (cost=6,796.90..20,254.30 rows=80,111 width=562) (actual time=74.234..203.222 rows=80,111 loops=1)

  • Hash Cond: (usuario0_.id_position = cargousuar1_.id)
6. 63.704 171.018 ↑ 1.0 80,111 1

Hash Left Join (cost=6,791.50..19,149.89 rows=80,111 width=526) (actual time=74.148..171.018 rows=80,111 loops=1)

  • Hash Cond: (usuario0_.chefia_imediata = usuario4_.id)
7. 33.191 33.191 ↑ 1.0 80,111 1

Seq Scan on tem_user usuario0_ (cost=0.00..2,973.11 rows=80,111 width=263) (actual time=0.007..33.191 rows=80,111 loops=1)

8. 37.978 74.123 ↑ 1.0 80,111 1

Hash (cost=2,973.11..2,973.11 rows=80,111 width=263) (actual time=74.123..74.123 rows=80,111 loops=1)

  • Buckets: 2,048 Batches: 8 Memory Usage: 2,170kB
9. 36.145 36.145 ↑ 1.0 80,111 1

Seq Scan on tem_user usuario4_ (cost=0.00..2,973.11 rows=80,111 width=263) (actual time=0.001..36.145 rows=80,111 loops=1)

10. 0.023 0.063 ↑ 1.0 151 1

Hash (cost=3.51..3.51 rows=151 width=36) (actual time=0.063..0.063 rows=151 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 11kB
11. 0.040 0.040 ↑ 1.0 151 1

Seq Scan on tem_position cargousuar1_ (cost=0.00..3.51 rows=151 width=36) (actual time=0.003..0.040 rows=151 loops=1)

12. 0.004 0.006 ↑ 1.0 9 1

Hash (cost=1.09..1.09 rows=9 width=235) (actual time=0.006..0.006 rows=9 loops=1)

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

Seq Scan on tem_function funcao2_ (cost=0.00..1.09 rows=9 width=235) (actual time=0.001..0.002 rows=9 loops=1)

14. 0.641 1.250 ↑ 1.0 2,737 1

Hash (cost=56.37..56.37 rows=2,737 width=82) (actual time=1.250..1.250 rows=2,737 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 214kB
15. 0.609 0.609 ↑ 1.0 2,737 1

Seq Scan on tem_cost_center centrocust3_ (cost=0.00..56.37 rows=2,737 width=82) (actual time=0.004..0.609 rows=2,737 loops=1)