explain.depesz.com

PostgreSQL's explain analyze made readable

Result: YWfU

Settings

Optimization(s) for this plan:

# exclusive inclusive rows x rows loops node
1. 4.640 4.640 ↑ 1.0 1,829 1

Bitmap Heap Scan on calendario cal (cost=622.68..2,222.40 rows=1,859 width=341) (actual time=3.742..4.640 rows=1,829 loops=1)

  • Recheck Cond: (((tienda_id)::text = '6042'::text) AND (dia >= '2019-01-01'::date) AND (dia <= '2019-01-31'::date))
  • Heap Blocks: exact=88
  • Buffers: shared hit=271
  • -> Bitmap Index Scan on pk_calendario (cost=0.00..622.22 rows=1859 width=0) (actual time=3.701..3.701 rows=1829 loops=1
  • Index Cond: (((tienda_id)::text = '6042'::text) AND (dia >= '2019-01-01'::date) AND (dia <= '2019-01-31'::date))
  • Buffers: shared hit=183