Hi Urql community, i'm struggling debugging / optimising urql request as these requests are then converted to Postgre SQL requests thru Hasura.
Extract of my urql file:
${GetApprovals_VersionFragmentDoc}`;
export const GetApprovalsDocument = gql`
query GetApprovals($projectId: uuid!) {
files(
where: {is_approval_mode: {_eq: true}, project: {id: {_eq: $projectId}}, folder: {is_in_bin: {_eq: false}}}
) {
...GetApprovals_file
}
}
${GetApprovals_FileFragmentDoc}`;
Extracts of a postgre request (log from EverSQL), maybe linked to this query (but i'm not sure, which is my problem):
SELECT
coalesce((json_agg("root") -> 0), 'null') AS "root"
FROM
(
SELECT
row_to_json(
(
SELECT
"_100_e"
FROM
(
SELECT
"_0_root.base"."id" AS "id",
"_0_root.base"."name" AS "name",
"public"."is_approved_on_a_version"("_0_root.base") AS "is_approved_on_a_version",
"_0_root.base"."is_approval_mode" AS "is_approval_mode",
"_16_root.or.assignation"."assignation" AS "assignation",
"_99_root.cf.last_version"."last_version" AS "last_version",
"_57_root.ar.root.file_versions"."file_versions" AS "file_versions",
"_0_root.base"."due_date" AS "due_date",
'files' AS "__typename"
) AS "_100_e"
)
) AS "root"
FROM
(
SELECT
*
FROM
"public"."files"
WHERE
(
(
(
(
"public"."get_user_can_read_file"("public"."files".*, $1)
) = (('true') :: boolean)
)
OR (
(
(
"public"."get_user_can_read_file"("public"."files".*, $1)
) IS NULL
)
AND ((('true') :: boolean) IS NULL)
)
)
As a conclusion here:
- i have no way to know if the SQL log comes from this specific query
- which user performed the query
- how to optimise the urql query to avoid performance provlems with SQL.
Do you have any tips / recommandations for that ?
Thanks a lot
Top comments (0)