Hi everyone I m upgrading to prisma2 but facing an issue One Prisma #orm-help

Hi everyone ! I’m upgrading to prisma2 but facing ...

Lucas

07/05/2021, 3:09 PM

Hi everyone ! I’m upgrading to prisma2 but facing an issue. One app usecase involves my api making 3 consecutive queries on the same table (with different WHERE params) in my postgres db. If repeating the operation, 2 or 3 times in a row, one database process blows up the cpu usage. I’ve tried to tune the _connection_limit_ param (setting it to 1) with no luck. Could this be related to the query lock mode ? I’m a bit confused by the pg_locks output. Have you already faced something similar ? Thanks prisma team for the great work !

janpio

07/05/2021, 4:55 PM

Uh this is weird.

janpio

07/05/2021, 4:55 PM

Is this database exclusively used by a Prisma 2 application?

janpio

07/05/2021, 4:55 PM

What queries are you running?

Lucas

07/05/2021, 5:38 PM

yes it is

Lucas

07/05/2021, 5:39 PM

here is the generated query :

Copy code

select
	"project$development"."Invoice"."id",
	"project$development"."Invoice"."status",
	"project$development"."Invoice"."paymentMethod",
	"project$development"."Invoice"."dueDate",
	"project$development"."Invoice"."paymentDate",
	"project$development"."Invoice"."description",
	"project$development"."Invoice"."subtotal",
	"project$development"."Invoice"."tax",
	"project$development"."Invoice"."total",
	"project$development"."Invoice"."voidedAt",
	"project$development"."Invoice"."updatedAt",
	"project$development"."Invoice"."createdAt",
	"project$development"."Invoice"."debtor",
	"project$development"."Invoice"."creditor",
	"project$development"."Invoice"."charge"
from
	"project$development"."Invoice"
where
	("project$development"."Invoice"."creditor" = $1
	and "project$development"."Invoice"."enrollment" = $2
	and "project$development"."Invoice"."status" = $3
	and ("project$development"."Invoice"."charge" is null
	or ("project$development"."Invoice"."id") in (
	select
		"t0"."id"
	from
		"project$development"."Invoice" as "t0"
	inner join "project$development"."Charge" as "j0" on
		("j0"."id") = ("t0"."charge")
	where
		("j0"."status" not in ($4,
		$5)
		and "t0"."id" is not null))))
order by
	"project$development"."Invoice"."paymentDate" desc,
	"project$development"."Invoice"."id" asc
limit $6 offset $7

janpio

07/05/2021, 6:34 PM

https://www.prisma.io/docs/concepts/components/prisma-client/debugging + https://www.prisma.io/docs/concepts/components/prisma-client/working-with-prismaclient/logging/ can give you some more context on the queries that are being run under the hood and what else is going on

Lucas

07/06/2021, 8:04 AM

Here are the logs

prisma_client.log prisma_engine.log

Lucas

07/06/2021, 8:04 AM

Is there a way to redirect the logs to files instead of stdout ?

Lucas

07/06/2021, 10:26 AM