explain.depesz.com

PostgreSQL's explain analyze made readable

Result: PUK3

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

Index Scan using i_docdeu_nit_estado on docdeu (cost=0.42..18,563.25 rows=2,405 width=3,460) (actual time=221.447..3,081.435 rows=18 loops=1)

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