Details
On ClinicCurrencyConfig ClinicCurrencyConfig_clinicDomain_idx (clinicDomain) is covered by ClinicCurrencyConfig_clinicDomain_currency_key (clinicDomain, currency)
On ControlledSubstanceEntry ControlledSubstanceEntry_clinicDomain_branchId_registerBook_idx (clinicDomain, branchId, registerBook, sequenceNumber) is covered by ControlledSubstanceEntry_clinicDomain_branchId_registerBook_key (clinicDomain, branchId, registerBook, sequenceNumber)
On DrugInteraction DrugInteraction_ingredientA_idx (ingredientA) is covered by DrugInteraction_ingredientA_ingredientB_key (ingredientA, ingredientB)
On EmployeeContract EmployeeContract_clinicDomain_idx (clinicDomain) is covered by EmployeeContract_clinicDomain_contractNumber_key (clinicDomain, contractNumber)
On FinancialOutboxEvent FinancialOutboxEvent_clinicDomain_sourceType_sourceId_idx (clinicDomain, sourceType, sourceId) is covered by FinancialOutboxEvent_clinicDomain_sourceType_sourceId_idemp_key (clinicDomain, sourceType, sourceId, idempotencyVersion)
On LabNotificationRule LabNotificationRule_clinicDomain_idx (clinicDomain) is covered by LabNotificationRule_clinicDomain_notificationType_key (clinicDomain, notificationType)
On PlatformCashSnapshot PlatformCashSnapshot_asOfDate_idx (asOfDate) is covered by PlatformCashSnapshot_asOfDate_key (asOfDate)
On PolicyHolderOrganization PolicyHolderOrganization_clinicDomain_idx (clinicDomain) is covered by PolicyHolderOrganization_clinicDomain_name_key (clinicDomain, name)
On SalesAgentDailyScore SalesAgentDailyScore_clinicDomain_userId_day_idx (clinicDomain, userId, day) is covered by SalesAgentDailyScore_clinicDomain_userId_day_key (clinicDomain, userId, day)
On SalesDailyReport SalesDailyReport_clinicDomain_day_idx (clinicDomain, day) is covered by SalesDailyReport_clinicDomain_day_key (clinicDomain, day)
On SalesReviewRun SalesReviewRun_clinicDomain_day_idx (clinicDomain, day) is covered by SalesReviewRun_clinicDomain_day_trigger_key (clinicDomain, day, trigger)
On SessionDiagnosis SessionDiagnosis_sessionId_idx (sessionId) is covered by SessionDiagnosis_sessionId_sequence_key (sessionId, sequence)
On SpecialtyPracticeCode SpecialtyPracticeCode_clinicDomain_idx (clinicDomain) is covered by SpecialtyPracticeCode_clinicDomain_specialty_key (clinicDomain, specialty)
On StaffDevice StaffDevice_userId_idx (userId) is covered by StaffDevice_userId_deviceToken_key (userId, deviceToken)
On TelemedicineDailyReconciliation TelemedicineDailyReconciliation_clinicDomain_date_idx (clinicDomain, date) is covered by TelemedicineDailyReconciliation_clinicDomain_date_key (clinicDomain, date)

Total Time	Average Time	Calls
7 min 0.2%	53 ms	8,332 postgres
SELECT "public"."Invoice"."id", "public"."Invoice"."sessionId", "public"."Invoice"."orderId", "public"."Invoice"."accommodationId", "public"."Invoice"."note", "public"."Invoice"."status"::text, "public"."Invoice"."paymentStatus"::text, "public"."Invoice"."ownerId", "public"."Invoice"."total", "public"."Invoice"."totalTax", "public"."Invoice"."subTotal", "public"."Invoice"."discountValue", "public"."Invoice"."tierBenefitDiscount", "public"."Invoice"."rewardDiscount", "public"."Invoice"."giftCardAmount", "public"."Invoice"."appliedTierBenefit", "public"."Invoice"."restNotPaid", "public"."Invoice"."packageDiscount", "public"."Invoice"."manualDiscount", "public"."Invoice"."skipInsurance", "public"."Invoice"."skipLoyaltyDiscount", "public"."Invoice"."insuranceCoverageAmount", "public"."Invoice"."patientDeductibleAmount", "public"."Invoice"."insuranceDiscountAmount", "public"."Invoice"."forDoctor", "public"."Invoice"."forManagers", "public"."Invoice"."insurancePolicyClassId", "public"."Invoice"."forAssistant", "public"."Invoice"."forReferralDoctor", "public"."Invoice"."paymentAttach", "public"."Invoice"."clinicDomain", "public"."Invoice"."createdAt", "public"."Invoice"."updatedAt", "public"."Invoice"."link", "public"."Invoice"."points", "public"."Invoice"."consumablesTotal", "public"."Invoice"."consumablesPayByPatient", "public"."Invoice"."closingShiftId", "public"."Invoice"."isLocked", "public"."Invoice"."serialNumber", "public"."Invoice"."currency"::text, "public"."Invoice"."txCurrency"::text, "public"."Invoice"."txTotal", "public"."Invoice"."exchangeRate", "public"."Invoice"."rateSource"::text, "public"."Invoice"."exchangeRateId", "public"."Invoice"."rateEffectiveAt", "public"."Invoice"."ratePurpose"::text, "public"."Invoice"."rateEnteredById", "public"."Invoice"."rateNote", "public"."Invoice"."txRestNotPaid", "public"."Invoice"."fxResidual" FROM "public"."Invoice" WHERE ("public"."Invoice"."status" = CAST($1::text AS "public"."InvoiceStatus") AND "public"."Invoice"."restNotPaid" > $2 AND "public"."Invoice"."clinicDomain" = $3) ORDER BY "public"."Invoice"."createdAt" DESC LIMIT $4 OFFSET $5

Total Time	Average Time	Calls
37 min 1%	450 ms	4,889 postgres
SELECT "public"."Logs"."id", "public"."Logs"."operationType"::text, "public"."Logs"."details", "public"."Logs"."description", "public"."Logs"."diff", "public"."Logs"."type"::text, "public"."Logs"."userId", "public"."Logs"."clinicDomain", "public"."Logs"."patientProfileId", "public"."Logs"."patientProfileSettingsId", "public"."Logs"."sessionId", "public"."Logs"."operationDetailsId", "public"."Logs"."patientOperationId", "public"."Logs"."sessionSettingsId", "public"."Logs"."medicalReportId", "public"."Logs"."examinationId", "public"."Logs"."createdAt", "public"."Logs"."accountantSettingsId", "public"."Logs"."clinicFeaturesId", "public"."Logs"."prescriptionId", "public"."Logs"."targetUserId", "public"."Logs"."packageId", "public"."Logs"."branchId", "public"."Logs"."clinicId", "public"."Logs"."formResponseId", "public"."Logs"."packageSubscriptionId", "public"."Logs"."paymentTransactionId", "public"."Logs"."insuranceCompanyId", "public"."Logs"."insurancePolicyId", "public"."Logs"."updatedAt" FROM "public"."Logs" WHERE "public"."Logs"."clinicDomain" = $1 ORDER BY "public"."Logs"."createdAt" DESC LIMIT $2 OFFSET $3

Total Time	Average Time	Calls
6 min 0.2%	24 ms	13,951 postgres
SELECT "public"."Session"."id", "public"."Session"."from", "public"."Session"."to", "public"."Session"."doctorId", "public"."Session"."branchId" FROM "public"."Session" WHERE (("public"."Session"."from" < $1 AND "public"."Session"."to" > $2 AND "public"."Session"."status" IN (CAST($3::text AS "public"."SessionStatus"),CAST($4::text AS "public"."SessionStatus"),CAST($5::text AS "public"."SessionStatus"))) AND "public"."Session"."branchId" IN ($6)) ORDER BY "public"."Session"."from" ASC LIMIT $7 OFFSET $8

Slow Queries

Slow queries take 20 ms or more on average and have been called at least 100 times.

Explain queries to see where to add indexes.

Total Time	Average Time	Calls
677 min 22%	1,193 ms	34,038 postgres
SELECT SUM("total") AS "_sum$total", SUM("restNotPaid") AS "_sum$restNotPaid" FROM (SELECT "public"."Invoice"."total", "public"."Invoice"."restNotPaid" FROM "public"."Invoice" LEFT JOIN "public"."Order" AS "j0" ON ("j0"."id") = ("public"."Invoice"."orderId") LEFT JOIN "public"."Session" AS "j1" ON ("j1"."id") = ("public"."Invoice"."sessionId") LEFT JOIN "public"."PackageSubscription" AS "j2" ON ("j2"."invoiceId") = ("public"."Invoice"."id") WHERE (("j0"."patientProfileId" = $1 AND ("j0"."id" IS NOT NULL)) OR ("j1"."patientProfileId" = $2 AND "j1"."status" <> CAST($3::text AS "public"."SessionStatus") AND ("j1"."date" IS NULL OR "j1"."date" <= $4) AND ("j1"."id" IS NOT NULL)) OR ("j2"."patientProfileId" = $5 AND "j2"."status" <> CAST($6::text AS "public"."PackageSubscriptionStatus") AND "j2"."startDate" <= $7 AND ("j2"."id" IS NOT NULL))) OFFSET $8) AS "sub"
626 min 20%	1,103 ms	34,038 postgres
SELECT SUM("restNotPaid") AS "_sum$restNotPaid" FROM (SELECT "public"."Invoice"."restNotPaid" FROM "public"."Invoice" LEFT JOIN "public"."Session" AS "j0" ON ("j0"."id") = ("public"."Invoice"."sessionId") LEFT JOIN "public"."PackageSubscription" AS "j1" ON ("j1"."invoiceId") = ("public"."Invoice"."id") WHERE (("j0"."patientProfileId" = $1 AND "j0"."status" <> CAST($2::text AS "public"."SessionStatus") AND "j0"."date" > $3 AND ("j0"."id" IS NOT NULL)) OR ("j1"."patientProfileId" = $4 AND "j1"."status" <> CAST($5::text AS "public"."PackageSubscriptionStatus") AND "j1"."startDate" > $6 AND ("j1"."id" IS NOT NULL))) OFFSET $7) AS "sub"
135 min 4%	60 ms	136,235 postgres
SELECT "public"."VariablePropertyValue"."id", "public"."VariablePropertyValue"."value", "public"."VariablePropertyValue"."propertyId", "public"."VariablePropertyValue"."createdAt", "public"."VariablePropertyValue"."updatedAt", "public"."VariablePropertyValue"."patientProfileId" FROM "public"."VariablePropertyValue" LEFT JOIN "public"."PatientProfile" AS "j0" ON ("j0"."id") = ("public"."VariablePropertyValue"."patientProfileId") WHERE ("public"."VariablePropertyValue"."propertyId" = $1 AND "public"."VariablePropertyValue"."patientProfileId" = $2 AND ("j0"."clinicDomain" = $3 AND ("j0"."id" IS NOT NULL))) ORDER BY "public"."VariablePropertyValue"."createdAt" DESC LIMIT $4 OFFSET $5
126 min 4%	55 ms	136,235 postgres
`SELECT COUNT(*) AS "_count$_all" FROM (SELECT "public"."VariablePropertyValue"."id" FROM "public"."VariablePropertyValue" LEFT JOIN "public"."PatientProfile" AS "j0" ON ("j0"."id") = ("public"."VariablePropertyValue"."patientProfileId") WHERE ("public"."VariablePropertyValue"."propertyId" = $1 AND "public"."VariablePropertyValue"."patientProfileId" = $2 AND ("j0"."clinicDomain" = $3 AND ("j0"."id" IS NOT NULL))) OFFSET $4) AS "sub"`
73 min 2%	26 ms	168,201 postgres
SELECT "public"."PatientProfile"."id", "public"."PatientProfile"."avatar", "public"."PatientProfile"."name", "public"."PatientProfile"."phone", "public"."PatientProfile"."phoneCode", "public"."PatientProfile"."email", "public"."PatientProfile"."address", "public"."PatientProfile"."patientIndex", "public"."PatientProfile"."taxApplicable", "public"."PatientProfile"."freeNote", "public"."PatientProfile"."city", "public"."PatientProfile"."state", "public"."PatientProfile"."zip", "public"."PatientProfile"."country", "public"."PatientProfile"."nationalId", "public"."PatientProfile"."nationalIdType"::text, "public"."PatientProfile"."nationality", "public"."PatientProfile"."source", "public"."PatientProfile"."longitude", "public"."PatientProfile"."latitude", "public"."PatientProfile"."birthday", "public"."PatientProfile"."note", "public"."PatientProfile"."weight", "public"."PatientProfile"."aiSummary", "public"."PatientProfile"."aiSummaryGeneratedAt", "public"."PatientProfile"."aiSummaryData", "public"."PatientProfile"."type"::text, "public"."PatientProfile"."firstSessionDate", "public"."PatientProfile"."lastSessionDate", "public"."PatientProfile"."isActive", "public"."PatientProfile"."noShowCount", "public"."PatientProfile"."noShowDepositExempt", "public"."PatientProfile"."medicalHistory", "public"."PatientProfile"."clinicDomain", "public"."PatientProfile"."createdAt", "public"."PatientProfile"."updatedAt", "public"."PatientProfile"."referralDoctorId", "public"."PatientProfile"."referredById", "public"."PatientProfile"."whatsappCampaignId", "public"."PatientProfile"."link", "public"."PatientProfile"."branchId", "public"."PatientProfile"."petType", "public"."PatientProfile"."color", "public"."PatientProfile"."petStatus", "public"."PatientProfile"."petBreed", "public"."PatientProfile"."petName", "public"."PatientProfile"."isVaccinated", "public"."PatientProfile"."totalPayed", "public"."PatientProfile"."totalPayments", "public"."PatientProfile"."totalPaymentsRest", "public"."PatientProfile"."totalUpcomingPayments", "public"."PatientProfile"."telegramChatId", "public"."PatientProfile"."telegramUsername" FROM "public"."PatientProfile" WHERE (("public"."PatientProfile"."name" ILIKE $1 OR "public"."PatientProfile"."phone" ILIKE $2) AND "public"."PatientProfile"."clinicDomain" = $3) ORDER BY "public"."PatientProfile"."isActive" DESC, "public"."PatientProfile"."createdAt" DESC LIMIT $4 OFFSET $5
63 min 2%	104 ms	36,735 postgres
SELECT "public"."Examination"."id", "public"."Examination"."name", "public"."Examination"."isActive", "public"."Examination"."price", "public"."Examination"."telemedicinePrice", "public"."Examination"."specialties"::text[], "public"."Examination"."defaultTime", "public"."Examination"."telemedicineDefaultTime", "public"."Examination"."isDefault", "public"."Examination"."isMultiple", "public"."Examination"."isOperation", "public"."Examination"."clinicDomain", "public"."Examination"."order", "public"."Examination"."createdAt", "public"."Examination"."updatedAt", "public"."Examination"."doctorPercentage", "public"."Examination"."doctorFixedBonus", "public"."Examination"."managerPercentage", "public"."Examination"."managerFixedBonus", "public"."Examination"."category", "public"."Examination"."generalTags", "public"."Examination"."image", "public"."Examination"."color", "public"."Examination"."taxApplicable", "public"."Examination"."visitModes"::text[], "public"."Examination"."maxManualDiscountAmount", "public"."Examination"."maxManualDiscountPercentage", "public"."Examination"."description", "public"."Examination"."descriptionAr", "public"."Examination"."instructions", "public"."Examination"."instructionsAr", "public"."Examination"."terms", "public"."Examination"."termsAr", "public"."Examination"."images", "public"."Examination"."serviceDuration", "public"."Examination"."isSellableOnline", "public"."Examination"."procedureCodeId" FROM "public"."Examination" WHERE (EXISTS(SELECT "t0"."A" FROM "public"."_ExaminationToSession" AS "t0" INNER JOIN "public"."Session" AS "j0" ON ("j0"."id") = ("t0"."B") WHERE ("j0"."from" >= $1 AND "j0"."from" <= $2 AND ("public"."Examination"."id") = ("t0"."A") AND "t0"."A" IS NOT NULL)) AND (EXISTS(SELECT "t1"."B" FROM "public"."_BranchToExamination" AS "t1" INNER JOIN "public"."Branch" AS "j1" ON ("j1"."id") = ("t1"."A") WHERE ("j1"."id" = $3 AND ("public"."Examination"."id") = ("t1"."B") AND "t1"."B" IS NOT NULL)) OR NOT EXISTS(SELECT "t2"."B" FROM "public"."_BranchToExamination" AS "t2" INNER JOIN "public"."Branch" AS "j2" ON ("j2"."id") = ("t2"."A") WHERE ($8=$9 AND ("public"."Examination"."id") = ("t2"."B") AND "t2"."B" IS NOT NULL))) AND "public"."Examination"."clinicDomain" = $4 AND (NOT EXISTS(SELECT "t3"."B" FROM "public"."_BranchToExamination" AS "t3" INNER JOIN "public"."Branch" AS "j3" ON ("j3"."id") = ("t3"."A") WHERE ($10=$11 AND ("public"."Examination"."id") = ("t3"."B") AND "t3"."B" IS NOT NULL)) OR EXISTS(SELECT "t4"."B" FROM "public"."_BranchToExamination" AS "t4" INNER JOIN "public"."Branch" AS "j4" ON ("j4"."id") = ("t4"."A") WHERE ("j4"."id" IN ($5) AND ("public"."Examination"."id") = ("t4"."B") AND "t4"."B" IS NOT NULL)))) ORDER BY "public"."Examination"."id" ASC LIMIT $6 OFFSET $7
43 min 1%	308 ms	8,341 postgres
SELECT SUM("forDoctor") AS "_sum$forDoctor", SUM("forAssistant") AS "_sum$forAssistant", SUM("forReferralDoctor") AS "_sum$forReferralDoctor", SUM("consumablesTotal") AS "_sum$consumablesTotal", SUM("forManagers") AS "_sum$forManagers" FROM (SELECT "public"."Invoice"."forDoctor", "public"."Invoice"."forAssistant", "public"."Invoice"."forReferralDoctor", "public"."Invoice"."consumablesTotal", "public"."Invoice"."forManagers" FROM "public"."Invoice" LEFT JOIN "public"."PackageSubscription" AS "j0" ON ("j0"."invoiceId") = ("public"."Invoice"."id") LEFT JOIN "public"."PatientProfile" AS "j2" ON ("j2"."id") = ("j0"."patientProfileId") LEFT JOIN "public"."Session" AS "j3" ON ("j3"."id") = ("public"."Invoice"."sessionId") LEFT JOIN "public"."PatientProfile" AS "j4" ON ("j4"."id") = ("j3"."patientProfileId") LEFT JOIN "public"."Accommodation" AS "j5" ON ("j5"."id") = ("public"."Invoice"."accommodationId") LEFT JOIN "public"."PatientProfile" AS "j6" ON ("j6"."id") = ("j5"."patientProfileId") WHERE ("public"."Invoice"."clinicDomain" = $1 AND ((NOT EXISTS(SELECT "t1"."B" FROM "public"."_BranchToPackageSubscription" AS "t1" INNER JOIN "public"."Branch" AS "j1" ON ("j1"."id") = ("t1"."A") WHERE ((NOT "j1"."id" = $2) AND ("j0"."id") = ("t1"."B") AND "t1"."B" IS NOT NULL)) AND ("j2"."clinicDomain" = $3 AND ("j2"."id" IS NOT NULL)) AND "j0"."createdAt" >= $4 AND "j0"."createdAt" <= $5 AND "j0"."status" <> CAST($6::text AS "public"."PackageSubscriptionStatus") AND ("j0"."id" IS NOT NULL)) OR ("j3"."branchId" = $7 AND ("j4"."clinicDomain" = $8 AND ("j4"."id" IS NOT NULL)) AND "j3"."from" >= $9 AND "j3"."from" <= $10 AND "j3"."status" <> CAST($11::text AS "public"."SessionStatus") AND ("j3"."id" IS NOT NULL)) OR ("j6"."clinicDomain" = $12 AND ("j6"."id" IS NOT NULL) AND ("j5"."id" IS NOT NULL)))) OFFSET $13) AS "sub"
40 min 1%	72 ms	33,662 postgres
SELECT "public"."PrescriptionUnit"."id", "public"."PrescriptionUnit"."isTemplate", "public"."PrescriptionUnit"."medicineId", "public"."PrescriptionUnit"."repetitionId", "public"."PrescriptionUnit"."periodId", "public"."PrescriptionUnit"."noteId", "public"."PrescriptionUnit"."order", "public"."PrescriptionUnit"."clinicDomain", "public"."PrescriptionUnit"."createdAt", "public"."PrescriptionUnit"."updatedAt", "public"."PrescriptionUnit"."drugId", "public"."PrescriptionUnit"."drugNameSnapshot", "public"."PrescriptionUnit"."doseAmount", "public"."PrescriptionUnit"."doseUnitId", "public"."PrescriptionUnit"."routeId", "public"."PrescriptionUnit"."frequencyId", "public"."PrescriptionUnit"."durationDays", "public"."PrescriptionUnit"."isPrn", "public"."PrescriptionUnit"."prnCondition", "public"."PrescriptionUnit"."quantityToDispense", "public"."PrescriptionUnit"."refillsAllowed", "public"."PrescriptionUnit"."instructionsAr", "public"."PrescriptionUnit"."instructionsEn" FROM "public"."PrescriptionUnit" LEFT JOIN "public"."UniqueText" AS "j0" ON ("j0"."id") = ("public"."PrescriptionUnit"."medicineId") WHERE ("public"."PrescriptionUnit"."isTemplate" = $1 AND ("j0"."text" ILIKE $2 AND ("j0"."id" IS NOT NULL)) AND "public"."PrescriptionUnit"."clinicDomain" = $3) ORDER BY "public"."PrescriptionUnit"."isTemplate" DESC LIMIT $4 OFFSET $5
37 min 1%	450 ms	4,889 postgres
SELECT "public"."Logs"."id", "public"."Logs"."operationType"::text, "public"."Logs"."details", "public"."Logs"."description", "public"."Logs"."diff", "public"."Logs"."type"::text, "public"."Logs"."userId", "public"."Logs"."clinicDomain", "public"."Logs"."patientProfileId", "public"."Logs"."patientProfileSettingsId", "public"."Logs"."sessionId", "public"."Logs"."operationDetailsId", "public"."Logs"."patientOperationId", "public"."Logs"."sessionSettingsId", "public"."Logs"."medicalReportId", "public"."Logs"."examinationId", "public"."Logs"."createdAt", "public"."Logs"."accountantSettingsId", "public"."Logs"."clinicFeaturesId", "public"."Logs"."prescriptionId", "public"."Logs"."targetUserId", "public"."Logs"."packageId", "public"."Logs"."branchId", "public"."Logs"."clinicId", "public"."Logs"."formResponseId", "public"."Logs"."packageSubscriptionId", "public"."Logs"."paymentTransactionId", "public"."Logs"."insuranceCompanyId", "public"."Logs"."insurancePolicyId", "public"."Logs"."updatedAt" FROM "public"."Logs" WHERE "public"."Logs"."clinicDomain" = $1 ORDER BY "public"."Logs"."createdAt" DESC LIMIT $2 OFFSET $3 Details `CREATE INDEX CONCURRENTLY ON Logs (clinicDomain, createdAt)` `Rows: 1729972 Row progression: 1729972, 7149, 0 Row estimates - clinicDomain (=): 7149 - createdAt (sort): 1 Existing indexes - id PRIMARY`
29 min 0.9%	206 ms	8,362 postgres
SELECT SUM("total") AS "_sum$total" FROM (SELECT "public"."Invoice"."total" FROM "public"."Invoice" LEFT JOIN "public"."PackageSubscription" AS "j0" ON ("j0"."invoiceId") = ("public"."Invoice"."id") LEFT JOIN "public"."PatientProfile" AS "j2" ON ("j2"."id") = ("j0"."patientProfileId") LEFT JOIN "public"."Order" AS "j3" ON ("j3"."id") = ("public"."Invoice"."orderId") LEFT JOIN "public"."PatientProfile" AS "j4" ON ("j4"."id") = ("j3"."patientProfileId") LEFT JOIN "public"."Session" AS "j5" ON ("j5"."id") = ("public"."Invoice"."sessionId") LEFT JOIN "public"."PatientProfile" AS "j6" ON ("j6"."id") = ("j5"."patientProfileId") LEFT JOIN "public"."Accommodation" AS "j7" ON ("j7"."id") = ("public"."Invoice"."accommodationId") LEFT JOIN "public"."PatientProfile" AS "j8" ON ("j8"."id") = ("j7"."patientProfileId") WHERE ("public"."Invoice"."clinicDomain" = $1 AND ((NOT EXISTS(SELECT "t1"."B" FROM "public"."_BranchToPackageSubscription" AS "t1" INNER JOIN "public"."Branch" AS "j1" ON ("j1"."id") = ("t1"."A") WHERE ((NOT "j1"."id" = $2) AND ("j0"."id") = ("t1"."B") AND "t1"."B" IS NOT NULL)) AND ("j2"."clinicDomain" = $3 AND ("j2"."id" IS NOT NULL)) AND "j0"."createdAt" >= $4 AND "j0"."createdAt" <= $5 AND "j0"."status" <> CAST($6::text AS "public"."PackageSubscriptionStatus") AND ("j0"."id" IS NOT NULL)) OR ("j3"."branchId" IN ($7) AND ("j4"."clinicDomain" = $8 AND ("j4"."id" IS NOT NULL)) AND "j3"."createdAt" >= $9 AND "j3"."createdAt" <= $10 AND ("j3"."id" IS NOT NULL)) OR ("j5"."branchId" = $11 AND ("j6"."clinicDomain" = $12 AND ("j6"."id" IS NOT NULL)) AND "j5"."from" >= $13 AND "j5"."from" <= $14 AND "j5"."status" <> CAST($15::text AS "public"."SessionStatus") AND ("j5"."id" IS NOT NULL)) OR (("j8"."clinicDomain" = $16 AND ("j8"."id" IS NOT NULL)) AND "j7"."createdAt" >= $17 AND "j7"."createdAt" <= $18 AND ("j7"."id" IS NOT NULL))) AND "public"."Invoice"."status" = CAST($19::text AS "public"."InvoiceStatus")) OFFSET $20) AS "sub"
27 min 0.9%	309 ms	5,239 postgres
SELECT SUM("forDoctor") AS "_sum$forDoctor", SUM("forAssistant") AS "_sum$forAssistant", SUM("forReferralDoctor") AS "_sum$forReferralDoctor", SUM("consumablesTotal") AS "_sum$consumablesTotal", SUM("forManagers") AS "_sum$forManagers" FROM (SELECT "public"."Invoice"."forDoctor", "public"."Invoice"."forAssistant", "public"."Invoice"."forReferralDoctor", "public"."Invoice"."consumablesTotal", "public"."Invoice"."forManagers" FROM "public"."Invoice" LEFT JOIN "public"."PackageSubscription" AS "j0" ON ("j0"."invoiceId") = ("public"."Invoice"."id") LEFT JOIN "public"."PatientProfile" AS "j1" ON ("j1"."id") = ("j0"."patientProfileId") LEFT JOIN "public"."Session" AS "j2" ON ("j2"."id") = ("public"."Invoice"."sessionId") LEFT JOIN "public"."PatientProfile" AS "j3" ON ("j3"."id") = ("j2"."patientProfileId") LEFT JOIN "public"."Accommodation" AS "j4" ON ("j4"."id") = ("public"."Invoice"."accommodationId") LEFT JOIN "public"."PatientProfile" AS "j5" ON ("j5"."id") = ("j4"."patientProfileId") WHERE ("public"."Invoice"."clinicDomain" = $1 AND ((("j1"."clinicDomain" = $2 AND ("j1"."id" IS NOT NULL)) AND "j0"."createdAt" >= $3 AND "j0"."createdAt" <= $4 AND "j0"."status" <> CAST($5::text AS "public"."PackageSubscriptionStatus") AND ("j0"."id" IS NOT NULL)) OR ("j2"."status" <> CAST($6::text AS "public"."SessionStatus") AND ("j3"."clinicDomain" = $7 AND ("j3"."id" IS NOT NULL)) AND "j2"."from" >= $8 AND "j2"."from" <= $9 AND ("j2"."id" IS NOT NULL)) OR ("j5"."clinicDomain" = $10 AND ("j5"."id" IS NOT NULL) AND ("j4"."id" IS NOT NULL)))) OFFSET $11) AS "sub"
25 min 0.8%	377 ms	4,007 postgres
SELECT SUM("forDoctor") AS "_sum$forDoctor", SUM("forAssistant") AS "_sum$forAssistant", SUM("forReferralDoctor") AS "_sum$forReferralDoctor", SUM("consumablesTotal") AS "_sum$consumablesTotal", SUM("forManagers") AS "_sum$forManagers" FROM (SELECT "public"."Invoice"."forDoctor", "public"."Invoice"."forAssistant", "public"."Invoice"."forReferralDoctor", "public"."Invoice"."consumablesTotal", "public"."Invoice"."forManagers" FROM "public"."Invoice" LEFT JOIN "public"."PackageSubscription" AS "j0" ON ("j0"."invoiceId") = ("public"."Invoice"."id") LEFT JOIN "public"."PatientProfile" AS "j2" ON ("j2"."id") = ("j0"."patientProfileId") LEFT JOIN "public"."Session" AS "j3" ON ("j3"."id") = ("public"."Invoice"."sessionId") LEFT JOIN "public"."PatientProfile" AS "j4" ON ("j4"."id") = ("j3"."patientProfileId") LEFT JOIN "public"."Accommodation" AS "j5" ON ("j5"."id") = ("public"."Invoice"."accommodationId") LEFT JOIN "public"."PatientProfile" AS "j6" ON ("j6"."id") = ("j5"."patientProfileId") WHERE ("public"."Invoice"."clinicDomain" = $1 AND ((NOT EXISTS(SELECT "t1"."B" FROM "public"."_BranchToPackageSubscription" AS "t1" INNER JOIN "public"."Branch" AS "j1" ON ("j1"."id") = ("t1"."A") WHERE ((NOT "j1"."id" = $2) AND ("j0"."id") = ("t1"."B") AND "t1"."B" IS NOT NULL)) AND "j0"."doctorId" = $3 AND ("j2"."clinicDomain" = $4 AND ("j2"."id" IS NOT NULL)) AND "j0"."createdAt" >= $5 AND "j0"."createdAt" <= $6 AND "j0"."status" <> CAST($7::text AS "public"."PackageSubscriptionStatus") AND ("j0"."id" IS NOT NULL)) OR ("j3"."doctorId" = $8 AND "j3"."branchId" = $9 AND ("j4"."clinicDomain" = $10 AND ("j4"."id" IS NOT NULL)) AND "j3"."from" >= $11 AND "j3"."from" <= $12 AND "j3"."status" <> CAST($13::text AS "public"."SessionStatus") AND ("j3"."id" IS NOT NULL)) OR ("j6"."clinicDomain" = $14 AND ("j6"."id" IS NOT NULL) AND ("j5"."id" IS NOT NULL)))) OFFSET $15) AS "sub"
23 min 0.7%	284 ms	4,889 postgres
`SELECT COUNT(*) AS "_count$_all" FROM (SELECT "public"."Logs"."id" FROM "public"."Logs" WHERE "public"."Logs"."clinicDomain" = $1 OFFSET $2) AS "sub"`
22 min 0.7%	249 ms	5,302 postgres
SELECT "public"."Invoice"."id" FROM "public"."Invoice" LEFT JOIN "public"."Session" AS "j0" ON ("j0"."id") = ("public"."Invoice"."sessionId") LEFT JOIN "public"."PatientProfile" AS "j1" ON ("j1"."id") = ("j0"."patientProfileId") LEFT JOIN "public"."Invoice" AS "j2" ON ("j2"."sessionId") = ("j0"."id") WHERE ("public"."Invoice"."clinicDomain" = $1 AND ("j0"."branchId" = $2 AND ("j1"."clinicDomain" = $3 AND ("j1"."id" IS NOT NULL)) AND ("j0"."doctorId" IN ($4) OR (EXISTS(SELECT "t3"."invoiceId" FROM "public"."InvoiceUnit" AS "t3" WHERE ("t3"."doctorId" IN ($5) AND ("j2"."id") = ("t3"."invoiceId") AND "t3"."invoiceId" IS NOT NULL)) AND ("j2"."id" IS NOT NULL))) AND ("j0"."id" IS NOT NULL))) OFFSET $6
21 min 0.7%	5,150 ms	241 postgres
`SELECT "public"."Invoice"."id", "public"."Invoice"."clinicDomain" FROM "public"."Invoice" LEFT JOIN "public"."Session" AS "j0" ON ("j0"."id") = ("public"."Invoice"."sessionId") WHERE ("public"."Invoice"."status" = CAST($1::text AS "public"."InvoiceStatus") AND ("j0"."status" = CAST($2::text AS "public"."SessionStatus") AND ("j0"."id" IS NOT NULL))) ORDER BY "public"."Invoice"."id" ASC LIMIT $3 OFFSET $4`
20 min 0.6%	114 ms	10,406 postgres
SELECT "public"."Prescription"."id", "public"."Prescription"."name", "public"."Prescription"."noteId", "public"."Prescription"."previewUrl", "public"."Prescription"."isTemplate", "public"."Prescription"."sessionId", "public"."Prescription"."clinicDomain", "public"."Prescription"."order", "public"."Prescription"."link", "public"."Prescription"."createdAt", "public"."Prescription"."updatedAt", "public"."Prescription"."patientProfileId", "public"."Prescription"."nextAppointment", "public"."Prescription"."designTemplate" FROM "public"."Prescription" LEFT JOIN "public"."Session" AS "j0" ON ("j0"."id") = ("public"."Prescription"."sessionId") WHERE ((("j0"."patientProfileId" = $1 AND ("j0"."id" IS NOT NULL)) OR "public"."Prescription"."patientProfileId" = $2) AND "public"."Prescription"."clinicDomain" = $3) ORDER BY "public"."Prescription"."id" ASC LIMIT $4 OFFSET $5
19 min 0.6%	112 ms	10,406 postgres
`SELECT COUNT(*) AS "_count$_all" FROM (SELECT "public"."Prescription"."id" FROM "public"."Prescription" LEFT JOIN "public"."Session" AS "j0" ON ("j0"."id") = ("public"."Prescription"."sessionId") WHERE ((("j0"."patientProfileId" = $1 AND ("j0"."id" IS NOT NULL)) OR "public"."Prescription"."patientProfileId" = $2) AND "public"."Prescription"."clinicDomain" = $3) OFFSET $4) AS "sub"`
19 min 0.6%	138 ms	8,362 postgres
SELECT SUM("amount") AS "_sum$amount" FROM (SELECT "public"."PaymentTransaction"."amount" FROM "public"."PaymentTransaction" LEFT JOIN "public"."Invoice" AS "j0" ON ("j0"."id") = ("public"."PaymentTransaction"."invoiceId") LEFT JOIN "public"."PackageSubscription" AS "j1" ON ("j1"."invoiceId") = ("j0"."id") LEFT JOIN "public"."PatientProfile" AS "j3" ON ("j3"."id") = ("j1"."patientProfileId") LEFT JOIN "public"."Order" AS "j4" ON ("j4"."id") = ("j0"."orderId") LEFT JOIN "public"."PatientProfile" AS "j5" ON ("j5"."id") = ("j4"."patientProfileId") LEFT JOIN "public"."Session" AS "j6" ON ("j6"."id") = ("j0"."sessionId") LEFT JOIN "public"."PatientProfile" AS "j7" ON ("j7"."id") = ("j6"."patientProfileId") LEFT JOIN "public"."Accommodation" AS "j8" ON ("j8"."id") = ("j0"."accommodationId") LEFT JOIN "public"."PatientProfile" AS "j9" ON ("j9"."id") = ("j8"."patientProfileId") WHERE ("j0"."clinicDomain" = $1 AND ((NOT EXISTS(SELECT "t2"."B" FROM "public"."_BranchToPackageSubscription" AS "t2" INNER JOIN "public"."Branch" AS "j2" ON ("j2"."id") = ("t2"."A") WHERE ((NOT "j2"."id" = $2) AND ("j1"."id") = ("t2"."B") AND "t2"."B" IS NOT NULL)) AND ("j3"."clinicDomain" = $3 AND ("j3"."id" IS NOT NULL)) AND "j1"."createdAt" >= $4 AND "j1"."createdAt" <= $5 AND "j1"."status" <> CAST($6::text AS "public"."PackageSubscriptionStatus") AND ("j1"."id" IS NOT NULL)) OR ("j4"."branchId" IN ($7) AND ("j5"."clinicDomain" = $8 AND ("j5"."id" IS NOT NULL)) AND "j4"."createdAt" >= $9 AND "j4"."createdAt" <= $10 AND ("j4"."id" IS NOT NULL)) OR ("j6"."branchId" = $11 AND ("j7"."clinicDomain" = $12 AND ("j7"."id" IS NOT NULL)) AND "j6"."from" >= $13 AND "j6"."from" <= $14 AND "j6"."status" <> CAST($15::text AS "public"."SessionStatus") AND ("j6"."id" IS NOT NULL)) OR (("j9"."clinicDomain" = $16 AND ("j9"."id" IS NOT NULL)) AND "j8"."createdAt" >= $17 AND "j8"."createdAt" <= $18 AND ("j8"."id" IS NOT NULL))) AND "j0"."status" = CAST($19::text AS "public"."InvoiceStatus") AND ("j0"."id" IS NOT NULL)) OFFSET $20) AS "sub"
19 min 0.6%	63 ms	18,127 postgres
SELECT "public"."Examination"."id", "public"."Examination"."name", "public"."Examination"."isActive", "public"."Examination"."price", "public"."Examination"."telemedicinePrice", "public"."Examination"."specialties"::text[], "public"."Examination"."defaultTime", "public"."Examination"."telemedicineDefaultTime", "public"."Examination"."isDefault", "public"."Examination"."isMultiple", "public"."Examination"."isOperation", "public"."Examination"."clinicDomain", "public"."Examination"."order", "public"."Examination"."createdAt", "public"."Examination"."updatedAt", "public"."Examination"."doctorPercentage", "public"."Examination"."doctorFixedBonus", "public"."Examination"."managerPercentage", "public"."Examination"."managerFixedBonus", "public"."Examination"."category", "public"."Examination"."generalTags", "public"."Examination"."image", "public"."Examination"."color", "public"."Examination"."taxApplicable", "public"."Examination"."visitModes"::text[], "public"."Examination"."maxManualDiscountAmount", "public"."Examination"."maxManualDiscountPercentage", "public"."Examination"."description", "public"."Examination"."descriptionAr", "public"."Examination"."instructions", "public"."Examination"."instructionsAr", "public"."Examination"."terms", "public"."Examination"."termsAr", "public"."Examination"."images", "public"."Examination"."serviceDuration", "public"."Examination"."isSellableOnline", "public"."Examination"."procedureCodeId" FROM "public"."Examination" WHERE (EXISTS(SELECT "t0"."A" FROM "public"."_ExaminationToSession" AS "t0" INNER JOIN "public"."Session" AS "j0" ON ("j0"."id") = ("t0"."B") WHERE ("j0"."from" >= $1 AND "j0"."from" <= $2 AND ("public"."Examination"."id") = ("t0"."A") AND "t0"."A" IS NOT NULL)) AND (EXISTS(SELECT "t1"."B" FROM "public"."_BranchToExamination" AS "t1" INNER JOIN "public"."Branch" AS "j1" ON ("j1"."id") = ("t1"."A") WHERE ("j1"."id" = $3 AND ("public"."Examination"."id") = ("t1"."B") AND "t1"."B" IS NOT NULL)) OR NOT EXISTS(SELECT "t2"."B" FROM "public"."_BranchToExamination" AS "t2" INNER JOIN "public"."Branch" AS "j2" ON ("j2"."id") = ("t2"."A") WHERE ($7=$8 AND ("public"."Examination"."id") = ("t2"."B") AND "t2"."B" IS NOT NULL))) AND "public"."Examination"."clinicDomain" = $4) ORDER BY "public"."Examination"."id" ASC LIMIT $5 OFFSET $6
18 min 0.6%	52 ms	20,243 postgres
`SELECT MAX("serialNumber") AS "_max$serialNumber" FROM (SELECT "public"."Invoice"."serialNumber" FROM "public"."Invoice" WHERE "public"."Invoice"."clinicDomain" = $1 OFFSET $2) AS "sub"`
17 min 0.6%	205 ms	5,032 postgres
SELECT SUM("points") AS "_sum$points" FROM (SELECT "public"."LoyaltyTransaction"."points" FROM "public"."LoyaltyTransaction" LEFT JOIN "public"."PatientLoyalty" AS "j0" ON ("j0"."id") = ("public"."LoyaltyTransaction"."patientLoyaltyId") LEFT JOIN "public"."PatientProfile" AS "j1" ON ("j1"."id") = ("j0"."patientId") WHERE (("j1"."clinicDomain" = $1 AND ("j1"."id" IS NOT NULL) AND ("j0"."id" IS NOT NULL)) AND "public"."LoyaltyTransaction"."type" = CAST($2::text AS "public"."TransactionType") AND "public"."LoyaltyTransaction"."status" = CAST($3::text AS "public"."TransactionStatus")) OFFSET $4 /* traceparent='00-292d84f8c1dca4e08d320acb64bb4a50-245101a6fc7356e8-01' /) AS "sub" / traceparent='00-292d84f8c1dca4e08d320acb64bb4a50-245101a6fc7356e8-01' */
17 min 0.5%	440 ms	2,269 postgres
`UPDATE ONLY "public"."Logs" SET "patientProfileId" = NULL WHERE $1 OPERATOR(pg_catalog.=) "patientProfileId"`
16 min 0.5%	447 ms	2,093 postgres
SELECT "public"."Invoice"."id", "public"."Invoice"."sessionId", "public"."Invoice"."orderId", "public"."Invoice"."accommodationId", "public"."Invoice"."note", "public"."Invoice"."status"::text, "public"."Invoice"."paymentStatus"::text, "public"."Invoice"."ownerId", "public"."Invoice"."total", "public"."Invoice"."totalTax", "public"."Invoice"."subTotal", "public"."Invoice"."discountValue", "public"."Invoice"."tierBenefitDiscount", "public"."Invoice"."rewardDiscount", "public"."Invoice"."giftCardAmount", "public"."Invoice"."appliedTierBenefit", "public"."Invoice"."restNotPaid", "public"."Invoice"."packageDiscount", "public"."Invoice"."manualDiscount", "public"."Invoice"."skipInsurance", "public"."Invoice"."skipLoyaltyDiscount", "public"."Invoice"."insuranceCoverageAmount", "public"."Invoice"."patientDeductibleAmount", "public"."Invoice"."insuranceDiscountAmount", "public"."Invoice"."forDoctor", "public"."Invoice"."forManagers", "public"."Invoice"."insurancePolicyClassId", "public"."Invoice"."forAssistant", "public"."Invoice"."forReferralDoctor", "public"."Invoice"."paymentAttach", "public"."Invoice"."clinicDomain", "public"."Invoice"."createdAt", "public"."Invoice"."updatedAt", "public"."Invoice"."link", "public"."Invoice"."points", "public"."Invoice"."consumablesTotal", "public"."Invoice"."consumablesPayByPatient", "public"."Invoice"."closingShiftId", "public"."Invoice"."isLocked", "public"."Invoice"."serialNumber", "public"."Invoice"."currency"::text, "public"."Invoice"."txCurrency"::text, "public"."Invoice"."txTotal", "public"."Invoice"."exchangeRate", "public"."Invoice"."rateSource"::text, "public"."Invoice"."exchangeRateId", "public"."Invoice"."rateEffectiveAt", "public"."Invoice"."ratePurpose"::text, "public"."Invoice"."rateEnteredById", "public"."Invoice"."rateNote", "public"."Invoice"."txRestNotPaid", "public"."Invoice"."fxResidual" FROM "public"."Invoice" LEFT JOIN "public"."Session" AS "j0" ON ("j0"."id") = ("public"."Invoice"."sessionId") LEFT JOIN "public"."PackageSubscription" AS "j1" ON ("j1"."invoiceId") = ("public"."Invoice"."id") LEFT JOIN "public"."Order" AS "j2" ON ("j2"."id") = ("public"."Invoice"."orderId") LEFT JOIN "public"."Accommodation" AS "j3" ON ("j3"."id") = ("public"."Invoice"."accommodationId") WHERE ((("j0"."patientProfileId" = $1 AND ("j0"."id" IS NOT NULL)) OR ("j1"."patientProfileId" = $2 AND ("j1"."id" IS NOT NULL)) OR ("j2"."patientProfileId" = $3 AND ("j2"."id" IS NOT NULL)) OR ("j3"."patientProfileId" = $4 AND ("j3"."id" IS NOT NULL))) AND "public"."Invoice"."clinicDomain" = $5) ORDER BY "public"."Invoice"."id" DESC LIMIT $6 OFFSET $7
15 min 0.5%	45 ms	20,245 postgres
SELECT "public"."VariablePropertyValue"."id", "public"."VariablePropertyValue"."value", "public"."VariablePropertyValue"."propertyId", "public"."VariablePropertyValue"."createdAt", "public"."VariablePropertyValue"."updatedAt", "public"."VariablePropertyValue"."patientProfileId" FROM "public"."VariablePropertyValue" LEFT JOIN "public"."PatientProfile" AS "j0" ON ("j0"."id") = ("public"."VariablePropertyValue"."patientProfileId") WHERE ("public"."VariablePropertyValue"."patientProfileId" = $1 AND ("j0"."clinicDomain" = $2 AND ("j0"."id" IS NOT NULL))) ORDER BY "public"."VariablePropertyValue"."createdAt" DESC LIMIT $3 OFFSET $4
15 min 0.5%	67 ms	13,539 postgres
`SELECT SUM("amount") AS "_sum$amount" FROM (SELECT "public"."Expense"."amount" FROM "public"."Expense" WHERE ("public"."Expense"."clinicDomain" = $1 AND "public"."Expense"."date" >= $2 AND "public"."Expense"."date" <= $3 AND "public"."Expense"."branchId" IN ($4)) OFFSET $5) AS "sub"`
15 min 0.5%	164 ms	5,327 postgres
SELECT SUM("total") AS "_sum$total" FROM (SELECT "public"."Invoice"."total" FROM "public"."Invoice" LEFT JOIN "public"."PackageSubscription" AS "j0" ON ("j0"."invoiceId") = ("public"."Invoice"."id") LEFT JOIN "public"."PatientProfile" AS "j1" ON ("j1"."id") = ("j0"."patientProfileId") LEFT JOIN "public"."Order" AS "j2" ON ("j2"."id") = ("public"."Invoice"."orderId") LEFT JOIN "public"."PatientProfile" AS "j3" ON ("j3"."id") = ("j2"."patientProfileId") LEFT JOIN "public"."Session" AS "j4" ON ("j4"."id") = ("public"."Invoice"."sessionId") LEFT JOIN "public"."PatientProfile" AS "j5" ON ("j5"."id") = ("j4"."patientProfileId") LEFT JOIN "public"."Accommodation" AS "j6" ON ("j6"."id") = ("public"."Invoice"."accommodationId") LEFT JOIN "public"."PatientProfile" AS "j7" ON ("j7"."id") = ("j6"."patientProfileId") WHERE ("public"."Invoice"."clinicDomain" = $1 AND ((("j1"."clinicDomain" = $2 AND ("j1"."id" IS NOT NULL)) AND "j0"."createdAt" >= $3 AND "j0"."createdAt" <= $4 AND "j0"."status" <> CAST($5::text AS "public"."PackageSubscriptionStatus") AND ("j0"."id" IS NOT NULL)) OR (("j3"."clinicDomain" = $6 AND ("j3"."id" IS NOT NULL)) AND "j2"."createdAt" >= $7 AND "j2"."createdAt" <= $8 AND ("j2"."id" IS NOT NULL)) OR ("j4"."status" <> CAST($9::text AS "public"."SessionStatus") AND ("j5"."clinicDomain" = $10 AND ("j5"."id" IS NOT NULL)) AND "j4"."from" >= $11 AND "j4"."from" <= $12 AND ("j4"."id" IS NOT NULL)) OR (("j7"."clinicDomain" = $13 AND ("j7"."id" IS NOT NULL)) AND "j6"."createdAt" >= $14 AND "j6"."createdAt" <= $15 AND ("j6"."id" IS NOT NULL))) AND "public"."Invoice"."status" = CAST($16::text AS "public"."InvoiceStatus")) OFFSET $17) AS "sub"
14 min 0.4%	41 ms	20,245 postgres
`SELECT COUNT(*) AS "_count$_all" FROM (SELECT "public"."VariablePropertyValue"."id" FROM "public"."VariablePropertyValue" LEFT JOIN "public"."PatientProfile" AS "j0" ON ("j0"."id") = ("public"."VariablePropertyValue"."patientProfileId") WHERE ("public"."VariablePropertyValue"."patientProfileId" = $1 AND ("j0"."clinicDomain" = $2 AND ("j0"."id" IS NOT NULL))) OFFSET $3) AS "sub"`
14 min 0.4%	98 ms	8,362 postgres
SELECT SUM("amount") AS "_sum$amount" FROM (SELECT "public"."PaymentTransaction"."amount" FROM "public"."PaymentTransaction" LEFT JOIN "public"."PatientProfile" AS "j0" ON ("j0"."id") = ("public"."PaymentTransaction"."patientProfileId") LEFT JOIN "public"."Invoice" AS "j1" ON ("j1"."id") = ("public"."PaymentTransaction"."invoiceId") LEFT JOIN "public"."PackageSubscription" AS "j2" ON ("j2"."invoiceId") = ("j1"."id") LEFT JOIN "public"."PatientProfile" AS "j4" ON ("j4"."id") = ("j2"."patientProfileId") LEFT JOIN "public"."Session" AS "j5" ON ("j5"."id") = ("j1"."sessionId") LEFT JOIN "public"."PatientProfile" AS "j6" ON ("j6"."id") = ("j5"."patientProfileId") LEFT JOIN "public"."Accommodation" AS "j7" ON ("j7"."id") = ("j1"."accommodationId") LEFT JOIN "public"."PatientProfile" AS "j8" ON ("j8"."id") = ("j7"."patientProfileId") LEFT JOIN "public"."Order" AS "j9" ON ("j9"."id") = ("j1"."orderId") LEFT JOIN "public"."PatientProfile" AS "j10" ON ("j10"."id") = ("j9"."patientProfileId") WHERE ("public"."PaymentTransaction"."method" NOT IN (CAST($1::text AS "public"."PaymentMethod"),CAST($2::text AS "public"."PaymentMethod"),CAST($3::text AS "public"."PaymentMethod")) AND ("j0"."clinicDomain" = $4 AND ("j0"."id" IS NOT NULL)) AND "public"."PaymentTransaction"."createdAt" >= $5 AND "public"."PaymentTransaction"."createdAt" <= $6 AND "public"."PaymentTransaction"."amount" >= $7 AND (((NOT EXISTS(SELECT "t3"."B" FROM "public"."_BranchToPackageSubscription" AS "t3" INNER JOIN "public"."Branch" AS "j3" ON ("j3"."id") = ("t3"."A") WHERE ((NOT "j3"."id" = $8) AND ("j2"."id") = ("t3"."B") AND "t3"."B" IS NOT NULL)) AND ("j4"."clinicDomain" = $9 AND ("j4"."id" IS NOT NULL)) AND ("j2"."id" IS NOT NULL)) OR ("j5"."branchId" = $10 AND ("j6"."clinicDomain" = $11 AND ("j6"."id" IS NOT NULL)) AND ("j5"."id" IS NOT NULL)) OR ("j8"."clinicDomain" = $12 AND ("j8"."id" IS NOT NULL) AND ("j7"."id" IS NOT NULL)) OR ("j9"."branchId" IN ($13) AND ("j10"."clinicDomain" = $14 AND ("j10"."id" IS NOT NULL)) AND ("j9"."id" IS NOT NULL))) AND ("j1"."id" IS NOT NULL))) OFFSET $15) AS "sub"
13 min 0.4%	320 ms	2,516 postgres
SELECT COUNT() AS "_count$_all" FROM (SELECT "public"."LoyaltyTransaction"."id" FROM "public"."LoyaltyTransaction" LEFT JOIN "public"."PatientLoyalty" AS "j0" ON ("j0"."id") = ("public"."LoyaltyTransaction"."patientLoyaltyId") LEFT JOIN "public"."PatientProfile" AS "j1" ON ("j1"."id") = ("j0"."patientId") WHERE (("j1"."clinicDomain" = $1 AND ("j1"."id" IS NOT NULL) AND ("j0"."id" IS NOT NULL)) AND "public"."LoyaltyTransaction"."createdAt" >= $2) OFFSET $3 / traceparent='00-292d84f8c1dca4e08d320acb64bb4a50-419b9bfe82d19707-01' /) AS "sub" / traceparent='00-292d84f8c1dca4e08d320acb64bb4a50-419b9bfe82d19707-01' */
13 min 0.4%	149 ms	5,327 postgres
SELECT SUM("total") AS "_sum$total" FROM (SELECT "public"."Invoice"."total" FROM "public"."Invoice" LEFT JOIN "public"."Session" AS "j0" ON ("j0"."id") = ("public"."Invoice"."sessionId") LEFT JOIN "public"."PatientProfile" AS "j1" ON ("j1"."id") = ("j0"."patientProfileId") WHERE (("j0"."status" <> CAST($1::text AS "public"."SessionStatus") AND ("j1"."clinicDomain" = $2 AND ("j1"."id" IS NOT NULL)) AND "j0"."from" >= $3 AND "j0"."from" <= $4 AND ("j0"."id" IS NOT NULL)) AND "public"."Invoice"."clinicDomain" = $5) OFFSET $6) AS "sub"
13 min 0.4%	195 ms	4,045 postgres
SELECT SUM("total") AS "_sum$total" FROM (SELECT "public"."Invoice"."total" FROM "public"."Invoice" LEFT JOIN "public"."PackageSubscription" AS "j0" ON ("j0"."invoiceId") = ("public"."Invoice"."id") LEFT JOIN "public"."PatientProfile" AS "j2" ON ("j2"."id") = ("j0"."patientProfileId") LEFT JOIN "public"."Session" AS "j3" ON ("j3"."id") = ("public"."Invoice"."sessionId") LEFT JOIN "public"."PatientProfile" AS "j4" ON ("j4"."id") = ("j3"."patientProfileId") LEFT JOIN "public"."Accommodation" AS "j5" ON ("j5"."id") = ("public"."Invoice"."accommodationId") LEFT JOIN "public"."PatientProfile" AS "j6" ON ("j6"."id") = ("j5"."patientProfileId") WHERE ("public"."Invoice"."clinicDomain" = $1 AND ((NOT EXISTS(SELECT "t1"."B" FROM "public"."_BranchToPackageSubscription" AS "t1" INNER JOIN "public"."Branch" AS "j1" ON ("j1"."id") = ("t1"."A") WHERE ((NOT "j1"."id" = $2) AND ("j0"."id") = ("t1"."B") AND "t1"."B" IS NOT NULL)) AND "j0"."doctorId" = $3 AND ("j2"."clinicDomain" = $4 AND ("j2"."id" IS NOT NULL)) AND "j0"."createdAt" >= $5 AND "j0"."createdAt" <= $6 AND "j0"."status" <> CAST($7::text AS "public"."PackageSubscriptionStatus") AND ("j0"."id" IS NOT NULL)) OR ("j3"."doctorId" = $8 AND "j3"."branchId" = $9 AND ("j4"."clinicDomain" = $10 AND ("j4"."id" IS NOT NULL)) AND "j3"."from" >= $11 AND "j3"."from" <= $12 AND "j3"."status" <> CAST($13::text AS "public"."SessionStatus") AND ("j3"."id" IS NOT NULL)) OR (("j6"."clinicDomain" = $14 AND ("j6"."id" IS NOT NULL)) AND "j5"."createdAt" >= $15 AND "j5"."createdAt" <= $16 AND ("j5"."id" IS NOT NULL))) AND "public"."Invoice"."status" = CAST($17::text AS "public"."InvoiceStatus")) OFFSET $18) AS "sub"
13 min 0.4%	94 ms	8,341 postgres
SELECT SUM("forDoctor") AS "_sum$forDoctor", SUM("forAssistant") AS "_sum$forAssistant", SUM("forReferralDoctor") AS "_sum$forReferralDoctor" FROM (SELECT "public"."PaymentTransaction"."forDoctor", "public"."PaymentTransaction"."forAssistant", "public"."PaymentTransaction"."forReferralDoctor" FROM "public"."PaymentTransaction" LEFT JOIN "public"."PatientProfile" AS "j0" ON ("j0"."id") = ("public"."PaymentTransaction"."patientProfileId") LEFT JOIN "public"."Invoice" AS "j1" ON ("j1"."id") = ("public"."PaymentTransaction"."invoiceId") LEFT JOIN "public"."PackageSubscription" AS "j2" ON ("j2"."invoiceId") = ("j1"."id") LEFT JOIN "public"."PatientProfile" AS "j4" ON ("j4"."id") = ("j2"."patientProfileId") LEFT JOIN "public"."Session" AS "j5" ON ("j5"."id") = ("j1"."sessionId") LEFT JOIN "public"."PatientProfile" AS "j6" ON ("j6"."id") = ("j5"."patientProfileId") LEFT JOIN "public"."Accommodation" AS "j7" ON ("j7"."id") = ("j1"."accommodationId") LEFT JOIN "public"."PatientProfile" AS "j8" ON ("j8"."id") = ("j7"."patientProfileId") LEFT JOIN "public"."Order" AS "j9" ON ("j9"."id") = ("j1"."orderId") LEFT JOIN "public"."PatientProfile" AS "j10" ON ("j10"."id") = ("j9"."patientProfileId") WHERE (("j0"."clinicDomain" = $1 AND ("j0"."id" IS NOT NULL)) AND "public"."PaymentTransaction"."createdAt" >= $2 AND "public"."PaymentTransaction"."createdAt" <= $3 AND (((NOT EXISTS(SELECT "t3"."B" FROM "public"."_BranchToPackageSubscription" AS "t3" INNER JOIN "public"."Branch" AS "j3" ON ("j3"."id") = ("t3"."A") WHERE ((NOT "j3"."id" = $4) AND ("j2"."id") = ("t3"."B") AND "t3"."B" IS NOT NULL)) AND ("j4"."clinicDomain" = $5 AND ("j4"."id" IS NOT NULL)) AND "j2"."status" <> CAST($6::text AS "public"."PackageSubscriptionStatus") AND ("j2"."id" IS NOT NULL)) OR ("j5"."branchId" = $7 AND ("j6"."clinicDomain" = $8 AND ("j6"."id" IS NOT NULL)) AND ("j5"."id" IS NOT NULL)) OR ("j8"."clinicDomain" = $9 AND ("j8"."id" IS NOT NULL) AND ("j7"."id" IS NOT NULL)) OR ("j9"."branchId" IN ($10) AND ("j10"."clinicDomain" = $11 AND ("j10"."id" IS NOT NULL)) AND ("j9"."id" IS NOT NULL))) AND ("j1"."id" IS NOT NULL))) OFFSET $12) AS "sub"
13 min 0.4%	146 ms	5,327 postgres
SELECT SUM("amount") AS "_sum$amount" FROM (SELECT "public"."PaymentTransaction"."amount" FROM "public"."PaymentTransaction" LEFT JOIN "public"."Invoice" AS "j0" ON ("j0"."id") = ("public"."PaymentTransaction"."invoiceId") LEFT JOIN "public"."PackageSubscription" AS "j1" ON ("j1"."invoiceId") = ("j0"."id") LEFT JOIN "public"."PatientProfile" AS "j2" ON ("j2"."id") = ("j1"."patientProfileId") LEFT JOIN "public"."Order" AS "j3" ON ("j3"."id") = ("j0"."orderId") LEFT JOIN "public"."PatientProfile" AS "j4" ON ("j4"."id") = ("j3"."patientProfileId") LEFT JOIN "public"."Session" AS "j5" ON ("j5"."id") = ("j0"."sessionId") LEFT JOIN "public"."PatientProfile" AS "j6" ON ("j6"."id") = ("j5"."patientProfileId") LEFT JOIN "public"."Accommodation" AS "j7" ON ("j7"."id") = ("j0"."accommodationId") LEFT JOIN "public"."PatientProfile" AS "j8" ON ("j8"."id") = ("j7"."patientProfileId") WHERE ("j0"."clinicDomain" = $1 AND ((("j2"."clinicDomain" = $2 AND ("j2"."id" IS NOT NULL)) AND "j1"."createdAt" >= $3 AND "j1"."createdAt" <= $4 AND "j1"."status" <> CAST($5::text AS "public"."PackageSubscriptionStatus") AND ("j1"."id" IS NOT NULL)) OR (("j4"."clinicDomain" = $6 AND ("j4"."id" IS NOT NULL)) AND "j3"."createdAt" >= $7 AND "j3"."createdAt" <= $8 AND ("j3"."id" IS NOT NULL)) OR ("j5"."status" <> CAST($9::text AS "public"."SessionStatus") AND ("j6"."clinicDomain" = $10 AND ("j6"."id" IS NOT NULL)) AND "j5"."from" >= $11 AND "j5"."from" <= $12 AND ("j5"."id" IS NOT NULL)) OR (("j8"."clinicDomain" = $13 AND ("j8"."id" IS NOT NULL)) AND "j7"."createdAt" >= $14 AND "j7"."createdAt" <= $15 AND ("j7"."id" IS NOT NULL))) AND "j0"."status" = CAST($16::text AS "public"."InvoiceStatus") AND ("j0"."id" IS NOT NULL)) OFFSET $17) AS "sub"
13 min 0.4%	80 ms	9,664 postgres
SELECT "public"."Drug"."id", "public"."Drug"."registrySource"::text, "public"."Drug"."registryCode", "public"."Drug"."region", "public"."Drug"."tradeName", "public"."Drug"."tradeNameAr", "public"."Drug"."genericName", "public"."Drug"."strength", "public"."Drug"."formId", "public"."Drug"."routeId", "public"."Drug"."manufacturer", "public"."Drug"."referencePrice", "public"."Drug"."referencePriceAt", "public"."Drug"."atcCode", "public"."Drug"."isControlled", "public"."Drug"."controlledSchedule", "public"."Drug"."isActive", "public"."Drug"."sourceGroup", "public"."Drug"."monograph", "public"."Drug"."createdAt", "public"."Drug"."updatedAt" FROM "public"."Drug" WHERE ("public"."Drug"."region" = $1 AND "public"."Drug"."isActive" = $2 AND ("public"."Drug"."tradeName" ILIKE $3 OR "public"."Drug"."genericName" ILIKE $4 OR EXISTS(SELECT "t0"."drugId" FROM "public"."DrugIngredient" AS "t0" WHERE ("t0"."name"::text LIKE $5 AND ("public"."Drug"."id") = ("t0"."drugId") AND "t0"."drugId" IS NOT NULL)))) ORDER BY "public"."Drug"."tradeName" ASC LIMIT $6 OFFSET $7
13 min 0.4%	187 ms	4,045 postgres
SELECT SUM("amount") AS "_sum$amount" FROM (SELECT "public"."PaymentTransaction"."amount" FROM "public"."PaymentTransaction" LEFT JOIN "public"."Invoice" AS "j0" ON ("j0"."id") = ("public"."PaymentTransaction"."invoiceId") LEFT JOIN "public"."PackageSubscription" AS "j1" ON ("j1"."invoiceId") = ("j0"."id") LEFT JOIN "public"."PatientProfile" AS "j3" ON ("j3"."id") = ("j1"."patientProfileId") LEFT JOIN "public"."Session" AS "j4" ON ("j4"."id") = ("j0"."sessionId") LEFT JOIN "public"."PatientProfile" AS "j5" ON ("j5"."id") = ("j4"."patientProfileId") LEFT JOIN "public"."Accommodation" AS "j6" ON ("j6"."id") = ("j0"."accommodationId") LEFT JOIN "public"."PatientProfile" AS "j7" ON ("j7"."id") = ("j6"."patientProfileId") WHERE ("j0"."clinicDomain" = $1 AND ((NOT EXISTS(SELECT "t2"."B" FROM "public"."_BranchToPackageSubscription" AS "t2" INNER JOIN "public"."Branch" AS "j2" ON ("j2"."id") = ("t2"."A") WHERE ((NOT "j2"."id" = $2) AND ("j1"."id") = ("t2"."B") AND "t2"."B" IS NOT NULL)) AND "j1"."doctorId" = $3 AND ("j3"."clinicDomain" = $4 AND ("j3"."id" IS NOT NULL)) AND "j1"."createdAt" >= $5 AND "j1"."createdAt" <= $6 AND "j1"."status" <> CAST($7::text AS "public"."PackageSubscriptionStatus") AND ("j1"."id" IS NOT NULL)) OR ("j4"."doctorId" = $8 AND "j4"."branchId" = $9 AND ("j5"."clinicDomain" = $10 AND ("j5"."id" IS NOT NULL)) AND "j4"."from" >= $11 AND "j4"."from" <= $12 AND "j4"."status" <> CAST($13::text AS "public"."SessionStatus") AND ("j4"."id" IS NOT NULL)) OR (("j7"."clinicDomain" = $14 AND ("j7"."id" IS NOT NULL)) AND "j6"."createdAt" >= $15 AND "j6"."createdAt" <= $16 AND ("j6"."id" IS NOT NULL))) AND "j0"."status" = CAST($17::text AS "public"."InvoiceStatus") AND ("j0"."id" IS NOT NULL)) OFFSET $18) AS "sub"
12 min 0.4%	89 ms	8,362 postgres
SELECT SUM("amount") AS "_sum$amount" FROM (SELECT "public"."PaymentTransaction"."amount" FROM "public"."PaymentTransaction" LEFT JOIN "public"."PatientProfile" AS "j0" ON ("j0"."id") = ("public"."PaymentTransaction"."patientProfileId") LEFT JOIN "public"."Invoice" AS "j1" ON ("j1"."id") = ("public"."PaymentTransaction"."invoiceId") LEFT JOIN "public"."PackageSubscription" AS "j2" ON ("j2"."invoiceId") = ("j1"."id") LEFT JOIN "public"."PatientProfile" AS "j4" ON ("j4"."id") = ("j2"."patientProfileId") LEFT JOIN "public"."Session" AS "j5" ON ("j5"."id") = ("j1"."sessionId") LEFT JOIN "public"."PatientProfile" AS "j6" ON ("j6"."id") = ("j5"."patientProfileId") LEFT JOIN "public"."Accommodation" AS "j7" ON ("j7"."id") = ("j1"."accommodationId") LEFT JOIN "public"."PatientProfile" AS "j8" ON ("j8"."id") = ("j7"."patientProfileId") LEFT JOIN "public"."Order" AS "j9" ON ("j9"."id") = ("j1"."orderId") LEFT JOIN "public"."PatientProfile" AS "j10" ON ("j10"."id") = ("j9"."patientProfileId") WHERE (("j0"."clinicDomain" = $1 AND ("j0"."id" IS NOT NULL)) AND "public"."PaymentTransaction"."createdAt" >= $2 AND "public"."PaymentTransaction"."createdAt" <= $3 AND "public"."PaymentTransaction"."amount" < $4 AND (((NOT EXISTS(SELECT "t3"."B" FROM "public"."_BranchToPackageSubscription" AS "t3" INNER JOIN "public"."Branch" AS "j3" ON ("j3"."id") = ("t3"."A") WHERE ((NOT "j3"."id" = $5) AND ("j2"."id") = ("t3"."B") AND "t3"."B" IS NOT NULL)) AND ("j4"."clinicDomain" = $6 AND ("j4"."id" IS NOT NULL)) AND ("j2"."id" IS NOT NULL)) OR ("j5"."branchId" = $7 AND ("j6"."clinicDomain" = $8 AND ("j6"."id" IS NOT NULL)) AND ("j5"."id" IS NOT NULL)) OR ("j8"."clinicDomain" = $9 AND ("j8"."id" IS NOT NULL) AND ("j7"."id" IS NOT NULL)) OR ("j9"."branchId" IN ($10) AND ("j10"."clinicDomain" = $11 AND ("j10"."id" IS NOT NULL)) AND ("j9"."id" IS NOT NULL))) AND ("j1"."id" IS NOT NULL))) OFFSET $12) AS "sub"
12 min 0.4%	136 ms	5,327 postgres
SELECT SUM("total") AS "_sum$total" FROM (SELECT "public"."Invoice"."total" FROM "public"."Invoice" LEFT JOIN "public"."Session" AS "j0" ON ("j0"."id") = ("public"."Invoice"."sessionId") LEFT JOIN "public"."PatientProfile" AS "j1" ON ("j1"."id") = ("j0"."patientProfileId") WHERE (("j0"."status" = CAST($1::text AS "public"."SessionStatus") AND ("j1"."clinicDomain" = $2 AND ("j1"."id" IS NOT NULL)) AND "j0"."from" >= $3 AND "j0"."from" <= $4 AND ("j0"."id" IS NOT NULL)) AND "public"."Invoice"."clinicDomain" = $5) OFFSET $6) AS "sub"
12 min 0.4%	285 ms	2,501 postgres
SELECT "public"."PatientProfile"."id", "public"."PatientProfile"."avatar", "public"."PatientProfile"."name", "public"."PatientProfile"."phone", "public"."PatientProfile"."phoneCode", "public"."PatientProfile"."email", "public"."PatientProfile"."address", "public"."PatientProfile"."patientIndex", "public"."PatientProfile"."taxApplicable", "public"."PatientProfile"."freeNote", "public"."PatientProfile"."city", "public"."PatientProfile"."state", "public"."PatientProfile"."zip", "public"."PatientProfile"."country", "public"."PatientProfile"."nationalId", "public"."PatientProfile"."nationalIdType"::text, "public"."PatientProfile"."nationality", "public"."PatientProfile"."source", "public"."PatientProfile"."longitude", "public"."PatientProfile"."latitude", "public"."PatientProfile"."birthday", "public"."PatientProfile"."note", "public"."PatientProfile"."weight", "public"."PatientProfile"."aiSummary", "public"."PatientProfile"."aiSummaryGeneratedAt", "public"."PatientProfile"."aiSummaryData", "public"."PatientProfile"."type"::text, "public"."PatientProfile"."firstSessionDate", "public"."PatientProfile"."lastSessionDate", "public"."PatientProfile"."isActive", "public"."PatientProfile"."noShowCount", "public"."PatientProfile"."noShowDepositExempt", "public"."PatientProfile"."medicalHistory", "public"."PatientProfile"."clinicDomain", "public"."PatientProfile"."createdAt", "public"."PatientProfile"."updatedAt", "public"."PatientProfile"."referralDoctorId", "public"."PatientProfile"."referredById", "public"."PatientProfile"."whatsappCampaignId", "public"."PatientProfile"."link", "public"."PatientProfile"."branchId", "public"."PatientProfile"."petType", "public"."PatientProfile"."color", "public"."PatientProfile"."petStatus", "public"."PatientProfile"."petBreed", "public"."PatientProfile"."petName", "public"."PatientProfile"."isVaccinated", "public"."PatientProfile"."totalPayed", "public"."PatientProfile"."totalPayments", "public"."PatientProfile"."totalPaymentsRest", "public"."PatientProfile"."totalUpcomingPayments", "public"."PatientProfile"."telegramChatId", "public"."PatientProfile"."telegramUsername" FROM "public"."PatientProfile" WHERE ("public"."PatientProfile"."isActive" = $1 AND ("public"."PatientProfile"."name" ILIKE $2 OR "public"."PatientProfile"."phone" IS NULL) AND "public"."PatientProfile"."id" <> $3 AND "public"."PatientProfile"."clinicDomain" = $4) ORDER BY "public"."PatientProfile"."id" ASC LIMIT $5 OFFSET $6
11 min 0.4%	63 ms	10,455 postgres
`SELECT SUM("public"."InvoiceUnit"."total") AS "_sum$total", "public"."InvoiceUnit"."examinationId" FROM "public"."InvoiceUnit" LEFT JOIN "public"."Invoice" AS "j0" ON ("j0"."id") = ("public"."InvoiceUnit"."invoiceId") WHERE ("public"."InvoiceUnit"."examinationId" IN ($1,$2) AND ($4=$5 AND ("j0"."id" IS NOT NULL))) GROUP BY "public"."InvoiceUnit"."examinationId" OFFSET $3`
11 min 0.3%	878 ms	740 postgres
SELECT SUM("forDoctor") AS "_sum$forDoctor", SUM("forAssistant") AS "_sum$forAssistant", SUM("forReferralDoctor") AS "_sum$forReferralDoctor", SUM("consumablesTotal") AS "_sum$consumablesTotal", SUM("forManagers") AS "_sum$forManagers" FROM (SELECT "public"."Invoice"."forDoctor", "public"."Invoice"."forAssistant", "public"."Invoice"."forReferralDoctor", "public"."Invoice"."consumablesTotal", "public"."Invoice"."forManagers" FROM "public"."Invoice" LEFT JOIN "public"."PackageSubscription" AS "j0" ON ("j0"."invoiceId") = ("public"."Invoice"."id") LEFT JOIN "public"."PatientProfile" AS "j2" ON ("j2"."id") = ("j0"."patientProfileId") LEFT JOIN "public"."Session" AS "j3" ON ("j3"."id") = ("public"."Invoice"."sessionId") LEFT JOIN "public"."PatientProfile" AS "j4" ON ("j4"."id") = ("j3"."patientProfileId") LEFT JOIN "public"."Accommodation" AS "j5" ON ("j5"."id") = ("public"."Invoice"."accommodationId") LEFT JOIN "public"."PatientProfile" AS "j6" ON ("j6"."id") = ("j5"."patientProfileId") WHERE ("public"."Invoice"."clinicDomain" = $1 AND ((NOT EXISTS(SELECT "t1"."B" FROM "public"."_BranchToPackageSubscription" AS "t1" INNER JOIN "public"."Branch" AS "j1" ON ("j1"."id") = ("t1"."A") WHERE ((NOT "j1"."id" = $2) AND ("j0"."id") = ("t1"."B") AND "t1"."B" IS NOT NULL)) AND "j0"."doctorId" = $3 AND ("j2"."clinicDomain" = $4 AND ("j2"."id" IS NOT NULL)) AND "j0"."createdAt" >= $5 AND "j0"."createdAt" <= $6 AND "j0"."status" <> CAST($7::text AS "public"."PackageSubscriptionStatus") AND ("j0"."id" IS NOT NULL)) OR ("j3"."doctorId" = $8 AND "j3"."shiftId" = $9 AND "j3"."branchId" = $10 AND ("j4"."clinicDomain" = $11 AND ("j4"."id" IS NOT NULL)) AND "j3"."from" >= $12 AND "j3"."from" <= $13 AND "j3"."status" <> CAST($14::text AS "public"."SessionStatus") AND ("j3"."id" IS NOT NULL)) OR ("j6"."clinicDomain" = $15 AND ("j6"."id" IS NOT NULL) AND ("j5"."id" IS NOT NULL)))) OFFSET $16) AS "sub"
10 min 0.3%	110 ms	5,327 postgres
SELECT SUM("amount") AS "_sum$amount" FROM (SELECT "public"."PaymentTransaction"."amount" FROM "public"."PaymentTransaction" LEFT JOIN "public"."PatientProfile" AS "j0" ON ("j0"."id") = ("public"."PaymentTransaction"."patientProfileId") LEFT JOIN "public"."Invoice" AS "j1" ON ("j1"."id") = ("public"."PaymentTransaction"."invoiceId") LEFT JOIN "public"."PackageSubscription" AS "j2" ON ("j2"."invoiceId") = ("j1"."id") LEFT JOIN "public"."PatientProfile" AS "j3" ON ("j3"."id") = ("j2"."patientProfileId") LEFT JOIN "public"."Session" AS "j4" ON ("j4"."id") = ("j1"."sessionId") LEFT JOIN "public"."PatientProfile" AS "j5" ON ("j5"."id") = ("j4"."patientProfileId") LEFT JOIN "public"."Accommodation" AS "j6" ON ("j6"."id") = ("j1"."accommodationId") LEFT JOIN "public"."PatientProfile" AS "j7" ON ("j7"."id") = ("j6"."patientProfileId") LEFT JOIN "public"."Order" AS "j8" ON ("j8"."id") = ("j1"."orderId") LEFT JOIN "public"."PatientProfile" AS "j9" ON ("j9"."id") = ("j8"."patientProfileId") WHERE ("public"."PaymentTransaction"."method" NOT IN (CAST($1::text AS "public"."PaymentMethod"),CAST($2::text AS "public"."PaymentMethod"),CAST($3::text AS "public"."PaymentMethod")) AND ("j0"."clinicDomain" = $4 AND ("j0"."id" IS NOT NULL)) AND "public"."PaymentTransaction"."createdAt" >= $5 AND "public"."PaymentTransaction"."createdAt" <= $6 AND "public"."PaymentTransaction"."amount" >= $7 AND ((("j3"."clinicDomain" = $8 AND ("j3"."id" IS NOT NULL) AND ("j2"."id" IS NOT NULL)) OR ("j4"."status" = CAST($9::text AS "public"."SessionStatus") AND ("j5"."clinicDomain" = $10 AND ("j5"."id" IS NOT NULL)) AND ("j4"."id" IS NOT NULL)) OR ("j7"."clinicDomain" = $11 AND ("j7"."id" IS NOT NULL) AND ("j6"."id" IS NOT NULL)) OR ("j9"."clinicDomain" = $12 AND ("j9"."id" IS NOT NULL) AND ("j8"."id" IS NOT NULL))) AND ("j1"."id" IS NOT NULL))) OFFSET $13) AS "sub"
10 min 0.3%	28 ms	20,258 postgres
SELECT "public"."PatientProfile"."id", "public"."PatientProfile"."avatar", "public"."PatientProfile"."name", "public"."PatientProfile"."phone", "public"."PatientProfile"."phoneCode", "public"."PatientProfile"."email", "public"."PatientProfile"."address", "public"."PatientProfile"."patientIndex", "public"."PatientProfile"."taxApplicable", "public"."PatientProfile"."freeNote", "public"."PatientProfile"."city", "public"."PatientProfile"."state", "public"."PatientProfile"."zip", "public"."PatientProfile"."country", "public"."PatientProfile"."nationalId", "public"."PatientProfile"."nationalIdType"::text, "public"."PatientProfile"."nationality", "public"."PatientProfile"."source", "public"."PatientProfile"."longitude", "public"."PatientProfile"."latitude", "public"."PatientProfile"."birthday", "public"."PatientProfile"."note", "public"."PatientProfile"."weight", "public"."PatientProfile"."aiSummary", "public"."PatientProfile"."aiSummaryGeneratedAt", "public"."PatientProfile"."aiSummaryData", "public"."PatientProfile"."type"::text, "public"."PatientProfile"."firstSessionDate", "public"."PatientProfile"."lastSessionDate", "public"."PatientProfile"."isActive", "public"."PatientProfile"."noShowCount", "public"."PatientProfile"."noShowDepositExempt", "public"."PatientProfile"."medicalHistory", "public"."PatientProfile"."clinicDomain", "public"."PatientProfile"."createdAt", "public"."PatientProfile"."updatedAt", "public"."PatientProfile"."referralDoctorId", "public"."PatientProfile"."referredById", "public"."PatientProfile"."whatsappCampaignId", "public"."PatientProfile"."link", "public"."PatientProfile"."branchId", "public"."PatientProfile"."petType", "public"."PatientProfile"."color", "public"."PatientProfile"."petStatus", "public"."PatientProfile"."petBreed", "public"."PatientProfile"."petName", "public"."PatientProfile"."isVaccinated", "public"."PatientProfile"."totalPayed", "public"."PatientProfile"."totalPayments", "public"."PatientProfile"."totalPaymentsRest", "public"."PatientProfile"."totalUpcomingPayments", "public"."PatientProfile"."telegramChatId", "public"."PatientProfile"."telegramUsername" FROM "public"."PatientProfile" WHERE ("public"."PatientProfile"."isActive" = $1 AND ("public"."PatientProfile"."name" ILIKE $2 OR "public"."PatientProfile"."phone" = $3) AND "public"."PatientProfile"."id" <> $4 AND "public"."PatientProfile"."clinicDomain" = $5) ORDER BY "public"."PatientProfile"."id" ASC LIMIT $6 OFFSET $7 /* traceparent='00-ac562ad2f8e7c9caee453d75bdac3156-433cd0ffe55210a4-01' */
9 min 0.3%	104 ms	5,327 postgres
SELECT SUM("amount") AS "_sum$amount" FROM (SELECT "public"."PaymentTransaction"."amount" FROM "public"."PaymentTransaction" LEFT JOIN "public"."PatientProfile" AS "j0" ON ("j0"."id") = ("public"."PaymentTransaction"."patientProfileId") LEFT JOIN "public"."Invoice" AS "j1" ON ("j1"."id") = ("public"."PaymentTransaction"."invoiceId") LEFT JOIN "public"."PackageSubscription" AS "j2" ON ("j2"."invoiceId") = ("j1"."id") LEFT JOIN "public"."PatientProfile" AS "j3" ON ("j3"."id") = ("j2"."patientProfileId") LEFT JOIN "public"."Session" AS "j4" ON ("j4"."id") = ("j1"."sessionId") LEFT JOIN "public"."PatientProfile" AS "j5" ON ("j5"."id") = ("j4"."patientProfileId") LEFT JOIN "public"."Accommodation" AS "j6" ON ("j6"."id") = ("j1"."accommodationId") LEFT JOIN "public"."PatientProfile" AS "j7" ON ("j7"."id") = ("j6"."patientProfileId") LEFT JOIN "public"."Order" AS "j8" ON ("j8"."id") = ("j1"."orderId") LEFT JOIN "public"."PatientProfile" AS "j9" ON ("j9"."id") = ("j8"."patientProfileId") WHERE (("j0"."clinicDomain" = $1 AND ("j0"."id" IS NOT NULL)) AND "public"."PaymentTransaction"."createdAt" >= $2 AND "public"."PaymentTransaction"."createdAt" <= $3 AND "public"."PaymentTransaction"."amount" < $4 AND ((("j3"."clinicDomain" = $5 AND ("j3"."id" IS NOT NULL) AND ("j2"."id" IS NOT NULL)) OR ("j4"."status" = CAST($6::text AS "public"."SessionStatus") AND ("j5"."clinicDomain" = $7 AND ("j5"."id" IS NOT NULL)) AND ("j4"."id" IS NOT NULL)) OR ("j7"."clinicDomain" = $8 AND ("j7"."id" IS NOT NULL) AND ("j6"."id" IS NOT NULL)) OR ("j9"."clinicDomain" = $9 AND ("j9"."id" IS NOT NULL) AND ("j8"."id" IS NOT NULL))) AND ("j1"."id" IS NOT NULL))) OFFSET $10) AS "sub"
9 min 0.3%	105 ms	5,239 postgres
SELECT SUM("forDoctor") AS "_sum$forDoctor", SUM("forAssistant") AS "_sum$forAssistant", SUM("forReferralDoctor") AS "_sum$forReferralDoctor" FROM (SELECT "public"."PaymentTransaction"."forDoctor", "public"."PaymentTransaction"."forAssistant", "public"."PaymentTransaction"."forReferralDoctor" FROM "public"."PaymentTransaction" LEFT JOIN "public"."PatientProfile" AS "j0" ON ("j0"."id") = ("public"."PaymentTransaction"."patientProfileId") LEFT JOIN "public"."Invoice" AS "j1" ON ("j1"."id") = ("public"."PaymentTransaction"."invoiceId") LEFT JOIN "public"."PackageSubscription" AS "j2" ON ("j2"."invoiceId") = ("j1"."id") LEFT JOIN "public"."PatientProfile" AS "j3" ON ("j3"."id") = ("j2"."patientProfileId") LEFT JOIN "public"."Session" AS "j4" ON ("j4"."id") = ("j1"."sessionId") LEFT JOIN "public"."PatientProfile" AS "j5" ON ("j5"."id") = ("j4"."patientProfileId") LEFT JOIN "public"."Accommodation" AS "j6" ON ("j6"."id") = ("j1"."accommodationId") LEFT JOIN "public"."PatientProfile" AS "j7" ON ("j7"."id") = ("j6"."patientProfileId") LEFT JOIN "public"."Order" AS "j8" ON ("j8"."id") = ("j1"."orderId") LEFT JOIN "public"."PatientProfile" AS "j9" ON ("j9"."id") = ("j8"."patientProfileId") WHERE (("j0"."clinicDomain" = $1 AND ("j0"."id" IS NOT NULL)) AND "public"."PaymentTransaction"."createdAt" >= $2 AND "public"."PaymentTransaction"."createdAt" <= $3 AND (((("j3"."clinicDomain" = $4 AND ("j3"."id" IS NOT NULL)) AND "j2"."status" <> CAST($5::text AS "public"."PackageSubscriptionStatus") AND ("j2"."id" IS NOT NULL)) OR ("j4"."status" = CAST($6::text AS "public"."SessionStatus") AND ("j5"."clinicDomain" = $7 AND ("j5"."id" IS NOT NULL)) AND ("j4"."id" IS NOT NULL)) OR ("j7"."clinicDomain" = $8 AND ("j7"."id" IS NOT NULL) AND ("j6"."id" IS NOT NULL)) OR ("j9"."clinicDomain" = $9 AND ("j9"."id" IS NOT NULL) AND ("j8"."id" IS NOT NULL))) AND ("j1"."id" IS NOT NULL))) OFFSET $10) AS "sub"
9 min 0.3%	550 ms	966 postgres
SELECT "public"."Session"."id", "public"."Session"."patientProfileId", "public"."Session"."packageSubscriptionId" FROM "public"."Session" LEFT JOIN "public"."PatientProfile" AS "j0" ON ("j0"."id") = ("public"."Session"."patientProfileId") LEFT JOIN "public"."Clinic" AS "j1" ON ("j1"."domain") = ("public"."Session"."clinicDomain") WHERE ("public"."Session"."status" IN (CAST($1::text AS "public"."SessionStatus"),CAST($2::text AS "public"."SessionStatus")) AND "public"."Session"."isPatientInWaitingRoom" = $3 AND "public"."Session"."to" < $4 AND "public"."Session"."to" > $5 AND "public"."Session"."noShowPolicyAppliedAt" IS NULL AND "public"."Session"."packageSubscriptionId" IS NOT NULL AND "public"."Session"."patientProfileId" IS NOT NULL AND ("j0"."noShowDepositExempt" = $6 AND ("j0"."id" IS NOT NULL)) AND ("j1"."isActive" = $7 AND ("j1"."id" IS NOT NULL))) OFFSET $8
8 min 0.3%	697 ms	724 postgres
`UPDATE ONLY "public"."Logs" SET "paymentTransactionId" = $2 WHERE $1 OPERATOR(pg_catalog.=) "paymentTransactionId"`
8 min 0.3%	195 ms	2,516 postgres
SELECT SUM("public"."LoyaltyTransaction"."points") AS "_sum$points", COUNT() AS "_count$_all", "public"."LoyaltyTransaction"."earnSource"::text FROM "public"."LoyaltyTransaction" LEFT JOIN "public"."PatientLoyalty" AS "j0" ON ("j0"."id") = ("public"."LoyaltyTransaction"."patientLoyaltyId") LEFT JOIN "public"."PatientProfile" AS "j1" ON ("j1"."id") = ("j0"."patientId") WHERE (("j1"."clinicDomain" = $1 AND ("j1"."id" IS NOT NULL) AND ("j0"."id" IS NOT NULL)) AND "public"."LoyaltyTransaction"."type" = CAST($2::text AS "public"."TransactionType") AND "public"."LoyaltyTransaction"."status" = CAST($3::text AS "public"."TransactionStatus")) GROUP BY "public"."LoyaltyTransaction"."earnSource" OFFSET $4 / traceparent='00-292d84f8c1dca4e08d320acb64bb4a50-09f81e5cda91a096-01' */
8 min 0.3%	29 ms	16,724 postgres
SELECT SUM("amount") AS "_sum$amount" FROM (SELECT "public"."PaymentTransaction"."amount" FROM "public"."PaymentTransaction" LEFT JOIN "public"."PatientProfile" AS "j0" ON ("j0"."id") = ("public"."PaymentTransaction"."patientProfileId") LEFT JOIN "public"."Invoice" AS "j1" ON ("j1"."id") = ("public"."PaymentTransaction"."invoiceId") LEFT JOIN "public"."PackageSubscription" AS "j2" ON ("j2"."invoiceId") = ("j1"."id") LEFT JOIN "public"."PatientProfile" AS "j4" ON ("j4"."id") = ("j2"."patientProfileId") LEFT JOIN "public"."Session" AS "j5" ON ("j5"."id") = ("j1"."sessionId") LEFT JOIN "public"."PatientProfile" AS "j6" ON ("j6"."id") = ("j5"."patientProfileId") LEFT JOIN "public"."Accommodation" AS "j7" ON ("j7"."id") = ("j1"."accommodationId") LEFT JOIN "public"."PatientProfile" AS "j8" ON ("j8"."id") = ("j7"."patientProfileId") LEFT JOIN "public"."Order" AS "j9" ON ("j9"."id") = ("j1"."orderId") LEFT JOIN "public"."PatientProfile" AS "j10" ON ("j10"."id") = ("j9"."patientProfileId") WHERE ("public"."PaymentTransaction"."method" = CAST($1::text AS "public"."PaymentMethod") AND ("j0"."clinicDomain" = $2 AND ("j0"."id" IS NOT NULL)) AND "public"."PaymentTransaction"."createdAt" >= $3 AND "public"."PaymentTransaction"."createdAt" <= $4 AND "public"."PaymentTransaction"."amount" >= $5 AND (((NOT EXISTS(SELECT "t3"."B" FROM "public"."_BranchToPackageSubscription" AS "t3" INNER JOIN "public"."Branch" AS "j3" ON ("j3"."id") = ("t3"."A") WHERE ((NOT "j3"."id" = $6) AND ("j2"."id") = ("t3"."B") AND "t3"."B" IS NOT NULL)) AND ("j4"."clinicDomain" = $7 AND ("j4"."id" IS NOT NULL)) AND ("j2"."id" IS NOT NULL)) OR ("j5"."branchId" = $8 AND ("j6"."clinicDomain" = $9 AND ("j6"."id" IS NOT NULL)) AND ("j5"."id" IS NOT NULL)) OR ("j8"."clinicDomain" = $10 AND ("j8"."id" IS NOT NULL) AND ("j7"."id" IS NOT NULL)) OR ("j9"."branchId" IN ($11) AND ("j10"."clinicDomain" = $12 AND ("j10"."id" IS NOT NULL)) AND ("j9"."id" IS NOT NULL))) AND ("j1"."id" IS NOT NULL))) OFFSET $13) AS "sub"
8 min 0.2%	44 ms	10,340 postgres
SELECT "public"."PackageSubscription"."id" FROM "public"."PackageSubscription" LEFT JOIN "public"."Package" AS "j4" ON ("j4"."id") = ("public"."PackageSubscription"."packageId") WHERE ("public"."PackageSubscription"."patientProfileId" = $1 AND (EXISTS(SELECT "t0"."B" FROM "public"."_BranchToPackageSubscription" AS "t0" INNER JOIN "public"."Branch" AS "j0" ON ("j0"."id") = ("t0"."A") WHERE ("j0"."id" = $2 AND ("public"."PackageSubscription"."id") = ("t0"."B") AND "t0"."B" IS NOT NULL)) OR NOT EXISTS(SELECT "t1"."B" FROM "public"."_BranchToPackageSubscription" AS "t1" INNER JOIN "public"."Branch" AS "j1" ON ("j1"."id") = ("t1"."A") WHERE ($9=$10 AND ("public"."PackageSubscription"."id") = ("t1"."B") AND "t1"."B" IS NOT NULL))) AND "public"."PackageSubscription"."status" = CAST($3::text AS "public"."PackageSubscriptionStatus") AND "public"."PackageSubscription"."isOnHold" = $4 AND (EXISTS(SELECT "t2"."packageSubscriptionId" FROM "public"."PackageSubscriptionUnit" AS "t2" WHERE ("t2"."examinationId" IN ($5) AND ("public"."PackageSubscription"."id") = ("t2"."packageSubscriptionId") AND "t2"."packageSubscriptionId" IS NOT NULL)) OR (NOT EXISTS(SELECT "t3"."packageSubscriptionId" FROM "public"."PackageSubscriptionUnit" AS "t3" WHERE ($11=$12 AND ("public"."PackageSubscription"."id") = ("t3"."packageSubscriptionId") AND "t3"."packageSubscriptionId" IS NOT NULL)) AND (EXISTS(SELECT "t5"."packageId" FROM "public"."PackageUnit" AS "t5" WHERE ("t5"."examinationId" IN ($6) AND ("j4"."id") = ("t5"."packageId") AND "t5"."packageId" IS NOT NULL)) AND ("j4"."id" IS NOT NULL))))) LIMIT $7 OFFSET $8
7 min 0.2%	53 ms	8,332 postgres
SELECT "public"."Invoice"."id", "public"."Invoice"."sessionId", "public"."Invoice"."orderId", "public"."Invoice"."accommodationId", "public"."Invoice"."note", "public"."Invoice"."status"::text, "public"."Invoice"."paymentStatus"::text, "public"."Invoice"."ownerId", "public"."Invoice"."total", "public"."Invoice"."totalTax", "public"."Invoice"."subTotal", "public"."Invoice"."discountValue", "public"."Invoice"."tierBenefitDiscount", "public"."Invoice"."rewardDiscount", "public"."Invoice"."giftCardAmount", "public"."Invoice"."appliedTierBenefit", "public"."Invoice"."restNotPaid", "public"."Invoice"."packageDiscount", "public"."Invoice"."manualDiscount", "public"."Invoice"."skipInsurance", "public"."Invoice"."skipLoyaltyDiscount", "public"."Invoice"."insuranceCoverageAmount", "public"."Invoice"."patientDeductibleAmount", "public"."Invoice"."insuranceDiscountAmount", "public"."Invoice"."forDoctor", "public"."Invoice"."forManagers", "public"."Invoice"."insurancePolicyClassId", "public"."Invoice"."forAssistant", "public"."Invoice"."forReferralDoctor", "public"."Invoice"."paymentAttach", "public"."Invoice"."clinicDomain", "public"."Invoice"."createdAt", "public"."Invoice"."updatedAt", "public"."Invoice"."link", "public"."Invoice"."points", "public"."Invoice"."consumablesTotal", "public"."Invoice"."consumablesPayByPatient", "public"."Invoice"."closingShiftId", "public"."Invoice"."isLocked", "public"."Invoice"."serialNumber", "public"."Invoice"."currency"::text, "public"."Invoice"."txCurrency"::text, "public"."Invoice"."txTotal", "public"."Invoice"."exchangeRate", "public"."Invoice"."rateSource"::text, "public"."Invoice"."exchangeRateId", "public"."Invoice"."rateEffectiveAt", "public"."Invoice"."ratePurpose"::text, "public"."Invoice"."rateEnteredById", "public"."Invoice"."rateNote", "public"."Invoice"."txRestNotPaid", "public"."Invoice"."fxResidual" FROM "public"."Invoice" WHERE ("public"."Invoice"."status" = CAST($1::text AS "public"."InvoiceStatus") AND "public"."Invoice"."restNotPaid" > $2 AND "public"."Invoice"."clinicDomain" = $3) ORDER BY "public"."Invoice"."createdAt" DESC LIMIT $4 OFFSET $5 Details `CREATE INDEX CONCURRENTLY ON Invoice (clinicDomain, restNotPaid)` `Rows: 739338 Row progression: 739338, 3345, 336 Row estimates - clinicDomain (=): 3345 - restNotPaid (>): 74264 - status (=): 246446 - createdAt (sort): 1 Existing indexes - id PRIMARY - accommodationId UNIQUE - clinicDomain, createdAt - clinicDomain, serialNumber UNIQUE - clinicDomain, txCurrency, createdAt - closingShiftId - exchangeRateId - orderId UNIQUE - sessionId UNIQUE`
7 min 0.2%	83 ms	5,288 postgres
`SELECT SUM("public"."InvoiceUnit"."total") AS "_sum$total", "public"."InvoiceUnit"."examinationId" FROM "public"."InvoiceUnit" LEFT JOIN "public"."Invoice" AS "j0" ON ("j0"."id") = ("public"."InvoiceUnit"."invoiceId") WHERE ("public"."InvoiceUnit"."examinationId" IN ($1,$2,$3,$4) AND ($6=$7 AND ("j0"."id" IS NOT NULL))) GROUP BY "public"."InvoiceUnit"."examinationId" OFFSET $5`
7 min 0.2%	59 ms	7,378 postgres
`SELECT SUM("amount") AS "_sum$amount" FROM (SELECT "public"."Expense"."amount" FROM "public"."Expense" WHERE ("public"."Expense"."clinicDomain" = $1 AND "public"."Expense"."date" >= $2 AND "public"."Expense"."date" <= $3) OFFSET $4) AS "sub"`
7 min 0.2%	106 ms	4,045 postgres
SELECT SUM("amount") AS "_sum$amount" FROM (SELECT "public"."PaymentTransaction"."amount" FROM "public"."PaymentTransaction" LEFT JOIN "public"."PatientProfile" AS "j0" ON ("j0"."id") = ("public"."PaymentTransaction"."patientProfileId") LEFT JOIN "public"."Invoice" AS "j1" ON ("j1"."id") = ("public"."PaymentTransaction"."invoiceId") LEFT JOIN "public"."PackageSubscription" AS "j2" ON ("j2"."invoiceId") = ("j1"."id") LEFT JOIN "public"."PatientProfile" AS "j4" ON ("j4"."id") = ("j2"."patientProfileId") LEFT JOIN "public"."Session" AS "j5" ON ("j5"."id") = ("j1"."sessionId") LEFT JOIN "public"."PatientProfile" AS "j6" ON ("j6"."id") = ("j5"."patientProfileId") LEFT JOIN "public"."Accommodation" AS "j7" ON ("j7"."id") = ("j1"."accommodationId") LEFT JOIN "public"."PatientProfile" AS "j8" ON ("j8"."id") = ("j7"."patientProfileId") WHERE ("public"."PaymentTransaction"."method" NOT IN (CAST($1::text AS "public"."PaymentMethod"),CAST($2::text AS "public"."PaymentMethod"),CAST($3::text AS "public"."PaymentMethod")) AND ("j0"."clinicDomain" = $4 AND ("j0"."id" IS NOT NULL)) AND "public"."PaymentTransaction"."createdAt" >= $5 AND "public"."PaymentTransaction"."createdAt" <= $6 AND "public"."PaymentTransaction"."amount" >= $7 AND (((NOT EXISTS(SELECT "t3"."B" FROM "public"."_BranchToPackageSubscription" AS "t3" INNER JOIN "public"."Branch" AS "j3" ON ("j3"."id") = ("t3"."A") WHERE ((NOT "j3"."id" = $8) AND ("j2"."id") = ("t3"."B") AND "t3"."B" IS NOT NULL)) AND "j2"."doctorId" = $9 AND ("j4"."clinicDomain" = $10 AND ("j4"."id" IS NOT NULL)) AND ("j2"."id" IS NOT NULL)) OR ("j5"."doctorId" = $11 AND "j5"."branchId" = $12 AND ("j6"."clinicDomain" = $13 AND ("j6"."id" IS NOT NULL)) AND ("j5"."id" IS NOT NULL)) OR ("j8"."clinicDomain" = $14 AND ("j8"."id" IS NOT NULL) AND ("j7"."id" IS NOT NULL))) AND ("j1"."id" IS NOT NULL))) OFFSET $15) AS "sub"
7 min 0.2%	65 ms	6,564 postgres
`SELECT SUM("public"."InvoiceUnit"."total") AS "_sum$total", "public"."InvoiceUnit"."examinationId" FROM "public"."InvoiceUnit" LEFT JOIN "public"."Invoice" AS "j0" ON ("j0"."id") = ("public"."InvoiceUnit"."invoiceId") WHERE ("public"."InvoiceUnit"."examinationId" IN ($1,$2,$3) AND ($5=$6 AND ("j0"."id" IS NOT NULL))) GROUP BY "public"."InvoiceUnit"."examinationId" OFFSET $4`
7 min 0.2%	39 ms	10,654 postgres
SELECT SUM("amount") AS "_sum$amount" FROM (SELECT "public"."PaymentTransaction"."amount" FROM "public"."PaymentTransaction" LEFT JOIN "public"."PatientProfile" AS "j0" ON ("j0"."id") = ("public"."PaymentTransaction"."patientProfileId") LEFT JOIN "public"."Invoice" AS "j1" ON ("j1"."id") = ("public"."PaymentTransaction"."invoiceId") LEFT JOIN "public"."PackageSubscription" AS "j2" ON ("j2"."invoiceId") = ("j1"."id") LEFT JOIN "public"."PatientProfile" AS "j3" ON ("j3"."id") = ("j2"."patientProfileId") LEFT JOIN "public"."Session" AS "j4" ON ("j4"."id") = ("j1"."sessionId") LEFT JOIN "public"."PatientProfile" AS "j5" ON ("j5"."id") = ("j4"."patientProfileId") LEFT JOIN "public"."Accommodation" AS "j6" ON ("j6"."id") = ("j1"."accommodationId") LEFT JOIN "public"."PatientProfile" AS "j7" ON ("j7"."id") = ("j6"."patientProfileId") LEFT JOIN "public"."Order" AS "j8" ON ("j8"."id") = ("j1"."orderId") LEFT JOIN "public"."PatientProfile" AS "j9" ON ("j9"."id") = ("j8"."patientProfileId") WHERE ("public"."PaymentTransaction"."method" = CAST($1::text AS "public"."PaymentMethod") AND ("j0"."clinicDomain" = $2 AND ("j0"."id" IS NOT NULL)) AND "public"."PaymentTransaction"."createdAt" >= $3 AND "public"."PaymentTransaction"."createdAt" <= $4 AND "public"."PaymentTransaction"."amount" >= $5 AND ((("j3"."clinicDomain" = $6 AND ("j3"."id" IS NOT NULL) AND ("j2"."id" IS NOT NULL)) OR ("j4"."status" = CAST($7::text AS "public"."SessionStatus") AND ("j5"."clinicDomain" = $8 AND ("j5"."id" IS NOT NULL)) AND ("j4"."id" IS NOT NULL)) OR ("j7"."clinicDomain" = $9 AND ("j7"."id" IS NOT NULL) AND ("j6"."id" IS NOT NULL)) OR ("j9"."clinicDomain" = $10 AND ("j9"."id" IS NOT NULL) AND ("j8"."id" IS NOT NULL))) AND ("j1"."id" IS NOT NULL))) OFFSET $11) AS "sub"
7 min 0.2%	131 ms	3,174 postgres
SELECT "public"."PatientProfile"."id", "public"."PatientProfile"."avatar", "public"."PatientProfile"."name", "public"."PatientProfile"."phone", "public"."PatientProfile"."phoneCode", "public"."PatientProfile"."email", "public"."PatientProfile"."address", "public"."PatientProfile"."patientIndex", "public"."PatientProfile"."taxApplicable", "public"."PatientProfile"."freeNote", "public"."PatientProfile"."city", "public"."PatientProfile"."state", "public"."PatientProfile"."zip", "public"."PatientProfile"."country", "public"."PatientProfile"."nationalId", "public"."PatientProfile"."nationalIdType"::text, "public"."PatientProfile"."nationality", "public"."PatientProfile"."source", "public"."PatientProfile"."longitude", "public"."PatientProfile"."latitude", "public"."PatientProfile"."birthday", "public"."PatientProfile"."note", "public"."PatientProfile"."weight", "public"."PatientProfile"."aiSummary", "public"."PatientProfile"."aiSummaryGeneratedAt", "public"."PatientProfile"."aiSummaryData", "public"."PatientProfile"."type"::text, "public"."PatientProfile"."firstSessionDate", "public"."PatientProfile"."lastSessionDate", "public"."PatientProfile"."isActive", "public"."PatientProfile"."noShowCount", "public"."PatientProfile"."noShowDepositExempt", "public"."PatientProfile"."medicalHistory", "public"."PatientProfile"."clinicDomain", "public"."PatientProfile"."createdAt", "public"."PatientProfile"."updatedAt", "public"."PatientProfile"."referralDoctorId", "public"."PatientProfile"."referredById", "public"."PatientProfile"."whatsappCampaignId", "public"."PatientProfile"."link", "public"."PatientProfile"."branchId", "public"."PatientProfile"."petType", "public"."PatientProfile"."color", "public"."PatientProfile"."petStatus", "public"."PatientProfile"."petBreed", "public"."PatientProfile"."petName", "public"."PatientProfile"."isVaccinated", "public"."PatientProfile"."totalPayed", "public"."PatientProfile"."totalPayments", "public"."PatientProfile"."totalPaymentsRest", "public"."PatientProfile"."totalUpcomingPayments", "public"."PatientProfile"."telegramChatId", "public"."PatientProfile"."telegramUsername" FROM "public"."PatientProfile" WHERE ("public"."PatientProfile"."isActive" = $1 AND "public"."PatientProfile"."clinicDomain" = $2) ORDER BY "public"."PatientProfile"."id" ASC LIMIT $3 OFFSET $4 `Covered by index on (clinicDomain, patientIndex) Rows: 293272 Row progression: 293272, 1125, 563 Row estimates - clinicDomain (=): 1125 - isActive (=): 146636 - id (sort): 1 Existing indexes - id PRIMARY - clinicDomain, link UNIQUE - clinicDomain, patientIndex UNIQUE - referredById`
6 min 0.2%	96 ms	4,022 postgres
`SELECT SUM("public"."InvoiceUnit"."total") AS "_sum$total", "public"."InvoiceUnit"."examinationId" FROM "public"."InvoiceUnit" LEFT JOIN "public"."Invoice" AS "j0" ON ("j0"."id") = ("public"."InvoiceUnit"."invoiceId") WHERE ("public"."InvoiceUnit"."examinationId" IN ($1,$2,$3,$4,$5) AND ($7=$8 AND ("j0"."id" IS NOT NULL))) GROUP BY "public"."InvoiceUnit"."examinationId" OFFSET $6`
6 min 0.2%	718 ms	539 postgres
SELECT SUM("forDoctor") AS "_sum$forDoctor", SUM("forAssistant") AS "_sum$forAssistant", SUM("forReferralDoctor") AS "_sum$forReferralDoctor", SUM("consumablesTotal") AS "_sum$consumablesTotal", SUM("forManagers") AS "_sum$forManagers" FROM (SELECT "public"."Invoice"."forDoctor", "public"."Invoice"."forAssistant", "public"."Invoice"."forReferralDoctor", "public"."Invoice"."consumablesTotal", "public"."Invoice"."forManagers" FROM "public"."Invoice" LEFT JOIN "public"."PackageSubscription" AS "j0" ON ("j0"."invoiceId") = ("public"."Invoice"."id") LEFT JOIN "public"."PatientProfile" AS "j2" ON ("j2"."id") = ("j0"."patientProfileId") LEFT JOIN "public"."Session" AS "j3" ON ("j3"."id") = ("public"."Invoice"."sessionId") LEFT JOIN "public"."PatientProfile" AS "j4" ON ("j4"."id") = ("j3"."patientProfileId") LEFT JOIN "public"."Accommodation" AS "j5" ON ("j5"."id") = ("public"."Invoice"."accommodationId") LEFT JOIN "public"."PatientProfile" AS "j6" ON ("j6"."id") = ("j5"."patientProfileId") WHERE ("public"."Invoice"."clinicDomain" = $1 AND ((NOT EXISTS(SELECT "t1"."B" FROM "public"."_BranchToPackageSubscription" AS "t1" INNER JOIN "public"."Branch" AS "j1" ON ("j1"."id") = ("t1"."A") WHERE ((NOT "j1"."id" = $2) AND ("j0"."id") = ("t1"."B") AND "t1"."B" IS NOT NULL)) AND ("j2"."clinicDomain" = $3 AND ("j2"."id" IS NOT NULL)) AND "j0"."createdAt" >= $4 AND "j0"."createdAt" <= $5 AND "j0"."status" <> CAST($6::text AS "public"."PackageSubscriptionStatus") AND ("j0"."id" IS NOT NULL)) OR ("j3"."shiftId" = $7 AND "j3"."branchId" = $8 AND ("j4"."clinicDomain" = $9 AND ("j4"."id" IS NOT NULL)) AND "j3"."from" >= $10 AND "j3"."from" <= $11 AND "j3"."status" <> CAST($12::text AS "public"."SessionStatus") AND ("j3"."id" IS NOT NULL)) OR ("j6"."clinicDomain" = $13 AND ("j6"."id" IS NOT NULL) AND ("j5"."id" IS NOT NULL)))) OFFSET $14) AS "sub"
6 min 0.2%	62 ms	6,177 postgres
`SELECT SUM("amount") AS "_sum$amount" FROM (SELECT "public"."Expense"."amount" FROM "public"."Expense" WHERE ("public"."Expense"."clinicDomain" = $1 AND "public"."Expense"."date" >= $2 AND "public"."Expense"."date" <= $3 AND "public"."Expense"."branchId" IN ($4) AND "public"."Expense"."toId" IN ($5)) OFFSET $6) AS "sub"`
6 min 0.2%	95 ms	4,045 postgres
SELECT SUM("amount") AS "_sum$amount" FROM (SELECT "public"."PaymentTransaction"."amount" FROM "public"."PaymentTransaction" LEFT JOIN "public"."PatientProfile" AS "j0" ON ("j0"."id") = ("public"."PaymentTransaction"."patientProfileId") LEFT JOIN "public"."Invoice" AS "j1" ON ("j1"."id") = ("public"."PaymentTransaction"."invoiceId") LEFT JOIN "public"."PackageSubscription" AS "j2" ON ("j2"."invoiceId") = ("j1"."id") LEFT JOIN "public"."PatientProfile" AS "j4" ON ("j4"."id") = ("j2"."patientProfileId") LEFT JOIN "public"."Session" AS "j5" ON ("j5"."id") = ("j1"."sessionId") LEFT JOIN "public"."PatientProfile" AS "j6" ON ("j6"."id") = ("j5"."patientProfileId") LEFT JOIN "public"."Accommodation" AS "j7" ON ("j7"."id") = ("j1"."accommodationId") LEFT JOIN "public"."PatientProfile" AS "j8" ON ("j8"."id") = ("j7"."patientProfileId") WHERE (("j0"."clinicDomain" = $1 AND ("j0"."id" IS NOT NULL)) AND "public"."PaymentTransaction"."createdAt" >= $2 AND "public"."PaymentTransaction"."createdAt" <= $3 AND "public"."PaymentTransaction"."amount" < $4 AND (((NOT EXISTS(SELECT "t3"."B" FROM "public"."_BranchToPackageSubscription" AS "t3" INNER JOIN "public"."Branch" AS "j3" ON ("j3"."id") = ("t3"."A") WHERE ((NOT "j3"."id" = $5) AND ("j2"."id") = ("t3"."B") AND "t3"."B" IS NOT NULL)) AND "j2"."doctorId" = $6 AND ("j4"."clinicDomain" = $7 AND ("j4"."id" IS NOT NULL)) AND ("j2"."id" IS NOT NULL)) OR ("j5"."doctorId" = $8 AND "j5"."branchId" = $9 AND ("j6"."clinicDomain" = $10 AND ("j6"."id" IS NOT NULL)) AND ("j5"."id" IS NOT NULL)) OR ("j8"."clinicDomain" = $11 AND ("j8"."id" IS NOT NULL) AND ("j7"."id" IS NOT NULL))) AND ("j1"."id" IS NOT NULL))) OFFSET $12) AS "sub"
6 min 0.2%	440 ms	867 postgres
SELECT "public"."Invoice"."id" FROM "public"."Invoice" LEFT JOIN "public"."Session" AS "j0" ON ("j0"."id") = ("public"."Invoice"."sessionId") LEFT JOIN "public"."PatientProfile" AS "j1" ON ("j1"."id") = ("j0"."patientProfileId") LEFT JOIN "public"."Invoice" AS "j2" ON ("j2"."sessionId") = ("j0"."id") WHERE ("public"."Invoice"."clinicDomain" = $1 AND ("j0"."shiftId" = $2 AND "j0"."branchId" = $3 AND ("j1"."clinicDomain" = $4 AND ("j1"."id" IS NOT NULL)) AND ("j0"."doctorId" IN ($5) OR (EXISTS(SELECT "t3"."invoiceId" FROM "public"."InvoiceUnit" AS "t3" WHERE ("t3"."doctorId" IN ($6) AND ("j2"."id") = ("t3"."invoiceId") AND "t3"."invoiceId" IS NOT NULL)) AND ("j2"."id" IS NOT NULL))) AND ("j0"."id" IS NOT NULL))) OFFSET $7
6 min 0.2%	83 ms	4,503 postgres
SELECT "public"."Invoice"."id", "public"."Invoice"."sessionId", "public"."Invoice"."orderId", "public"."Invoice"."accommodationId", "public"."Invoice"."note", "public"."Invoice"."status"::text, "public"."Invoice"."paymentStatus"::text, "public"."Invoice"."ownerId", "public"."Invoice"."total", "public"."Invoice"."totalTax", "public"."Invoice"."subTotal", "public"."Invoice"."discountValue", "public"."Invoice"."tierBenefitDiscount", "public"."Invoice"."rewardDiscount", "public"."Invoice"."giftCardAmount", "public"."Invoice"."appliedTierBenefit", "public"."Invoice"."restNotPaid", "public"."Invoice"."packageDiscount", "public"."Invoice"."manualDiscount", "public"."Invoice"."skipInsurance", "public"."Invoice"."skipLoyaltyDiscount", "public"."Invoice"."insuranceCoverageAmount", "public"."Invoice"."patientDeductibleAmount", "public"."Invoice"."insuranceDiscountAmount", "public"."Invoice"."forDoctor", "public"."Invoice"."forManagers", "public"."Invoice"."insurancePolicyClassId", "public"."Invoice"."forAssistant", "public"."Invoice"."forReferralDoctor", "public"."Invoice"."paymentAttach", "public"."Invoice"."clinicDomain", "public"."Invoice"."createdAt", "public"."Invoice"."updatedAt", "public"."Invoice"."link", "public"."Invoice"."points", "public"."Invoice"."consumablesTotal", "public"."Invoice"."consumablesPayByPatient", "public"."Invoice"."closingShiftId", "public"."Invoice"."isLocked", "public"."Invoice"."serialNumber", "public"."Invoice"."currency"::text, "public"."Invoice"."txCurrency"::text, "public"."Invoice"."txTotal", "public"."Invoice"."exchangeRate", "public"."Invoice"."rateSource"::text, "public"."Invoice"."exchangeRateId", "public"."Invoice"."rateEffectiveAt", "public"."Invoice"."ratePurpose"::text, "public"."Invoice"."rateEnteredById", "public"."Invoice"."rateNote", "public"."Invoice"."txRestNotPaid", "public"."Invoice"."fxResidual" FROM "public"."Invoice" LEFT JOIN "public"."Order" AS "j0" ON ("j0"."id") = ("public"."Invoice"."orderId") LEFT JOIN "public"."PackageSubscription" AS "j1" ON ("j1"."invoiceId") = ("public"."Invoice"."id") LEFT JOIN "public"."Session" AS "j2" ON ("j2"."id") = ("public"."Invoice"."sessionId") LEFT JOIN "public"."Accommodation" AS "j3" ON ("j3"."id") = ("public"."Invoice"."accommodationId") WHERE ("public"."Invoice"."status" = CAST($1::text AS "public"."InvoiceStatus") AND (("j0"."patientProfileId" = $2 AND ("j0"."id" IS NOT NULL)) OR ("j1"."patientProfileId" = $3 AND "j1"."status" <> CAST($4::text AS "public"."PackageSubscriptionStatus") AND ("j1"."id" IS NOT NULL)) OR ("j2"."patientProfileId" = $5 AND "j2"."status" <> CAST($6::text AS "public"."SessionStatus") AND ("j2"."id" IS NOT NULL)) OR ("j3"."patientProfileId" = $7 AND ("j3"."id" IS NOT NULL))) AND "public"."Invoice"."clinicDomain" = $8) ORDER BY "public"."Invoice"."id" DESC LIMIT $9 OFFSET $10
6 min 0.2%	85 ms	4,413 postgres
`SELECT SUM("public"."InvoiceUnit"."total") AS "_sum$total", "public"."InvoiceUnit"."examinationId" FROM "public"."InvoiceUnit" LEFT JOIN "public"."Invoice" AS "j0" ON ("j0"."id") = ("public"."InvoiceUnit"."invoiceId") WHERE ("public"."InvoiceUnit"."examinationId" IN ($1,$2,$3,$4,$5,$6) AND ($8=$9 AND ("j0"."id" IS NOT NULL))) GROUP BY "public"."InvoiceUnit"."examinationId" OFFSET $7`
6 min 0.2%	145 ms	2,516 postgres
SELECT "public"."PatientLoyalty"."id", "public"."PatientLoyalty"."patientId", "public"."PatientLoyalty"."points", "public"."PatientLoyalty"."tier"::text, "public"."PatientLoyalty"."createdAt", "public"."PatientLoyalty"."updatedAt" FROM "public"."PatientLoyalty" LEFT JOIN "public"."PatientProfile" AS "j0" ON ("j0"."id") = ("public"."PatientLoyalty"."patientId") WHERE ("j0"."clinicDomain" = $1 AND ("j0"."id" IS NOT NULL)) ORDER BY "public"."PatientLoyalty"."points" DESC LIMIT $2 OFFSET $3 /* traceparent='00-292d84f8c1dca4e08d320acb64bb4a50-f3cfff03cf1345ed-01' */
6 min 0.2%	69 ms	5,307 postgres
SELECT "public"."PackageSubscription"."id", "public"."PackageSubscription"."packageId", "public"."PackageSubscription"."patientProfileId", "public"."PackageSubscription"."invoiceId", "public"."PackageSubscription"."doctorId", "public"."PackageSubscription"."assistantId", "public"."PackageSubscription"."referralDoctorId", "public"."PackageSubscription"."status"::text, "public"."PackageSubscription"."isOnHold", "public"."PackageSubscription"."startDate", "public"."PackageSubscription"."endDate", "public"."PackageSubscription"."effectiveEndDate", "public"."PackageSubscription"."createdAt", "public"."PackageSubscription"."updatedAt", "public"."PackageSubscription"."finishedAt", "public"."PackageSubscription"."shiftId", "public"."PackageSubscription"."patientInsuranceId", "public"."PackageSubscription"."mainBranchId", "public"."PackageSubscription"."customPrice", "public"."PackageSubscription"."priceCurrency"::text, "public"."PackageSubscription"."issuedPrice", "public"."PackageSubscription"."pricingNamedPriceListId", "public"."PackageSubscription"."customPriceCurrency"::text, "public"."PackageSubscription"."customPriceById", "public"."PackageSubscription"."customPeriod", "public"."PackageSubscription"."createdById" FROM "public"."PackageSubscription" LEFT JOIN "public"."PatientProfile" AS "j0" ON ("j0"."id") = ("public"."PackageSubscription"."patientProfileId") WHERE ("public"."PackageSubscription"."status" IN (CAST($1::text AS "public"."PackageSubscriptionStatus"),CAST($2::text AS "public"."PackageSubscriptionStatus"),CAST($3::text AS "public"."PackageSubscriptionStatus")) AND ("j0"."clinicDomain" = $4 AND ("j0"."id" IS NOT NULL))) ORDER BY "public"."PackageSubscription"."createdAt" DESC LIMIT $5 OFFSET $6
6 min 0.2%	143 ms	2,516 postgres
`SELECT COUNT() AS "_count$_all", "public"."PatientLoyalty"."tier"::text FROM "public"."PatientLoyalty" LEFT JOIN "public"."PatientProfile" AS "j0" ON ("j0"."id") = ("public"."PatientLoyalty"."patientId") WHERE ("j0"."clinicDomain" = $1 AND ("j0"."id" IS NOT NULL)) GROUP BY "public"."PatientLoyalty"."tier" OFFSET $2 / traceparent='00-292d84f8c1dca4e08d320acb64bb4a50-dffcc147ddd72217-01' */`
6 min 0.2%	151 ms	2,380 postgres
`SELECT SUM("public"."InvoiceUnit"."total") AS "_sum$total", "public"."InvoiceUnit"."examinationId" FROM "public"."InvoiceUnit" LEFT JOIN "public"."Invoice" AS "j0" ON ("j0"."id") = ("public"."InvoiceUnit"."invoiceId") WHERE ("public"."InvoiceUnit"."examinationId" IN ($1,$2,$3,$4,$5,$6,$7,$8,$9) AND ($11=$12 AND ("j0"."id" IS NOT NULL))) GROUP BY "public"."InvoiceUnit"."examinationId" OFFSET $10`
6 min 0.2%	139 ms	2,516 postgres
`SELECT COUNT() AS "_count$_all" FROM (SELECT "public"."PatientLoyalty"."id" FROM "public"."PatientLoyalty" LEFT JOIN "public"."PatientProfile" AS "j0" ON ("j0"."id") = ("public"."PatientLoyalty"."patientId") WHERE ("j0"."clinicDomain" = $1 AND ("j0"."id" IS NOT NULL)) OFFSET $2 / traceparent='00-292d84f8c1dca4e08d320acb64bb4a50-ea2ab43c0c5191ae-01' /) AS "sub" / traceparent='00-292d84f8c1dca4e08d320acb64bb4a50-ea2ab43c0c5191ae-01' */`
6 min 0.2%	24 ms	13,951 postgres
SELECT "public"."Session"."id", "public"."Session"."from", "public"."Session"."to", "public"."Session"."doctorId", "public"."Session"."branchId" FROM "public"."Session" WHERE (("public"."Session"."from" < $1 AND "public"."Session"."to" > $2 AND "public"."Session"."status" IN (CAST($3::text AS "public"."SessionStatus"),CAST($4::text AS "public"."SessionStatus"),CAST($5::text AS "public"."SessionStatus"))) AND "public"."Session"."branchId" IN ($6)) ORDER BY "public"."Session"."from" ASC LIMIT $7 OFFSET $8 Details `CREATE INDEX CONCURRENTLY ON Session (branchId, to)` `Rows: 713399 Row progression: 713399, 2451, 236 Row estimates - branchId (=): 2451 - to (>): 68812 - from (<): 70663 - status (=): 178350 - from (sort): 9 Existing indexes - id PRIMARY - acceptedFromSessionRequestId UNIQUE - branchId, from - clinicDomain, from - clinicDomain, isOperation, date - clinicDomain, link UNIQUE - date, branchId - date, clinicDomain - date, doctorId - date, patientProfileId - doctorId, branchId - doctorId, date, branchId, clinicDomain - patientProfileId`
6 min 0.2%	26 ms	12,641 postgres
SELECT "public"."WeightTracking"."id", "public"."WeightTracking"."weightId", "public"."WeightTracking"."heightId", "public"."WeightTracking"."nutritionProfileId", "public"."WeightTracking"."dietId", "public"."WeightTracking"."dietInDetails", "public"."WeightTracking"."files", "public"."WeightTracking"."water", "public"."WeightTracking"."sleep", "public"."WeightTracking"."exercise", "public"."WeightTracking"."stress", "public"."WeightTracking"."muscles", "public"."WeightTracking"."fat", "public"."WeightTracking"."abdominalObesity", "public"."WeightTracking"."patientDietId", "public"."WeightTracking"."sessionId", "public"."WeightTracking"."createdAt", "public"."WeightTracking"."updatedAt" FROM "public"."WeightTracking" LEFT JOIN "public"."VariablePropertyValue" AS "orderby_1" ON ("orderby_1"."id") = ("public"."WeightTracking"."weightId") LEFT JOIN "public"."NutritionProfile" AS "j0" ON ("j0"."id") = ("public"."WeightTracking"."nutritionProfileId") LEFT JOIN "public"."PatientProfile" AS "j1" ON ("j1"."id") = ("j0"."patientProfileId") WHERE ("public"."WeightTracking"."nutritionProfileId" = $1 AND ("j1"."clinicDomain" = $2 AND ("j1"."id" IS NOT NULL) AND ("j0"."id" IS NOT NULL))) ORDER BY "orderby_1"."createdAt" DESC LIMIT $3 OFFSET $4
5 min 0.2%	99 ms	3,141 postgres
`SELECT SUM("public"."InvoiceUnit"."total") AS "_sum$total", "public"."InvoiceUnit"."examinationId" FROM "public"."InvoiceUnit" LEFT JOIN "public"."Invoice" AS "j0" ON ("j0"."id") = ("public"."InvoiceUnit"."invoiceId") WHERE ("public"."InvoiceUnit"."examinationId" IN ($1,$2,$3,$4,$5,$6,$7) AND ($9=$10 AND ("j0"."id" IS NOT NULL))) GROUP BY "public"."InvoiceUnit"."examinationId" OFFSET $8`
5 min 0.2%	119 ms	2,516 postgres
`SELECT SUM("tierBenefitDiscount") AS "_sum$tierBenefitDiscount" FROM (SELECT "public"."Invoice"."tierBenefitDiscount" FROM "public"."Invoice" WHERE ("public"."Invoice"."clinicDomain" = $1 AND "public"."Invoice"."tierBenefitDiscount" > $2) OFFSET $3) AS "sub"`
5 min 0.2%	36 ms	8,332 postgres
`SELECT COUNT() AS "_count$_all" FROM (SELECT "public"."Invoice"."id" FROM "public"."Invoice" WHERE ("public"."Invoice"."status" = CAST($1::text AS "public"."InvoiceStatus") AND "public"."Invoice"."restNotPaid" > $2 AND "public"."Invoice"."clinicDomain" = $3) OFFSET $4 / traceparent='00-b92485c0f5a173dd1fbf2aa64bc1ad43-6451749bd2dd2f54-01' /) AS "sub" / traceparent='00-b92485c0f5a173dd1fbf2aa64bc1ad43-6451749bd2dd2f54-01' */`
5 min 0.2%	238 ms	1,246 postgres
SELECT SUM("forDoctor") AS "_sum$forDoctor", SUM("forAssistant") AS "_sum$forAssistant", SUM("forReferralDoctor") AS "_sum$forReferralDoctor", SUM("consumablesTotal") AS "_sum$consumablesTotal", SUM("forManagers") AS "_sum$forManagers" FROM (SELECT "public"."Invoice"."forDoctor", "public"."Invoice"."forAssistant", "public"."Invoice"."forReferralDoctor", "public"."Invoice"."consumablesTotal", "public"."Invoice"."forManagers" FROM "public"."Invoice" LEFT JOIN "public"."PackageSubscription" AS "j0" ON ("j0"."invoiceId") = ("public"."Invoice"."id") LEFT JOIN "public"."PatientProfile" AS "j2" ON ("j2"."id") = ("j0"."patientProfileId") LEFT JOIN "public"."Session" AS "j3" ON ("j3"."id") = ("public"."Invoice"."sessionId") LEFT JOIN "public"."PatientProfile" AS "j4" ON ("j4"."id") = ("j3"."patientProfileId") LEFT JOIN "public"."Accommodation" AS "j5" ON ("j5"."id") = ("public"."Invoice"."accommodationId") LEFT JOIN "public"."PatientProfile" AS "j6" ON ("j6"."id") = ("j5"."patientProfileId") WHERE ("public"."Invoice"."clinicDomain" = $1 AND ((NOT EXISTS(SELECT "t1"."B" FROM "public"."_BranchToPackageSubscription" AS "t1" INNER JOIN "public"."Branch" AS "j1" ON ("j1"."id") = ("t1"."A") WHERE ((NOT "j1"."id" = $2) AND ("j0"."id") = ("t1"."B") AND "t1"."B" IS NOT NULL)) AND ("j2"."clinicDomain" = $3 AND ("j2"."id" IS NOT NULL)) AND "j0"."createdAt" >= $4 AND "j0"."createdAt" <= $5 AND "j0"."status" <> CAST($6::text AS "public"."PackageSubscriptionStatus") AND ("j0"."id" IS NOT NULL)) OR ("j3"."doctorId" = $7 AND "j3"."branchId" = $8 AND ("j4"."clinicDomain" = $9 AND ("j4"."id" IS NOT NULL)) AND "j3"."from" >= $10 AND "j3"."from" <= $11 AND "j3"."status" <> CAST($12::text AS "public"."SessionStatus") AND ("j3"."id" IS NOT NULL)) OR ("j6"."clinicDomain" = $13 AND ("j6"."id" IS NOT NULL) AND ("j5"."id" IS NOT NULL)))) OFFSET $14) AS "sub"
5 min 0.2%	53 ms	5,484 postgres
`SELECT COUNT(*) AS "_count$_all" FROM (SELECT "public"."TreasuryTransaction"."id" FROM "public"."TreasuryTransaction" LEFT JOIN "public"."Treasury" AS "j0" ON ("j0"."id") = ("public"."TreasuryTransaction"."treasuryId") WHERE (("j0"."clinicDomain" = $1 AND ("j0"."id" IS NOT NULL)) AND "public"."TreasuryTransaction"."createdAt" >= $2 AND "public"."TreasuryTransaction"."createdAt" <= $3) OFFSET $4) AS "sub"`
5 min 0.2%	176 ms	1,633 postgres
SELECT "public"."Invoice"."id", "public"."Invoice"."sessionId", "public"."Invoice"."orderId", "public"."Invoice"."accommodationId", "public"."Invoice"."note", "public"."Invoice"."status"::text, "public"."Invoice"."paymentStatus"::text, "public"."Invoice"."ownerId", "public"."Invoice"."total", "public"."Invoice"."totalTax", "public"."Invoice"."subTotal", "public"."Invoice"."discountValue", "public"."Invoice"."tierBenefitDiscount", "public"."Invoice"."rewardDiscount", "public"."Invoice"."giftCardAmount", "public"."Invoice"."appliedTierBenefit", "public"."Invoice"."restNotPaid", "public"."Invoice"."packageDiscount", "public"."Invoice"."manualDiscount", "public"."Invoice"."skipInsurance", "public"."Invoice"."skipLoyaltyDiscount", "public"."Invoice"."insuranceCoverageAmount", "public"."Invoice"."patientDeductibleAmount", "public"."Invoice"."insuranceDiscountAmount", "public"."Invoice"."forDoctor", "public"."Invoice"."forManagers", "public"."Invoice"."insurancePolicyClassId", "public"."Invoice"."forAssistant", "public"."Invoice"."forReferralDoctor", "public"."Invoice"."paymentAttach", "public"."Invoice"."clinicDomain", "public"."Invoice"."createdAt", "public"."Invoice"."updatedAt", "public"."Invoice"."link", "public"."Invoice"."points", "public"."Invoice"."consumablesTotal", "public"."Invoice"."consumablesPayByPatient", "public"."Invoice"."closingShiftId", "public"."Invoice"."isLocked", "public"."Invoice"."serialNumber", "public"."Invoice"."currency"::text, "public"."Invoice"."txCurrency"::text, "public"."Invoice"."txTotal", "public"."Invoice"."exchangeRate", "public"."Invoice"."rateSource"::text, "public"."Invoice"."exchangeRateId", "public"."Invoice"."rateEffectiveAt", "public"."Invoice"."ratePurpose"::text, "public"."Invoice"."rateEnteredById", "public"."Invoice"."rateNote", "public"."Invoice"."txRestNotPaid", "public"."Invoice"."fxResidual" FROM "public"."Invoice" LEFT JOIN "public"."PackageSubscription" AS "j0" ON ("j0"."invoiceId") = ("public"."Invoice"."id") LEFT JOIN "public"."Order" AS "j2" ON ("j2"."id") = ("public"."Invoice"."orderId") LEFT JOIN "public"."Session" AS "j3" ON ("j3"."id") = ("public"."Invoice"."sessionId") WHERE (((NOT EXISTS(SELECT "t1"."B" FROM "public"."_BranchToPackageSubscription" AS "t1" INNER JOIN "public"."Branch" AS "j1" ON ("j1"."id") = ("t1"."A") WHERE ((NOT "j1"."id" = $1) AND ("j0"."id") = ("t1"."B") AND "t1"."B" IS NOT NULL)) AND "j0"."status" <> CAST($2::text AS "public"."PackageSubscriptionStatus") AND "j0"."startDate" >= $3 AND "j0"."startDate" <= $4 AND ("j0"."id" IS NOT NULL)) OR ("j2"."branchId" = $5 AND "j2"."createdAt" >= $6 AND "j2"."createdAt" <= $7 AND ("j2"."id" IS NOT NULL)) OR ("j3"."date" >= $8 AND "j3"."date" <= $9 AND "j3"."status" <> CAST($10::text AS "public"."SessionStatus") AND "j3"."branchId" = $11 AND ("j3"."id" IS NOT NULL))) AND "public"."Invoice"."clinicDomain" = $12) ORDER BY "public"."Invoice"."id" DESC LIMIT $13 OFFSET $14
5 min 0.1%	51 ms	5,484 postgres
`SELECT SUM("amount") AS "_sum$amount" FROM (SELECT "public"."TreasuryTransaction"."amount" FROM "public"."TreasuryTransaction" LEFT JOIN "public"."Treasury" AS "j0" ON ("j0"."id") = ("public"."TreasuryTransaction"."treasuryId") WHERE (("j0"."clinicDomain" = $1 AND ("j0"."id" IS NOT NULL)) AND "public"."TreasuryTransaction"."createdAt" >= $2 AND "public"."TreasuryTransaction"."createdAt" <= $3 AND "public"."TreasuryTransaction"."amount" > $4) OFFSET $5) AS "sub"`
4 min 0.1%	101 ms	2,593 postgres
SELECT COUNT(*) AS "_count$_all" FROM (SELECT "public"."Invoice"."id" FROM "public"."Invoice" LEFT JOIN "public"."Session" AS "j0" ON ("j0"."id") = ("public"."Invoice"."sessionId") LEFT JOIN "public"."PackageSubscription" AS "j1" ON ("j1"."invoiceId") = ("public"."Invoice"."id") LEFT JOIN "public"."Order" AS "j2" ON ("j2"."id") = ("public"."Invoice"."orderId") LEFT JOIN "public"."Accommodation" AS "j3" ON ("j3"."id") = ("public"."Invoice"."accommodationId") WHERE ((("j0"."patientProfileId" = $1 AND ("j0"."id" IS NOT NULL)) OR ("j1"."patientProfileId" = $2 AND ("j1"."id" IS NOT NULL)) OR ("j2"."patientProfileId" = $3 AND ("j2"."id" IS NOT NULL)) OR ("j3"."patientProfileId" = $4 AND ("j3"."id" IS NOT NULL))) AND "public"."Invoice"."clinicDomain" = $5) OFFSET $6) AS "sub"
4 min 0.1%	21 ms	11,997 postgres
SELECT "public"."PatientProfile"."id", "public"."PatientProfile"."avatar", "public"."PatientProfile"."name", "public"."PatientProfile"."phone", "public"."PatientProfile"."phoneCode", "public"."PatientProfile"."email", "public"."PatientProfile"."address", "public"."PatientProfile"."patientIndex", "public"."PatientProfile"."taxApplicable", "public"."PatientProfile"."freeNote", "public"."PatientProfile"."city", "public"."PatientProfile"."state", "public"."PatientProfile"."zip", "public"."PatientProfile"."country", "public"."PatientProfile"."nationalId", "public"."PatientProfile"."nationalIdType"::text, "public"."PatientProfile"."nationality", "public"."PatientProfile"."source", "public"."PatientProfile"."longitude", "public"."PatientProfile"."latitude", "public"."PatientProfile"."birthday", "public"."PatientProfile"."note", "public"."PatientProfile"."weight", "public"."PatientProfile"."aiSummary", "public"."PatientProfile"."aiSummaryGeneratedAt", "public"."PatientProfile"."aiSummaryData", "public"."PatientProfile"."type"::text, "public"."PatientProfile"."firstSessionDate", "public"."PatientProfile"."lastSessionDate", "public"."PatientProfile"."isActive", "public"."PatientProfile"."noShowCount", "public"."PatientProfile"."noShowDepositExempt", "public"."PatientProfile"."medicalHistory", "public"."PatientProfile"."clinicDomain", "public"."PatientProfile"."createdAt", "public"."PatientProfile"."updatedAt", "public"."PatientProfile"."referralDoctorId", "public"."PatientProfile"."referredById", "public"."PatientProfile"."whatsappCampaignId", "public"."PatientProfile"."link", "public"."PatientProfile"."branchId", "public"."PatientProfile"."petType", "public"."PatientProfile"."color", "public"."PatientProfile"."petStatus", "public"."PatientProfile"."petBreed", "public"."PatientProfile"."petName", "public"."PatientProfile"."isVaccinated", "public"."PatientProfile"."totalPayed", "public"."PatientProfile"."totalPayments", "public"."PatientProfile"."totalPaymentsRest", "public"."PatientProfile"."totalUpcomingPayments", "public"."PatientProfile"."telegramChatId", "public"."PatientProfile"."telegramUsername" FROM "public"."PatientProfile" WHERE (("public"."PatientProfile"."name" ILIKE $1 OR "public"."PatientProfile"."phone"::text LIKE $2) AND "public"."PatientProfile"."clinicDomain" = $3) ORDER BY "public"."PatientProfile"."createdAt" DESC LIMIT $4 OFFSET $5
4 min 0.1%	54 ms	4,443 postgres
SELECT "public"."Invoice"."id", "public"."Invoice"."sessionId", "public"."Invoice"."orderId", "public"."Invoice"."accommodationId", "public"."Invoice"."note", "public"."Invoice"."status"::text, "public"."Invoice"."paymentStatus"::text, "public"."Invoice"."ownerId", "public"."Invoice"."total", "public"."Invoice"."totalTax", "public"."Invoice"."subTotal", "public"."Invoice"."discountValue", "public"."Invoice"."tierBenefitDiscount", "public"."Invoice"."rewardDiscount", "public"."Invoice"."giftCardAmount", "public"."Invoice"."appliedTierBenefit", "public"."Invoice"."restNotPaid", "public"."Invoice"."packageDiscount", "public"."Invoice"."manualDiscount", "public"."Invoice"."skipInsurance", "public"."Invoice"."skipLoyaltyDiscount", "public"."Invoice"."insuranceCoverageAmount", "public"."Invoice"."patientDeductibleAmount", "public"."Invoice"."insuranceDiscountAmount", "public"."Invoice"."forDoctor", "public"."Invoice"."forManagers", "public"."Invoice"."insurancePolicyClassId", "public"."Invoice"."forAssistant", "public"."Invoice"."forReferralDoctor", "public"."Invoice"."paymentAttach", "public"."Invoice"."clinicDomain", "public"."Invoice"."createdAt", "public"."Invoice"."updatedAt", "public"."Invoice"."link", "public"."Invoice"."points", "public"."Invoice"."consumablesTotal", "public"."Invoice"."consumablesPayByPatient", "public"."Invoice"."closingShiftId", "public"."Invoice"."isLocked", "public"."Invoice"."serialNumber", "public"."Invoice"."currency"::text, "public"."Invoice"."txCurrency"::text, "public"."Invoice"."txTotal", "public"."Invoice"."exchangeRate", "public"."Invoice"."rateSource"::text, "public"."Invoice"."exchangeRateId", "public"."Invoice"."rateEffectiveAt", "public"."Invoice"."ratePurpose"::text, "public"."Invoice"."rateEnteredById", "public"."Invoice"."rateNote", "public"."Invoice"."txRestNotPaid", "public"."Invoice"."fxResidual" FROM "public"."Invoice" LEFT JOIN "public"."Order" AS "j0" ON ("j0"."id") = ("public"."Invoice"."orderId") LEFT JOIN "public"."PackageSubscription" AS "j1" ON ("j1"."invoiceId") = ("public"."Invoice"."id") LEFT JOIN "public"."Session" AS "j2" ON ("j2"."id") = ("public"."Invoice"."sessionId") WHERE ("public"."Invoice"."status" = CAST($1::text AS "public"."InvoiceStatus") AND (("j0"."patientProfileId" = $2 AND ("j0"."id" IS NOT NULL)) OR ("j1"."patientProfileId" = $3 AND "j1"."status" <> CAST($4::text AS "public"."PackageSubscriptionStatus") AND ("j1"."id" IS NOT NULL)) OR ("j2"."patientProfileId" = $5 AND "j2"."status" <> CAST($6::text AS "public"."SessionStatus") AND ("j2"."id" IS NOT NULL))) AND "public"."Invoice"."clinicDomain" = $7) ORDER BY "public"."Invoice"."id" DESC LIMIT $8 OFFSET $9
4 min 0.1%	41 ms	5,918 postgres
`SELECT SUM("public"."InvoiceUnit"."total") AS "_sum$total", "public"."InvoiceUnit"."examinationId" FROM "public"."InvoiceUnit" LEFT JOIN "public"."Invoice" AS "j0" ON ("j0"."id") = ("public"."InvoiceUnit"."invoiceId") WHERE ("public"."InvoiceUnit"."examinationId" IN ($1) AND ($3=$4 AND ("j0"."id" IS NOT NULL))) GROUP BY "public"."InvoiceUnit"."examinationId" OFFSET $2`
4 min 0.1%	747 ms	317 postgres
DELETE FROM "public"."PaymentTransaction" WHERE ("public"."PaymentTransaction"."id" = $1 AND $2=$3) RETURNING "public"."PaymentTransaction"."id", "public"."PaymentTransaction"."status"::text, "public"."PaymentTransaction"."reason", "public"."PaymentTransaction"."documents", "public"."PaymentTransaction"."data", "public"."PaymentTransaction"."amount", "public"."PaymentTransaction"."forDoctor", "public"."PaymentTransaction"."forAssistant", "public"."PaymentTransaction"."forReferralDoctor", "public"."PaymentTransaction"."forManagers", "public"."PaymentTransaction"."currency"::text, "public"."PaymentTransaction"."txCurrency"::text, "public"."PaymentTransaction"."txAmount", "public"."PaymentTransaction"."exchangeRate", "public"."PaymentTransaction"."rateSource"::text, "public"."PaymentTransaction"."exchangeRateId", "public"."PaymentTransaction"."rateEffectiveAt", "public"."PaymentTransaction"."ratePurpose"::text, "public"."PaymentTransaction"."rateEnteredById", "public"."PaymentTransaction"."rateNote", "public"."PaymentTransaction"."method"::text, "public"."PaymentTransaction"."paymentProviderId", "public"."PaymentTransaction"."invoiceId", "public"."PaymentTransaction"."updatedAt", "public"."PaymentTransaction"."createdAt", "public"."PaymentTransaction"."clinicInvoiceId", "public"."PaymentTransaction"."clinicDomain", "public"."PaymentTransaction"."patientProfileId", "public"."PaymentTransaction"."isClaimed", "public"."PaymentTransaction"."invoiceUnitId", "public"."PaymentTransaction"."patientInsuranceId", "public"."PaymentTransaction"."insuranceClaimId", "public"."PaymentTransaction"."bulkTransactionOfForDoctorId", "public"."PaymentTransaction"."bulkTransactionOfForAssistantId", "public"."PaymentTransaction"."bulkTransactionOfForReferralDoctorId", "public"."PaymentTransaction"."closingShiftId", "public"."PaymentTransaction"."isLocked", "public"."PaymentTransaction"."shiftId"
4 min 0.1%	109 ms	2,170 postgres
`SELECT SUM("public"."InvoiceUnit"."total") AS "_sum$total", "public"."InvoiceUnit"."examinationId" FROM "public"."InvoiceUnit" LEFT JOIN "public"."Invoice" AS "j0" ON ("j0"."id") = ("public"."InvoiceUnit"."invoiceId") WHERE ("public"."InvoiceUnit"."examinationId" IN ($1,$2,$3,$4,$5,$6,$7,$8) AND ($10=$11 AND ("j0"."id" IS NOT NULL))) GROUP BY "public"."InvoiceUnit"."examinationId" OFFSET $9`
4 min 0.1%	313 ms	740 postgres
SELECT SUM("total") AS "_sum$total" FROM (SELECT "public"."Invoice"."total" FROM "public"."Invoice" LEFT JOIN "public"."PackageSubscription" AS "j0" ON ("j0"."invoiceId") = ("public"."Invoice"."id") LEFT JOIN "public"."PatientProfile" AS "j2" ON ("j2"."id") = ("j0"."patientProfileId") LEFT JOIN "public"."Session" AS "j3" ON ("j3"."id") = ("public"."Invoice"."sessionId") LEFT JOIN "public"."PatientProfile" AS "j4" ON ("j4"."id") = ("j3"."patientProfileId") LEFT JOIN "public"."Accommodation" AS "j5" ON ("j5"."id") = ("public"."Invoice"."accommodationId") LEFT JOIN "public"."PatientProfile" AS "j6" ON ("j6"."id") = ("j5"."patientProfileId") WHERE ("public"."Invoice"."clinicDomain" = $1 AND ((NOT EXISTS(SELECT "t1"."B" FROM "public"."_BranchToPackageSubscription" AS "t1" INNER JOIN "public"."Branch" AS "j1" ON ("j1"."id") = ("t1"."A") WHERE ((NOT "j1"."id" = $2) AND ("j0"."id") = ("t1"."B") AND "t1"."B" IS NOT NULL)) AND "j0"."doctorId" = $3 AND ("j2"."clinicDomain" = $4 AND ("j2"."id" IS NOT NULL)) AND "j0"."createdAt" >= $5 AND "j0"."createdAt" <= $6 AND "j0"."status" <> CAST($7::text AS "public"."PackageSubscriptionStatus") AND ("j0"."id" IS NOT NULL)) OR ("j3"."doctorId" = $8 AND "j3"."shiftId" = $9 AND "j3"."branchId" = $10 AND ("j4"."clinicDomain" = $11 AND ("j4"."id" IS NOT NULL)) AND "j3"."from" >= $12 AND "j3"."from" <= $13 AND "j3"."status" <> CAST($14::text AS "public"."SessionStatus") AND ("j3"."id" IS NOT NULL)) OR (("j6"."clinicDomain" = $15 AND ("j6"."id" IS NOT NULL)) AND "j5"."createdAt" >= $16 AND "j5"."createdAt" <= $17 AND ("j5"."id" IS NOT NULL))) AND "public"."Invoice"."status" = CAST($18::text AS "public"."InvoiceStatus")) OFFSET $19) AS "sub"
4 min 0.1%	126 ms	1,828 postgres
`SELECT SUM("public"."InvoiceUnit"."total") AS "_sum$total", "public"."InvoiceUnit"."examinationId" FROM "public"."InvoiceUnit" LEFT JOIN "public"."Invoice" AS "j0" ON ("j0"."id") = ("public"."InvoiceUnit"."invoiceId") WHERE ("public"."InvoiceUnit"."examinationId" IN ($1,$2,$3,$4,$5,$6,$7,$8,$9,$10,$11) AND ($13=$14 AND ("j0"."id" IS NOT NULL))) GROUP BY "public"."InvoiceUnit"."examinationId" OFFSET $12`
4 min 0.1%	427 ms	539 postgres
SELECT SUM("total") AS "_sum$total" FROM (SELECT "public"."Invoice"."total" FROM "public"."Invoice" LEFT JOIN "public"."PackageSubscription" AS "j0" ON ("j0"."invoiceId") = ("public"."Invoice"."id") LEFT JOIN "public"."PatientProfile" AS "j2" ON ("j2"."id") = ("j0"."patientProfileId") LEFT JOIN "public"."Order" AS "j3" ON ("j3"."id") = ("public"."Invoice"."orderId") LEFT JOIN "public"."PatientProfile" AS "j4" ON ("j4"."id") = ("j3"."patientProfileId") LEFT JOIN "public"."Session" AS "j5" ON ("j5"."id") = ("public"."Invoice"."sessionId") LEFT JOIN "public"."PatientProfile" AS "j6" ON ("j6"."id") = ("j5"."patientProfileId") LEFT JOIN "public"."Accommodation" AS "j7" ON ("j7"."id") = ("public"."Invoice"."accommodationId") LEFT JOIN "public"."PatientProfile" AS "j8" ON ("j8"."id") = ("j7"."patientProfileId") WHERE ("public"."Invoice"."clinicDomain" = $1 AND ((NOT EXISTS(SELECT "t1"."B" FROM "public"."_BranchToPackageSubscription" AS "t1" INNER JOIN "public"."Branch" AS "j1" ON ("j1"."id") = ("t1"."A") WHERE ((NOT "j1"."id" = $2) AND ("j0"."id") = ("t1"."B") AND "t1"."B" IS NOT NULL)) AND ("j2"."clinicDomain" = $3 AND ("j2"."id" IS NOT NULL)) AND "j0"."createdAt" >= $4 AND "j0"."createdAt" <= $5 AND "j0"."status" <> CAST($6::text AS "public"."PackageSubscriptionStatus") AND ("j0"."id" IS NOT NULL)) OR ("j3"."branchId" IN ($7) AND ("j4"."clinicDomain" = $8 AND ("j4"."id" IS NOT NULL)) AND "j3"."createdAt" >= $9 AND "j3"."createdAt" <= $10 AND ("j3"."id" IS NOT NULL)) OR ("j5"."shiftId" = $11 AND "j5"."branchId" = $12 AND ("j6"."clinicDomain" = $13 AND ("j6"."id" IS NOT NULL)) AND "j5"."from" >= $14 AND "j5"."from" <= $15 AND "j5"."status" <> CAST($16::text AS "public"."SessionStatus") AND ("j5"."id" IS NOT NULL)) OR (("j8"."clinicDomain" = $17 AND ("j8"."id" IS NOT NULL)) AND "j7"."createdAt" >= $18 AND "j7"."createdAt" <= $19 AND ("j7"."id" IS NOT NULL))) AND "public"."Invoice"."status" = CAST($20::text AS "public"."InvoiceStatus")) OFFSET $21) AS "sub"
4 min 0.1%	150 ms	1,528 postgres
`SELECT SUM("public"."InvoiceUnit"."total") AS "_sum$total", "public"."InvoiceUnit"."examinationId" FROM "public"."InvoiceUnit" LEFT JOIN "public"."Invoice" AS "j0" ON ("j0"."id") = ("public"."InvoiceUnit"."invoiceId") WHERE ("public"."InvoiceUnit"."examinationId" IN ($1,$2,$3,$4,$5,$6,$7,$8,$9,$10,$11,$12,$13) AND ($15=$16 AND ("j0"."id" IS NOT NULL))) GROUP BY "public"."InvoiceUnit"."examinationId" OFFSET $14`
4 min 0.1%	28 ms	8,090 postgres
SELECT SUM("amount") AS "_sum$amount" FROM (SELECT "public"."PaymentTransaction"."amount" FROM "public"."PaymentTransaction" LEFT JOIN "public"."PatientProfile" AS "j0" ON ("j0"."id") = ("public"."PaymentTransaction"."patientProfileId") LEFT JOIN "public"."Invoice" AS "j1" ON ("j1"."id") = ("public"."PaymentTransaction"."invoiceId") LEFT JOIN "public"."PackageSubscription" AS "j2" ON ("j2"."invoiceId") = ("j1"."id") LEFT JOIN "public"."PatientProfile" AS "j4" ON ("j4"."id") = ("j2"."patientProfileId") LEFT JOIN "public"."Session" AS "j5" ON ("j5"."id") = ("j1"."sessionId") LEFT JOIN "public"."PatientProfile" AS "j6" ON ("j6"."id") = ("j5"."patientProfileId") LEFT JOIN "public"."Accommodation" AS "j7" ON ("j7"."id") = ("j1"."accommodationId") LEFT JOIN "public"."PatientProfile" AS "j8" ON ("j8"."id") = ("j7"."patientProfileId") WHERE ("public"."PaymentTransaction"."method" = CAST($1::text AS "public"."PaymentMethod") AND ("j0"."clinicDomain" = $2 AND ("j0"."id" IS NOT NULL)) AND "public"."PaymentTransaction"."createdAt" >= $3 AND "public"."PaymentTransaction"."createdAt" <= $4 AND "public"."PaymentTransaction"."amount" >= $5 AND (((NOT EXISTS(SELECT "t3"."B" FROM "public"."_BranchToPackageSubscription" AS "t3" INNER JOIN "public"."Branch" AS "j3" ON ("j3"."id") = ("t3"."A") WHERE ((NOT "j3"."id" = $6) AND ("j2"."id") = ("t3"."B") AND "t3"."B" IS NOT NULL)) AND "j2"."doctorId" = $7 AND ("j4"."clinicDomain" = $8 AND ("j4"."id" IS NOT NULL)) AND ("j2"."id" IS NOT NULL)) OR ("j5"."doctorId" = $9 AND "j5"."branchId" = $10 AND ("j6"."clinicDomain" = $11 AND ("j6"."id" IS NOT NULL)) AND ("j5"."id" IS NOT NULL)) OR ("j8"."clinicDomain" = $12 AND ("j8"."id" IS NOT NULL) AND ("j7"."id" IS NOT NULL))) AND ("j1"."id" IS NOT NULL))) OFFSET $13) AS "sub"
4 min 0.1%	145 ms	1,535 postgres
`SELECT SUM("public"."InvoiceUnit"."total") AS "_sum$total", "public"."InvoiceUnit"."examinationId" FROM "public"."InvoiceUnit" LEFT JOIN "public"."Invoice" AS "j0" ON ("j0"."id") = ("public"."InvoiceUnit"."invoiceId") WHERE ("public"."InvoiceUnit"."examinationId" IN ($1,$2,$3,$4,$5,$6,$7,$8,$9,$10) AND ($12=$13 AND ("j0"."id" IS NOT NULL))) GROUP BY "public"."InvoiceUnit"."examinationId" OFFSET $11`
4 min 0.1%	300 ms	740 postgres
SELECT SUM("amount") AS "_sum$amount" FROM (SELECT "public"."PaymentTransaction"."amount" FROM "public"."PaymentTransaction" LEFT JOIN "public"."Invoice" AS "j0" ON ("j0"."id") = ("public"."PaymentTransaction"."invoiceId") LEFT JOIN "public"."PackageSubscription" AS "j1" ON ("j1"."invoiceId") = ("j0"."id") LEFT JOIN "public"."PatientProfile" AS "j3" ON ("j3"."id") = ("j1"."patientProfileId") LEFT JOIN "public"."Session" AS "j4" ON ("j4"."id") = ("j0"."sessionId") LEFT JOIN "public"."PatientProfile" AS "j5" ON ("j5"."id") = ("j4"."patientProfileId") LEFT JOIN "public"."Accommodation" AS "j6" ON ("j6"."id") = ("j0"."accommodationId") LEFT JOIN "public"."PatientProfile" AS "j7" ON ("j7"."id") = ("j6"."patientProfileId") WHERE ("j0"."clinicDomain" = $1 AND ((NOT EXISTS(SELECT "t2"."B" FROM "public"."_BranchToPackageSubscription" AS "t2" INNER JOIN "public"."Branch" AS "j2" ON ("j2"."id") = ("t2"."A") WHERE ((NOT "j2"."id" = $2) AND ("j1"."id") = ("t2"."B") AND "t2"."B" IS NOT NULL)) AND "j1"."doctorId" = $3 AND ("j3"."clinicDomain" = $4 AND ("j3"."id" IS NOT NULL)) AND "j1"."createdAt" >= $5 AND "j1"."createdAt" <= $6 AND "j1"."status" <> CAST($7::text AS "public"."PackageSubscriptionStatus") AND ("j1"."id" IS NOT NULL)) OR ("j4"."doctorId" = $8 AND "j4"."shiftId" = $9 AND "j4"."branchId" = $10 AND ("j5"."clinicDomain" = $11 AND ("j5"."id" IS NOT NULL)) AND "j4"."from" >= $12 AND "j4"."from" <= $13 AND "j4"."status" <> CAST($14::text AS "public"."SessionStatus") AND ("j4"."id" IS NOT NULL)) OR (("j7"."clinicDomain" = $15 AND ("j7"."id" IS NOT NULL)) AND "j6"."createdAt" >= $16 AND "j6"."createdAt" <= $17 AND ("j6"."id" IS NOT NULL))) AND "j0"."status" = CAST($18::text AS "public"."InvoiceStatus") AND ("j0"."id" IS NOT NULL)) OFFSET $19) AS "sub"
4 min 0.1%	41 ms	5,307 postgres
SELECT COUNT(*) AS "_count$_all" FROM (SELECT "public"."PackageSubscription"."id" FROM "public"."PackageSubscription" LEFT JOIN "public"."PatientProfile" AS "j0" ON ("j0"."id") = ("public"."PackageSubscription"."patientProfileId") WHERE ("public"."PackageSubscription"."status" IN (CAST($1::text AS "public"."PackageSubscriptionStatus"),CAST($2::text AS "public"."PackageSubscriptionStatus"),CAST($3::text AS "public"."PackageSubscriptionStatus")) AND ("j0"."clinicDomain" = $4 AND ("j0"."id" IS NOT NULL))) OFFSET $5) AS "sub"

Duplicate Indexes

Suggested Indexes

Slow Queries