Live Queries
6 queries
| Pid |
Duration |
State |
|
| 3267547 |
4.4 s
|
active
|
|
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-f38d9fd8880086955ec5f84a708e1b4c-2ed44e7631373f97-01' */
|
| 3267500 |
3.5 s
|
active
|
|
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 ((1=1 AND ("j0"."id" IS NOT NULL)) AND "public"."InvoiceUnit"."examinationId" = $1) OFFSET $2 /* traceparent='00-03c86106e273b9ca5e87537e2770bb37-041ef5a34a0ba22e-01' */) AS "sub" /* traceparent='00-03c86106e273b9ca5e87537e2770bb37-041ef5a34a0ba22e-01' */
|
| 3267605 |
1.6 s
|
active
|
|
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-7eda8838424a6d0edbfe5bce94ffee1a-3ed15929c00da239-01' */
|
| 3267614 |
0.1 s
|
active
|
|
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-a6c50bfc712cf19cc1dc862c70159581-508df4f003f0669f-01' */
|
| 3267123 |
0.1 s
|
active
|
|
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-a6c50bfc712cf19cc1dc862c70159581-508df4f003f0669f-01' */
|
| 3267458 |
-0.2 s
|
active
|
|
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
|
You may need to restart your app servers afterwards.