explain.depesz.com

PostgreSQL's explain analyze made readable

Result: tOlA

Settings
# exclusive inclusive rows x rows loops node
1. 0.079 0.296 ↓ 4.0 4 1

HashAggregate (cost=286.93..286.94 rows=1 width=156) (actual time=0.295..0.296 rows=4 loops=1)

  • Group Key: mensaje
2. 0.217 0.217 ↑ 1.1 144 1

Index Scan using sync_sippau2_ix_01 on sync_sippau2_update (cost=0.42..286.16 rows=153 width=156) (actual time=0.021..0.217 rows=144 loops=1)

  • Index Cond: ((estado)::text = 'ERROR'::text)