explain.depesz.com

PostgreSQL's explain analyze made readable

Result: ebAd

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

Sort (cost=15.81..15.83 rows=9 width=73) (actual rows= loops=)

  • Sort Key: rdd."DATEON" DESC
2. 0.000 0.000 ↓ 0.0

Append (cost=2.14..15.44 rows=9 width=73) (actual rows= loops=)

3. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on "REG_DATA_DAYS_2020" rdd (cost=2.14..15.40 rows=9 width=73) (actual rows= loops=)

  • Recheck Cond: (("COUNTER" = '41389f25-3888-4061-adcb-ed25052baca0'::uuid) AND ("DATEON" >= '2020-01-13'::date) AND ("DATEON" <= '2020-01-24'::date))
  • Filter: ("IS_ACTIVE" = 1)
4. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on "REG_DATA_DAYS_2020_COUNTER_LIC_SCHET_DATEON_idx" (cost=0.00..2.14 rows=9 width=0) (actual rows= loops=)

  • Index Cond: (("COUNTER" = '41389f25-3888-4061-adcb-ed25052baca0'::uuid) AND ("DATEON" >= '2020-01-13'::date) AND ("DATEON" <= '2020-01-24'::date))