explain.depesz.com

PostgreSQL's explain analyze made readable

Result: KYub : Optimization for: Test; plan #oxBV

Settings

Optimization path:

# exclusive inclusive rows x rows loops node
1. 0.024 0.024 ↓ 0.0 0 1

Seq Scan on t_cvg_entr_val_enrt (cost=0.00..2.62 rows=1 width=80) (actual time=0.024..0.024 rows=0 loops=1)

  • Filter: (('2020-01-08'::date >= eff_strt_dt) AND ('2020-01-08'::date <= eff_end_dt) AND (clnt_id = 34,567) AND (pl_typ_id = 20) AND (pl_id = 30) AND (enbld_flg = 'Y'::bpchar))
  • Rows Removed by Filter: 36
Planning time : 0.758 ms
Execution time : 0.078 ms