explain.depesz.com

PostgreSQL's explain analyze made readable

Result: VBfG

Settings
# exclusive inclusive rows x rows loops node
1. 369.998 561.160 ↓ 48.4 122,382 1

HashAggregate (cost=18,532.57..18,557.83 rows=2,526 width=336) (actual time=456.309..561.160 rows=122,382 loops=1)

  • Output: core_case.id, core_case.logical_timestamp, core_case.uuid, core_case.parent_id, core_case.customer_id, core_case.case_group_id, core_case.number, core_case.name, core_case.street_address, core_case.zip_code, core_case.city, core_case.country, core_case.latitude, core_case.longitude, core_case.creation_date, core_case.start_date, core_case.end_date, core_case.active, core_case.notes, core_case.department_id, core_case.hour_budget, core_case.permit_new_workreports, core_case.all_employees_may_add_work_reports, core_case.responsible_id, core_case.co_responsible_id, core_case.case_state_id, core_case.auto_numbered, core_case.all_worktypes_may_used_in_work_reports, core_case.geofence, core_case.priority_id, core_customer.id, core_customer.logical_timestamp, core_customer.uuid, core_customer.company_id, core_customer.customer_group_id, core_customer.number, core_customer.name, core_customer.street_address, core_customer.zip_code, core_customer.city, core_customer.country, core_customer.contact, core_customer.phone, core_customer.email, core_customer.vat_registration_number, core_customer.european_article_number, core_customer.active, core_customer.notes, core_customer.latitude, core_customer.longitude
  • Group Key: core_case.id, core_case.logical_timestamp, core_case.uuid, core_case.parent_id, core_case.customer_id, core_case.case_group_id, core_case.number, core_case.name, core_case.street_address, core_case.zip_code, core_case.city, core_case.country, core_case.latitude, core_case.longitude, core_case.creation_date, core_case.start_date, core_case.end_date, core_case.active, core_case.notes, core_case.department_id, core_case.hour_budget, core_case.permit_new_workreports, core_case.all_employees_may_add_work_reports, core_case.responsible_id, core_case.co_responsible_id, core_case.case_state_id, core_case.auto_numbered, core_case.all_worktypes_may_used_in_work_reports, core_case.geofence, core_case.priority_id, core_customer.id, core_customer.logical_timestamp, core_customer.uuid, core_customer.company_id, core_customer.customer_group_id, core_customer.number, core_customer.name, core_customer.street_address, core_customer.zip_code, core_customer.city, core_customer.country, core_customer.contact, core_customer.phone, core_customer.email, core_customer.vat_registration_number, core_customer.european_article_number, core_customer.active, core_customer.notes, core_customer.latitude, core_customer.longitude
  • Buffers: shared hit=59,746 read=1,159
2. 45.669 191.162 ↓ 48.4 122,382 1

Nested Loop (cost=0.85..18,216.82 rows=2,526 width=336) (actual time=0.183..191.162 rows=122,382 loops=1)

  • Output: core_case.id, core_case.logical_timestamp, core_case.uuid, core_case.parent_id, core_case.customer_id, core_case.case_group_id, core_case.number, core_case.name, core_case.street_address, core_case.zip_code, core_case.city, core_case.country, core_case.latitude, core_case.longitude, core_case.creation_date, core_case.start_date, core_case.end_date, core_case.active, core_case.notes, core_case.department_id, core_case.hour_budget, core_case.permit_new_workreports, core_case.all_employees_may_add_work_reports, core_case.responsible_id, core_case.co_responsible_id, core_case.case_state_id, core_case.auto_numbered, core_case.all_worktypes_may_used_in_work_reports, core_case.geofence, core_case.priority_id, core_customer.id, core_customer.logical_timestamp, core_customer.uuid, core_customer.company_id, core_customer.customer_group_id, core_customer.number, core_customer.name, core_customer.street_address, core_customer.zip_code, core_customer.city, core_customer.country, core_customer.contact, core_customer.phone, core_customer.email, core_customer.vat_registration_number, core_customer.european_article_number, core_customer.active, core_customer.notes, core_customer.latitude, core_customer.longitude
  • Buffers: shared hit=59,746 read=1,159
3. 1.839 1.839 ↓ 1.1 2,317 1

Index Scan using core_customer_company_id on public.core_customer (cost=0.42..1,050.17 rows=2,149 width=162) (actual time=0.099..1.839 rows=2,317 loops=1)

  • Output: core_customer.id, core_customer.company_id, core_customer.name, core_customer.street_address, core_customer.zip_code, core_customer.city, core_customer.country, core_customer.contact, core_customer.phone, core_customer.email, core_customer.notes, core_customer.logical_timestamp, core_customer.customer_group_id, core_customer.number, core_customer.uuid, core_customer.active, core_customer.european_article_number, core_customer.vat_registration_number, core_customer.latitude, core_customer.longitude
  • Index Cond: (core_customer.company_id = 16,077)
  • Buffers: shared hit=115 read=9
4. 143.654 143.654 ↓ 1.5 53 2,317

Index Scan using core_case_not_null_customer_id on public.core_case (cost=0.43..7.63 rows=36 width=174) (actual time=0.005..0.062 rows=53 loops=2,317)

  • Output: core_case.id, core_case.customer_id, core_case.name, core_case.creation_date, core_case.active, core_case.notes, core_case.number, core_case.permit_new_workreports, core_case.logical_timestamp, core_case.all_employees_may_add_work_reports, core_case.case_group_id, core_case.responsible_id, core_case.street_address, core_case.zip_code, core_case.city, core_case.country, core_case.uuid, core_case.co_responsible_id, core_case.case_state_id, core_case.auto_numbered, core_case.parent_id, core_case.start_date, core_case.end_date, core_case.hour_budget, core_case.all_worktypes_may_used_in_work_reports, core_case.department_id, core_case.geofence, core_case.latitude, core_case.longitude, core_case.priority_id
  • Index Cond: (core_case.customer_id = core_customer.id)
  • Filter: ((core_case.logical_timestamp > 0) OR core_case.active)
  • Buffers: shared hit=59,631 read=1,150
Planning time : 4.965 ms
Execution time : 572.766 ms