explain.depesz.com

PostgreSQL's explain analyze made readable

Result: FYiP

Settings
# exclusive inclusive rows x rows loops node
1. 0.004 86,042.606 ↑ 1.0 1 1

Limit (cost=44.37..44.38 rows=1 width=4) (actual time=86,042.605..86,042.606 rows=1 loops=1)

  • Output: (count(serviceren1_.id))
  • Buffers: shared hit=319920 read=35707
  • I/O Timings: read=85408.135
2. 0.011 86,042.602 ↑ 1.0 1 1

Aggregate (cost=44.37..44.38 rows=1 width=4) (actual time=86,042.602..86,042.602 rows=1 loops=1)

  • Output: count(serviceren1_.id)
  • Buffers: shared hit=319920 read=35707
  • I/O Timings: read=85408.135
3. 85.860 86,042.591 ↓ 0.0 0 1

Nested Loop (cost=1.13..44.37 rows=1 width=4) (actual time=86,042.591..86,042.591 rows=0 loops=1)

  • Output: serviceren1_.id
  • Buffers: shared hit=319920 read=35707
  • I/O Timings: read=85408.135
4. 66,548.726 66,548.726 ↓ 70,065.0 70,065 1

Index Scan using sr_srv_rendered_planned_date_idx on public.sr_srv_rendered serviceren1_ (cost=0.57..8.59 rows=1 width=4) (actual time=23.695..66,548.726 rows=70,065 loops=1)

  • Output: serviceren1_.id, serviceren1_.bdate, serviceren1_.comment, serviceren1_.cost, serviceren1_.duration, serviceren1_.edate, serviceren1_.is_rendered, serviceren1_.quantity, serviceren1_.total_cost, serviceren1_.contract_id, serviceren1_.customer_id, serviceren1_.funding_id, serviceren1_.res_group_id, serviceren1_.service_id, serviceren1_.duration_measure_unit_id, serviceren1_.begin_time, serviceren1_.prototype_id, serviceren1_.org_id, serviceren1_.price_list_id, serviceren1_.cul, serviceren1_.parent_id, serviceren1_.payment_status_id, serviceren1_.root_service_id, serviceren1_.is_wholly_rendered, serviceren1_.planned_date, serviceren1_.planned_time, serviceren1_.tooth_number, serviceren1_.is_refused, serviceren1_.aud_who, serviceren1_.aud_when, serviceren1_.aud_source, serviceren1_.aud_who_create, serviceren1_.aud_when_create, serviceren1_.aud_source_create, serviceren1_.is_amalgam_filling, serviceren1_.is_mobile_medical_teams, serviceren1_.close_date, serviceren1_.complex_srv_id, serviceren1_.for_upload, serviceren1_.uid, serviceren1_.is_need_consulting
  • Index Cond: ((serviceren1_.planned_date >= '2019-12-09'::date) AND (serviceren1_.planned_date < '2019-12-10'::date))
  • Buffers: shared hit=37869 read=25499
  • I/O Timings: read=66326.750
5. 19,408.005 19,408.005 ↓ 0.0 0 70,065

Index Scan using sr_srv_rendered_q_rate_srv_rendered_id_idx on public.sr_srv_rendered_q_rate serviceren0_ (cost=0.56..35.77 rows=1 width=4) (actual time=0.277..0.277 rows=0 loops=70,065)

  • Output: serviceren0_.id, serviceren0_.rate_id, serviceren0_.srv_rendered_id, serviceren0_.clause_id, serviceren0_.aud_who, serviceren0_.aud_when, serviceren0_.aud_source, serviceren0_.aud_who_create, serviceren0_.aud_when_create, serviceren0_.aud_source_create
  • Index Cond: (serviceren0_.srv_rendered_id = serviceren1_.id)
  • Filter: (serviceren0_.rate_id = 1644)
  • Rows Removed by Filter: 1
  • Buffers: shared hit=282051 read=10208
  • I/O Timings: read=19081.385
Planning time : 0.506 ms
Execution time : 86,042.685 ms