explain.depesz.com

PostgreSQL's explain analyze made readable

Result: CGoi

Settings
# exclusive inclusive rows x rows loops node
1. 0.002 2.312 ↑ 1.0 1 1

Aggregate (cost=378,869.74..378,869.75 rows=1 width=12) (actual time=2.312..2.312 rows=1 loops=1)

2. 0.001 2.310 ↓ 0.0 0 1

Subquery Scan on t (cost=378,869.69..378,869.74 rows=1 width=4) (actual time=2.310..2.310 rows=0 loops=1)

  • Filter: CASE WHEN ((t.is_allow_lease_progression IS NULL) OR (t.app_id IS NULL)) THEN (t.rank1 = 1) ELSE (t.rank1 IS NOT NULL) END
3. 0.000 2.309 ↓ 0.0 0 1

Unique (cost=378,869.69..378,869.73 rows=1 width=186) (actual time=2.309..2.309 rows=0 loops=1)

4. 0.023 2.309 ↓ 0.0 0 1

Sort (cost=378,869.69..378,869.70 rows=1 width=186) (actual time=2.309..2.309 rows=0 loops=1)

  • Sort Key: (CASE WHEN ((btrim((dp.approvals_esign_docs ->> 'urgent_move_in_date_within'::text)) <> ''::text) AND (ca.lease_start_date <= (CURRENT_DATE + ((dp.approvals_esign_docs ->> 'urgent_move_in_date_within'::text))::integer))) THEN 3 WHEN ((btrim((dp.approvals_esign_docs ->> 'urgent_lease_type_ids'::text)) <> ''::text) AND (ca.lease_interval_type_id = ANY (((dp.approvals_esign_docs ->> 'urgent_lease_type_ids'::text))::integer[]))) THEN 3 WHEN ((btrim((dp.approvals_esign_docs ->> 'urgent_document_signed_since'::text)) <> ''::text) AND (CURRENT_DATE >= ((f.file_signed_on)::date + ((dp.approvals_esign_docs ->> 'urgent_document_signed_since'::text))::integer))) THEN 3 WHEN ((btrim((dp.approvals_esign_docs ->> 'important_document_signed_since'::text)) <> ''::text) AND (CURRENT_DATE >= ((f.file_signed_on)::date + ((dp.approvals_esign_docs ->> 'important_document_signed_since'::text))::integer))) THEN 2 WHEN ((btrim((dp.approvals_esign_docs ->> 'important_lease_type_ids'::text)) <> ''::text) AND (ca.lease_interval_type_id = ANY (((dp.approvals_esign_docs ->> 'important_lease_type_ids'::text))::integer[]))) THEN 2 WHEN ((btrim((dp.approvals_esign_docs ->> 'important_move_in_date_within'::text)) <> ''::text) AND (ca.lease_start_date <= (CURRENT_DATE + ((dp.approvals_esign_docs ->> 'important_move_in_date_within'::text))::integer))) THEN 2 ELSE 1 END), ca.id, f.lease_id, ap.lease_signed_on, f.applicant_id, f.application_id, f.is_allow_lease_progression, f.id, p.property_name, p.id, (rank() OVER (?))
  • Sort Method: quicksort Memory: 25kB
5. 0.001 2.286 ↓ 0.0 0 1

WindowAgg (cost=378,869.66..378,869.68 rows=1 width=186) (actual time=2.286..2.286 rows=0 loops=1)

6. 0.002 2.285 ↓ 0.0 0 1

Sort (cost=378,869.66..378,869.66 rows=1 width=178) (actual time=2.285..2.285 rows=0 loops=1)

  • Sort Key: fa_1.file_id, lc.customer_type_id, lc.id
  • Sort Method: quicksort Memory: 25kB
7. 0.000 2.283 ↓ 0.0 0 1

Nested Loop (cost=378,846.65..378,869.65 rows=1 width=178) (actual time=2.283..2.283 rows=0 loops=1)

8. 0.001 2.283 ↓ 0.0 0 1

Nested Loop (cost=378,846.22..378,869.19 rows=1 width=186) (actual time=2.283..2.283 rows=0 loops=1)

9. 0.000 2.282 ↓ 0.0 0 1

Nested Loop (cost=378,845.79..378,866.01 rows=7 width=178) (actual time=2.282..2.282 rows=0 loops=1)

10. 0.001 2.282 ↓ 0.0 0 1

Group (cost=378,845.22..378,845.43 rows=1 width=290) (actual time=2.282..2.282 rows=0 loops=1)

  • Group Key: ((dp.approvals_esign_docs ->> 'urgent_move_in_date_within'::text)), ((dp.approvals_esign_docs ->> 'urgent_lease_type_ids'::text)), ((dp.approvals_esign_docs ->> 'important_lease_type_ids'::text)), ((dp.approvals_esign_docs ->> 'important_move_in_date_within'::text)), p.id, p.property_name, ca.id, (CASE WHEN ((btrim((dp.approvals_esign_docs ->> 'urgent_move_in_date_within'::text)) <> ''::text) AND (ca.lease_start_date <= (CURRENT_DATE + ((dp.approvals_esign_docs ->> 'urgent_move_in_date_within'::text))::integer))) THEN 3 WHEN ((btrim((dp.approvals_esign_docs ->> 'urgent_lease_type_ids'::text)) <> ''::text) AND (ca.lease_interval_type_id = ANY (((dp.approvals_esign_docs ->> 'urgent_lease_type_ids'::text))::integer[]))) THEN 3 WHEN ((btrim((dp.approvals_esign_docs ->> 'urgent_document_signed_since'::text)) <> ''::text) AND (CURRENT_DATE >= ((f.file_signed_on)::date + ((dp.approvals_esign_docs ->> 'urgent_document_signed_since'::text))::integer))) THEN 3 WHEN ((btrim((dp.approvals_esign_docs ->> 'important_document_signed_since'::text)) <> ''::text) AND (CURRENT_DATE >= ((f.file_signed_on)::date + ((dp.approvals_esign_docs ->> 'important_document_signed_since'::text))::integer))) THEN 2 WHEN ((btrim((dp.approvals_esign_docs ->> 'important_lease_type_ids'::text)) <> ''::text) AND (ca.lease_interval_type_id = ANY (((dp.approvals_esign_docs ->> 'important_lease_type_ids'::text))::integer[]))) THEN 2 WHEN ((btrim((dp.approvals_esign_docs ->> 'important_move_in_date_within'::text)) <> ''::text) AND (ca.lease_start_date <= (CURRENT_DATE + ((dp.approvals_esign_docs ->> 'important_move_in_date_within'::text))::integer))) THEN 2 ELSE 1 END), f.lease_id, f.cid, f.id, ap.lease_signed_on, f.application_id, f.applicant_id, f.is_allow_lease_progression
11. 0.003 2.281 ↓ 0.0 0 1

Sort (cost=378,845.22..378,845.23 rows=1 width=290) (actual time=2.281..2.281 rows=0 loops=1)

  • Sort Key: ((dp.approvals_esign_docs ->> 'urgent_move_in_date_within'::text)), ((dp.approvals_esign_docs ->> 'urgent_lease_type_ids'::text)), ((dp.approvals_esign_docs ->> 'important_lease_type_ids'::text)), ((dp.approvals_esign_docs ->> 'important_move_in_date_within'::text)), p.id, p.property_name, ca.id, (CASE WHEN ((btrim((dp.approvals_esign_docs ->> 'urgent_move_in_date_within'::text)) <> ''::text) AND (ca.lease_start_date <= (CURRENT_DATE + ((dp.approvals_esign_docs ->> 'urgent_move_in_date_within'::text))::integer))) THEN 3 WHEN ((btrim((dp.approvals_esign_docs ->> 'urgent_lease_type_ids'::text)) <> ''::text) AND (ca.lease_interval_type_id = ANY (((dp.approvals_esign_docs ->> 'urgent_lease_type_ids'::text))::integer[]))) THEN 3 WHEN ((btrim((dp.approvals_esign_docs ->> 'urgent_document_signed_since'::text)) <> ''::text) AND (CURRENT_DATE >= ((f.file_signed_on)::date + ((dp.approvals_esign_docs ->> 'urgent_document_signed_since'::text))::integer))) THEN 3 WHEN ((btrim((dp.approvals_esign_docs ->> 'important_document_signed_since'::text)) <> ''::text) AND (CURRENT_DATE >= ((f.file_signed_on)::date + ((dp.approvals_esign_docs ->> 'important_document_signed_since'::text))::integer))) THEN 2 WHEN ((btrim((dp.approvals_esign_docs ->> 'important_lease_type_ids'::text)) <> ''::text) AND (ca.lease_interval_type_id = ANY (((dp.approvals_esign_docs ->> 'important_lease_type_ids'::text))::integer[]))) THEN 2 WHEN ((btrim((dp.approvals_esign_docs ->> 'important_move_in_date_within'::text)) <> ''::text) AND (ca.lease_start_date <= (CURRENT_DATE + ((dp.approvals_esign_docs ->> 'important_move_in_date_within'::text))::integer))) THEN 2 ELSE 1 END), f.lease_id, f.id, ap.lease_signed_on, f.application_id, f.applicant_id, f.is_allow_lease_progression
  • Sort Method: quicksort Memory: 25kB
12. 0.001 2.278 ↓ 0.0 0 1

Nested Loop Left Join (cost=378,841.42..378,845.21 rows=1 width=290) (actual time=2.278..2.278 rows=0 loops=1)

  • Join Filter: (dp.cid = f.cid)
13. 0.001 2.277 ↓ 0.0 0 1

Merge Right Join (cost=378,841.42..378,844.02 rows=1 width=174) (actual time=2.277..2.277 rows=0 loops=1)

  • Merge Cond: (f1.file_id = f.id)
  • Filter: (((f1.file_id IS NOT NULL) AND (0 < (count(f1.id)))) OR (f.document_id IS NULL))
14. 0.000 2.270 ↓ 0.0 0 1

GroupAggregate (cost=378,736.49..378,737.99 rows=86 width=12) (actual time=2.270..2.270 rows=0 loops=1)

  • Group Key: f1.file_id
15. 0.003 2.270 ↓ 0.0 0 1

Sort (cost=378,736.49..378,736.70 rows=86 width=8) (actual time=2.270..2.270 rows=0 loops=1)

  • Sort Key: f1.file_id
  • Sort Method: quicksort Memory: 25kB
16. 0.000 2.267 ↓ 0.0 0 1

Nested Loop Left Join (cost=12.88..378,733.73 rows=86 width=8) (actual time=2.267..2.267 rows=0 loops=1)

  • Filter: CASE WHEN ((cu.is_administrator = 0) AND (da.countersign_company_group_ids IS NOT NULL)) THEN ((SubPlan 8) && da.countersign_company_group_ids) WHEN ((cu.is_administrator = 1) OR (da.countersign_company_group_ids IS NULL)) THEN true ELSE NULL::boolean END
17. 0.001 2.267 ↓ 0.0 0 1

Nested Loop Semi Join (cost=12.59..378,130.05 rows=172 width=32) (actual time=2.267..2.267 rows=0 loops=1)

18. 0.006 2.266 ↓ 0.0 0 1

Hash Semi Join (cost=12.03..373,590.10 rows=7,448 width=32) (actual time=2.266..2.266 rows=0 loops=1)

  • Hash Cond: (f1.property_id = properties.id)
19. 0.002 2.257 ↑ 102,333.0 1 1

Nested Loop (cost=1.12..373,227.72 rows=102,333 width=36) (actual time=2.257..2.257 rows=1 loops=1)

20. 0.003 0.649 ↑ 1.0 1 1

Nested Loop (cost=0.56..5.01 rows=1 width=20) (actual time=0.649..0.649 rows=1 loops=1)

21. 0.026 0.026 ↑ 1.0 1 1

Index Scan using idx_file_types_cid_system_code on file_types ft1 (cost=0.27..2.49 rows=1 width=8) (actual time=0.026..0.026 rows=1 loops=1)

  • Index Cond: ((cid = 3,395) AND ((system_code)::text = 'LA'::text))
22. 0.620 0.620 ↑ 1.0 1 1

Index Scan using idx_company_users_id on company_users cu (cost=0.29..2.51 rows=1 width=12) (actual time=0.620..0.620 rows=1 loops=1)

  • Index Cond: (id = 100,595)
  • Filter: ((cid = 3,395) AND (company_user_type_id = 2))
23. 1.606 1.606 ↑ 898,482.0 1 1

Index Scan using idx_files_cid_file_type_id on files f1 (cost=0.56..364,237.89 rows=898,482 width=28) (actual time=1.606..1.606 rows=1 loops=1)

  • Index Cond: ((cid = 3,395) AND (file_type_id = ft1.id))
24. 0.001 0.003 ↓ 0.0 0 1

Hash (cost=10.40..10.40 rows=40 width=4) (actual time=0.003..0.003 rows=0 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 8kB
25. 0.002 0.002 ↓ 0.0 0 1

Seq Scan on properties (cost=0.00..10.40 rows=40 width=4) (actual time=0.002..0.002 rows=0 loops=1)

26. 0.000 0.000 ↓ 0.0 0

Index Scan using idx_file_associations_cid_file_id on file_associations fa1 (cost=0.56..1.30 rows=17 width=8) (never executed)

  • Index Cond: ((cid = 3,395) AND (file_id = f1.id))
  • Filter: ((deleted_by IS NULL) AND (deleted_on IS NULL) AND (approved_on IS NULL) AND (approved_by IS NULL))
27. 0.000 0.000 ↓ 0.0 0

Index Scan using idx_document_addendas on document_addendas da (cost=0.29..0.31 rows=1 width=44) (never executed)

  • Index Cond: (id = f1.document_addenda_id)
  • Filter: ((cid = 3,395) AND (cid = f1.cid) AND (document_id = f1.document_id))
28.          

SubPlan (for Nested Loop Left Join)

29. 0.000 0.000 ↓ 0.0 0

Index Scan using idx_company_user_groups_company_user_id on company_user_groups (cost=0.29..3.18 rows=3 width=4) (never executed)

  • Index Cond: (company_user_id = cu.id)
  • Filter: (cid = cu.cid)
30. 0.003 0.006 ↓ 0.0 0 1

Sort (cost=104.93..104.93 rows=1 width=178) (actual time=0.006..0.006 rows=0 loops=1)

  • Sort Key: f.id
  • Sort Method: quicksort Memory: 25kB
31. 0.000 0.003 ↓ 0.0 0 1

Nested Loop Left Join (cost=2.14..104.92 rows=1 width=178) (actual time=0.003..0.003 rows=0 loops=1)

  • Filter: ((CASE WHEN (f.is_resident_verify = 1) THEN CASE WHEN (sar.id IS NOT NULL) THEN ((sar.request_status_type_id = 2) AND CASE WHEN (sar.screening_decision_type_id IS NOT NULL) THEN ((sar.screening_decision_type_id <> 3) AND CASE WHEN ((sar.screening_decision_type_id = 2) AND (alternatives: SubPlan 3 or hashed SubPlan 4)) THEN ((ap.lease_signed_on IS NOT NULL) AND (ap.lease_signature IS NOT NULL) AND (ap.lease_ip_address IS NOT NULL)) ELSE true END) ELSE NULL::boolean END) WHEN (sar.id IS NULL) THEN (sar.id IS NULL) ELSE NULL::boolean END ELSE true END AND (((ca.lease_interval_type_id = 1) AND ((SubPlan 5) IS NOT NULL) AND (pp.id IS NOT NULL)) OR (ca.lease_interval_type_id = ANY ('{3,4,5}'::integer[])) OR (pp.id IS NULL)) AND (f.applicant_id <> ALL ('{17731377,17736429,17741395,17756234,17762399,17764600,17764729,17791487,17794074,17811731,17825707,17842401,17848771,17854014,17856304,17871083,17873160,17886116,17886594,17888890,17893816,17899631,17909879,17916356,17923575,17928942,17938111,17943022,17945391,17947958,17959815,17965086,17965758,17968494,17969365,17969851,17972292,17982979,17983309,17985536,17985614,17994152,17994446,17996273}'::integer[])) AND (NOT (alternatives: SubPlan 6 or hashed SubPlan 7)) AND (ca.application_stage_id = 4) AND CASE WHEN (f.is_allow_lease_progression IS NULL) THEN (ca.application_status_id = 3) ELSE ((ca.application_status_id = ANY ('{2,3}'::integer[])) AND (ap.lease_signed_on IS NOT NULL)) END) OR ((ca.id IS NULL) AND (f.file_signed_on IS NOT NULL) AND ((cl.lease_status_type_id = 3) OR (cl.lease_status_type_id = 4))))
32. 0.000 0.003 ↓ 0.0 0 1

Nested Loop Left Join (cost=1.72..90.60 rows=1 width=254) (actual time=0.003..0.003 rows=0 loops=1)

  • Join Filter: (f.cid = sar.cid)
33. 0.001 0.003 ↓ 0.0 0 1

Nested Loop Left Join (cost=1.29..90.13 rows=1 width=234) (actual time=0.002..0.003 rows=0 loops=1)

34. 0.000 0.002 ↓ 0.0 0 1

Nested Loop Left Join (cost=0.86..87.48 rows=1 width=198) (actual time=0.002..0.002 rows=0 loops=1)

  • Filter: ((ca.lease_interval_type_id IS NOT NULL) OR ((f.application_id IS NULL) AND (alternatives: SubPlan 1 or hashed SubPlan 2)))
35. 0.000 0.002 ↓ 0.0 0 1

Nested Loop (cost=0.43..23.66 rows=1 width=170) (actual time=0.002..0.002 rows=0 loops=1)

  • Join Filter: (f.property_id = p.id)
36. 0.000 0.002 ↓ 0.0 0 1

Nested Loop (cost=0.43..13.15 rows=1 width=48) (actual time=0.002..0.002 rows=0 loops=1)

37. 0.002 0.002 ↓ 0.0 0 1

Seq Scan on f (cost=0.00..10.50 rows=1 width=44) (actual time=0.002..0.002 rows=0 loops=1)

  • Filter: (cid = 3,395)
38. 0.000 0.000 ↓ 0.0 0

Index Scan using pk_cached_leases on cached_leases cl (cost=0.43..2.65 rows=1 width=12) (never executed)

  • Index Cond: ((cid = 3,395) AND (id = f.lease_id))
39. 0.000 0.000 ↓ 0.0 0

Seq Scan on properties p (cost=0.00..10.50 rows=1 width=126) (never executed)

  • Filter: (cid = 3,395)
40. 0.000 0.000 ↓ 0.0 0

Index Scan using idx_cached_applications_id on cached_applications ca (cost=0.43..2.65 rows=1 width=28) (never executed)

  • Index Cond: (id = f.application_id)
  • Filter: ((cancelled_on IS NULL) AND (cid = 3,395) AND (cid = f.cid))
41.          

SubPlan (for Nested Loop Left Join)

42. 0.000 0.000 ↓ 0.0 0

Nested Loop Semi Join (cost=3.07..61.15 rows=1 width=0) (never executed)

  • Join Filter: (cf.property_id = properties_1.id)
43. 0.000 0.000 ↓ 0.0 0

Hash Join (cost=3.07..50.25 rows=1 width=4) (never executed)

  • Hash Cond: (cf.file_type_id = ft.id)
44. 0.000 0.000 ↓ 0.0 0

Index Scan using idx_files_file_id on files cf (cost=0.56..47.52 rows=88 width=12) (never executed)

  • Index Cond: ((cid = 3,395) AND (file_id = f.id))
45. 0.000 0.000 ↓ 0.0 0

Hash (cost=2.49..2.49 rows=1 width=8) (never executed)

46. 0.000 0.000 ↓ 0.0 0

Index Scan using idx_file_types_cid_system_code on file_types ft (cost=0.27..2.49 rows=1 width=8) (never executed)

  • Index Cond: ((cid = 3,395) AND ((system_code)::text = 'SIGNED'::text))
47. 0.000 0.000 ↓ 0.0 0

Seq Scan on properties properties_1 (cost=0.00..10.40 rows=40 width=4) (never executed)

48. 0.000 0.000 ↓ 0.0 0

Hash Semi Join (cost=11.74..373,587.58 rows=7,448 width=4) (never executed)

  • Hash Cond: (cf_1.property_id = properties_2.id)
49. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=0.84..373,225.20 rows=102,333 width=8) (never executed)

50. 0.000 0.000 ↓ 0.0 0

Index Scan using idx_file_types_cid_system_code on file_types ft_1 (cost=0.27..2.49 rows=1 width=8) (never executed)

  • Index Cond: ((cid = 3,395) AND ((system_code)::text = 'SIGNED'::text))
51. 0.000 0.000 ↓ 0.0 0

Index Scan using idx_files_cid_file_type_id on files cf_1 (cost=0.56..364,237.89 rows=898,482 width=16) (never executed)

  • Index Cond: ((cid = 3,395) AND (file_type_id = ft_1.id))
52. 0.000 0.000 ↓ 0.0 0

Hash (cost=10.40..10.40 rows=40 width=4) (never executed)

53. 0.000 0.000 ↓ 0.0 0

Seq Scan on properties properties_2 (cost=0.00..10.40 rows=40 width=4) (never executed)

54. 0.000 0.000 ↓ 0.0 0

Index Scan using uk_applicant_applications_cid_applicant_id_application_id on applicant_applications ap (cost=0.43..2.66 rows=1 width=48) (never executed)

  • Index Cond: ((cid = f.cid) AND (cid = 3,395) AND (applicant_id = f.applicant_id) AND (application_id = f.application_id))
  • Filter: (lease_signed_on IS NOT NULL)
55. 0.000 0.000 ↓ 0.0 0

Index Scan using idx_screening_application_requests_application_id on screening_application_requests sar (cost=0.42..0.45 rows=1 width=20) (never executed)

  • Index Cond: (ca.id = application_id)
  • Filter: (cid = 3,395)
56. 0.000 0.000 ↓ 0.0 0

Index Scan using uk_property_preferences_cid_property_id_key on property_preferences pp (cost=0.42..2.64 rows=1 width=12) (never executed)

  • Index Cond: ((cid = f.cid) AND (cid = 3,395) AND (property_id = f.property_id) AND ((key)::text = 'REQUIRE_RENTERS_INSURANCE_FOR_LEASE_APPROVAL'::text))
  • Filter: (value IS NOT NULL)
57.          

SubPlan (for Nested Loop Left Join)

58. 0.000 0.000 ↓ 0.0 0

Index Scan using idx_screening_application_condition_sets_application_id on screening_application_condition_sets sacs (cost=0.29..2.51 rows=1 width=0) (never executed)

  • Index Cond: (application_id = sar.application_id)
  • Filter: ((satisfied_by IS NULL) AND (satisfied_on IS NULL) AND (cid = sar.cid) AND (is_active = 1))
59. 0.000 0.000 ↓ 0.0 0

Seq Scan on screening_application_condition_sets sacs_1 (cost=0.00..1,110.89 rows=1,688 width=8) (never executed)

  • Filter: ((satisfied_by IS NULL) AND (satisfied_on IS NULL) AND (is_active = 1))
60. 0.000 0.000 ↓ 0.0 0

Limit (cost=5.90..5.91 rows=1 width=12) (never executed)

61. 0.000 0.000 ↓ 0.0 0

Sort (cost=5.90..5.91 rows=1 width=12) (never executed)

  • Sort Key: sub_rip.id DESC
62. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=0.84..5.89 rows=1 width=12) (never executed)

63. 0.000 0.000 ↓ 0.0 0

Index Scan using idx_insurance_policy_customers_lease_id on insurance_policy_customers ipc (cost=0.42..3.25 rows=1 width=8) (never executed)

  • Index Cond: (ca.lease_id = lease_id)
  • Filter: ((cid IS NOT NULL) AND (cid = f.cid) AND (f.application_id = application_id))
64. 0.000 0.000 ↓ 0.0 0

Index Scan using idx_resident_insurance_policies_id on resident_insurance_policies sub_rip (cost=0.42..2.65 rows=1 width=16) (never executed)

  • Index Cond: (id = ipc.resident_insurance_policy_id)
  • Filter: ((cid = f.cid) AND (insurance_policy_status_type_id = ANY ('{2,3,8}'::integer[])))
65. 0.000 0.000 ↓ 0.0 0

Index Scan using idx_applicant_applications_cid_application_id on applicant_applications aa (cost=0.43..3.16 rows=1 width=0) (never executed)

  • Index Cond: ((cid = ca.cid) AND (application_id = ca.id))
  • Filter: ((deleted_on IS NOT NULL) AND (customer_type_id = 1))
66. 0.000 0.000 ↓ 0.0 0

Gather (cost=1,000.00..124,290.25 rows=94,889 width=8) (never executed)

  • Workers Planned: 2
  • Workers Launched: 0
67. 0.000 0.000 ↓ 0.0 0

Parallel Seq Scan on applicant_applications aa_1 (cost=0.00..113,801.35 rows=39,537 width=8) (never executed)

  • Filter: ((deleted_on IS NOT NULL) AND (customer_type_id = 1))
68. 0.000 0.000 ↓ 0.0 0

Seq Scan on dashboard_priorities dp (cost=0.00..1.02 rows=1 width=36) (never executed)

  • Filter: (cid = 3,395)
69. 0.000 0.000 ↓ 0.0 0

Index Scan using idx_file_associations_cid_file_id on file_associations fa_1 (cost=0.56..20.51 rows=7 width=24) (never executed)

  • Index Cond: ((cid = 3,395) AND (file_id = f.id))
  • Filter: (((ca.id = application_id) AND (f.applicant_id = applicant_id)) OR (application_id IS NULL))
70. 0.000 0.000 ↓ 0.0 0

Index Scan using idx_lease_customers_cid_lease_id_customer_id_lease_status_type_ on lease_customers lc (cost=0.43..0.45 rows=1 width=20) (never executed)

  • Index Cond: ((cid = 3,395) AND (lease_id = fa_1.lease_id) AND (customer_id = fa_1.customer_id))
71. 0.000 0.000 ↓ 0.0 0

Index Scan using idx_customers_id on customers c (cost=0.43..0.45 rows=1 width=8) (never executed)

  • Index Cond: (id = fa_1.customer_id)
  • Filter: (cid = 3,395)
Planning time : 139.899 ms
Execution time : 2.746 ms