explain.depesz.com

PostgreSQL's explain analyze made readable

Result: oCyf

Settings
# exclusive inclusive rows x rows loops node
1. 0.002 0.057 ↑ 1.0 1 1

Limit (cost=10.74..10.74 rows=1 width=12) (actual time=0.056..0.057 rows=1 loops=1)

  • Output: (max((dt_atualizacao)::timestamp without time zone)), id_processo_evento
  • Buffers: shared hit=9
2. 0.013 0.055 ↑ 6.0 1 1

Sort (cost=10.74..10.76 rows=6 width=12) (actual time=0.055..0.055 rows=1 loops=1)

  • Output: (max((dt_atualizacao)::timestamp without time zone)), id_processo_evento
  • Sort Key: (max((tb_processo_evento.dt_atualizacao)::timestamp without time zone)) DESC
  • Sort Method: top-N heapsort Memory: 25kB
  • Buffers: shared hit=9
3. 0.004 0.042 ↑ 1.0 6 1

GroupAggregate (cost=10.61..10.71 rows=6 width=12) (actual time=0.040..0.042 rows=6 loops=1)

  • Output: max((dt_atualizacao)::timestamp without time zone), id_processo_evento
  • Group Key: tb_processo_evento.id_processo_evento
  • Buffers: shared hit=9
4. 0.007 0.038 ↑ 1.0 6 1

Sort (cost=10.61..10.62 rows=6 width=12) (actual time=0.038..0.038 rows=6 loops=1)

  • Output: id_processo_evento, dt_atualizacao
  • Sort Key: tb_processo_evento.id_processo_evento
  • Sort Method: quicksort Memory: 25kB
  • Buffers: shared hit=9
5. 0.031 0.031 ↑ 1.0 6 1

Index Scan using tb_processo_evento_in14 on pje.tb_processo_evento (cost=0.42..10.53 rows=6 width=12) (actual time=0.024..0.031 rows=6 loops=1)

  • Output: id_processo_evento, dt_atualizacao
  • Index Cond: ((tb_processo_evento.id_processo)::integer = 27)
  • Buffers: shared hit=9
Planning time : 0.198 ms
Execution time : 0.080 ms