explain.depesz.com

PostgreSQL's explain analyze made readable

Result: iWLc

Settings
# exclusive inclusive rows x rows loops node
1. 405.850 624.129 ↓ 48.4 122,382 1

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

  • 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
2. 49.613 218.279 ↓ 48.4 122,382 1

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

3. 1.842 1.842 ↓ 1.1 2,317 1

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

  • Index Cond: (company_id = 16,077)
4. 166.824 166.824 ↓ 1.5 53 2,317

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

  • Index Cond: (customer_id = core_customer.id)
  • Filter: ((logical_timestamp > 0) OR active)
Planning time : 5.176 ms
Execution time : 633.779 ms