explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 1tvT

Settings
# exclusive inclusive rows x rows loops node
1. 0.003 35.498 ↑ 1.0 1 1

Aggregate (cost=361,639.31..361,639.32 rows=1 width=12) (actual time=35.498..35.498 rows=1 loops=1)

2. 0.000 35.495 ↓ 0.0 0 1

Subquery Scan on t (cost=361,639.26..361,639.30 rows=1 width=4) (actual time=35.495..35.495 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.001 35.495 ↓ 0.0 0 1

Unique (cost=361,639.26..361,639.29 rows=1 width=186) (actual time=35.495..35.495 rows=0 loops=1)

4. 0.014 35.494 ↓ 0.0 0 1

Sort (cost=361,639.26..361,639.26 rows=1 width=186) (actual time=35.494..35.494 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 35.480 ↓ 0.0 0 1

WindowAgg (cost=361,639.22..361,639.25 rows=1 width=186) (actual time=35.480..35.480 rows=0 loops=1)

6. 0.009 35.479 ↓ 0.0 0 1

Sort (cost=361,639.22..361,639.22 rows=1 width=178) (actual time=35.479..35.479 rows=0 loops=1)

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

Nested Loop (cost=361,616.21..361,639.21 rows=1 width=178) (actual time=35.470..35.470 rows=0 loops=1)

8. 0.001 35.469 ↓ 0.0 0 1

Nested Loop (cost=361,615.78..361,638.76 rows=1 width=186) (actual time=35.469..35.469 rows=0 loops=1)

9. 0.000 35.468 ↓ 0.0 0 1

Nested Loop (cost=361,615.35..361,635.58 rows=7 width=178) (actual time=35.468..35.468 rows=0 loops=1)

10. 0.001 35.468 ↓ 0.0 0 1

Group (cost=361,614.79..361,614.99 rows=1 width=290) (actual time=35.468..35.468 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.016 35.467 ↓ 0.0 0 1

Sort (cost=361,614.79..361,614.79 rows=1 width=290) (actual time=35.467..35.467 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.000 35.451 ↓ 0.0 0 1

Nested Loop Left Join (cost=361,610.95..361,614.78 rows=1 width=290) (actual time=35.451..35.451 rows=0 loops=1)

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

Merge Right Join (cost=361,610.95..361,613.58 rows=1 width=174) (actual time=35.451..35.451 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.001 35.437 ↓ 0.0 0 1

GroupAggregate (cost=361,507.03..361,508.55 rows=87 width=12) (actual time=35.437..35.437 rows=0 loops=1)

  • Group Key: f1.file_id
15. 0.008 35.436 ↓ 0.0 0 1

Sort (cost=361,507.03..361,507.25 rows=87 width=8) (actual time=35.436..35.436 rows=0 loops=1)

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

Nested Loop Left Join (cost=12.88..361,504.23 rows=87 width=8) (actual time=35.428..35.428 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.000 35.427 ↓ 0.0 0 1

Nested Loop Semi Join (cost=12.59..360,893.53 rows=174 width=32) (actual time=35.427..35.427 rows=0 loops=1)

18. 0.027 35.427 ↓ 0.0 0 1

Hash Semi Join (cost=12.03..356,319.41 rows=7,504 width=32) (actual time=35.427..35.427 rows=0 loops=1)

  • Hash Cond: (f1.property_id = properties.id)
19. 0.005 35.396 ↑ 102,176.0 1 1

Nested Loop (cost=1.12..355,956.81 rows=102,176 width=36) (actual time=35.396..35.396 rows=1 loops=1)

20. 0.004 28.175 ↑ 1.0 1 1

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

21. 1.709 1.709 ↑ 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=1.709..1.709 rows=1 loops=1)

  • Index Cond: ((cid = 3,395) AND ((system_code)::text = 'LA'::text))
22. 26.462 26.462 ↑ 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=26.462..26.462 rows=1 loops=1)

  • Index Cond: (id = 100,595)
  • Filter: ((cid = 3,395) AND (company_user_type_id = 2))
23. 7.216 7.216 ↑ 846,322.0 1 1

Index Scan using idx_files_cid_file_type_id on files f1 (cost=0.56..347,488.58 rows=846,322 width=28) (actual time=7.216..7.216 rows=1 loops=1)

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

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

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

Seq Scan on properties (cost=0.00..10.40 rows=40 width=4) (actual time=0.004..0.004 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.009 0.013 ↓ 0.0 0 1

Sort (cost=103.92..103.92 rows=1 width=178) (actual time=0.013..0.013 rows=0 loops=1)

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

Nested Loop Left Join (cost=2.14..103.91 rows=1 width=178) (actual time=0.004..0.004 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..89.59 rows=1 width=254) (actual time=0.003..0.003 rows=0 loops=1)

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

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

34. 0.001 0.003 ↓ 0.0 0 1

Nested Loop Left Join (cost=0.86..86.47 rows=1 width=198) (actual time=0.003..0.003 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..60.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..49.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..46.52 rows=86 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..356,316.89 rows=7,504 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..355,954.29 rows=102,176 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..347,488.58 rows=846,322 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 : 307.224 ms
Execution time : 36.616 ms