explain.depesz.com

PostgreSQL's explain analyze made readable

Result: ESEf

Settings
# exclusive inclusive rows x rows loops node
1. 0.000 0.000 ↓ 0.0

Limit (cost=2.36..2.40 rows=1 width=210) (actual rows= loops=)

2. 0.000 0.000 ↓ 0.0

WindowAgg (cost=2.36..2.40 rows=1 width=210) (actual rows= loops=)

3. 0.000 0.000 ↓ 0.0

Sort (cost=2.36..2.36 rows=1 width=194) (actual rows= loops=)

  • Sort Key: egs_cod, art_cod, gyt_cod, sho_cod, dpy_hdk DESC, dpy_no DESC, dpy_eda DESC, gyo_no DESC
4. 0.000 0.000 ↓ 0.0

Seq Scan on dta_sir_mes (cost=0.00..2.35 rows=1 width=194) (actual rows= loops=)

  • Filter: ((dpy_hdk > '2019-01-31'::date) AND (dpy_hdk < '2019-03-01'::date) AND ((dpy_kbn)::text = ANY ('{01,11}'::text[])))