explain.depesz.com

PostgreSQL's explain analyze made readable

Result: ByL9

Settings
# exclusive inclusive rows x rows loops node
1. 2.996 13.566 ↓ 7.2 172 1

HashAggregate (cost=217.60..217.84 rows=24 width=99) (actual time=12.503..13.566 rows=172 loops=1)

  • Group Key: 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. 3.306 10.570 ↓ 10.6 255 1

Hash Join (cost=59.01..216.52 rows=24 width=99) (actual time=5.311..10.570 rows=255 loops=1)

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

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

  • Filter: ((men_cod_remetente = 22856) OR (men_cod_destinatario = 22856))
  • Rows Removed by Filter: 3168
4. 1.322 4.795 ↓ 1.0 198 1

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

  • Buckets: 1024 Batches: 1 Memory Usage: 38kB
5. 3.473 3.473 ↓ 1.0 198 1

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

  • Filter: (cod_ger_entidade = 434)
  • Rows Removed by Filter: 1521
Planning time : 1.562 ms
Execution time : 14.653 ms