explain.depesz.com

PostgreSQL's explain analyze made readable

Result: Gqig : watman

Settings
# exclusive inclusive rows x rows loops node
1. 0.007 38,960.698 ↑ 52.2 23 1

Limit (cost=4.45..821,645.54 rows=1,200 width=368) (actual time=179.868..38,960.698 rows=23 loops=1)

  • Output: core_workreport.id, core_workreport.start_date, core_workreport.start_time, core_workreport.end_date, core_workreport.end_time, core_workreport.amount, core_workreport.remarks, core_workreport.creation_datetime, core_workreport.approved, core_workreport.car_registration_number, core_employee.name, core_employee.number, core_workreport.employee_id, core_workmodel.name, core_case.number, core_case.name, core_case.street_address, core_case.zip_code, core_case.city, core_case.country, t11.name, t12.name, core_customer.number, core_customer.name, core_case.active, core_workreport.case_id, core_workcategory.name, core_worktype.work_category_id, core_workcategory.hue, core_worktype.name, core_worktype.unit_cost, core_worktype.factor, core_workreport.work_type_id, core_worktype.report_interval, core_worktype.date_interval, core_worktype.piece_work, core_workreport.surplus_distributed, core_product.number, core_product.name, core_productgroup.number, core_productgroup.name, dataloen_api_dataloenworkreportsync.synced, core_workreport.start_latitude, core_workreport.start_longitude, core_workreport.end_latitude, core_workreport.end_longitude, core_workreport.start_date_week_number, core_department.name, t17.name, core_employee.initial, ((alternatives: SubPlan 1 or hashed SubPlan 2)), ((SubPlan 3)), ((SubPlan 4)), (CASE WHEN (core_workreport.work_type_id IS NOT NULL) THEN core_worktype.input_type ELSE core_product.unit END), ((SubPlan 5)), ((SubPlan 7)), ((SubPlan 9)), (CASE WHEN (core_workreport.work_type_id IS NULL) THEN NULL::interval WHEN (NOT core_worktype.report_interval) THEN NULL::interval WHEN (((core_worktype.input_type)::text <> 'Timer'::text) OR (core_worktype.input_type IS NULL)) THEN NULL::interval WHEN (core_workreport.start_time IS NULL) THEN NULL::interval WHEN (core_workreport.end_time IS NULL) THEN NULL::interval ELSE ((core_workreport.end_date + core_workreport.end_time) - (core_workreport.start_date + core_workreport.start_time)) END), (CASE WHEN (CASE WHEN (core_workreport.work_type_id IS NULL) THEN NULL::interval WHEN (NOT core_worktype.report_interval) THEN NULL::interval WHEN (((core_worktype.input_type)::text <> 'Timer'::text) OR (core_worktype.input_type IS NULL)) THEN NULL::interval WHEN (core_workreport.start_time IS NULL) THEN NULL::interval WHEN (core_workreport.end_time IS NULL) THEN NULL::interval ELSE ((core_workreport.end_date + core_workreport.end_time) - (core_workreport.start_date + core_workreport.start_time)) END IS NULL) THEN NULL::double precision WHEN (core_workreport.start_time IS NULL) THEN '0'::double precision WHEN (core_workreport.end_time IS NULL) THEN '0'::double precision ELSE ((date_part('epoch'::text, CASE WHEN (core_workreport.work_type_id IS NULL) THEN NULL::interval WHEN (NOT core_worktype.report_interval) THEN NULL::interval WHEN (((core_worktype.input_type)::text <> 'Timer'::text) OR (core_worktype.input_type IS NULL)) THEN NULL::interval WHEN (core_workreport.start_time IS NULL) THEN NULL::interval WHEN (core_workreport.end_time IS NULL) THEN NULL::interval ELSE ((core_workreport.end_date + core_workreport.end_time) - (core_workreport.start_date + core_workreport.start_time)) END) / '3600'::double precision) - (core_workreport.amount)::double precision) END), (CASE WHEN ((SubPlan 10) <> '0'::numeric) THEN (core_workreport.amount * (SubPlan 11)) WHEN ((SubPlan 12) <> '0'::numeric) THEN (core_workreport.amount * (SubPlan 13)) WHEN ((SubPlan 14) <> '0'::numeric) THEN (core_workreport.amount * (SubPlan 15)) WHEN ((SubPlan 16) <> '0'::numeric) THEN (core_workreport.amount * (SubPlan 17)) WHEN ((SubPlan 18) <> '0'::numeric) THEN (core_workreport.amount * (SubPlan 19)) ELSE '0'::numeric END)
2. 56.476 38,960.691 ↑ 2,138.9 23 1

Nested Loop Left Join (cost=4.45..33,683,180.91 rows=49,194 width=368) (actual time=179.867..38,960.691 rows=23 loops=1)

  • Output: core_workreport.id, core_workreport.start_date, core_workreport.start_time, core_workreport.end_date, core_workreport.end_time, core_workreport.amount, core_workreport.remarks, core_workreport.creation_datetime, core_workreport.approved, core_workreport.car_registration_number, core_employee.name, core_employee.number, core_workreport.employee_id, core_workmodel.name, core_case.number, core_case.name, core_case.street_address, core_case.zip_code, core_case.city, core_case.country, t11.name, t12.name, core_customer.number, core_customer.name, core_case.active, core_workreport.case_id, core_workcategory.name, core_worktype.work_category_id, core_workcategory.hue, core_worktype.name, core_worktype.unit_cost, core_worktype.factor, core_workreport.work_type_id, core_worktype.report_interval, core_worktype.date_interval, core_worktype.piece_work, core_workreport.surplus_distributed, core_product.number, core_product.name, core_productgroup.number, core_productgroup.name, dataloen_api_dataloenworkreportsync.synced, core_workreport.start_latitude, core_workreport.start_longitude, core_workreport.end_latitude, core_workreport.end_longitude, core_workreport.start_date_week_number, core_department.name, t17.name, core_employee.initial, (alternatives: SubPlan 1 or hashed SubPlan 2), (SubPlan 3), (SubPlan 4), CASE WHEN (core_workreport.work_type_id IS NOT NULL) THEN core_worktype.input_type ELSE core_product.unit END, (SubPlan 5), (SubPlan 7), (SubPlan 9), CASE WHEN (core_workreport.work_type_id IS NULL) THEN NULL::interval WHEN (NOT core_worktype.report_interval) THEN NULL::interval WHEN (((core_worktype.input_type)::text <> 'Timer'::text) OR (core_worktype.input_type IS NULL)) THEN NULL::interval WHEN (core_workreport.start_time IS NULL) THEN NULL::interval WHEN (core_workreport.end_time IS NULL) THEN NULL::interval ELSE ((core_workreport.end_date + core_workreport.end_time) - (core_workreport.start_date + core_workreport.start_time)) END, CASE WHEN (CASE WHEN (core_workreport.work_type_id IS NULL) THEN NULL::interval WHEN (NOT core_worktype.report_interval) THEN NULL::interval WHEN (((core_worktype.input_type)::text <> 'Timer'::text) OR (core_worktype.input_type IS NULL)) THEN NULL::interval WHEN (core_workreport.start_time IS NULL) THEN NULL::interval WHEN (core_workreport.end_time IS NULL) THEN NULL::interval ELSE ((core_workreport.end_date + core_workreport.end_time) - (core_workreport.start_date + core_workreport.start_time)) END IS NULL) THEN NULL::double precision WHEN (core_workreport.start_time IS NULL) THEN '0'::double precision WHEN (core_workreport.end_time IS NULL) THEN '0'::double precision ELSE ((date_part('epoch'::text, CASE WHEN (core_workreport.work_type_id IS NULL) THEN NULL::interval WHEN (NOT core_worktype.report_interval) THEN NULL::interval WHEN (((core_worktype.input_type)::text <> 'Timer'::text) OR (core_worktype.input_type IS NULL)) THEN NULL::interval WHEN (core_workreport.start_time IS NULL) THEN NULL::interval WHEN (core_workreport.end_time IS NULL) THEN NULL::interval ELSE ((core_workreport.end_date + core_workreport.end_time) - (core_workreport.start_date + core_workreport.start_time)) END) / '3600'::double precision) - (core_workreport.amount)::double precision) END, CASE WHEN ((SubPlan 10) <> '0'::numeric) THEN (core_workreport.amount * (SubPlan 11)) WHEN ((SubPlan 12) <> '0'::numeric) THEN (core_workreport.amount * (SubPlan 13)) WHEN ((SubPlan 14) <> '0'::numeric) THEN (core_workreport.amount * (SubPlan 15)) WHEN ((SubPlan 16) <> '0'::numeric) THEN (core_workreport.amount * (SubPlan 17)) WHEN ((SubPlan 18) <> '0'::numeric) THEN (core_workreport.amount * (SubPlan 19)) ELSE '0'::numeric END
3. 0.057 38,829.200 ↑ 2,138.9 23 1

Nested Loop Left Join (cost=4.30..5,069,036.31 rows=49,194 width=361) (actual time=50.880..38,829.200 rows=23 loops=1)

  • Output: core_workreport.id, core_workreport.start_date, core_workreport.start_time, core_workreport.end_date, core_workreport.end_time, core_workreport.amount, core_workreport.remarks, core_workreport.creation_datetime, core_workreport.approved, core_workreport.car_registration_number, core_workreport.employee_id, core_workreport.case_id, core_workreport.work_type_id, core_workreport.surplus_distributed, core_workreport.start_latitude, core_workreport.start_longitude, core_workreport.end_latitude, core_workreport.end_longitude, core_workreport.start_date_week_number, core_workreport.company_id, core_workreport.contract_id, core_employee.name, core_employee.number, core_employee.initial, core_employee.department_id, core_worktype.work_category_id, core_worktype.name, core_worktype.unit_cost, core_worktype.factor, core_worktype.report_interval, core_worktype.date_interval, core_worktype.piece_work, core_worktype.input_type, core_product.number, core_product.name, core_product.unit, core_case.number, core_case.name, core_case.street_address, core_case.zip_code, core_case.city, core_case.country, core_case.active, core_workcategory.name, core_workcategory.hue, core_workmodel.name, t11.name, t12.name, core_customer.number, core_customer.name, core_productgroup.number, core_productgroup.name, dataloen_api_dataloenworkreportsync.synced, core_department.name
4. 0.046 38,829.143 ↑ 2,138.9 23 1

Nested Loop Left Join (cost=4.16..5,060,673.09 rows=49,194 width=354) (actual time=50.874..38,829.143 rows=23 loops=1)

  • Output: core_workreport.id, core_workreport.start_date, core_workreport.start_time, core_workreport.end_date, core_workreport.end_time, core_workreport.amount, core_workreport.remarks, core_workreport.creation_datetime, core_workreport.approved, core_workreport.car_registration_number, core_workreport.employee_id, core_workreport.case_id, core_workreport.work_type_id, core_workreport.surplus_distributed, core_workreport.start_latitude, core_workreport.start_longitude, core_workreport.end_latitude, core_workreport.end_longitude, core_workreport.start_date_week_number, core_workreport.company_id, core_workreport.contract_id, core_employee.name, core_employee.number, core_employee.initial, core_employee.department_id, core_worktype.work_category_id, core_worktype.name, core_worktype.unit_cost, core_worktype.factor, core_worktype.report_interval, core_worktype.date_interval, core_worktype.piece_work, core_worktype.input_type, core_product.number, core_product.name, core_product.unit, core_case.number, core_case.name, core_case.street_address, core_case.zip_code, core_case.city, core_case.country, core_case.active, core_case.department_id, core_workcategory.name, core_workcategory.hue, core_workmodel.name, t11.name, t12.name, core_customer.number, core_customer.name, core_productgroup.number, core_productgroup.name, dataloen_api_dataloenworkreportsync.synced
5. 0.054 38,829.005 ↑ 2,138.9 23 1

Nested Loop Left Join (cost=3.87..5,045,050.28 rows=49,194 width=353) (actual time=50.863..38,829.005 rows=23 loops=1)

  • Output: core_workreport.id, core_workreport.start_date, core_workreport.start_time, core_workreport.end_date, core_workreport.end_time, core_workreport.amount, core_workreport.remarks, core_workreport.creation_datetime, core_workreport.approved, core_workreport.car_registration_number, core_workreport.employee_id, core_workreport.case_id, core_workreport.work_type_id, core_workreport.surplus_distributed, core_workreport.start_latitude, core_workreport.start_longitude, core_workreport.end_latitude, core_workreport.end_longitude, core_workreport.start_date_week_number, core_workreport.company_id, core_workreport.contract_id, core_employee.name, core_employee.number, core_employee.initial, core_employee.department_id, core_worktype.work_category_id, core_worktype.name, core_worktype.unit_cost, core_worktype.factor, core_worktype.report_interval, core_worktype.date_interval, core_worktype.piece_work, core_worktype.input_type, core_product.number, core_product.name, core_product.unit, core_case.number, core_case.name, core_case.street_address, core_case.zip_code, core_case.city, core_case.country, core_case.active, core_case.department_id, core_workcategory.name, core_workcategory.hue, core_workmodel.name, t11.name, t12.name, core_customer.number, core_customer.name, core_productgroup.number, core_productgroup.name
6. 0.075 38,828.951 ↑ 2,138.9 23 1

Nested Loop Left Join (cost=3.58..5,029,427.96 rows=49,194 width=343) (actual time=50.860..38,828.951 rows=23 loops=1)

  • Output: core_workreport.id, core_workreport.start_date, core_workreport.start_time, core_workreport.end_date, core_workreport.end_time, core_workreport.amount, core_workreport.remarks, core_workreport.creation_datetime, core_workreport.approved, core_workreport.car_registration_number, core_workreport.employee_id, core_workreport.case_id, core_workreport.work_type_id, core_workreport.surplus_distributed, core_workreport.start_latitude, core_workreport.start_longitude, core_workreport.end_latitude, core_workreport.end_longitude, core_workreport.start_date_week_number, core_workreport.company_id, core_workreport.contract_id, core_employee.name, core_employee.number, core_employee.initial, core_employee.department_id, core_worktype.work_category_id, core_worktype.name, core_worktype.unit_cost, core_worktype.factor, core_worktype.report_interval, core_worktype.date_interval, core_worktype.piece_work, core_worktype.input_type, core_product.number, core_product.name, core_product.unit, core_product.product_group_id, core_case.number, core_case.name, core_case.street_address, core_case.zip_code, core_case.city, core_case.country, core_case.active, core_case.department_id, core_workcategory.name, core_workcategory.hue, core_workmodel.name, t11.name, t12.name, core_customer.number, core_customer.name
7. 0.051 38,828.761 ↑ 2,138.9 23 1

Nested Loop Left Join (cost=3.16..5,006,091.46 rows=49,194 width=322) (actual time=50.848..38,828.761 rows=23 loops=1)

  • Output: core_workreport.id, core_workreport.start_date, core_workreport.start_time, core_workreport.end_date, core_workreport.end_time, core_workreport.amount, core_workreport.remarks, core_workreport.creation_datetime, core_workreport.approved, core_workreport.car_registration_number, core_workreport.employee_id, core_workreport.case_id, core_workreport.work_type_id, core_workreport.surplus_distributed, core_workreport.start_latitude, core_workreport.start_longitude, core_workreport.end_latitude, core_workreport.end_longitude, core_workreport.start_date_week_number, core_workreport.company_id, core_workreport.contract_id, core_employee.name, core_employee.number, core_employee.initial, core_employee.department_id, core_worktype.work_category_id, core_worktype.name, core_worktype.unit_cost, core_worktype.factor, core_worktype.report_interval, core_worktype.date_interval, core_worktype.piece_work, core_worktype.input_type, core_product.number, core_product.name, core_product.unit, core_product.product_group_id, core_case.number, core_case.name, core_case.street_address, core_case.zip_code, core_case.city, core_case.country, core_case.active, core_case.customer_id, core_case.department_id, core_workcategory.name, core_workcategory.hue, core_workmodel.name, t11.name, t12.name
8. 0.055 38,828.710 ↑ 2,138.9 23 1

Nested Loop Left Join (cost=2.87..4,990,405.93 rows=49,194 width=310) (actual time=50.845..38,828.710 rows=23 loops=1)

  • Output: core_workreport.id, core_workreport.start_date, core_workreport.start_time, core_workreport.end_date, core_workreport.end_time, core_workreport.amount, core_workreport.remarks, core_workreport.creation_datetime, core_workreport.approved, core_workreport.car_registration_number, core_workreport.employee_id, core_workreport.case_id, core_workreport.work_type_id, core_workreport.surplus_distributed, core_workreport.start_latitude, core_workreport.start_longitude, core_workreport.end_latitude, core_workreport.end_longitude, core_workreport.start_date_week_number, core_workreport.company_id, core_workreport.contract_id, core_employee.name, core_employee.number, core_employee.initial, core_employee.department_id, core_worktype.work_category_id, core_worktype.name, core_worktype.unit_cost, core_worktype.factor, core_worktype.report_interval, core_worktype.date_interval, core_worktype.piece_work, core_worktype.input_type, core_product.number, core_product.name, core_product.unit, core_product.product_group_id, core_case.number, core_case.name, core_case.street_address, core_case.zip_code, core_case.city, core_case.country, core_case.active, core_case.co_responsible_id, core_case.customer_id, core_case.department_id, core_workcategory.name, core_workcategory.hue, core_workmodel.name, t11.name
9. 0.048 38,828.586 ↑ 2,138.9 23 1

Nested Loop Left Join (cost=2.58..4,974,720.40 rows=49,194 width=298) (actual time=50.837..38,828.586 rows=23 loops=1)

  • Output: core_workreport.id, core_workreport.start_date, core_workreport.start_time, core_workreport.end_date, core_workreport.end_time, core_workreport.amount, core_workreport.remarks, core_workreport.creation_datetime, core_workreport.approved, core_workreport.car_registration_number, core_workreport.employee_id, core_workreport.case_id, core_workreport.work_type_id, core_workreport.surplus_distributed, core_workreport.start_latitude, core_workreport.start_longitude, core_workreport.end_latitude, core_workreport.end_longitude, core_workreport.start_date_week_number, core_workreport.company_id, core_workreport.contract_id, core_employee.name, core_employee.number, core_employee.initial, core_employee.department_id, core_worktype.work_category_id, core_worktype.name, core_worktype.unit_cost, core_worktype.factor, core_worktype.report_interval, core_worktype.date_interval, core_worktype.piece_work, core_worktype.input_type, core_product.number, core_product.name, core_product.unit, core_product.product_group_id, core_case.number, core_case.name, core_case.street_address, core_case.zip_code, core_case.city, core_case.country, core_case.active, core_case.responsible_id, core_case.co_responsible_id, core_case.customer_id, core_case.department_id, core_workcategory.name, core_workcategory.hue, core_workmodel.name
10. 0.057 38,828.423 ↑ 2,138.9 23 1

Nested Loop Left Join (cost=2.29..4,959,140.59 rows=49,194 width=285) (actual time=50.822..38,828.423 rows=23 loops=1)

  • Output: core_workreport.id, core_workreport.start_date, core_workreport.start_time, core_workreport.end_date, core_workreport.end_time, core_workreport.amount, core_workreport.remarks, core_workreport.creation_datetime, core_workreport.approved, core_workreport.car_registration_number, core_workreport.employee_id, core_workreport.case_id, core_workreport.work_type_id, core_workreport.surplus_distributed, core_workreport.start_latitude, core_workreport.start_longitude, core_workreport.end_latitude, core_workreport.end_longitude, core_workreport.start_date_week_number, core_workreport.company_id, core_workreport.contract_id, core_employee.name, core_employee.number, core_employee.initial, core_employee.department_id, core_worktype.work_category_id, core_worktype.name, core_worktype.unit_cost, core_worktype.factor, core_worktype.report_interval, core_worktype.date_interval, core_worktype.piece_work, core_worktype.input_type, core_product.number, core_product.name, core_product.unit, core_product.product_group_id, core_case.number, core_case.name, core_case.street_address, core_case.zip_code, core_case.city, core_case.country, core_case.active, core_case.responsible_id, core_case.co_responsible_id, core_case.customer_id, core_case.department_id, core_workcategory.name, core_workcategory.hue, core_workcategory.work_model_id
11. 0.053 38,828.228 ↑ 2,138.9 23 1

Nested Loop Left Join (cost=2.00..4,943,393.34 rows=49,194 width=262) (actual time=50.811..38,828.228 rows=23 loops=1)

  • Output: core_workreport.id, core_workreport.start_date, core_workreport.start_time, core_workreport.end_date, core_workreport.end_time, core_workreport.amount, core_workreport.remarks, core_workreport.creation_datetime, core_workreport.approved, core_workreport.car_registration_number, core_workreport.employee_id, core_workreport.case_id, core_workreport.work_type_id, core_workreport.surplus_distributed, core_workreport.start_latitude, core_workreport.start_longitude, core_workreport.end_latitude, core_workreport.end_longitude, core_workreport.start_date_week_number, core_workreport.company_id, core_workreport.contract_id, core_employee.name, core_employee.number, core_employee.initial, core_employee.department_id, core_worktype.work_category_id, core_worktype.name, core_worktype.unit_cost, core_worktype.factor, core_worktype.report_interval, core_worktype.date_interval, core_worktype.piece_work, core_worktype.input_type, core_product.number, core_product.name, core_product.unit, core_product.product_group_id, core_case.number, core_case.name, core_case.street_address, core_case.zip_code, core_case.city, core_case.country, core_case.active, core_case.responsible_id, core_case.co_responsible_id, core_case.customer_id, core_case.department_id
12. 0.056 38,828.037 ↑ 2,138.9 23 1

Nested Loop Left Join (cost=1.58..4,921,056.78 rows=49,194 width=203) (actual time=50.799..38,828.037 rows=23 loops=1)

  • Output: core_workreport.id, core_workreport.start_date, core_workreport.start_time, core_workreport.end_date, core_workreport.end_time, core_workreport.amount, core_workreport.remarks, core_workreport.creation_datetime, core_workreport.approved, core_workreport.car_registration_number, core_workreport.employee_id, core_workreport.case_id, core_workreport.work_type_id, core_workreport.surplus_distributed, core_workreport.start_latitude, core_workreport.start_longitude, core_workreport.end_latitude, core_workreport.end_longitude, core_workreport.start_date_week_number, core_workreport.company_id, core_workreport.contract_id, core_employee.name, core_employee.number, core_employee.initial, core_employee.department_id, core_worktype.work_category_id, core_worktype.name, core_worktype.unit_cost, core_worktype.factor, core_worktype.report_interval, core_worktype.date_interval, core_worktype.piece_work, core_worktype.input_type, core_product.number, core_product.name, core_product.unit, core_product.product_group_id
13. 0.070 38,827.981 ↑ 2,138.9 23 1

Nested Loop Left Join (cost=1.15..4,897,922.53 rows=49,194 width=160) (actual time=50.792..38,827.981 rows=23 loops=1)

  • Output: core_workreport.id, core_workreport.start_date, core_workreport.start_time, core_workreport.end_date, core_workreport.end_time, core_workreport.amount, core_workreport.remarks, core_workreport.creation_datetime, core_workreport.approved, core_workreport.car_registration_number, core_workreport.employee_id, core_workreport.case_id, core_workreport.work_type_id, core_workreport.surplus_distributed, core_workreport.start_latitude, core_workreport.start_longitude, core_workreport.end_latitude, core_workreport.end_longitude, core_workreport.start_date_week_number, core_workreport.company_id, core_workreport.contract_id, core_workreport.product_id, core_employee.name, core_employee.number, core_employee.initial, core_employee.department_id, core_worktype.work_category_id, core_worktype.name, core_worktype.unit_cost, core_worktype.factor, core_worktype.report_interval, core_worktype.date_interval, core_worktype.piece_work, core_worktype.input_type
14. 2,293.527 38,827.750 ↑ 2,138.9 23 1

Nested Loop (cost=0.72..4,875,893.11 rows=49,194 width=123) (actual time=50.778..38,827.750 rows=23 loops=1)

  • Output: core_workreport.id, core_workreport.start_date, core_workreport.start_time, core_workreport.end_date, core_workreport.end_time, core_workreport.amount, core_workreport.remarks, core_workreport.creation_datetime, core_workreport.approved, core_workreport.car_registration_number, core_workreport.employee_id, core_workreport.case_id, core_workreport.work_type_id, core_workreport.surplus_distributed, core_workreport.start_latitude, core_workreport.start_longitude, core_workreport.end_latitude, core_workreport.end_longitude, core_workreport.start_date_week_number, core_workreport.company_id, core_workreport.contract_id, core_workreport.product_id, core_employee.name, core_employee.number, core_employee.initial, core_employee.department_id
15. 9,967.725 9,967.725 ↓ 1.0 13,283,249 1

Index Scan Backward using core_workreport_pkey on public.core_workreport (cost=0.43..624,016.25 rows=13,283,248 width=99) (actual time=0.011..9,967.725 rows=13,283,249 loops=1)

  • Output: core_workreport.id, core_workreport.employee_id, core_workreport.case_id, core_workreport.work_type_id, core_workreport.start_date, core_workreport.start_time, core_workreport.end_date, core_workreport.end_time, core_workreport.amount, core_workreport.remarks, core_workreport.approved, core_workreport.logical_timestamp, core_workreport.start_latitude, core_workreport.start_longitude, core_workreport.end_latitude, core_workreport.end_longitude, core_workreport.uuid, core_workreport.creation_id, core_workreport.contract_id, core_workreport.product_id, core_workreport.creation_datetime, core_workreport.route_format, core_workreport.route_data, core_workreport.surplus_distributed, core_workreport.car_registration_number, core_workreport.approved_initial, core_workreport.approved_by_initial_id, core_workreport.approved_by_final_id, core_workreport.overtime_taboo, core_workreport.company_id, core_workreport.start_date_week_number, core_workreport.primary_work_report_id
16. 26,566.498 26,566.498 ↓ 0.0 0 13,283,249

Index Scan using core_employee_pkey on public.core_employee (cost=0.29..0.31 rows=1 width=28) (actual time=0.002..0.002 rows=0 loops=13,283,249)

  • Output: core_employee.id, core_employee.company_id, core_employee.name, core_employee.cpr_number, core_employee.street_address, core_employee.zip_code, core_employee.city, core_employee.country, core_employee.phone, core_employee.email, core_employee.logical_timestamp, core_employee."may_CUD_customers_and_cases", core_employee.may_add_work_reports_to_all_cases, core_employee.wipe_native_clients_logged_in_before, core_employee.number, core_employee.uuid, core_employee.file_server_auth_hash, core_employee.car_registration_number, core_employee.responsible_id, core_employee.co_responsible_id, core_employee.department_id, core_employee.initial
  • Index Cond: (core_employee.id = core_workreport.employee_id)
  • Filter: (core_employee.company_id = 11990)
  • Rows Removed by Filter: 1
17. 0.161 0.161 ↑ 1.0 1 23

Index Scan using core_worktype_pkey on public.core_worktype (cost=0.42..0.44 rows=1 width=41) (actual time=0.007..0.007 rows=1 loops=23)

  • Output: core_worktype.id, core_worktype.work_category_id, core_worktype.name, core_worktype.report_interval, core_worktype.input_type, core_worktype.unit_cost, core_worktype.factor, core_worktype.logical_timestamp, core_worktype.active, core_worktype.uuid, core_worktype.lieu_factor, core_worktype.bill_as_product_id, core_worktype.amount_cutoff, core_worktype.piece_work, core_worktype.date_interval, core_worktype.disable_messages_on_day, core_worktype.number, core_worktype.gps_interval, core_worktype.gps_mode, core_worktype.visible_for_all_cases, core_worktype.overtime_taboo
  • Index Cond: (core_workreport.work_type_id = core_worktype.id)
18. 0.000 0.000 ↓ 0.0 0 23

Index Scan using core_product_pkey on public.core_product (cost=0.43..0.46 rows=1 width=51) (actual time=0.000..0.000 rows=0 loops=23)

  • Output: core_product.id, core_product.product_group_id, core_product.name, core_product.sales_price, core_product.cost_price, core_product.recommended_price, core_product.accessible, core_product.volume, core_product.in_stock, core_product.on_order, core_product.ordered, core_product.available, core_product.bar_code, core_product.description, core_product.logical_timestamp, core_product.number, core_product.unit, core_product.uuid
  • Index Cond: (core_workreport.product_id = core_product.id)
19. 0.138 0.138 ↑ 1.0 1 23

Index Scan using core_case_pkey on public.core_case (cost=0.42..0.44 rows=1 width=63) (actual time=0.005..0.006 rows=1 loops=23)

  • 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
  • Index Cond: (core_workreport.case_id = core_case.id)
20. 0.138 0.138 ↑ 1.0 1 23

Index Scan using core_workcategory_pkey on public.core_workcategory (cost=0.29..0.31 rows=1 width=27) (actual time=0.004..0.006 rows=1 loops=23)

  • Output: core_workcategory.id, core_workcategory.work_model_id, core_workcategory.name, core_workcategory.case_related, core_workcategory.logical_timestamp, core_workcategory.supplement, core_workcategory.hue, core_workcategory.uuid
  • Index Cond: (core_worktype.work_category_id = core_workcategory.id)
21. 0.115 0.115 ↑ 1.0 1 23

Index Scan using core_workmodel_pkey on public.core_workmodel (cost=0.29..0.31 rows=1 width=21) (actual time=0.004..0.005 rows=1 loops=23)

  • Output: core_workmodel.id, core_workmodel.company_id, core_workmodel.name, core_workmodel.default_hourly_wage, core_workmodel.logical_timestamp, core_workmodel.number, core_workmodel.uuid, core_workmodel.lieu_balance_transfer_worktype_id
  • Index Cond: (core_workcategory.work_model_id = core_workmodel.id)
22. 0.069 0.069 ↑ 1.0 1 23

Index Scan using core_employee_pkey on public.core_employee t11 (cost=0.29..0.31 rows=1 width=20) (actual time=0.003..0.003 rows=1 loops=23)

  • Output: t11.id, t11.company_id, t11.name, t11.cpr_number, t11.street_address, t11.zip_code, t11.city, t11.country, t11.phone, t11.email, t11.logical_timestamp, t11."may_CUD_customers_and_cases", t11.may_add_work_reports_to_all_cases, t11.wipe_native_clients_logged_in_before, t11.number, t11.uuid, t11.file_server_auth_hash, t11.car_registration_number, t11.responsible_id, t11.co_responsible_id, t11.department_id, t11.initial
  • Index Cond: (core_case.responsible_id = t11.id)
23. 0.000 0.000 ↓ 0.0 0 23

Index Scan using core_employee_pkey on public.core_employee t12 (cost=0.29..0.31 rows=1 width=20) (actual time=0.000..0.000 rows=0 loops=23)

  • Output: t12.id, t12.company_id, t12.name, t12.cpr_number, t12.street_address, t12.zip_code, t12.city, t12.country, t12.phone, t12.email, t12.logical_timestamp, t12."may_CUD_customers_and_cases", t12.may_add_work_reports_to_all_cases, t12.wipe_native_clients_logged_in_before, t12.number, t12.uuid, t12.file_server_auth_hash, t12.car_registration_number, t12.responsible_id, t12.co_responsible_id, t12.department_id, t12.initial
  • Index Cond: (core_case.co_responsible_id = t12.id)
24. 0.115 0.115 ↑ 1.0 1 23

Index Scan using core_customer_pkey on public.core_customer (cost=0.42..0.46 rows=1 width=29) (actual time=0.005..0.005 rows=1 loops=23)

  • 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
  • Index Cond: (core_case.customer_id = core_customer.id)
25. 0.000 0.000 ↓ 0.0 0 23

Index Scan using core_productgroup_pkey on public.core_productgroup (cost=0.29..0.31 rows=1 width=18) (actual time=0.000..0.000 rows=0 loops=23)

  • Output: core_productgroup.id, core_productgroup.company_id, core_productgroup.name, core_productgroup.logical_timestamp, core_productgroup.number, core_productgroup.uuid, core_productgroup.accessible
  • Index Cond: (core_product.product_group_id = core_productgroup.id)
26. 0.092 0.092 ↓ 0.0 0 23

Index Scan using dataloen_api_dataloenworkreportsync_workreport_id_key on public.dataloen_api_dataloenworkreportsync (cost=0.29..0.31 rows=1 width=5) (actual time=0.004..0.004 rows=0 loops=23)

  • Output: dataloen_api_dataloenworkreportsync.id, dataloen_api_dataloenworkreportsync.value, dataloen_api_dataloenworkreportsync.deleted_from_integration, dataloen_api_dataloenworkreportsync.created_by, dataloen_api_dataloenworkreportsync.creation_datetime, dataloen_api_dataloenworkreportsync.company_integration_id, dataloen_api_dataloenworkreportsync.dataloen_uuid, dataloen_api_dataloenworkreportsync.workreport_id, dataloen_api_dataloenworkreportsync.synced
  • Index Cond: (core_workreport.id = dataloen_api_dataloenworkreportsync.workreport_id)
27. 0.000 0.000 ↓ 0.0 0 23

Index Scan using core_department_pkey on public.core_department (cost=0.14..0.16 rows=1 width=15) (actual time=0.000..0.000 rows=0 loops=23)

  • Output: core_department.id, core_department.logical_timestamp, core_department.uuid, core_department.company_id, core_department.number, core_department.name
  • Index Cond: (core_case.department_id = core_department.id)
28. 0.000 0.000 ↓ 0.0 0 23

Index Scan using core_department_pkey on public.core_department t17 (cost=0.14..0.18 rows=1 width=15) (actual time=0.000..0.000 rows=0 loops=23)

  • Output: t17.id, t17.logical_timestamp, t17.uuid, t17.company_id, t17.number, t17.name
  • Index Cond: (core_employee.department_id = t17.id)
29.          

SubPlan (forNested Loop Left Join)

30. 0.000 0.000 ↓ 0.0 0

Index Scan using core_approvedby_work_report_id_2c40e461 on public.core_approvedby u0 (cost=0.42..2.71 rows=1 width=0) (never executed)

  • Index Cond: (u0.work_report_id = core_workreport.id)
  • Filter: ((u0.responsible_level)::text = 'first_approver'::text)
31. 72.853 72.853 ↓ 1.0 137,208 1

Seq Scan on public.core_approvedby u0_1 (cost=0.00..6,395.24 rows=136,645 width=4) (actual time=0.823..72.853 rows=137,208 loops=1)

  • Output: u0_1.work_report_id
  • Filter: ((u0_1.responsible_level)::text = 'first_approver'::text)
  • Rows Removed by Filter: 162891
32. 0.000 0.207 ↓ 0.0 0 23

Limit (cost=1.00..5.57 rows=1 width=16) (actual time=0.009..0.009 rows=0 loops=23)

  • Output: u3.name
33. 0.023 0.207 ↓ 0.0 0 23

Nested Loop Left Join (cost=1.00..5.57 rows=1 width=16) (actual time=0.009..0.009 rows=0 loops=23)

  • Output: u3.name
34. 0.023 0.184 ↓ 0.0 0 23

Nested Loop (cost=0.71..5.23 rows=1 width=4) (actual time=0.008..0.008 rows=0 loops=23)

  • Output: u2.employee_id
35. 0.161 0.161 ↓ 0.0 0 23

Index Scan using core_approvedby_work_report_id_2c40e461 on public.core_approvedby u0_2 (cost=0.42..2.71 rows=1 width=4) (actual time=0.007..0.007 rows=0 loops=23)

  • Output: u0_2.id, u0_2.logical_timestamp, u0_2.uuid, u0_2.responsible_level, u0_2.approved_datetime, u0_2.user_profile_id, u0_2.work_report_id
  • Index Cond: (u0_2.work_report_id = core_workreport.id)
  • Filter: ((u0_2.responsible_level)::text = 'first_approver'::text)
  • Rows Removed by Filter: 1
36. 0.000 0.000 ↓ 0.0 0

Index Scan using core_userprofile_pkey on public.core_userprofile u2 (cost=0.29..2.51 rows=1 width=8) (never executed)

  • Output: u2.id, u2.user_id, u2.company_id, u2.employee_id, u2.may_log_into_backend, u2.first_login, u2.logical_timestamp, u2.language, u2.uuid, u2.may_log_into_approval, u2.may_log_into_intempus_partner
  • Index Cond: (u2.id = u0_2.user_profile_id)
37. 0.000 0.000 ↓ 0.0 0

Index Scan using core_employee_pkey on public.core_employee u3 (cost=0.29..0.33 rows=1 width=20) (never executed)

  • Output: u3.id, u3.company_id, u3.name, u3.cpr_number, u3.street_address, u3.zip_code, u3.city, u3.country, u3.phone, u3.email, u3.logical_timestamp, u3."may_CUD_customers_and_cases", u3.may_add_work_reports_to_all_cases, u3.wipe_native_clients_logged_in_before, u3.number, u3.uuid, u3.file_server_auth_hash, u3.car_registration_number, u3.responsible_id, u3.co_responsible_id, u3.department_id, u3.initial
  • Index Cond: (u2.employee_id = u3.id)
38. 0.000 0.276 ↑ 1.0 1 23

Limit (cost=1.00..5.57 rows=1 width=16) (actual time=0.012..0.012 rows=1 loops=23)

  • Output: u3_1.name
39. 0.058 0.276 ↑ 1.0 1 23

Nested Loop Left Join (cost=1.00..5.57 rows=1 width=16) (actual time=0.012..0.012 rows=1 loops=23)

  • Output: u3_1.name
40. 0.047 0.184 ↑ 1.0 1 23

Nested Loop (cost=0.71..5.23 rows=1 width=4) (actual time=0.008..0.008 rows=1 loops=23)

  • Output: u2_1.employee_id
41. 0.069 0.069 ↑ 1.0 1 23

Index Scan using core_approvedby_work_report_id_2c40e461 on public.core_approvedby u0_3 (cost=0.42..2.71 rows=1 width=4) (actual time=0.003..0.003 rows=1 loops=23)

  • Output: u0_3.id, u0_3.logical_timestamp, u0_3.uuid, u0_3.responsible_level, u0_3.approved_datetime, u0_3.user_profile_id, u0_3.work_report_id
  • Index Cond: (u0_3.work_report_id = core_workreport.id)
  • Filter: ((u0_3.responsible_level)::text = ANY ('{admin,final_approver}'::text[]))
42. 0.068 0.068 ↑ 1.0 1 17

Index Scan using core_userprofile_pkey on public.core_userprofile u2_1 (cost=0.29..2.51 rows=1 width=8) (actual time=0.004..0.004 rows=1 loops=17)

  • Output: u2_1.id, u2_1.user_id, u2_1.company_id, u2_1.employee_id, u2_1.may_log_into_backend, u2_1.first_login, u2_1.logical_timestamp, u2_1.language, u2_1.uuid, u2_1.may_log_into_approval, u2_1.may_log_into_intempus_partner
  • Index Cond: (u2_1.id = u0_3.user_profile_id)
43. 0.034 0.034 ↑ 1.0 1 17

Index Scan using core_employee_pkey on public.core_employee u3_1 (cost=0.29..0.33 rows=1 width=20) (actual time=0.002..0.002 rows=1 loops=17)

  • Output: u3_1.id, u3_1.company_id, u3_1.name, u3_1.cpr_number, u3_1.street_address, u3_1.zip_code, u3_1.city, u3_1.country, u3_1.phone, u3_1.email, u3_1.logical_timestamp, u3_1."may_CUD_customers_and_cases", u3_1.may_add_work_reports_to_all_cases, u3_1.wipe_native_clients_logged_in_before, u3_1.number, u3_1.uuid, u3_1.file_server_auth_hash, u3_1.car_registration_number, u3_1.responsible_id, u3_1.co_responsible_id, u3_1.department_id, u3_1.initial
  • Index Cond: (u2_1.employee_id = u3_1.id)
44. 0.138 0.138 ↑ 1.0 1 23

Index Scan using core_workreport_pkey on public.core_workreport u0_4 (cost=0.43..2.66 rows=1 width=0) (actual time=0.006..0.006 rows=1 loops=23)

  • Index Cond: (u0_4.id = core_workreport.id)
  • Filter: (u0_4.company_id = core_workreport.company_id)
45. 0.253 0.253 ↑ 1.0 1 23

CTE Scan on ancestors ancestors_1 (cost=271.91..273.93 rows=1 width=516) (actual time=0.008..0.011 rows=1 loops=23)

  • Output: ancestors_1.name
  • Filter: (ancestors_1.parent_id IS NULL)
46.          

CTE ancestors

47. 0.046 0.184 ↑ 101.0 1 23

Recursive Union (cost=0.42..271.91 rows=101 width=37) (actual time=0.005..0.008 rows=1 loops=23)

48. 0.092 0.092 ↑ 1.0 1 23

Index Scan using core_case_pkey on public.core_case m (cost=0.42..2.64 rows=1 width=37) (actual time=0.004..0.004 rows=1 loops=23)

  • Output: m.id, m.name, m.number, m.parent_id
  • Index Cond: (m.id = core_workreport.case_id)
49. 0.046 0.046 ↓ 0.0 0 23

Nested Loop (cost=0.42..26.73 rows=10 width=37) (actual time=0.002..0.002 rows=0 loops=23)

  • Output: m_1.id, m_1.name, m_1.number, m_1.parent_id
50. 0.000 0.000 ↑ 10.0 1 23

WorkTable Scan on ancestors (cost=0.00..0.20 rows=10 width=4) (actual time=0.000..0.000 rows=1 loops=23)

  • Output: ancestors.id, ancestors.name, ancestors.number, ancestors.parent_id
51. 0.000 0.000 ↓ 0.0 0 22

Index Scan using core_case_pkey on public.core_case m_1 (cost=0.42..2.64 rows=1 width=37) (actual time=0.000..0.000 rows=0 loops=22)

  • Output: m_1.id, m_1.customer_id, m_1.name, m_1.creation_date, m_1.active, m_1.notes, m_1.number, m_1.permit_new_workreports, m_1.logical_timestamp, m_1.all_employees_may_add_work_reports, m_1.case_group_id, m_1.responsible_id, m_1.street_address, m_1.zip_code, m_1.city, m_1.country, m_1.uuid, m_1.co_responsible_id, m_1.case_state_id, m_1.auto_numbered, m_1.parent_id, m_1.start_date, m_1.end_date, m_1.hour_budget, m_1.all_worktypes_may_used_in_work_reports, m_1.department_id, m_1.geofence, m_1.latitude, m_1.longitude
  • Index Cond: (m_1.id = ancestors.parent_id)
52. 0.184 0.184 ↑ 1.0 1 23

CTE Scan on ancestors ancestors_3 (cost=271.91..273.93 rows=1 width=32) (actual time=0.005..0.008 rows=1 loops=23)

  • Output: ancestors_3.number
  • Filter: (ancestors_3.parent_id IS NULL)
53.          

CTE ancestors

54. 0.023 0.138 ↑ 101.0 1 23

Recursive Union (cost=0.42..271.91 rows=101 width=37) (actual time=0.004..0.006 rows=1 loops=23)

55. 0.069 0.069 ↑ 1.0 1 23

Index Scan using core_case_pkey on public.core_case m_2 (cost=0.42..2.64 rows=1 width=37) (actual time=0.003..0.003 rows=1 loops=23)

  • Output: m_2.id, m_2.name, m_2.number, m_2.parent_id
  • Index Cond: (m_2.id = core_workreport.case_id)
56. 0.046 0.046 ↓ 0.0 0 23

Nested Loop (cost=0.42..26.73 rows=10 width=37) (actual time=0.002..0.002 rows=0 loops=23)

  • Output: m_3.id, m_3.name, m_3.number, m_3.parent_id
57. 0.000 0.000 ↑ 10.0 1 23

WorkTable Scan on ancestors ancestors_2 (cost=0.00..0.20 rows=10 width=4) (actual time=0.000..0.000 rows=1 loops=23)

  • Output: ancestors_2.id, ancestors_2.name, ancestors_2.number, ancestors_2.parent_id
58. 0.000 0.000 ↓ 0.0 0 22

Index Scan using core_case_pkey on public.core_case m_3 (cost=0.42..2.64 rows=1 width=37) (actual time=0.000..0.000 rows=0 loops=22)

  • Output: m_3.id, m_3.customer_id, m_3.name, m_3.creation_date, m_3.active, m_3.notes, m_3.number, m_3.permit_new_workreports, m_3.logical_timestamp, m_3.all_employees_may_add_work_reports, m_3.case_group_id, m_3.responsible_id, m_3.street_address, m_3.zip_code, m_3.city, m_3.country, m_3.uuid, m_3.co_responsible_id, m_3.case_state_id, m_3.auto_numbered, m_3.parent_id, m_3.start_date, m_3.end_date, m_3.hour_budget, m_3.all_worktypes_may_used_in_work_reports, m_3.department_id, m_3.geofence, m_3.latitude, m_3.longitude
  • Index Cond: (m_3.id = ancestors_2.parent_id)
59. 0.092 0.299 ↓ 0.0 0 23

Limit (cost=0.00..1.76 rows=1 width=30) (actual time=0.013..0.013 rows=0 loops=23)

  • Output: u0_5.value
60. 0.207 0.207 ↓ 0.0 0 23

Seq Scan on public.core_price u0_5 (cost=0.00..1.76 rows=1 width=30) (actual time=0.009..0.009 rows=0 loops=23)

  • Output: u0_5.value
  • Filter: ((u0_5.contract_id IS NULL) AND ((u0_5.price_type)::text = 'unit'::text) AND (u0_5.case_id = core_workreport.case_id) AND (u0_5.work_type_id = core_workreport.work_type_id) AND (u0_5.company_id = 11990))
  • Rows Removed by Filter: 38
61. 0.000 0.000 ↓ 0.0 0

Limit (cost=0.00..1.76 rows=1 width=30) (never executed)

  • Output: u0_6.value
62. 0.000 0.000 ↓ 0.0 0

Seq Scan on public.core_price u0_6 (cost=0.00..1.76 rows=1 width=30) (never executed)

  • Output: u0_6.value
  • Filter: ((u0_6.contract_id IS NULL) AND ((u0_6.price_type)::text = 'unit'::text) AND (u0_6.case_id = core_workreport.case_id) AND (u0_6.work_type_id = core_workreport.work_type_id) AND (u0_6.company_id = 11990))
63. 0.023 0.161 ↓ 0.0 0 23

Limit (cost=0.00..1.67 rows=1 width=30) (actual time=0.007..0.007 rows=0 loops=23)

  • Output: u0_7.value
64. 0.138 0.138 ↓ 0.0 0 23

Seq Scan on public.core_price u0_7 (cost=0.00..1.67 rows=1 width=30) (actual time=0.006..0.006 rows=0 loops=23)

  • Output: u0_7.value
  • Filter: ((u0_7.work_type_id IS NULL) AND (u0_7.contract_id IS NULL) AND ((u0_7.price_type)::text = 'unit'::text) AND (u0_7.case_id = core_workreport.case_id) AND (u0_7.company_id = 11990))
  • Rows Removed by Filter: 38
65. 0.000 0.000 ↓ 0.0 0

Limit (cost=0.00..1.67 rows=1 width=30) (never executed)

  • Output: u0_8.value
66. 0.000 0.000 ↓ 0.0 0

Seq Scan on public.core_price u0_8 (cost=0.00..1.67 rows=1 width=30) (never executed)

  • Output: u0_8.value
  • Filter: ((u0_8.work_type_id IS NULL) AND (u0_8.contract_id IS NULL) AND ((u0_8.price_type)::text = 'unit'::text) AND (u0_8.case_id = core_workreport.case_id) AND (u0_8.company_id = 11990))
67. 0.023 0.253 ↓ 0.0 0 23

Limit (cost=0.00..1.76 rows=1 width=30) (actual time=0.011..0.011 rows=0 loops=23)

  • Output: u0_9.value
68. 0.230 0.230 ↓ 0.0 0 23

Seq Scan on public.core_price u0_9 (cost=0.00..1.76 rows=1 width=30) (actual time=0.010..0.010 rows=0 loops=23)

  • Output: u0_9.value
  • Filter: ((u0_9.case_id IS NULL) AND ((u0_9.price_type)::text = 'unit'::text) AND (u0_9.work_type_id = core_workreport.work_type_id) AND (u0_9.contract_id = core_workreport.contract_id) AND (u0_9.company_id = 11990))
  • Rows Removed by Filter: 38
69. 0.000 0.000 ↓ 0.0 0

Limit (cost=0.00..1.76 rows=1 width=30) (never executed)

  • Output: u0_10.value
70. 0.000 0.000 ↓ 0.0 0

Seq Scan on public.core_price u0_10 (cost=0.00..1.76 rows=1 width=30) (never executed)

  • Output: u0_10.value
  • Filter: ((u0_10.case_id IS NULL) AND ((u0_10.price_type)::text = 'unit'::text) AND (u0_10.work_type_id = core_workreport.work_type_id) AND (u0_10.contract_id = core_workreport.contract_id) AND (u0_10.company_id = 11990))
71. 0.023 0.184 ↓ 0.0 0 23

Limit (cost=0.00..1.67 rows=1 width=30) (actual time=0.008..0.008 rows=0 loops=23)

  • Output: u0_11.value
72. 0.161 0.161 ↓ 0.0 0 23

Seq Scan on public.core_price u0_11 (cost=0.00..1.67 rows=1 width=30) (actual time=0.007..0.007 rows=0 loops=23)

  • Output: u0_11.value
  • Filter: ((u0_11.case_id IS NULL) AND (u0_11.work_type_id IS NULL) AND ((u0_11.price_type)::text = 'unit'::text) AND (u0_11.contract_id = core_workreport.contract_id) AND (u0_11.company_id = 11990))
  • Rows Removed by Filter: 38
73. 0.000 0.000 ↓ 0.0 0

Limit (cost=0.00..1.67 rows=1 width=30) (never executed)

  • Output: u0_12.value
74. 0.000 0.000 ↓ 0.0 0

Seq Scan on public.core_price u0_12 (cost=0.00..1.67 rows=1 width=30) (never executed)

  • Output: u0_12.value
  • Filter: ((u0_12.case_id IS NULL) AND (u0_12.work_type_id IS NULL) AND ((u0_12.price_type)::text = 'unit'::text) AND (u0_12.contract_id = core_workreport.contract_id) AND (u0_12.company_id = 11990))
75. 0.023 0.207 ↓ 0.0 0 23

Limit (cost=0.00..1.67 rows=1 width=30) (actual time=0.009..0.009 rows=0 loops=23)

  • Output: u0_13.value
76. 0.184 0.184 ↓ 0.0 0 23

Seq Scan on public.core_price u0_13 (cost=0.00..1.67 rows=1 width=30) (actual time=0.008..0.008 rows=0 loops=23)

  • Output: u0_13.value
  • Filter: ((u0_13.case_id IS NULL) AND (u0_13.contract_id IS NULL) AND ((u0_13.price_type)::text = 'unit'::text) AND (u0_13.work_type_id = core_workreport.work_type_id) AND (u0_13.company_id = 11990))
  • Rows Removed by Filter: 38
77. 0.000 0.000 ↓ 0.0 0

Limit (cost=0.00..1.67 rows=1 width=30) (never executed)

  • Output: u0_14.value
78. 0.000 0.000 ↓ 0.0 0

Seq Scan on public.core_price u0_14 (cost=0.00..1.67 rows=1 width=30) (never executed)

  • Output: u0_14.value
  • Filter: ((u0_14.case_id IS NULL) AND (u0_14.contract_id IS NULL) AND ((u0_14.price_type)::text = 'unit'::text) AND (u0_14.work_type_id = core_workreport.work_type_id) AND (u0_14.company_id = 11990))