explain.depesz.com

PostgreSQL's explain analyze made readable

Result: UDZJ

Settings
# exclusive inclusive rows x rows loops node
1. 827.445 827.445 ↓ 147.5 356,710 1

Index Scan using docdeu_estado_idx on docdeu (cost=0.42..2,704.74 rows=2,418 width=3,036) (actual time=0.058..827.445 rows=356,710 loops=1)

  • Index Cond: (estado = 'A'::bpchar)
Planning time : 0.280 ms
Execution time : 842.800 ms