explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 1Wui

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

Index Scan using i_docdeu_estado_codcob on docdeu (cost=0.42..2,802.26 rows=2,405 width=3,460) (actual time=0.267..1,434.651 rows=18 loops=1)

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