Details
On AttendanceSettings AttendanceSettings_clinicDomain_idx (clinicDomain) is covered by AttendanceSettings_clinicDomain_key (clinicDomain)
On HRSettings HRSettings_clinicDomain_idx (clinicDomain) is covered by HRSettings_clinicDomain_key (clinicDomain)
On PayrollPeriod PayrollPeriod_clinicDomain_idx (clinicDomain) is covered by PayrollPeriod_clinicDomain_startDate_endDate_key (clinicDomain, startDate, endDate)
On Payslip Payslip_periodId_idx (periodId) is covered by Payslip_periodId_userId_key (periodId, userId)
On VacationBalance VacationBalance_userId_idx (userId) is covered by VacationBalance_userId_year_clinicDomain_key (userId, year, clinicDomain)

Total Time	Average Time	Calls
18 min 0.1%	51 ms	20,852 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"."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-4e410c6feb0fa566e066888a1a72dc22-2da019cac1d3ad28-01' */

Total Time	Average Time	Calls
18 min 0.1%	29 ms	37,676 postgres
SELECT "public"."Notification"."id", "public"."Notification"."userId", "public"."Notification"."title", "public"."Notification"."content", "public"."Notification"."type"::text, "public"."Notification"."isRead", "public"."Notification"."createdAt", "public"."Notification"."updatedAt", "public"."Notification"."sentToWhatsappAt", "public"."Notification"."whatsappLogId" FROM "public"."Notification" WHERE "public"."Notification"."userId" = $1 ORDER BY "public"."Notification"."createdAt" DESC LIMIT $2 OFFSET $3 /* traceparent='00-d59b7c4f367db7b07cc5413ecaaa6b00-cadee7d1de09e2f9-01' */

Total Time	Average Time	Calls
859 min 6%	178 ms	290,055 postgres
SELECT "public"."UniqueText"."id", "public"."UniqueText"."type"::text, "public"."UniqueText"."text", "public"."UniqueText"."clinicDomain", "public"."UniqueText"."createdAt", "public"."UniqueText"."updatedAt" FROM "public"."UniqueText" WHERE ("public"."UniqueText"."type" = CAST($1::text AS "public"."UniqueTextType") AND "public"."UniqueText"."text" ILIKE $2 AND "public"."UniqueText"."clinicDomain" = $3) ORDER BY "public"."UniqueText"."createdAt" DESC LIMIT $4 OFFSET $5 /* traceparent='00-2bc4dd2c659c489355bf5a3749c45ef3-6977fe0835fcc6b6-01' */
128 min 0.9%	81 ms	94,780 postgres
SELECT "public"."UniqueText"."id", "public"."UniqueText"."type"::text, "public"."UniqueText"."text", "public"."UniqueText"."clinicDomain", "public"."UniqueText"."createdAt", "public"."UniqueText"."updatedAt" FROM "public"."UniqueText" WHERE ("public"."UniqueText"."type" = CAST($1::text AS "public"."UniqueTextType") AND "public"."UniqueText"."clinicDomain" = $2) ORDER BY "public"."UniqueText"."createdAt" DESC LIMIT $3 OFFSET $4 /* traceparent='00-b7eb66579427bae2067d604b6b1611f2-cc5452a3ed8ce062-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,718 min 25%	325 ms	686,885 postgres
`SELECT SUM("total") AS "_sum$total" FROM (SELECT "public"."InvoiceUnit"."total" FROM "public"."InvoiceUnit" LEFT JOIN "public"."Invoice" AS "j0" ON ("j0"."id") = ("public"."InvoiceUnit"."invoiceId") WHERE (($3=$4 AND ("j0"."id" IS NOT NULL)) AND "public"."InvoiceUnit"."examinationId" = $1) OFFSET $2 /* traceparent='00-73e9a1e8b42a96e6e4e0f646bde40bda-bbe5907469d210f8-01' */) AS "sub"`
2,380 min 16%	624 ms	228,700 postgres
SELECT SUM("total") AS "_sum$total" FROM (SELECT "public"."Invoice"."total" 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 /* traceparent='00-f6556dfe566619fb95dfd86be505cc4d-809f4c79fcee0fec-01' /) AS "sub" / traceparent='00-f6556dfe566619fb95dfd86be505cc4d-809f4c79fcee0fec-01' */
1,921 min 13%	566 ms	203,822 postgres
SELECT SUM("restNotPaid") AS "_sum$restNotPaid" FROM (SELECT "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 /* traceparent='00-791567810990e2bc32e82084af5cbf28-21048d35d8f2a40b-01' /) AS "sub" / traceparent='00-791567810990e2bc32e82084af5cbf28-21048d35d8f2a40b-01' */
1,813 min 12%	534 ms	203,824 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-791567810990e2bc32e82084af5cbf28-ecb4441b2bf1b524-01' /) AS "sub" / traceparent='00-791567810990e2bc32e82084af5cbf28-ecb4441b2bf1b524-01' */
859 min 6%	178 ms	290,055 postgres
SELECT "public"."UniqueText"."id", "public"."UniqueText"."type"::text, "public"."UniqueText"."text", "public"."UniqueText"."clinicDomain", "public"."UniqueText"."createdAt", "public"."UniqueText"."updatedAt" FROM "public"."UniqueText" WHERE ("public"."UniqueText"."type" = CAST($1::text AS "public"."UniqueTextType") AND "public"."UniqueText"."text" ILIKE $2 AND "public"."UniqueText"."clinicDomain" = $3) ORDER BY "public"."UniqueText"."createdAt" DESC LIMIT $4 OFFSET $5 /* traceparent='00-2bc4dd2c659c489355bf5a3749c45ef3-6977fe0835fcc6b6-01' / Details `CREATE INDEX CONCURRENTLY ON UniqueText (clinicDomain, type)` `Rows: 145441 Row progression: 145441, 641, 6 Row estimates - clinicDomain (=): 641 - type (=): 1276 - text (~~): 14544 - createdAt (sort): 1 Existing indexes - id PRIMARY - text, clinicDomain, type UNIQUE`
786 min 5%	163 ms	290,052 postgres
`SELECT COUNT() AS "_count$_all" FROM (SELECT "public"."UniqueText"."id" FROM "public"."UniqueText" WHERE ("public"."UniqueText"."type" = CAST($1::text AS "public"."UniqueTextType") AND "public"."UniqueText"."text" ILIKE $2 AND "public"."UniqueText"."clinicDomain" = $3) OFFSET $4 / traceparent='00-2bc4dd2c659c489355bf5a3749c45ef3-61ff011f57eea51d-01' /) AS "sub" / traceparent='00-2bc4dd2c659c489355bf5a3749c45ef3-61ff011f57eea51d-01' */`
191 min 1%	460 ms	24,859 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"."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-f6556dfe566619fb95dfd86be505cc4d-12b743fb2995efb6-01' /) AS "sub" / traceparent='00-f6556dfe566619fb95dfd86be505cc4d-12b743fb2995efb6-01' */
157 min 1%	397 ms	23,773 postgres
SELECT "public"."Session"."id", "public"."Session"."patientProfileId", "public"."Session"."doctorId", "public"."Session"."assistantId", "public"."Session"."referralDoctorId", "public"."Session"."number", "public"."Session"."date", "public"."Session"."from", "public"."Session"."to", "public"."Session"."shiftId", "public"."Session"."note", "public"."Session"."totalTimeInSec", "public"."Session"."clinicDomain", "public"."Session"."isWhatsAppNotificationSentHour", "public"."Session"."isWhatsAppNotificationSentTenMin", "public"."Session"."isPatientInWaitingRoom", "public"."Session"."patientInWaitingRoomFrom", "public"."Session"."startTime", "public"."Session"."endTime", "public"."Session"."order", "public"."Session"."timeType"::text, "public"."Session"."status"::text, "public"."Session"."branchId", "public"."Session"."createdAt", "public"."Session"."updatedAt", "public"."Session"."packageSubscriptionId", "public"."Session"."link", "public"."Session"."confirmedAt", "public"."Session"."specialty"::text, "public"."Session"."cancellationReason", "public"."Session"."cancellationDate", "public"."Session"."generalTags", "public"."Session"."expectedTotalTime", "public"."Session"."treatmentPlanId", "public"."Session"."patientJourneyId" FROM "public"."Session" WHERE ((EXISTS(SELECT "t0"."A" FROM "public"."_SessionToUniqueText" AS "t0" INNER JOIN "public"."UniqueText" AS "j0" ON ("j0"."id") = ("t0"."B") WHERE ($4=$5 AND ("public"."Session"."id") = ("t0"."A") AND "t0"."A" IS NOT NULL)) OR EXISTS(SELECT "t1"."A" FROM "public"."_SessionComplaints" AS "t1" INNER JOIN "public"."UniqueText" AS "j1" ON ("j1"."id") = ("t1"."B") WHERE ($6=$7 AND ("public"."Session"."id") = ("t1"."A") AND "t1"."A" IS NOT NULL))) AND "public"."Session"."clinicDomain" = $1) ORDER BY "public"."Session"."createdAt" DESC LIMIT $2 OFFSET $3
130 min 0.9%	71 ms	110,342 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-e56b191febea0abb5ab1bea83c07c11a-87582eb1314b88c5-01' */
128 min 0.9%	81 ms	94,780 postgres
SELECT "public"."UniqueText"."id", "public"."UniqueText"."type"::text, "public"."UniqueText"."text", "public"."UniqueText"."clinicDomain", "public"."UniqueText"."createdAt", "public"."UniqueText"."updatedAt" FROM "public"."UniqueText" WHERE ("public"."UniqueText"."type" = CAST($1::text AS "public"."UniqueTextType") AND "public"."UniqueText"."clinicDomain" = $2) ORDER BY "public"."UniqueText"."createdAt" DESC LIMIT $3 OFFSET $4 /* traceparent='00-b7eb66579427bae2067d604b6b1611f2-cc5452a3ed8ce062-01' */ Details `CREATE INDEX CONCURRENTLY ON UniqueText (clinicDomain, type)` `Rows: 145441 Row progression: 145441, 641, 6 Row estimates - clinicDomain (=): 641 - type (=): 1276 - createdAt (sort): 1 Existing indexes - id PRIMARY - text, clinicDomain, type UNIQUE`
110 min 0.7%	279 ms	23,773 postgres
SELECT COUNT() AS "_count$_all" FROM (SELECT "public"."Session"."id" FROM "public"."Session" WHERE ((EXISTS(SELECT "t0"."A" FROM "public"."_SessionToUniqueText" AS "t0" INNER JOIN "public"."UniqueText" AS "j0" ON ("j0"."id") = ("t0"."B") WHERE ($3=$4 AND ("public"."Session"."id") = ("t0"."A") AND "t0"."A" IS NOT NULL)) OR EXISTS(SELECT "t1"."A" FROM "public"."_SessionComplaints" AS "t1" INNER JOIN "public"."UniqueText" AS "j1" ON ("j1"."id") = ("t1"."B") WHERE ($5=$6 AND ("public"."Session"."id") = ("t1"."A") AND "t1"."A" IS NOT NULL))) AND "public"."Session"."clinicDomain" = $1) OFFSET $2 / traceparent='00-5e349a6a575436e56900f6c08dcb4767-f2e642c8a20e7e3c-01' */) AS "sub"
108 min 0.7%	68 ms	94,779 postgres
`SELECT COUNT() AS "_count$_all" FROM (SELECT "public"."UniqueText"."id" FROM "public"."UniqueText" WHERE ("public"."UniqueText"."type" = CAST($1::text AS "public"."UniqueTextType") AND "public"."UniqueText"."clinicDomain" = $2) OFFSET $3 / traceparent='00-b7eb66579427bae2067d604b6b1611f2-2c3eea0ceba9867c-01' /) AS "sub" / traceparent='00-b7eb66579427bae2067d604b6b1611f2-2c3eea0ceba9867c-01' */`
104 min 0.7%	26 ms	244,747 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-bcea28170369dce3d6f554d2be40ecd7-6efb2a5d3891821e-01' */
89 min 0.6%	22 ms	244,747 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-bcea28170369dce3d6f554d2be40ecd7-0033b0d31bf16b20-01' /) AS "sub" / traceparent='00-bcea28170369dce3d6f554d2be40ecd7-0033b0d31bf16b20-01' */
87 min 0.6%	583 ms	8,931 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") 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 ("j2"."clinicDomain" = $2 AND ("j2"."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 (("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"."branchId" = $9 AND ("j6"."clinicDomain" = $10 AND ("j6"."id" IS NOT NULL)) AND "j5"."date" >= $11 AND "j5"."date" <= $12 AND "j5"."status" <> CAST($13::text AS "public"."SessionStatus") AND ("j5"."id" IS NOT NULL))) AND "public"."Invoice"."status" = CAST($14::text AS "public"."InvoiceStatus")) OFFSET $15 /* traceparent='00-0490f24aa581d472d36d7ee4b5f99f86-d507fb121ada1872-01' /) AS "sub" / traceparent='00-0490f24aa581d472d36d7ee4b5f99f86-d507fb121ada1872-01' */
74 min 0.5%	568 ms	7,861 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") WHERE (((("j1"."clinicDomain" = $1 AND ("j1"."id" IS NOT NULL)) AND "j0"."createdAt" >= $2 AND "j0"."createdAt" <= $3 AND "j0"."status" <> CAST($4::text AS "public"."PackageSubscriptionStatus") AND ("j0"."id" IS NOT NULL)) OR (("j3"."clinicDomain" = $5 AND ("j3"."id" IS NOT NULL)) AND "j2"."createdAt" >= $6 AND "j2"."createdAt" <= $7 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"."date" >= $10 AND "j4"."date" <= $11 AND ("j4"."id" IS NOT NULL))) AND "public"."Invoice"."status" = CAST($12::text AS "public"."InvoiceStatus")) OFFSET $13 /* traceparent='00-4204664206eb0dfcdd0af733619eef74-f28f5e6299ad89be-01' /) AS "sub" / traceparent='00-4204664206eb0dfcdd0af733619eef74-f28f5e6299ad89be-01' */
52 min 0.4%	73 ms	42,880 postgres
SELECT "public"."UniqueText"."id", "public"."UniqueText"."type"::text, "public"."UniqueText"."text", "public"."UniqueText"."clinicDomain", "public"."UniqueText"."createdAt", "public"."UniqueText"."updatedAt" FROM "public"."UniqueText" WHERE ("public"."UniqueText"."type" = CAST($1::text AS "public"."UniqueTextType") AND "public"."UniqueText"."text"::text LIKE $2 AND "public"."UniqueText"."clinicDomain" = $3) ORDER BY "public"."UniqueText"."createdAt" DESC LIMIT $4 OFFSET $5 /* traceparent='00-ba63b748c4bbc8133404429561673723-a3c84ac2f0f0dfac-01' */
49 min 0.3%	70 ms	42,182 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"."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" 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
47 min 0.3%	65 ms	42,880 postgres
`SELECT COUNT() AS "_count$_all" FROM (SELECT "public"."UniqueText"."id" FROM "public"."UniqueText" WHERE ("public"."UniqueText"."type" = CAST($1::text AS "public"."UniqueTextType") AND "public"."UniqueText"."text"::text LIKE $2 AND "public"."UniqueText"."clinicDomain" = $3) OFFSET $4 / traceparent='00-ba63b748c4bbc8133404429561673723-8a24cc1df7d1396c-01' /) AS "sub" / traceparent='00-ba63b748c4bbc8133404429561673723-8a24cc1df7d1396c-01' */`
46 min 0.3%	859 ms	3,199 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"."User" AS "j5" ON ("j5"."id") = ("j3"."doctorId") 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 ((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"."date" >= $11 AND "j3"."date" <= $12 AND "j3"."status" <> CAST($13::text AS "public"."SessionStatus") AND ((NOT $16=$17) AND ("j5"."id" IS NOT NULL)) AND ("j3"."id" IS NOT NULL)) OR ("j7"."clinicDomain" = $14 AND ("j7"."id" IS NOT NULL) AND ("j6"."id" IS NOT NULL)))) OFFSET $15 /* traceparent='00-993e05221af96cac375f9b691516c471-5b627bbe02c22e68-01' */) AS "sub"
40 min 0.3%	35 ms	67,797 postgres
`SELECT MAX("serialNumber") AS "_max$serialNumber" FROM (SELECT "public"."Invoice"."serialNumber" FROM "public"."Invoice" WHERE "public"."Invoice"."clinicDomain" = $1 OFFSET $2 /* traceparent='00-e6b532352eebb1b414fe9db9550c16de-5a11b71ca25e82c0-01' /) AS "sub" / traceparent='00-e6b532352eebb1b414fe9db9550c16de-5a11b71ca25e82c0-01' */`
39 min 0.3%	135 ms	17,318 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"."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-c09946c1ea761b8b7c61caadee384ef0-bac0ee4cc24f30ec-01' */ `Covered by index on (clinicDomain, link) Rows: 216581 Row progression: 216581, 985, 493 Row estimates - clinicDomain (=): 985 - isActive (=): 108291 - id (sort): 1 Existing indexes - id PRIMARY - clinicDomain, link UNIQUE - clinicDomain, patientIndex UNIQUE`
38 min 0.3%	33 ms	70,406 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"."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" 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
33 min 0.2%	59 ms	33,227 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-0490f24aa581d472d36d7ee4b5f99f86-7d612a68450d8de1-01' /) AS "sub" / traceparent='00-0490f24aa581d472d36d7ee4b5f99f86-7d612a68450d8de1-01' */`
30 min 0.2%	684 ms	2,647 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") 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"."doctorId" = $2 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"."date" >= $10 AND "j3"."date" <= $11 AND "j3"."status" <> CAST($12::text AS "public"."SessionStatus") AND ("j3"."id" IS NOT NULL))) AND "public"."Invoice"."status" = CAST($13::text AS "public"."InvoiceStatus")) OFFSET $14 /* traceparent='00-82a429e1bf5aeb58407cc4fbdf858041-a1f44088fbcf6885-01' /) AS "sub" / traceparent='00-82a429e1bf5aeb58407cc4fbdf858041-a1f44088fbcf6885-01' */
26 min 0.2%	242 ms	6,462 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"."User" AS "j5" ON ("j5"."id") = ("j3"."doctorId") 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 ((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"."date" >= $9 AND "j3"."date" <= $10 AND "j3"."status" <> CAST($11::text AS "public"."SessionStatus") AND ((NOT $14=$15) AND ("j5"."id" IS NOT NULL)) AND ("j3"."id" IS NOT NULL)) OR ("j7"."clinicDomain" = $12 AND ("j7"."id" IS NOT NULL) AND ("j6"."id" IS NOT NULL)))) OFFSET $13 /* traceparent='00-c129a136a6f64cdb969df1e2717c1082-f95f2a2578329900-01' */) AS "sub"
24 min 0.2%	81 ms	17,678 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-df1c976d41162663d926108e17dc791f-3342fc0e78679305-01' */
23 min 0.2%	218 ms	6,345 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"."whatsappCampaignId", "public"."PatientProfile"."link", "public"."PatientProfile"."branchId", "public"."PatientProfile"."petType", "public"."PatientProfile"."color", "public"."PatientProfile"."petStatus", "public"."PatientProfile"."petBreed", "public"."PatientProfile"."petName", "public"."PatientProfile"."isVaccinated", "public"."PatientProfile"."totalPayed", "public"."PatientProfile"."totalPayments", "public"."PatientProfile"."totalPaymentsRest", "public"."PatientProfile"."totalUpcomingPayments", "public"."PatientProfile"."telegramChatId", "public"."PatientProfile"."telegramUsername" FROM "public"."PatientProfile" WHERE ("public"."PatientProfile"."isActive" = $1 AND ("public"."PatientProfile"."name" ILIKE $2 OR "public"."PatientProfile"."phone" IS NULL) AND "public"."PatientProfile"."id" <> $3 AND "public"."PatientProfile"."clinicDomain" = $4) ORDER BY "public"."PatientProfile"."id" ASC LIMIT $5 OFFSET $6 /* traceparent='00-7cc4f0a3891f56b700019bebcb950085-7179b05309459ac6-01' */
22 min 0.1%	25 ms	51,731 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"."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-787b3eb8716d00c89d755b287f889127-4ebe948c59d0c2df-01' */
20 min 0.1%	204 ms	5,959 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"."User" AS "j5" ON ("j5"."id") = ("j3"."doctorId") 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"."date" >= $9 AND "j3"."date" <= $10 AND "j3"."status" <> CAST($11::text AS "public"."SessionStatus") AND ((NOT $13=$14) AND ("j5"."id" IS NOT NULL)) AND ("j3"."id" IS NOT NULL)))) OFFSET $12 /* traceparent='00-0490f24aa581d472d36d7ee4b5f99f86-d70bd720e18cdd8a-01' */) AS "sub"
19 min 0.1%	265 ms	4,381 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-993e05221af96cac375f9b691516c471-d8bacef60a377b04-01' /) AS "sub" / traceparent='00-993e05221af96cac375f9b691516c471-d8bacef60a377b04-01' */
19 min 0.1%	27 ms	42,890 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"."clinicDomain" = $3 AND "public"."Session"."status" = CAST($4::text AS "public"."SessionStatus")) OFFSET $5 / traceparent='00-13659963b5616fc87634e7a08c293e9e-83110bfb6ddaa408-01' /) AS "sub" / traceparent='00-13659963b5616fc87634e7a08c293e9e-83110bfb6ddaa408-01' */`
19 min 0.1%	261 ms	4,372 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-993e05221af96cac375f9b691516c471-4c714725400df3b5-01' /) AS "sub" / traceparent='00-993e05221af96cac375f9b691516c471-4c714725400df3b5-01' */
19 min 0.1%	63 ms	17,678 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-df1c976d41162663d926108e17dc791f-456d1cebe6c7e4ce-01' /) AS "sub" / traceparent='00-df1c976d41162663d926108e17dc791f-456d1cebe6c7e4ce-01' */
18 min 0.1%	29 ms	37,676 postgres
`SELECT COUNT() AS "_count$_all" FROM (SELECT "public"."Notification"."id" FROM "public"."Notification" WHERE "public"."Notification"."userId" = $1 OFFSET $2 / traceparent='00-d59b7c4f367db7b07cc5413ecaaa6b00-2e0b6a2f67618555-01' /) AS "sub" / traceparent='00-d59b7c4f367db7b07cc5413ecaaa6b00-2e0b6a2f67618555-01' */`
18 min 0.1%	29 ms	37,676 postgres
SELECT "public"."Notification"."id", "public"."Notification"."userId", "public"."Notification"."title", "public"."Notification"."content", "public"."Notification"."type"::text, "public"."Notification"."isRead", "public"."Notification"."createdAt", "public"."Notification"."updatedAt", "public"."Notification"."sentToWhatsappAt", "public"."Notification"."whatsappLogId" FROM "public"."Notification" WHERE "public"."Notification"."userId" = $1 ORDER BY "public"."Notification"."createdAt" DESC LIMIT $2 OFFSET $3 /* traceparent='00-d59b7c4f367db7b07cc5413ecaaa6b00-cadee7d1de09e2f9-01' */ Details `CREATE INDEX CONCURRENTLY ON Notification (userId, createdAt)` `Rows: 84205 Row progression: 84205, 726, 0 Row estimates - userId (=): 726 - createdAt (sort): 1 Existing indexes - id PRIMARY - whatsappLogId UNIQUE`
18 min 0.1%	108 ms	9,909 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 (("j4"."clinicDomain" = $7 AND ("j4"."id" IS NOT NULL)) AND "j3"."createdAt" >= $8 AND "j3"."createdAt" <= $9 AND ("j3"."id" IS NOT NULL)) OR ("j5"."branchId" = $10 AND ("j6"."clinicDomain" = $11 AND ("j6"."id" IS NOT NULL)) AND "j5"."date" >= $12 AND "j5"."date" <= $13 AND "j5"."status" <> CAST($14::text AS "public"."SessionStatus") AND ("j5"."id" IS NOT NULL)) OR ("j8"."clinicDomain" = $15 AND ("j8"."id" IS NOT NULL) AND ("j7"."id" IS NOT NULL))) AND "public"."Invoice"."status" = CAST($16::text AS "public"."InvoiceStatus")) OFFSET $17 /* traceparent='00-83b65343b11394e64f7eecfbca3d4a68-48b9303fb01f3c03-01' /) AS "sub" / traceparent='00-83b65343b11394e64f7eecfbca3d4a68-48b9303fb01f3c03-01' */
18 min 0.1%	244 ms	4,381 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-993e05221af96cac375f9b691516c471-6b00b3d8882d6db6-01' /) AS "sub" / traceparent='00-993e05221af96cac375f9b691516c471-6b00b3d8882d6db6-01' */
18 min 0.1%	51 ms	20,852 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"."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-4e410c6feb0fa566e066888a1a72dc22-2da019cac1d3ad28-01' */ Details `CREATE INDEX CONCURRENTLY ON Invoice (clinicDomain, restNotPaid)` `Rows: 506245 Row progression: 506245, 2531, 254 Row estimates - clinicDomain (=): 2531 - restNotPaid (>): 50849 - status (=): 168748 - createdAt (sort): 1 Existing indexes - id PRIMARY - accommodationId UNIQUE - clinicDomain, serialNumber UNIQUE - closingShiftId - orderId UNIQUE - sessionId UNIQUE`
17 min 0.1%	102 ms	9,909 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 (("j5"."clinicDomain" = $7 AND ("j5"."id" IS NOT NULL)) AND "j4"."createdAt" >= $8 AND "j4"."createdAt" <= $9 AND ("j4"."id" IS NOT NULL)) OR ("j6"."branchId" = $10 AND ("j7"."clinicDomain" = $11 AND ("j7"."id" IS NOT NULL)) AND "j6"."date" >= $12 AND "j6"."date" <= $13 AND "j6"."status" <> CAST($14::text AS "public"."SessionStatus") AND ("j6"."id" IS NOT NULL)) OR ("j9"."clinicDomain" = $15 AND ("j9"."id" IS NOT NULL) AND ("j8"."id" IS NOT NULL))) AND "j0"."status" = CAST($16::text AS "public"."InvoiceStatus") AND ("j0"."id" IS NOT NULL)) OFFSET $17 /* traceparent='00-83b65343b11394e64f7eecfbca3d4a68-d9f3ddb28a744e39-01' /) AS "sub" / traceparent='00-83b65343b11394e64f7eecfbca3d4a68-d9f3ddb28a744e39-01' */
17 min 0.1%	128 ms	7,889 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-3b47e0a76859f9e85fcf0c196b3cfab9-b4caa3ba447bbcd5-01' /) AS "sub" / traceparent='00-3b47e0a76859f9e85fcf0c196b3cfab9-b4caa3ba447bbcd5-01' */
16 min 0.1%	224 ms	4,381 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"."date" >= $11 AND "j3"."date" <= $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))) AND "public"."Invoice"."status" = CAST($15::text AS "public"."InvoiceStatus")) OFFSET $16 /* traceparent='00-993e05221af96cac375f9b691516c471-26d678678f3af7cb-01' /) AS "sub" / traceparent='00-993e05221af96cac375f9b691516c471-26d678678f3af7cb-01' */
16 min 0.1%	99 ms	9,893 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 ("j10"."clinicDomain" = $10 AND ("j10"."id" IS NOT NULL) AND ("j9"."id" IS NOT NULL))) AND ("j1"."id" IS NOT NULL))) OFFSET $11 /* traceparent='00-83b65343b11394e64f7eecfbca3d4a68-e791525a1ab06633-01' /) AS "sub" / traceparent='00-83b65343b11394e64f7eecfbca3d4a68-e791525a1ab06633-01' */
16 min 0.1%	99 ms	9,909 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 ("j10"."clinicDomain" = $10 AND ("j10"."id" IS NOT NULL) AND ("j9"."id" IS NOT NULL))) AND ("j1"."id" IS NOT NULL))) OFFSET $11 /* traceparent='00-83b65343b11394e64f7eecfbca3d4a68-ec81d08c5efcecb6-01' /) AS "sub" / traceparent='00-83b65343b11394e64f7eecfbca3d4a68-ec81d08c5efcecb6-01' */
16 min 0.1%	124 ms	7,871 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-3b47e0a76859f9e85fcf0c196b3cfab9-53f778a55840dc9f-01' /) AS "sub" / traceparent='00-3b47e0a76859f9e85fcf0c196b3cfab9-53f778a55840dc9f-01' */
16 min 0.1%	121 ms	7,889 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-3b47e0a76859f9e85fcf0c196b3cfab9-d227d8ae5ef3642c-01' /) AS "sub" / traceparent='00-3b47e0a76859f9e85fcf0c196b3cfab9-d227d8ae5ef3642c-01' */
16 min 0.1%	218 ms	4,381 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"."date" >= $11 AND "j4"."date" <= $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"."id" IS NOT NULL))) AND "j0"."status" = CAST($15::text AS "public"."InvoiceStatus") AND ("j0"."id" IS NOT NULL)) OFFSET $16 /* traceparent='00-993e05221af96cac375f9b691516c471-8d47aa83d3a82232-01' /) AS "sub" / traceparent='00-993e05221af96cac375f9b691516c471-8d47aa83d3a82232-01' */
16 min 0.1%	96 ms	9,909 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 ("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-83b65343b11394e64f7eecfbca3d4a68-5dd03ef5bb5fca89-01' /) AS "sub" / traceparent='00-83b65343b11394e64f7eecfbca3d4a68-5dd03ef5bb5fca89-01' */
15 min 0.1%	307 ms	2,960 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") 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"."date" >= $9 AND "j3"."date" <= $10 AND "j3"."status" <> CAST($11::text AS "public"."SessionStatus") AND ("j3"."id" IS NOT NULL)))) OFFSET $12 /* traceparent='00-66f091e63c5a31e9bb8d99c271eecfec-9f67c9cbd65e3415-01' /) AS "sub" / traceparent='00-66f091e63c5a31e9bb8d99c271eecfec-9f67c9cbd65e3415-01' */
15 min 0.1%	290 ms	3,090 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"."User" AS "j4" ON ("j4"."id") = ("j2"."doctorId") 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 ((("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"."date" >= $8 AND "j2"."date" <= $9 AND ((NOT $12=$13) AND ("j4"."id" IS NOT NULL)) AND ("j2"."id" IS NOT NULL)) OR ("j6"."clinicDomain" = $10 AND ("j6"."id" IS NOT NULL) AND ("j5"."id" IS NOT NULL)))) OFFSET $11 /* traceparent='00-acd9f5fa7d01887f5494210ac5a46bd8-dc4700482a4a63bc-01' */) AS "sub"
15 min < 0.1%	100 ms	8,919 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"."Order" AS "j7" ON ("j7"."id") = ("j1"."orderId") 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 ("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))) AND ("j1"."id" IS NOT NULL))) OFFSET $10 /* traceparent='00-0490f24aa581d472d36d7ee4b5f99f86-f20040656f4d4b54-01' /) AS "sub" / traceparent='00-0490f24aa581d472d36d7ee4b5f99f86-f20040656f4d4b54-01' */
15 min < 0.1%	30 ms	30,013 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-1ff6bf54cf73d995455be72bd8d044a5-5a42a81f7f093228-01' /) AS "sub" / traceparent='00-1ff6bf54cf73d995455be72bd8d044a5-5a42a81f7f093228-01' */`
14 min < 0.1%	179 ms	4,780 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"."date" >= $8 AND "j2"."date" <= $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-3b47e0a76859f9e85fcf0c196b3cfab9-f7a9a4bbb0af935a-01' /) AS "sub" / traceparent='00-3b47e0a76859f9e85fcf0c196b3cfab9-f7a9a4bbb0af935a-01' */
14 min < 0.1%	445 ms	1,905 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"."User" AS "j5" ON ("j5"."id") = ("j3"."doctorId") 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"."date" >= $11 AND "j3"."date" <= $12 AND "j3"."status" <> CAST($13::text AS "public"."SessionStatus") AND ((NOT $15=$16) AND ("j5"."id" IS NOT NULL)) AND ("j3"."id" IS NOT NULL)))) OFFSET $14 /* traceparent='00-82a429e1bf5aeb58407cc4fbdf858041-4201a6daf4cf7e5b-01' */) AS "sub"
14 min < 0.1%	38 ms	22,383 postgres
SELECT "public"."PackageSubscription"."id", "public"."PackageSubscription"."packageId", "public"."PackageSubscription"."patientProfileId", "public"."PackageSubscription"."invoiceId", "public"."PackageSubscription"."doctorId", "public"."PackageSubscription"."assistantId", "public"."PackageSubscription"."referralDoctorId", "public"."PackageSubscription"."status"::text, "public"."PackageSubscription"."isOnHold", "public"."PackageSubscription"."startDate", "public"."PackageSubscription"."endDate", "public"."PackageSubscription"."effectiveEndDate", "public"."PackageSubscription"."createdAt", "public"."PackageSubscription"."updatedAt", "public"."PackageSubscription"."finishedAt", "public"."PackageSubscription"."shiftId", "public"."PackageSubscription"."patientInsuranceId", "public"."PackageSubscription"."mainBranchId" FROM "public"."PackageSubscription" LEFT JOIN "public"."Package" AS "j2" ON ("j2"."id") = ("public"."PackageSubscription"."packageId") WHERE ("public"."PackageSubscription"."patientProfileId" = $1 AND (EXISTS(SELECT "t0"."B" FROM "public"."_BranchToPackageSubscription" AS "t0" INNER JOIN "public"."Branch" AS "j0" ON ("j0"."id") = ("t0"."A") WHERE ("j0"."id" = $2 AND ("public"."PackageSubscription"."id") = ("t0"."B") AND "t0"."B" IS NOT NULL)) OR NOT EXISTS(SELECT "t1"."B" FROM "public"."_BranchToPackageSubscription" AS "t1" INNER JOIN "public"."Branch" AS "j1" ON ("j1"."id") = ("t1"."A") WHERE ($7=$8 AND ("public"."PackageSubscription"."id") = ("t1"."B") AND "t1"."B" IS NOT NULL))) AND "public"."PackageSubscription"."status" = CAST($3::text AS "public"."PackageSubscriptionStatus") AND (EXISTS(SELECT "t3"."packageId" FROM "public"."PackageUnit" AS "t3" WHERE ("t3"."examinationId" IN ($4) AND ("j2"."id") = ("t3"."packageId") AND "t3"."packageId" IS NOT NULL)) AND ("j2"."id" IS NOT NULL))) LIMIT $5 OFFSET $6
14 min < 0.1%	233 ms	3,534 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"."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-8647724935b55aa444d9d4a7f949429e-c7a7da98adcd4344-01' */
13 min < 0.1%	280 ms	2,867 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"."User" AS "j4" ON ("j4"."id") = ("j2"."doctorId") 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"."date" >= $8 AND "j2"."date" <= $9 AND ((NOT $11=$12) AND ("j4"."id" IS NOT NULL)) AND ("j2"."id" IS NOT NULL)))) OFFSET $10 /* traceparent='00-5bb9fe8e4199c0dbbd21814e49c7716a-fc2cc31b9244a30f-01' */) AS "sub"
13 min < 0.1%	100 ms	7,889 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"."date" >= $11 AND "j4"."date" <= $12 AND ("j4"."id" IS NOT NULL)) OR ("j7"."clinicDomain" = $13 AND ("j7"."id" IS NOT NULL) AND ("j6"."id" IS NOT NULL))) AND "public"."Invoice"."status" = CAST($14::text AS "public"."InvoiceStatus")) OFFSET $15 /* traceparent='00-3b47e0a76859f9e85fcf0c196b3cfab9-a7e3103367e16dc5-01' /) AS "sub" / traceparent='00-3b47e0a76859f9e85fcf0c196b3cfab9-a7e3103367e16dc5-01' */
13 min < 0.1%	101 ms	7,816 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"."Order" AS "j7" ON ("j7"."id") = ("j1"."orderId") 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"."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))) AND ("j1"."id" IS NOT NULL))) OFFSET $10 /* traceparent='00-dae9d8e8ef09570bcf413df515b9dc6b-7ea168e8aa6c48c2-01' /) AS "sub" / traceparent='00-dae9d8e8ef09570bcf413df515b9dc6b-7ea168e8aa6c48c2-01' */
13 min < 0.1%	97 ms	7,816 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"."Order" AS "j7" ON ("j7"."id") = ("j1"."orderId") 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"."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-dae9d8e8ef09570bcf413df515b9dc6b-f5f1fbc7b4209f9b-01' /) AS "sub" / traceparent='00-dae9d8e8ef09570bcf413df515b9dc6b-f5f1fbc7b4209f9b-01' */
13 min < 0.1%	97 ms	7,830 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"."Order" AS "j6" ON ("j6"."id") = ("j1"."orderId") LEFT JOIN "public"."PatientProfile" AS "j7" ON ("j7"."id") = ("j6"."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))) AND ("j1"."id" IS NOT NULL))) OFFSET $9 /* traceparent='00-4204664206eb0dfcdd0af733619eef74-3422c06f5f027056-01' /) AS "sub" / traceparent='00-4204664206eb0dfcdd0af733619eef74-3422c06f5f027056-01' */
13 min < 0.1%	84 ms	8,931 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") 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 (("j5"."clinicDomain" = $7 AND ("j5"."id" IS NOT NULL)) AND "j4"."createdAt" >= $8 AND "j4"."createdAt" <= $9 AND ("j4"."id" IS NOT NULL)) OR ("j6"."branchId" = $10 AND ("j7"."clinicDomain" = $11 AND ("j7"."id" IS NOT NULL)) AND "j6"."date" >= $12 AND "j6"."date" <= $13 AND "j6"."status" <> CAST($14::text AS "public"."SessionStatus") AND ("j6"."id" IS NOT NULL))) AND "j0"."status" = CAST($15::text AS "public"."InvoiceStatus") AND ("j0"."id" IS NOT NULL)) OFFSET $16 /* traceparent='00-0490f24aa581d472d36d7ee4b5f99f86-9ecdfa8b1c3aac65-01' /) AS "sub" / traceparent='00-0490f24aa581d472d36d7ee4b5f99f86-9ecdfa8b1c3aac65-01' */
13 min < 0.1%	95 ms	7,889 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"."date" >= $11 AND "j5"."date" <= $12 AND ("j5"."id" IS NOT NULL)) OR ("j8"."clinicDomain" = $13 AND ("j8"."id" IS NOT NULL) AND ("j7"."id" IS NOT NULL))) AND "j0"."status" = CAST($14::text AS "public"."InvoiceStatus") AND ("j0"."id" IS NOT NULL)) OFFSET $15 /* traceparent='00-3b47e0a76859f9e85fcf0c196b3cfab9-a3f43f97e90112ba-01' /) AS "sub" / traceparent='00-3b47e0a76859f9e85fcf0c196b3cfab9-a3f43f97e90112ba-01' */
12 min < 0.1%	601 ms	1,180 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") 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 ("j2"."clinicDomain" = $2 AND ("j2"."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"."doctorId" = $6 AND "j3"."branchId" = $7 AND ("j4"."clinicDomain" = $8 AND ("j4"."id" IS NOT NULL)) AND "j3"."date" >= $9 AND "j3"."date" <= $10 AND "j3"."status" <> CAST($11::text AS "public"."SessionStatus") AND ("j3"."id" IS NOT NULL))) AND "public"."Invoice"."status" = CAST($12::text AS "public"."InvoiceStatus")) OFFSET $13 /* traceparent='00-777da4fe7fb1f79e9be077262e07c594-9fa25b42c5bd1eed-01' /) AS "sub" / traceparent='00-777da4fe7fb1f79e9be077262e07c594-9fa25b42c5bd1eed-01' */
12 min < 0.1%	143 ms	4,963 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") 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"."date" >= $8 AND "j2"."date" <= $9 AND ("j2"."id" IS NOT NULL)))) OFFSET $10 /* traceparent='00-4204664206eb0dfcdd0af733619eef74-3f68768f9336f114-01' /) AS "sub" / traceparent='00-4204664206eb0dfcdd0af733619eef74-3f68768f9336f114-01' */
12 min < 0.1%	21 ms	32,873 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-e7c4b4228a3d9e5562b37e1e5aadd564-e929d61f05f30d8b-01' */
11 min < 0.1%	99 ms	6,712 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"."Order" AS "j6" ON ("j6"."id") = ("j1"."orderId") LEFT JOIN "public"."PatientProfile" AS "j7" ON ("j7"."id") = ("j6"."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))) AND ("j1"."id" IS NOT NULL))) OFFSET $11 /* traceparent='00-ff16bf76e448ce5f3012aa56279297e7-64a1d564c21720e7-01' /) AS "sub" / traceparent='00-ff16bf76e448ce5f3012aa56279297e7-64a1d564c21720e7-01' */
11 min < 0.1%	49 ms	13,338 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-4443d3b33415eb4554659c48a2939b85-38e56fd95c00dfdb-01' */
11 min < 0.1%	98 ms	6,712 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"."Order" AS "j6" ON ("j6"."id") = ("j1"."orderId") LEFT JOIN "public"."PatientProfile" AS "j7" ON ("j7"."id") = ("j6"."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))) AND ("j1"."id" IS NOT NULL))) OFFSET $9 /* traceparent='00-ff16bf76e448ce5f3012aa56279297e7-2666eeb6e1599722-01' /) AS "sub" / traceparent='00-ff16bf76e448ce5f3012aa56279297e7-2666eeb6e1599722-01' */
11 min < 0.1%	141 ms	4,646 postgres
`SELECT COUNT() AS "_count$_all" FROM (SELECT "public"."Session"."id" FROM "public"."Session" WHERE (EXISTS(SELECT "t0"."A" FROM "public"."_SessionToUniqueText" AS "t0" INNER JOIN "public"."UniqueText" AS "j0" ON ("j0"."id") = ("t0"."B") WHERE ($3=$4 AND ("public"."Session"."id") = ("t0"."A") AND "t0"."A" IS NOT NULL)) AND "public"."Session"."clinicDomain" = $1) OFFSET $2 / traceparent='00-e45ef7a800318ade551aff628e0c03b6-737fe605407cdcf4-01' */) AS "sub"`
11 min < 0.1%	40 ms	15,766 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"."date" >= $3 AND "j0"."date" <= $4 AND ("j0"."id" IS NOT NULL)) AND "public"."Invoice"."clinicDomain" = $5) OFFSET $6 /* traceparent='00-4204664206eb0dfcdd0af733619eef74-98dd185f4abb3986-01' /) AS "sub" / traceparent='00-4204664206eb0dfcdd0af733619eef74-98dd185f4abb3986-01' */
11 min < 0.1%	23 ms	27,352 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-e36f55eaa95fb5ee4b8b68037d09613f-58298878a78f8d38-01' /) AS "sub" / traceparent='00-e36f55eaa95fb5ee4b8b68037d09613f-58298878a78f8d38-01' */
10 min < 0.1%	135 ms	4,654 postgres
SELECT "public"."Session"."id", "public"."Session"."patientProfileId", "public"."Session"."doctorId", "public"."Session"."assistantId", "public"."Session"."referralDoctorId", "public"."Session"."number", "public"."Session"."date", "public"."Session"."from", "public"."Session"."to", "public"."Session"."shiftId", "public"."Session"."note", "public"."Session"."totalTimeInSec", "public"."Session"."clinicDomain", "public"."Session"."isWhatsAppNotificationSentHour", "public"."Session"."isWhatsAppNotificationSentTenMin", "public"."Session"."isPatientInWaitingRoom", "public"."Session"."patientInWaitingRoomFrom", "public"."Session"."startTime", "public"."Session"."endTime", "public"."Session"."order", "public"."Session"."timeType"::text, "public"."Session"."status"::text, "public"."Session"."branchId", "public"."Session"."createdAt", "public"."Session"."updatedAt", "public"."Session"."packageSubscriptionId", "public"."Session"."link", "public"."Session"."confirmedAt", "public"."Session"."specialty"::text, "public"."Session"."cancellationReason", "public"."Session"."cancellationDate", "public"."Session"."generalTags", "public"."Session"."expectedTotalTime", "public"."Session"."treatmentPlanId", "public"."Session"."patientJourneyId" FROM "public"."Session" WHERE (EXISTS(SELECT "t0"."A" FROM "public"."_SessionComplaints" AS "t0" INNER JOIN "public"."UniqueText" AS "j0" ON ("j0"."id") = ("t0"."B") WHERE ($4=$5 AND ("public"."Session"."id") = ("t0"."A") AND "t0"."A" IS NOT NULL)) AND "public"."Session"."clinicDomain" = $1) ORDER BY "public"."Session"."createdAt" DESC LIMIT $2 OFFSET $3
10 min < 0.1%	24 ms	26,230 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"."clinicDomain" = $3) OFFSET $4 / traceparent='00-13659963b5616fc87634e7a08c293e9e-0c0441193e664514-01' /) AS "sub" / traceparent='00-13659963b5616fc87634e7a08c293e9e-0c0441193e664514-01' */`
10 min < 0.1%	22 ms	28,854 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" = CAST($3::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" = $4 AND ("public"."Session"."id") = ("t0"."B") AND "t0"."B" IS NOT NULL))) OFFSET $5 / traceparent='00-e36f55eaa95fb5ee4b8b68037d09613f-b08d3edcf3f41c78-01' /) AS "sub" / traceparent='00-e36f55eaa95fb5ee4b8b68037d09613f-b08d3edcf3f41c78-01' */
10 min < 0.1%	77 ms	7,861 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") 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"."date" >= $11 AND "j5"."date" <= $12 AND ("j5"."id" IS NOT NULL))) AND "j0"."status" = CAST($13::text AS "public"."InvoiceStatus") AND ("j0"."id" IS NOT NULL)) OFFSET $14 /* traceparent='00-4204664206eb0dfcdd0af733619eef74-774e75aa9eedcb99-01' /) AS "sub" / traceparent='00-4204664206eb0dfcdd0af733619eef74-774e75aa9eedcb99-01' */
10 min < 0.1%	778 ms	773 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-a22dab0740be88f907a259ca6ce18857-bfb235ac9e4aa84a-01' */`
10 min < 0.1%	28 ms	21,043 postgres
SELECT "public"."PackageSubscription"."id", "public"."PackageSubscription"."packageId", "public"."PackageSubscription"."patientProfileId", "public"."PackageSubscription"."invoiceId", "public"."PackageSubscription"."doctorId", "public"."PackageSubscription"."assistantId", "public"."PackageSubscription"."referralDoctorId", "public"."PackageSubscription"."status"::text, "public"."PackageSubscription"."startDate", "public"."PackageSubscription"."endDate", "public"."PackageSubscription"."createdAt", "public"."PackageSubscription"."updatedAt", "public"."PackageSubscription"."finishedAt", "public"."PackageSubscription"."shiftId", "public"."PackageSubscription"."patientInsuranceId", "public"."PackageSubscription"."mainBranchId" FROM "public"."PackageSubscription" LEFT JOIN "public"."Package" AS "j2" ON ("j2"."id") = ("public"."PackageSubscription"."packageId") WHERE ("public"."PackageSubscription"."patientProfileId" = $1 AND (EXISTS(SELECT "t0"."B" FROM "public"."_BranchToPackageSubscription" AS "t0" INNER JOIN "public"."Branch" AS "j0" ON ("j0"."id") = ("t0"."A") WHERE ("j0"."id" = $2 AND ("public"."PackageSubscription"."id") = ("t0"."B") AND "t0"."B" IS NOT NULL)) OR NOT EXISTS(SELECT "t1"."B" FROM "public"."_BranchToPackageSubscription" AS "t1" INNER JOIN "public"."Branch" AS "j1" ON ("j1"."id") = ("t1"."A") WHERE ($7=$8 AND ("public"."PackageSubscription"."id") = ("t1"."B") AND "t1"."B" IS NOT NULL))) AND "public"."PackageSubscription"."status" = CAST($3::text AS "public"."PackageSubscriptionStatus") AND (EXISTS(SELECT "t3"."packageId" FROM "public"."PackageUnit" AS "t3" WHERE ("t3"."examinationId" IN ($4) AND ("j2"."id") = ("t3"."packageId") AND "t3"."packageId" IS NOT NULL)) AND ("j2"."id" IS NOT NULL))) LIMIT $5 OFFSET $6
10 min < 0.1%	172 ms	3,364 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"."date" >= $9 AND "j3"."date" <= $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-25537bdecb8e0a5ed9181e6f6bba96f2-df150f7a6f8bccf2-01' /) AS "sub" / traceparent='00-25537bdecb8e0a5ed9181e6f6bba96f2-df150f7a6f8bccf2-01' */
9 min < 0.1%	26 ms	21,445 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"."clinicDomain" = $3 AND "public"."Session"."status" IN (CAST($4::text AS "public"."SessionStatus"),CAST($5::text AS "public"."SessionStatus"))) OFFSET $6 / traceparent='00-13659963b5616fc87634e7a08c293e9e-85c58af1485ae41d-01' /) AS "sub" / traceparent='00-13659963b5616fc87634e7a08c293e9e-85c58af1485ae41d-01' */
9 min < 0.1%	213 ms	2,647 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") 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"."date" >= $11 AND "j4"."date" <= $12 AND "j4"."status" <> CAST($13::text AS "public"."SessionStatus") AND ("j4"."id" IS NOT NULL))) AND "j0"."status" = CAST($14::text AS "public"."InvoiceStatus") AND ("j0"."id" IS NOT NULL)) OFFSET $15 /* traceparent='00-82a429e1bf5aeb58407cc4fbdf858041-4a532786411ad535-01' /) AS "sub" / traceparent='00-82a429e1bf5aeb58407cc4fbdf858041-4a532786411ad535-01' */
9 min < 0.1%	35 ms	16,009 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-752423796cb0756202a2de36841799d4-74e81b822eaf2ce3-01' /) AS "sub" / traceparent='00-752423796cb0756202a2de36841799d4-74e81b822eaf2ce3-01' */
9 min < 0.1%	35 ms	16,009 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-752423796cb0756202a2de36841799d4-d37e274e9bb2d68c-01' /) AS "sub" / traceparent='00-752423796cb0756202a2de36841799d4-d37e274e9bb2d68c-01' */
9 min < 0.1%	118 ms	4,646 postgres
SELECT "public"."Session"."id", "public"."Session"."patientProfileId", "public"."Session"."doctorId", "public"."Session"."assistantId", "public"."Session"."referralDoctorId", "public"."Session"."number", "public"."Session"."date", "public"."Session"."from", "public"."Session"."to", "public"."Session"."shiftId", "public"."Session"."note", "public"."Session"."totalTimeInSec", "public"."Session"."clinicDomain", "public"."Session"."isWhatsAppNotificationSentHour", "public"."Session"."isWhatsAppNotificationSentTenMin", "public"."Session"."isPatientInWaitingRoom", "public"."Session"."patientInWaitingRoomFrom", "public"."Session"."startTime", "public"."Session"."endTime", "public"."Session"."order", "public"."Session"."timeType"::text, "public"."Session"."status"::text, "public"."Session"."branchId", "public"."Session"."createdAt", "public"."Session"."updatedAt", "public"."Session"."packageSubscriptionId", "public"."Session"."link", "public"."Session"."confirmedAt", "public"."Session"."specialty"::text, "public"."Session"."cancellationReason", "public"."Session"."cancellationDate", "public"."Session"."generalTags", "public"."Session"."expectedTotalTime", "public"."Session"."treatmentPlanId", "public"."Session"."patientJourneyId" FROM "public"."Session" WHERE (EXISTS(SELECT "t0"."A" FROM "public"."_SessionToUniqueText" AS "t0" INNER JOIN "public"."UniqueText" AS "j0" ON ("j0"."id") = ("t0"."B") WHERE ($4=$5 AND ("public"."Session"."id") = ("t0"."A") AND "t0"."A" IS NOT NULL)) AND "public"."Session"."clinicDomain" = $1) ORDER BY "public"."Session"."createdAt" DESC LIMIT $2 OFFSET $3
9 min < 0.1%	116 ms	4,654 postgres
`SELECT COUNT() AS "_count$_all" FROM (SELECT "public"."Session"."id" FROM "public"."Session" WHERE (EXISTS(SELECT "t0"."A" FROM "public"."_SessionComplaints" AS "t0" INNER JOIN "public"."UniqueText" AS "j0" ON ("j0"."id") = ("t0"."B") WHERE ($3=$4 AND ("public"."Session"."id") = ("t0"."A") AND "t0"."A" IS NOT NULL)) AND "public"."Session"."clinicDomain" = $1) OFFSET $2 / traceparent='00-8f40be53350570a89b794442440b41d4-00f1abd94af7959b-01' */) AS "sub"`
9 min < 0.1%	213 ms	2,512 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 ("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"."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-480cf48d7ad616b30a596c71833667e7-e2ca7523df73cac0-01' /) AS "sub" / traceparent='00-480cf48d7ad616b30a596c71833667e7-e2ca7523df73cac0-01' */
9 min < 0.1%	113 ms	4,707 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-2fd8797e9acd82644868fffaca8c7630-702fe5a7fc67e42e-01' /) AS "sub" / traceparent='00-2fd8797e9acd82644868fffaca8c7630-702fe5a7fc67e42e-01' */
9 min < 0.1%	204 ms	2,512 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-480cf48d7ad616b30a596c71833667e7-6e756edbab6e3a9a-01' /) AS "sub" / traceparent='00-480cf48d7ad616b30a596c71833667e7-6e756edbab6e3a9a-01' */
9 min < 0.1%	51 ms	10,010 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"."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-6a6da4476e98aa3e271750472b1652c5-1160147cc312df8f-01' */
8 min < 0.1%	65 ms	7,569 postgres
SELECT "public"."PackageSubscription"."id", "public"."PackageSubscription"."packageId", "public"."PackageSubscription"."patientProfileId", "public"."PackageSubscription"."invoiceId", "public"."PackageSubscription"."doctorId", "public"."PackageSubscription"."assistantId", "public"."PackageSubscription"."referralDoctorId", "public"."PackageSubscription"."status"::text, "public"."PackageSubscription"."isOnHold", "public"."PackageSubscription"."startDate", "public"."PackageSubscription"."endDate", "public"."PackageSubscription"."effectiveEndDate", "public"."PackageSubscription"."createdAt", "public"."PackageSubscription"."updatedAt", "public"."PackageSubscription"."finishedAt", "public"."PackageSubscription"."shiftId", "public"."PackageSubscription"."patientInsuranceId", "public"."PackageSubscription"."mainBranchId" FROM "public"."PackageSubscription" LEFT JOIN "public"."PatientProfile" AS "j0" ON ("j0"."id") = ("public"."PackageSubscription"."patientProfileId") WHERE ("public"."PackageSubscription"."status" IN (CAST($1::text AS "public"."PackageSubscriptionStatus"),CAST($2::text AS "public"."PackageSubscriptionStatus"),CAST($3::text AS "public"."PackageSubscriptionStatus")) AND ("j0"."clinicDomain" = $4 AND ("j0"."id" IS NOT NULL))) ORDER BY "public"."PackageSubscription"."createdAt" DESC LIMIT $5 OFFSET $6 /* traceparent='00-ee83e244057d16129207e0f385238224-15bfe0cca71e1bae-01' */
8 min < 0.1%	194 ms	2,512 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-480cf48d7ad616b30a596c71833667e7-75a4be2f908332a2-01' /) AS "sub" / traceparent='00-480cf48d7ad616b30a596c71833667e7-75a4be2f908332a2-01' */
8 min < 0.1%	401 ms	1,205 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"."User" AS "j5" ON ("j5"."id") = ("j3"."doctorId") 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 ((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"."date" >= $10 AND "j3"."date" <= $11 AND "j3"."status" <> CAST($12::text AS "public"."SessionStatus") AND ((NOT $15=$16) AND ("j5"."id" IS NOT NULL)) AND ("j3"."id" IS NOT NULL)) OR ("j7"."clinicDomain" = $13 AND ("j7"."id" IS NOT NULL) AND ("j6"."id" IS NOT NULL)))) OFFSET $14 /* traceparent='00-fdd0a79e152571338ceccac8de31348f-3da1b212a2278fde-01' */) AS "sub"

Duplicate Indexes

Suggested Indexes

Slow Queries