explain.depesz.com

PostgreSQL's explain analyze made readable

Result: LUc

Settings
# exclusive inclusive rows x rows loops node
1. 5.383 63,177.248 ↓ 7.2 172 1

HashAggregate (cost=223.66..229.90 rows=24 width=99) (actual time=63,176.134..63,177.248 rows=172 loops=1)

  • Group Key: atendimento.ate_func_date_atendimento_int(ass.ass_codigo, 22856), ass.ass_codigo, ass.ass_titulo, ass.ass_cod_destinatario, ass.ass_cod_remetente, ass.ass_data, ass.cod_ger_entidade, ass.cod_adm_empresa, ass.ass_responsavel, ass.cod_ger_unidade, ass.ass_setor, ass.ass_nivel_remetente, ass.ass_nivel_destinatario, ass.ass_uni_remetente, ass.ass_uni_destinatario, ass.ass_atr_remetente, ass.ass_atr_destinatario, ass.ass_ultima_update_remet, ass.ass_status
2. 63,164.724 63,171.865 ↓ 10.6 255 1

Hash Join (cost=59.01..222.52 rows=24 width=99) (actual time=260.122..63,171.865 rows=255 loops=1)

  • Hash Cond: (ate.cod_ate_assunto = ass.ass_codigo)
3. 3.572 3.572 ↓ 1.2 255 1

Seq Scan on ate_mensagem ate (cost=0.00..156.47 rows=213 width=4) (actual time=0.825..3.572 rows=255 loops=1)

  • Filter: ((men_cod_remetente = 22,856) OR (men_cod_destinatario = 22,856))
  • Rows Removed by Filter: 3,168
4. 1.661 3.569 ↓ 1.0 198 1

Hash (cost=56.61..56.61 rows=192 width=99) (actual time=3.569..3.569 rows=198 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 38kB
5. 1.908 1.908 ↓ 1.0 198 1

Seq Scan on ate_assunto ass (cost=0.00..56.61 rows=192 width=99) (actual time=0.191..1.908 rows=198 loops=1)

  • Filter: (cod_ger_entidade = 434)
  • Rows Removed by Filter: 1,521
Planning time : 0.431 ms
Execution time : 63,178.413 ms