explain.depesz.com

PostgreSQL's explain analyze made readable

Result: dZQi : Optimization for: Optimization for: plan #ZSiL; plan #lB8k

Settings

Optimization path:

# exclusive inclusive rows x rows loops node
1. 0.001 0.031 ↑ 1.0 2 1

Limit (cost=4.37..4.44 rows=2 width=72) (actual time=0.029..0.031 rows=2 loops=1)

2. 0.007 0.030 ↑ 1.0 2 1

GroupAggregate (cost=4.37..4.44 rows=2 width=72) (actual time=0.028..0.030 rows=2 loops=1)

  • Group Key: teacher_id
3. 0.009 0.023 ↓ 1.5 3 1

Sort (cost=4.37..4.37 rows=2 width=40) (actual time=0.022..0.023 rows=3 loops=1)

  • Sort Key: teacher_id
  • Sort Method: quicksort Memory: 25kB
4. 0.009 0.014 ↓ 1.5 3 1

Bitmap Heap Scan on call_record_stat (cost=1.29..4.36 rows=2 width=40) (actual time=0.011..0.014 rows=3 loops=1)

  • Recheck Cond: ((stat_date >= '2020-09-03 00:55:01+00'::timestamp with time zone) AND (stat_date <= '2020-09-10 00:55:01+00'::timestamp with time zone))
  • Filter: (teacher_id = ANY ('{111903,112137}'::bigint[]))
  • Rows Removed by Filter: 2
  • Heap Blocks: exact=2
5. 0.005 0.005 ↓ 1.2 5 1

Bitmap Index Scan on call_record_stat_stat_date_idx (cost=0.00..1.29 rows=4 width=0) (actual time=0.005..0.005 rows=5 loops=1)

  • Index Cond: ((stat_date >= '2020-09-03 00:55:01+00'::timestamp with time zone) AND (stat_date <= '2020-09-10 00:55:01+00'::timestamp with time zone))
Planning time : 0.181 ms
Execution time : 0.069 ms