explain.depesz.com

PostgreSQL's explain analyze made readable

Result: hLCP

Settings
# exclusive inclusive rows x rows loops node
1. 51.684 3,021.438 ↓ 1.8 6,663 1

Bitmap Heap Scan on health_appointment_timeslots this_ (cost=215,711.03..354,315.72 rows=3,661 width=197) (actual time=2,974.935..3,021.438 rows=6,663 loops=1)

  • Recheck Cond: ((institution_id = 292::bigint) AND (from_time > '2019-01-09 07:39:56.064'::timestamp without time zone))
  • Filter: (is_available AND is_approved AND (NOT is_absent) AND (specialty_id = 203334::bigint) AND (((appointment_timeslot_type = 2::bigint) AND (institution_id = 292::bigint)) OR (appointment_timeslot_type = ANY ('{0,20}'::bigint[]))))
  • Rows Removed by Filter: 24170
  • Heap Blocks: exact=7178
2. 186.907 2,969.754 ↓ 0.0 0 1

BitmapAnd (cost=215,711.03..215,711.03 rows=38,139 width=0) (actual time=2,969.754..2,969.754 rows=0 loops=1)

3. 181.628 181.628 ↓ 1.0 613,766 1

Bitmap Index Scan on ix_health_appointment_timeslots_institution_id (cost=0.00..14,884.26 rows=589,293 width=0) (actual time=181.628..181.628 rows=613,766 loops=1)

  • Index Cond: (institution_id = 292::bigint)
4. 2,601.219 2,601.219 ↓ 1.0 8,471,285 1

Bitmap Index Scan on ix_health_appointment_timeslots_from_time (cost=0.00..200,824.68 rows=8,114,682 width=0) (actual time=2,601.219..2,601.219 rows=8,471,285 loops=1)

  • Index Cond: (from_time > '2019-01-09 07:39:56.064'::timestamp without time zone)