explain.depesz.com

PostgreSQL's explain analyze made readable

Result: P5U

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

Bitmap Heap Scan on calendario cal (cost=622.68..2,222.40 rows=1,859 width=341) (actual time=5.796..7.004 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
  • -> Bitmap Index Scan on pk_calendario (cost=0.00..622.22 rows=1859 width=0) (actual time=5.700..5.700 rows=1829 loops=1
  • Index Cond: (((tienda_id)::text = '6042'::text) AND (dia >= '2019-01-01'::date) AND (dia <= '2019-01-31'::date))
Planning time : 0.134 ms
Execution time : 7.167 ms