explain.depesz.com

PostgreSQL's explain analyze made readable

Result: zV0V

Settings
# exclusive inclusive rows x rows loops node
1. 31,534.189 31,534.189 ↓ 1.1 1,654,154 1

Index Scan using _suscrip_activa on suscripciones subscripti0_ (cost=0.44..487,600.32 rows=1,489,082 width=4) (actual time=3.009..31,534.189 rows=1,654,154 loops=1)

  • Index Cond: (activa = true)
  • Filter: (activa AND (operador_id = 19))
  • Rows Removed by Filter: 44379
Planning time : 0.200 ms
Execution time : 31,676.157 ms