explain.depesz.com

PostgreSQL's explain analyze made readable

Result: fBpu

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

Index Scan using docdeu_estado_idx on docdeu (cost=0.42..2,765.19 rows=2,418 width=3,460) (actual time=0.084..1,455.747 rows=356,710 loops=1)

  • Index Cond: (estado = 'A'::bpchar)
Planning time : 0.501 ms
Execution time : 1,476.870 ms