explain.depesz.com

PostgreSQL's explain analyze made readable

Result: Wx4y : Optimization for: plan #IsHI

Settings

Optimization path:

Optimization(s) for this plan:

# exclusive inclusive rows x rows loops node
1. 0.000 35.704 ↓ 4.7 7,605 1

Bitmap Heap Scan on polyclinic_availability_of_appointment_mat_master (cost=8,824.75..10,359.25 rows=1,626 width=117) (actual time=34.918..35.704 rows=7,605 loops=1)

  • Recheck Cond: ((rank_id = 1) AND (date = $1))
  • Heap Blocks: exact=198
2.          

Initplan (forBitmap Heap Scan)

3. 0.007 34.446 ↑ 1.0 1 1

Finalize Aggregate (cost=8,799.95..8,799.96 rows=1 width=4) (actual time=34.446..34.446 rows=1 loops=1)

4. 10.175 34.439 ↓ 1.5 3 1

Gather (cost=8,799.74..8,799.95 rows=2 width=4) (actual time=34.427..34.439 rows=3 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
5. 6.693 24.264 ↑ 1.0 1 3

Partial Aggregate (cost=7,799.74..7,799.75 rows=1 width=4) (actual time=24.264..24.264 rows=1 loops=3)

6. 17.571 17.571 ↑ 1.3 106,735 3

Parallel Seq Scan on polyclinic_availability_of_appointment_mat_master polyclinic_availability_of_appointment_mat_master_1 (cost=0.00..7,466.19 rows=133,419 width=4) (actual time=0.027..17.571 rows=106,735 loops=3)

7. 34.892 34.892 ↓ 4.7 7,605 1

Bitmap Index Scan on polyclinic_availability_of_appointme_rank_id_date_filial_id_idx (cost=0.00..24.38 rows=1,626 width=0) (actual time=34.892..34.892 rows=7,605 loops=1)

  • Index Cond: ((rank_id = 1) AND (date = $1))
Planning time : 0.378 ms
Execution time : 38.911 ms