explain.depesz.com

PostgreSQL's explain analyze made readable

Result: h25q

Settings
# exclusive inclusive rows x rows loops node
1. 0.003 0.180 ↑ 1.0 7 1

Limit (cost=2.45..2.69 rows=7 width=73) (actual time=0.159..0.180 rows=7 loops=1)

2. 0.066 0.177 ↑ 1.0 7 1

WindowAgg (cost=2.45..2.69 rows=7 width=73) (actual time=0.158..0.177 rows=7 loops=1)

3. 0.055 0.111 ↑ 1.0 7 1

Sort (cost=2.45..2.47 rows=7 width=46) (actual time=0.110..0.111 rows=7 loops=1)

  • Sort Key: dta_sir_mes.egs_cod, dta_sir_mes.art_cod, dta_sir_mes.gyt_cod, dta_sir_mes.sho_cod, dta_sir_mes.dpy_hdk DESC, dta_sir_mes.dpy_no DESC, dta_sir_mes.dpy_eda DESC, dta_sir_mes.gyo_no DESC
  • Sort Method: quicksort Memory: 17kB
4. 0.056 0.056 ↑ 1.0 7 1

Seq Scan on dta_sir_mes (cost=0.00..2.35 rows=7 width=46) (actual time=0.042..0.056 rows=7 loops=1)

  • Filter: ((dpy_hdk > '2019-01-31'::date) AND (dpy_hdk < '2019-03-01'::date) AND ((dpy_kbn)::text = ANY ('{01,11}'::text[])))
  • Rows Removed by Filter: 13
Planning time : 0.739 ms
Execution time : 0.243 ms