PgHero

Queries

Showing queries for readonly_user user. Show all

Total Time Average Time Calls
483 min 7% 1,116 ms 25,945 readonly_user
SELECT  json_build_object($6, json_build_object($7, COUNT(*) ) ) AS "root" FROM  (SELECT  $8  FROM  (SELECT  *  FROM "public"."upload"  WHERE ((("public"."upload"."status") = ANY(($2)::text[])) AND (EXISTS  (SELECT  $9  FROM "public"."user" AS "__be_0_user" WHERE (((("__be_0_user"."id") = ("public"."upload"."user_id")) AND ($10)) AND (($11) AND (((("__be_0_user"."email") IS NOT NULL) AND ((("__be_0_user"."email") <> (($3)::text)) AND ($12))) AND (((((("__be_0_user"."credit") > (($4)::integer)) AND ($13)) AND ($14)) OR ((((("__be_0_user"."recurring_credit") > (($5)::integer)) AND ($15)) AND ($16)) OR ($17))) AND ($18)))))     )))     ) AS "_root.base"      ) AS "_root"
14 min 0.2% 300 ms 2,843 readonly_user
SELECT  json_build_object($5, json_build_object($6, COUNT(*) ) ) AS "root" FROM  (SELECT  $7  FROM  (SELECT  *  FROM "public"."upload"  WHERE (((("public"."upload"."created_at") < (($2)::timestamptz)) AND (("public"."upload"."created_at") >= (($3)::timestamptz))) AND (("public"."upload"."source") ILIKE (($4)::text)))     ) AS "_root.base"      ) AS "_root"
7 min 0.1% 15 ms 28,722 readonly_user
SELECT  json_build_object($7, json_build_object($8, COUNT(*) ) ) AS "root" FROM  (SELECT  $9  FROM  (SELECT  *  FROM "public"."upload"  WHERE ((("public"."upload"."status") = ANY(($2)::text[])) AND ((("public"."upload"."created_at") >= (($3)::timestamptz)) AND (EXISTS  (SELECT  $10  FROM "public"."user" AS "__be_0_user" WHERE (((("__be_0_user"."id") = ("public"."upload"."user_id")) AND ($11)) AND (($12) AND (((("__be_0_user"."email") IS NOT NULL) AND ((("__be_0_user"."email") <> (($4)::text)) AND ($13))) AND (((((("__be_0_user"."credit") > (($5)::integer)) AND ($14)) AND ($15)) OR ((((("__be_0_user"."recurring_credit") > (($6)::integer)) AND ($16)) AND ($17)) OR ($18))) AND ($19)))))     ))))     ) AS "_root.base"      ) AS "_root"
5 min < 0.1% 162 ms 1,859 readonly_user
SELECT  json_build_object($4, json_build_object($5, COUNT(*) ) ) AS "root" FROM  (SELECT  $6  FROM  (SELECT  *  FROM "public"."user"  WHERE ((("public"."user"."created_at") < (($2)::timestamptz)) AND (("public"."user"."created_at") >= (($3)::timestamptz)))     ) AS "_root.base"      ) AS "_root"