Details
On PlatformCashSnapshot PlatformCashSnapshot_asOfDate_idx (asOfDate) is covered by PlatformCashSnapshot_asOfDate_key (asOfDate)

Total Time	Average Time	Calls
72 min 0.5%	120 ms	35,803 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"."appliedTierBenefit", "public"."Invoice"."restNotPaid", "public"."Invoice"."packageDiscount", "public"."Invoice"."manualDiscount", "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" 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 /* traceparent='00-faea614d08285f62d27b044136be25d9-e18e04e9c0a9a5fa-01' */

Total Time	Average Time	Calls
56 min 0.4%	475 ms	7,125 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"."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"."updatedAt" FROM "public"."Logs" WHERE "public"."Logs"."clinicDomain" = $1 ORDER BY "public"."Logs"."createdAt" DESC LIMIT $2 OFFSET $3

Total Time	Average Time	Calls
30 min 0.2%	6,246 ms	287 postgres
`SELECT "public"."Logs"."id" FROM "public"."Logs" WHERE ("public"."Logs"."type" IN (CAST($1::text AS "public"."Models"),CAST($2::text AS "public"."Models")) AND "public"."Logs"."createdAt" < $3) ORDER BY "public"."Logs"."id" ASC LIMIT $4 OFFSET $5 /* traceparent='00-2214a6181e071e5702c9187d27e04276-39a99e3117ae26cc-01' */`

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
3,534 min 24%	1,420 ms	149,372 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"
3,530 min 24%	1,331 ms	159,178 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 /* traceparent='00-25df44523a40d65692b5acffb6122b1d-d197363a2cec165a-01' /) AS "sub" / traceparent='00-25df44523a40d65692b5acffb6122b1d-d197363a2cec165a-01' */
387 min 3%	40 ms	580,241 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 /* traceparent='00-7fafcd063fa02720819c518397e33453-98213181e81fa5fb-01' */
330 min 2%	34 ms	580,233 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 / traceparent='00-7fafcd063fa02720819c518397e33453-bb5f45cffdf03ab2-01' /) AS "sub" / traceparent='00-7fafcd063fa02720819c518397e33453-bb5f45cffdf03ab2-01' */
256 min 2%	88 ms	173,896 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" 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 /* traceparent='00-da735cdab13464917af4d823721c5973-8302b70b35eb67ba-01' */
210 min 1%	21 ms	597,915 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"."source", "public"."PatientProfile"."longitude", "public"."PatientProfile"."latitude", "public"."PatientProfile"."birthday", "public"."PatientProfile"."note", "public"."PatientProfile"."weight", "public"."PatientProfile"."type"::text, "public"."PatientProfile"."firstSessionDate", "public"."PatientProfile"."lastSessionDate", "public"."PatientProfile"."isActive", "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 /* traceparent='00-63ecac01b7d31e7c728ae14ddddcbc31-48fb33d7e70dbbb5-01' */
131 min 0.9%	89 ms	88,489 postgres
SELECT "public"."Examination"."id", "public"."Examination"."name", "public"."Examination"."isActive", "public"."Examination"."price", "public"."Examination"."specialties"::text[], "public"."Examination"."defaultTime", "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[] 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
127 min 0.9%	201 ms	38,031 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 /* traceparent='00-c50c4047c7c008831bef0c32db4de60e-fbfeb8d7a36fc034-01' /) AS "sub" / traceparent='00-c50c4047c7c008831bef0c32db4de60e-fbfeb8d7a36fc034-01' */
116 min 0.8%	406 ms	17,167 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 /* traceparent='00-dbbce86a5ffc516ddcd60cb1568e29ab-167054399d9c1653-01' /) AS "sub" / traceparent='00-dbbce86a5ffc516ddcd60cb1568e29ab-167054399d9c1653-01' */
110 min 0.8%	313 ms	21,095 postgres
`SELECT COUNT() AS "_count$_all" FROM (SELECT "public"."Logs"."id" FROM "public"."Logs" WHERE "public"."Logs"."clinicDomain" = $1 OFFSET $2 / traceparent='00-91e66b1e55f4fe20236093ceedae3136-771958c27346f4d6-01' /) AS "sub" / traceparent='00-91e66b1e55f4fe20236093ceedae3136-771958c27346f4d6-01' */`
110 min 0.8%	174 ms	38,031 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 /* traceparent='00-c50c4047c7c008831bef0c32db4de60e-7e1b65d35b6c74a3-01' /) AS "sub" / traceparent='00-c50c4047c7c008831bef0c32db4de60e-7e1b65d35b6c74a3-01' */
109 min 0.8%	73 ms	90,160 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 /* traceparent='00-c50c4047c7c008831bef0c32db4de60e-23323a0845f984c4-01' /) AS "sub" / traceparent='00-c50c4047c7c008831bef0c32db4de60e-23323a0845f984c4-01' */`
106 min 0.7%	272 ms	23,416 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 /* traceparent='00-f33b8e590ca590a9c73c5a7183fac290-dc219f9a1cc8822f-01' */
102 min 0.7%	329 ms	18,634 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-8e9a1bc81987d3fbe60b26e25b606149-9980011d929fbaab-01' /) AS "sub" / traceparent='00-8e9a1bc81987d3fbe60b26e25b606149-9980011d929fbaab-01' */
99 min 0.7%	264 ms	22,625 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")) AND ("j0"."clinicDomain" = $3 AND ("j0"."id" IS NOT NULL)) AND "public"."PaymentTransaction"."createdAt" >= $4 AND "public"."PaymentTransaction"."createdAt" <= $5 AND "public"."PaymentTransaction"."amount" >= $6 AND ((("j3"."clinicDomain" = $7 AND ("j3"."id" IS NOT NULL) AND ("j2"."id" IS NOT NULL)) OR ("j4"."status" = CAST($8::text AS "public"."SessionStatus") AND ("j5"."clinicDomain" = $9 AND ("j5"."id" IS NOT NULL)) AND ("j4"."id" IS NOT NULL)) OR ("j7"."clinicDomain" = $10 AND ("j7"."id" IS NOT NULL) AND ("j6"."id" IS NOT NULL)) OR ("j9"."clinicDomain" = $11 AND ("j9"."id" IS NOT NULL) AND ("j8"."id" IS NOT NULL))) AND ("j1"."id" IS NOT NULL))) OFFSET $12 /* traceparent='00-d369e64f8fef995c3c9c64c018a29f57-a87033e8e510a46a-01' /) AS "sub" / traceparent='00-d369e64f8fef995c3c9c64c018a29f57-a87033e8e510a46a-01' */
97 min 0.7%	260 ms	22,459 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 /* traceparent='00-d369e64f8fef995c3c9c64c018a29f57-b2002805228e42a9-01' /) AS "sub" / traceparent='00-d369e64f8fef995c3c9c64c018a29f57-b2002805228e42a9-01' */
97 min 0.7%	256 ms	22,625 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 /* traceparent='00-d369e64f8fef995c3c9c64c018a29f57-0b3bba00e198e4eb-01' /) AS "sub" / traceparent='00-d369e64f8fef995c3c9c64c018a29f57-0b3bba00e198e4eb-01' */
93 min 0.6%	147 ms	38,031 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")) AND ("j0"."clinicDomain" = $3 AND ("j0"."id" IS NOT NULL)) AND "public"."PaymentTransaction"."createdAt" >= $4 AND "public"."PaymentTransaction"."createdAt" <= $5 AND "public"."PaymentTransaction"."amount" >= $6 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" = $7) AND ("j2"."id") = ("t3"."B") AND "t3"."B" IS NOT NULL)) AND ("j4"."clinicDomain" = $8 AND ("j4"."id" IS NOT NULL)) AND ("j2"."id" IS NOT NULL)) OR ("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)) OR ("j9"."branchId" IN ($12) AND ("j10"."clinicDomain" = $13 AND ("j10"."id" IS NOT NULL)) AND ("j9"."id" IS NOT NULL))) AND ("j1"."id" IS NOT NULL))) OFFSET $14 /* traceparent='00-c50c4047c7c008831bef0c32db4de60e-851de1567ad45bd5-01' /) AS "sub" / traceparent='00-c50c4047c7c008831bef0c32db4de60e-851de1567ad45bd5-01' */
91 min 0.6%	144 ms	37,768 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 /* traceparent='00-c50c4047c7c008831bef0c32db4de60e-f85324ca7bf8097e-01' /) AS "sub" / traceparent='00-c50c4047c7c008831bef0c32db4de60e-f85324ca7bf8097e-01' */
89 min 0.6%	140 ms	38,031 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 /* traceparent='00-c50c4047c7c008831bef0c32db4de60e-e8e0c53073251e0e-01' /) AS "sub" / traceparent='00-c50c4047c7c008831bef0c32db4de60e-e8e0c53073251e0e-01' */
86 min 0.6%	229 ms	22,625 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 /* traceparent='00-d369e64f8fef995c3c9c64c018a29f57-521c636397f243eb-01' /) AS "sub" / traceparent='00-d369e64f8fef995c3c9c64c018a29f57-521c636397f243eb-01' */
86 min 0.6%	256 ms	20,233 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 /* traceparent='00-c50c4047c7c008831bef0c32db4de60e-3fb9172d4ecccb4e-01' /) AS "sub" / traceparent='00-c50c4047c7c008831bef0c32db4de60e-3fb9172d4ecccb4e-01' */
80 min 0.6%	213 ms	22,625 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 /* traceparent='00-d369e64f8fef995c3c9c64c018a29f57-3afd65acc32893e2-01' /) AS "sub" / traceparent='00-d369e64f8fef995c3c9c64c018a29f57-3afd65acc32893e2-01' */
78 min 0.5%	49 ms	95,487 postgres
`SELECT MAX("serialNumber") AS "_max$serialNumber" FROM (SELECT "public"."Invoice"."serialNumber" FROM "public"."Invoice" WHERE "public"."Invoice"."clinicDomain" = $1 OFFSET $2 /* traceparent='00-25df44523a40d65692b5acffb6122b1d-81a046ffce8112d5-01' /) AS "sub" / traceparent='00-25df44523a40d65692b5acffb6122b1d-81a046ffce8112d5-01' */`
76 min 0.5%	201 ms	22,625 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 /* traceparent='00-d369e64f8fef995c3c9c64c018a29f57-4b17cf53e60984af-01' /) AS "sub" / traceparent='00-d369e64f8fef995c3c9c64c018a29f57-4b17cf53e60984af-01' */
74 min 0.5%	479 ms	9,317 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-8e9a1bc81987d3fbe60b26e25b606149-0f272d851e7e31fa-01' /) AS "sub" / traceparent='00-8e9a1bc81987d3fbe60b26e25b606149-0f272d851e7e31fa-01' */
73 min 0.5%	266 ms	16,520 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")) AND ("j0"."clinicDomain" = $3 AND ("j0"."id" IS NOT NULL)) AND "public"."PaymentTransaction"."createdAt" >= $4 AND "public"."PaymentTransaction"."createdAt" <= $5 AND "public"."PaymentTransaction"."amount" >= $6 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" = $7) AND ("j2"."id") = ("t3"."B") AND "t3"."B" IS NOT NULL)) AND "j2"."doctorId" = $8 AND ("j4"."clinicDomain" = $9 AND ("j4"."id" IS NOT NULL)) AND ("j2"."id" IS NOT NULL)) OR ("j5"."doctorId" = $10 AND "j5"."branchId" = $11 AND ("j6"."clinicDomain" = $12 AND ("j6"."id" IS NOT NULL)) AND ("j5"."id" IS NOT NULL)) OR ("j8"."clinicDomain" = $13 AND ("j8"."id" IS NOT NULL) AND ("j7"."id" IS NOT NULL))) AND ("j1"."id" IS NOT NULL))) OFFSET $14 /* traceparent='00-f33b8e590ca590a9c73c5a7183fac290-284739d5af463b3b-01' /) AS "sub" / traceparent='00-f33b8e590ca590a9c73c5a7183fac290-284739d5af463b3b-01' */
72 min 0.5%	120 ms	35,803 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"."appliedTierBenefit", "public"."Invoice"."restNotPaid", "public"."Invoice"."packageDiscount", "public"."Invoice"."manualDiscount", "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" 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 /* traceparent='00-faea614d08285f62d27b044136be25d9-e18e04e9c0a9a5fa-01' */ Details `CREATE INDEX CONCURRENTLY ON Invoice (clinicDomain, restNotPaid)` `Rows: 606351 Row progression: 606351, 2972, 299 Row estimates - clinicDomain (=): 2972 - restNotPaid (>): 60908 - status (=): 202117 - createdAt (sort): 1 Existing indexes - id PRIMARY - accommodationId UNIQUE - clinicDomain, serialNumber UNIQUE - closingShiftId - orderId UNIQUE - sessionId UNIQUE`
71 min 0.5%	256 ms	16,520 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 /* traceparent='00-f33b8e590ca590a9c73c5a7183fac290-e77b7e2389911fd3-01' /) AS "sub" / traceparent='00-f33b8e590ca590a9c73c5a7183fac290-e77b7e2389911fd3-01' */
68 min 0.5%	247 ms	16,520 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 /* traceparent='00-f33b8e590ca590a9c73c5a7183fac290-bd4db2b7b2e3511a-01' /) AS "sub" / traceparent='00-f33b8e590ca590a9c73c5a7183fac290-bd4db2b7b2e3511a-01' */
67 min 0.5%	178 ms	22,625 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 /* traceparent='00-d369e64f8fef995c3c9c64c018a29f57-3f3dd0e7f6273bc2-01' /) AS "sub" / traceparent='00-d369e64f8fef995c3c9c64c018a29f57-3f3dd0e7f6273bc2-01' */
67 min 0.5%	243 ms	16,520 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 /* traceparent='00-f33b8e590ca590a9c73c5a7183fac290-a837b6c9b36cc238-01' /) AS "sub" / traceparent='00-f33b8e590ca590a9c73c5a7183fac290-a837b6c9b36cc238-01' */
65 min 0.4%	150 ms	25,968 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"."source", "public"."PatientProfile"."longitude", "public"."PatientProfile"."latitude", "public"."PatientProfile"."birthday", "public"."PatientProfile"."note", "public"."PatientProfile"."weight", "public"."PatientProfile"."type"::text, "public"."PatientProfile"."firstSessionDate", "public"."PatientProfile"."lastSessionDate", "public"."PatientProfile"."isActive", "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 /* traceparent='00-a2623476b8d5528121a04a7655574d98-440c3b0e0b136b6c-01' */ `Covered by index on (clinicDomain, patientIndex) Rows: 248755 Row progression: 248755, 1051, 525 Row estimates - clinicDomain (=): 1051 - isActive (=): 124378 - id (sort): 1 Existing indexes - id PRIMARY - clinicDomain, link UNIQUE - clinicDomain, patientIndex UNIQUE - referredById`
65 min 0.4%	395 ms	9,859 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 /* traceparent='00-f33b8e590ca590a9c73c5a7183fac290-e4d272fdb3d7a31d-01' /) AS "sub" / traceparent='00-f33b8e590ca590a9c73c5a7183fac290-e4d272fdb3d7a31d-01' */
56 min 0.4%	475 ms	7,125 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"."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"."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: 1420308 Row progression: 1420308, 6312, 0 Row estimates - clinicDomain (=): 6312 - createdAt (sort): 1 Existing indexes - id PRIMARY`
50 min 0.3%	100 ms	30,102 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 /* traceparent='00-370597fc1a7fc67874646eb2b37aa7ba-8b58facde2449c7a-01' */
47 min 0.3%	306 ms	9,317 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-8e9a1bc81987d3fbe60b26e25b606149-d4b06273ee4137bc-01' */
47 min 0.3%	62 ms	45,042 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`
46 min 0.3%	662 ms	4,175 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 /* traceparent='00-436e9cb0cc1778be774c09f0dc32f8ce-3d533c5d70c59d74-01' /) AS "sub" / traceparent='00-436e9cb0cc1778be774c09f0dc32f8ce-3d533c5d70c59d74-01' */
43 min 0.3%	77 ms	33,581 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`
42 min 0.3%	63 ms	39,564 postgres
SELECT "public"."Examination"."id", "public"."Examination"."name", "public"."Examination"."isActive", "public"."Examination"."price", "public"."Examination"."specialties"::text[], "public"."Examination"."defaultTime", "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[] 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
42 min 0.3%	83 ms	30,101 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 / traceparent='00-370597fc1a7fc67874646eb2b37aa7ba-8ffdfc22a66db491-01' /) AS "sub" / traceparent='00-370597fc1a7fc67874646eb2b37aa7ba-8ffdfc22a66db491-01' */
39 min 0.3%	20 ms	115,093 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"."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"."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
39 min 0.3%	28 ms	84,669 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"."source", "public"."PatientProfile"."longitude", "public"."PatientProfile"."latitude", "public"."PatientProfile"."birthday", "public"."PatientProfile"."note", "public"."PatientProfile"."weight", "public"."PatientProfile"."type"::text, "public"."PatientProfile"."firstSessionDate", "public"."PatientProfile"."lastSessionDate", "public"."PatientProfile"."isActive", "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-4694bf8a8ad6f060f468627052b06058-c77806b7905dd820-01' */
39 min 0.3%	86 ms	26,739 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`
38 min 0.3%	245 ms	9,317 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-8e9a1bc81987d3fbe60b26e25b606149-af51ee73f52d3ae4-01' /) AS "sub" / traceparent='00-8e9a1bc81987d3fbe60b26e25b606149-af51ee73f52d3ae4-01' */`
37 min 0.3%	49 ms	45,250 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 /* traceparent='00-d369e64f8fef995c3c9c64c018a29f57-a6cb3602880f80fc-01' /) AS "sub" / traceparent='00-d369e64f8fef995c3c9c64c018a29f57-a6cb3602880f80fc-01' */
35 min 0.2%	367 ms	5,806 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 /* traceparent='00-a3dffe95dece6f5e3610869643d9ff56-d4af5a0029364e3a-01' */
35 min 0.2%	227 ms	9,317 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-8e9a1bc81987d3fbe60b26e25b606149-fc8f564b00d63818-01' */
35 min 0.2%	227 ms	9,317 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-8e9a1bc81987d3fbe60b26e25b606149-65998cf1e32f8761-01' */`
35 min 0.2%	88 ms	23,600 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 / traceparent='00-a2277d6805040827ea492e9a254d2d94-f7b55cd7fc8aa196-01' /) AS "sub" / traceparent='00-a2277d6805040827ea492e9a254d2d94-f7b55cd7fc8aa196-01' */
35 min 0.2%	88 ms	23,600 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 /* traceparent='00-a2277d6805040827ea492e9a254d2d94-e2c0e8654c0b6a34-01' /) AS "sub" / traceparent='00-a2277d6805040827ea492e9a254d2d94-e2c0e8654c0b6a34-01' */
34 min 0.2%	65 ms	31,532 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 /* traceparent='00-6054470d14d5644eab09e9bfc21848fb-b4d870aece7110f4-01' /) AS "sub" / traceparent='00-6054470d14d5644eab09e9bfc21848fb-b4d870aece7110f4-01' */`
33 min 0.2%	292 ms	6,775 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"."appliedTierBenefit", "public"."Invoice"."restNotPaid", "public"."Invoice"."packageDiscount", "public"."Invoice"."manualDiscount", "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" 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 /* traceparent='00-172ca8a0c250ad1e7c8e4b53a789a232-5c9d18ae321e8281-01' */
33 min 0.2%	26 ms	76,062 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 /* traceparent='00-c50c4047c7c008831bef0c32db4de60e-d5b8161d7dab7c01-01' /) AS "sub" / traceparent='00-c50c4047c7c008831bef0c32db4de60e-d5b8161d7dab7c01-01' */
32 min 0.2%	456 ms	4,175 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"."shiftId" = $11 AND "j6"."branchId" = $12 AND ("j7"."clinicDomain" = $13 AND ("j7"."id" IS NOT NULL)) AND "j6"."from" >= $14 AND "j6"."from" <= $15 AND "j6"."status" <> CAST($16::text AS "public"."SessionStatus") AND ("j6"."id" IS NOT NULL)) OR (("j9"."clinicDomain" = $17 AND ("j9"."id" IS NOT NULL)) AND "j8"."createdAt" >= $18 AND "j8"."createdAt" <= $19 AND ("j8"."id" IS NOT NULL))) AND "j0"."status" = CAST($20::text AS "public"."InvoiceStatus") AND ("j0"."id" IS NOT NULL)) OFFSET $21 /* traceparent='00-436e9cb0cc1778be774c09f0dc32f8ce-d6b8a3e1a7df81a1-01' /) AS "sub" / traceparent='00-436e9cb0cc1778be774c09f0dc32f8ce-d6b8a3e1a7df81a1-01' */
31 min 0.2%	1,440 ms	1,296 postgres
`UPDATE "public"."Invoice" SET "status" = CAST($1::text AS "public"."InvoiceStatus"), "updatedAt" = $2 WHERE ("public"."Invoice"."status" = CAST($3::text AS "public"."InvoiceStatus") AND EXISTS(SELECT "t0"."id" FROM "public"."Session" AS "t0" WHERE ("t0"."status" = CAST($4::text AS "public"."SessionStatus") AND ("public"."Invoice"."sessionId") = ("t0"."id") AND "t0"."id" IS NOT NULL))) /* traceparent='00-eaf9b18a3f9fb7a3771c3f444564ac1b-2b47d73a04d30b7c-01' */`
31 min 0.2%	113 ms	16,475 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") 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 "j2"."doctorId" = $5 AND ("j4"."clinicDomain" = $6 AND ("j4"."id" IS NOT NULL)) AND "j2"."status" <> CAST($7::text AS "public"."PackageSubscriptionStatus") 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 /* traceparent='00-f33b8e590ca590a9c73c5a7183fac290-37258bc12d410087-01' /) AS "sub" / traceparent='00-f33b8e590ca590a9c73c5a7183fac290-37258bc12d410087-01' */
30 min 0.2%	6,246 ms	287 postgres
`SELECT "public"."Logs"."id" FROM "public"."Logs" WHERE ("public"."Logs"."type" IN (CAST($1::text AS "public"."Models"),CAST($2::text AS "public"."Models")) AND "public"."Logs"."createdAt" < $3) ORDER BY "public"."Logs"."id" ASC LIMIT $4 OFFSET $5 /* traceparent='00-2214a6181e071e5702c9187d27e04276-39a99e3117ae26cc-01' */` Details `CREATE INDEX CONCURRENTLY ON Logs (type, createdAt)` `Rows: 1420308 Row progression: 1420308, 31562, 3156 Row estimates - type (=): 31562 - createdAt (<): 142031 - id (sort): 1 Existing indexes - id PRIMARY`
30 min 0.2%	98 ms	18,148 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`
29 min 0.2%	416 ms	4,175 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")) AND ("j0"."clinicDomain" = $3 AND ("j0"."id" IS NOT NULL)) AND "public"."PaymentTransaction"."createdAt" >= $4 AND "public"."PaymentTransaction"."createdAt" <= $5 AND "public"."PaymentTransaction"."amount" >= $6 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" = $7) AND ("j2"."id") = ("t3"."B") AND "t3"."B" IS NOT NULL)) AND ("j4"."clinicDomain" = $8 AND ("j4"."id" IS NOT NULL)) AND ("j2"."id" IS NOT NULL)) OR ("j5"."shiftId" = $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)) 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 /* traceparent='00-436e9cb0cc1778be774c09f0dc32f8ce-fada85767b73a637-01' /) AS "sub" / traceparent='00-436e9cb0cc1778be774c09f0dc32f8ce-fada85767b73a637-01' */
29 min 0.2%	411 ms	4,175 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"."shiftId" = $7 AND "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 /* traceparent='00-436e9cb0cc1778be774c09f0dc32f8ce-99f19590a600c2ce-01' /) AS "sub" / traceparent='00-436e9cb0cc1778be774c09f0dc32f8ce-99f19590a600c2ce-01' */
27 min 0.2%	388 ms	4,175 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"."shiftId" = $7 AND "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 /* traceparent='00-436e9cb0cc1778be774c09f0dc32f8ce-c6228793fa6b209b-01' /) AS "sub" / traceparent='00-436e9cb0cc1778be774c09f0dc32f8ce-c6228793fa6b209b-01' */
27 min 0.2%	354 ms	4,566 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"."shiftId" = $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 /* traceparent='00-59d3e87a93529f638a6c4e815697689f-3815d31ee6ab8107-01' /) AS "sub" / traceparent='00-59d3e87a93529f638a6c4e815697689f-3815d31ee6ab8107-01' */
27 min 0.2%	171 ms	9,317 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 /* traceparent='00-8e9a1bc81987d3fbe60b26e25b606149-3e7c79a983928b94-01' /) AS "sub" / traceparent='00-8e9a1bc81987d3fbe60b26e25b606149-3e7c79a983928b94-01' */`
26 min 0.2%	344 ms	4,566 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 /* traceparent='00-59d3e87a93529f638a6c4e815697689f-773b2ae537e51f28-01' /) AS "sub" / traceparent='00-59d3e87a93529f638a6c4e815697689f-773b2ae537e51f28-01' */
26 min 0.2%	344 ms	4,566 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")) AND ("j0"."clinicDomain" = $3 AND ("j0"."id" IS NOT NULL)) AND "public"."PaymentTransaction"."createdAt" >= $4 AND "public"."PaymentTransaction"."createdAt" <= $5 AND "public"."PaymentTransaction"."amount" >= $6 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" = $7) AND ("j2"."id") = ("t3"."B") AND "t3"."B" IS NOT NULL)) AND "j2"."doctorId" = $8 AND ("j4"."clinicDomain" = $9 AND ("j4"."id" IS NOT NULL)) AND ("j2"."id" IS NOT NULL)) OR ("j5"."doctorId" = $10 AND "j5"."shiftId" = $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 /* traceparent='00-59d3e87a93529f638a6c4e815697689f-66fbe83014c4f732-01' /) AS "sub" / traceparent='00-59d3e87a93529f638a6c4e815697689f-66fbe83014c4f732-01' */
26 min 0.2%	24 ms	65,898 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 /* traceparent='00-40bbf5e326456ec4c23d4332cf685456-9a7e9bc0ece7fdff-01' */
26 min 0.2%	55 ms	28,286 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" FROM "public"."PrescriptionUnit" LEFT JOIN "public"."UniqueText" AS "j0" ON ("j0"."id") = ("public"."PrescriptionUnit"."medicineId") LEFT JOIN "public"."UniqueText" AS "j1" ON ("j1"."id") = ("public"."PrescriptionUnit"."repetitionId") LEFT JOIN "public"."UniqueText" AS "j2" ON ("j2"."id") = ("public"."PrescriptionUnit"."periodId") LEFT JOIN "public"."UniqueText" AS "j3" ON ("j3"."id") = ("public"."PrescriptionUnit"."noteId") WHERE ("public"."PrescriptionUnit"."clinicDomain" = $1 AND ("j0"."text" = $2 AND "j0"."clinicDomain" = $3 AND ("j0"."id" IS NOT NULL)) AND ("j1"."text" = $4 AND "j1"."clinicDomain" = $5 AND ("j1"."id" IS NOT NULL)) AND ("j2"."text" = $6 AND "j2"."clinicDomain" = $7 AND ("j2"."id" IS NOT NULL)) AND ("j3"."text" = $8 AND "j3"."clinicDomain" = $9 AND ("j3"."id" IS NOT NULL))) LIMIT $10 OFFSET $11 /* traceparent='00-19857c9c37b4f31591639b7e452dabc7-ff3dc7365a76cd34-01' */
25 min 0.2%	780 ms	1,941 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"
25 min 0.2%	729 ms	2,040 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 /* traceparent='00-9fc4009bff1c838b582ffa712f12fd10-5038af83cad26cc5-01' /) AS "sub" / traceparent='00-9fc4009bff1c838b582ffa712f12fd10-5038af83cad26cc5-01' */
25 min 0.2%	325 ms	4,566 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 /* traceparent='00-59d3e87a93529f638a6c4e815697689f-87e5ab45e553db39-01' /) AS "sub" / traceparent='00-59d3e87a93529f638a6c4e815697689f-87e5ab45e553db39-01' */
24 min 0.2%	61 ms	23,600 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 /* traceparent='00-a2277d6805040827ea492e9a254d2d94-0e41351de6d9c344-01' /) AS "sub" / traceparent='00-a2277d6805040827ea492e9a254d2d94-0e41351de6d9c344-01' */
23 min 0.2%	108 ms	12,768 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`
22 min 0.2%	190 ms	6,893 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 ("j4"."clinicDomain" = $6 AND ("j4"."id" IS NOT NULL)) AND ("j2"."id" IS NOT NULL)) OR ("j5"."doctorId" = $7 AND "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))) AND ("j1"."id" IS NOT NULL))) OFFSET $11 /* traceparent='00-4f004af6c5aa0a422148c5578f4500d7-cbda212df649c00f-01' /) AS "sub" / traceparent='00-4f004af6c5aa0a422148c5578f4500d7-cbda212df649c00f-01' */
22 min 0.1%	128 ms	10,159 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`
22 min 0.1%	151 ms	8,549 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`
21 min 0.1%	54 ms	23,714 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 / traceparent='00-1631167fa67bf1f8217acf223182416d-183d5afb46715e10-01' /) AS "sub" / traceparent='00-1631167fa67bf1f8217acf223182416d-183d5afb46715e10-01' */
21 min 0.1%	141 ms	9,084 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`
21 min 0.1%	260 ms	4,752 postgres
SELECT "public"."LaserSession"."id", "public"."LaserSession"."amount", "public"."LaserSession"."quantity", "public"."LaserSession"."examinationId", "public"."LaserSession"."overridePrice", "public"."LaserSession"."sessionId", "public"."LaserSession"."patientId", "public"."LaserSession"."area", "public"."LaserSession"."power", "public"."LaserSession"."duration", "public"."LaserSession"."remarks", "public"."LaserSession"."frequency", "public"."LaserSession"."doctorAssistant", "public"."LaserSession"."createdAt", "public"."LaserSession"."updatedAt" FROM "public"."LaserSession" LEFT JOIN "public"."Session" AS "j0" ON ("j0"."id") = ("public"."LaserSession"."sessionId") LEFT JOIN "public"."Session" AS "j1" ON ("j1"."id") = ("public"."LaserSession"."sessionId") WHERE (("public"."LaserSession"."patientId" = $1 OR ("j0"."patientProfileId" = $2 AND ("j0"."id" IS NOT NULL))) AND ("j1"."clinicDomain" = $3 AND ("j1"."id" IS NOT NULL))) ORDER BY "public"."LaserSession"."createdAt" DESC LIMIT $4 OFFSET $5 /* traceparent='00-596158abcb37433111b3510724de5dfc-f9e216d541909c15-01' */
20 min 0.1%	177 ms	6,893 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")) AND ("j0"."clinicDomain" = $3 AND ("j0"."id" IS NOT NULL)) AND "public"."PaymentTransaction"."createdAt" >= $4 AND "public"."PaymentTransaction"."createdAt" <= $5 AND "public"."PaymentTransaction"."amount" >= $6 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" = $7) AND ("j2"."id") = ("t3"."B") AND "t3"."B" IS NOT NULL)) 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 /* traceparent='00-4f004af6c5aa0a422148c5578f4500d7-6125bad3bca09766-01' /) AS "sub" / traceparent='00-4f004af6c5aa0a422148c5578f4500d7-6125bad3bca09766-01' */
20 min 0.1%	29 ms	41,684 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 /* traceparent='00-36ddb4ea77cbfb5b5705acc337b4adb0-f7c26cf2f2c53708-01' */
19 min 0.1%	115 ms	9,969 postgres
SELECT COUNT() AS "_count$_all" FROM (SELECT "public"."Invoice"."id" 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) OFFSET $13 / traceparent='00-172ca8a0c250ad1e7c8e4b53a789a232-dc46ff9110bf704d-01' /) AS "sub" / traceparent='00-172ca8a0c250ad1e7c8e4b53a789a232-dc46ff9110bf704d-01' */
19 min 0.1%	31 ms	35,795 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-faea614d08285f62d27b044136be25d9-bfcd4507ffe2140f-01' /) AS "sub" / traceparent='00-faea614d08285f62d27b044136be25d9-bfcd4507ffe2140f-01' */`
18 min 0.1%	26 ms	41,684 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 / traceparent='00-36ddb4ea77cbfb5b5705acc337b4adb0-36f6ffdf1dc56ca5-01' /) AS "sub" / traceparent='00-36ddb4ea77cbfb5b5705acc337b4adb0-36f6ffdf1dc56ca5-01' */
18 min 0.1%	43 ms	24,955 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`
18 min 0.1%	140 ms	7,680 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`
18 min 0.1%	108 ms	9,739 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`
17 min 0.1%	150 ms	6,893 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 ("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"."createdAt" >= $14 AND "j5"."createdAt" <= $15 AND ("j5"."id" IS NOT NULL))) AND "public"."Invoice"."status" = CAST($16::text AS "public"."InvoiceStatus")) OFFSET $17 /* traceparent='00-4f004af6c5aa0a422148c5578f4500d7-4e7c502d69707271-01' /) AS "sub" / traceparent='00-4f004af6c5aa0a422148c5578f4500d7-4e7c502d69707271-01' */
17 min 0.1%	21 ms	48,551 postgres
SELECT COUNT() AS "_count$_all" FROM (SELECT "public"."Session"."id" FROM "public"."Session" WHERE ("public"."Session"."from" >= $1 AND "public"."Session"."from" <= $2 AND "public"."Session"."status" NOT IN (CAST($3::text AS "public"."SessionStatus"),CAST($4::text AS "public"."SessionStatus")) AND EXISTS(SELECT "t0"."B" FROM "public"."_ExaminationToSession" AS "t0" INNER JOIN "public"."Examination" AS "j0" ON ("j0"."id") = ("t0"."A") WHERE ("j0"."id" = $5 AND ("public"."Session"."id") = ("t0"."B") AND "t0"."B" IS NOT NULL))) OFFSET $6 / traceparent='00-2c1f0e355ca8eafa306ba681438d785e-cc30540a0c381e3e-01' /) AS "sub" / traceparent='00-2c1f0e355ca8eafa306ba681438d785e-cc30540a0c381e3e-01' */
17 min 0.1%	49 ms	20,550 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"."source", "public"."PatientProfile"."longitude", "public"."PatientProfile"."latitude", "public"."PatientProfile"."birthday", "public"."PatientProfile"."note", "public"."PatientProfile"."weight", "public"."PatientProfile"."type"::text, "public"."PatientProfile"."firstSessionDate", "public"."PatientProfile"."lastSessionDate", "public"."PatientProfile"."isActive", "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 OR "public"."PatientProfile"."phone" ILIKE $3 OR "public"."PatientProfile"."patientIndex" = $4) AND "public"."PatientProfile"."clinicDomain" = $5) ORDER BY "public"."PatientProfile"."isActive" DESC, "public"."PatientProfile"."createdAt" DESC LIMIT $6 OFFSET $7 /* traceparent='00-b4cb1a65e77ab70036fe14ca3a115dd7-2dd0e26c707582df-01' */

Duplicate Indexes

Suggested Indexes

Slow Queries