explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 63ZU

Settings
# exclusive inclusive rows x rows loops node
1. 0.648 1.239 ↓ 51.0 51 1

HashAggregate (cost=13,010.99..13,011.00 rows=1 width=8) (actual time=1.221..1.239 rows=51 loops=1)

  • Group Key: attendance_date
2. 0.454 0.591 ↑ 3.8 1,503 1

Bitmap Heap Scan on student_attendance satt (cost=141.23..12,982.35 rows=5,727 width=8) (actual time=0.155..0.591 rows=1,503 loops=1)

  • Recheck Cond: (school_classes_id = ANY ('{652,970}'::integer[]))
  • Heap Blocks: exact=78
3. 0.137 0.137 ↑ 3.8 1,503 1

Bitmap Index Scan on uk_single_student_attendanceLogic (cost=0.00..139.80 rows=5,727 width=0) (actual time=0.137..0.137 rows=1,503 loops=1)

  • Index Cond: (school_classes_id = ANY ('{652,970}'::integer[]))