explain.depesz.com

PostgreSQL's explain analyze made readable

Result: F6Gg

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

Limit (cost=14,203.14..14,203.17 rows=15 width=11) (actual rows= loops=)

2. 0.000 0.000 ↓ 0.0

Sort (cost=14,203.14..14,203.24 rows=42 width=11) (actual rows= loops=)

  • Sort Key: clid
3. 0.000 0.000 ↓ 0.0

HashAggregate (cost=14,201.68..14,202.10 rows=42 width=11) (actual rows= loops=)

  • Group Key: clid
4. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on vc_cdrlog_2017 c (cost=139.64..13,972.19 rows=6,557 width=11) (actual rows= loops=)

  • Recheck Cond: ((date(calldate) >= '2017-05-19'::date) AND (date(calldate) <= '2017-07-19'::date))
5. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on event_creation_time_date_idx (cost=0.00..138.00 rows=6,557 width=0) (actual rows= loops=)

  • Index Cond: ((date(calldate) >= '2017-05-19'::date) AND (date(calldate) <= '2017-07-19'::date))