explain.depesz.com

PostgreSQL's explain analyze made readable

Result: Uase

Settings
# exclusive inclusive rows x rows loops node
1. 769.594 769.594 ↑ 133.6 18 1

Index Scan using docdeu_estado_idx on docdeu (cost=0.42..2,704.74 rows=2,405 width=3,036) (actual time=87.238..769.594 rows=18 loops=1)

  • Index Cond: (estado = 'A'::bpchar)
  • Filter: (meses_transcurridos_neg IS NOT NULL)
  • Rows Removed by Filter: 356692
Planning time : 0.249 ms
Execution time : 769.663 ms