PgHero

Live Queries

2 queries

Pid Duration State
856832 53.5 s active
hasura
SELECT  "_subs"."result_id" , "_fld_resp"."root" AS "result" FROM UNNEST(($1)::uuid[], ($2)::json[]) AS "_subs"("result_id", "result_vars") LEFT OUTER JOIN LATERAL (SELECT  json_build_object('search_output_prefix', "search_output_prefix"."root" ) AS "root" FROM  (SELECT  coalesce(json_agg("root" ORDER BY "root.or.transaction.pg.internal_id" DESC NULLS FIRST), '[]' ) AS "root" FROM  (SELECT  "_root.or.transaction"."root.or.transaction.pg.internal_id" AS "root.or.transaction.pg.internal_id", row_to_json((SELECT  "_e"  FROM  (SELECT  "_root.base"."locking_bytecode" AS "locking_bytecode", ("_root.base"."output_index")::text AS "output_index", "_root.base"."transaction_hash" AS "transaction_hash", "_root.or.transaction"."transaction" AS "transaction"       ) AS "_e"      ) ) AS "root" FROM  (SELECT  *  FROM "public"."search_output_prefix"((("_subs"."result_vars"#>>ARRAY['synthetic', '1']))::text) AS "_search_output_prefix" WHERE ('true')     ) AS "_root.base" LEFT OUTER JOIN LATERAL (SELECT  "_root.or.transaction
857530 53.5 s active
hasura
SELECT  "_subs"."result_id" , "_fld_resp"."root" AS "result" FROM UNNEST(($1)::uuid[], ($2)::json[]) AS "_subs"("result_id", "result_vars") LEFT OUTER JOIN LATERAL (SELECT  json_build_object('search_output_prefix', "search_output_prefix"."root" ) AS "root" FROM  (SELECT  coalesce(json_agg("root" ORDER BY "root.or.transaction.pg.internal_id" DESC NULLS FIRST), '[]' ) AS "root" FROM  (SELECT  "_root.or.transaction"."root.or.transaction.pg.internal_id" AS "root.or.transaction.pg.internal_id", row_to_json((SELECT  "_e"  FROM  (SELECT  "_root.base"."locking_bytecode" AS "locking_bytecode", ("_root.base"."output_index")::text AS "output_index", "_root.base"."transaction_hash" AS "transaction_hash", "_root.or.transaction"."transaction" AS "transaction"       ) AS "_e"      ) ) AS "root" FROM  (SELECT  *  FROM "public"."search_output_prefix"((("_subs"."result_vars"#>>ARRAY['synthetic', '2']))::text) AS "_search_output_prefix" WHERE ('true')     ) AS "_root.base" LEFT OUTER JOIN LATERAL (SELECT  "_root.or.transaction

You may need to restart your app servers afterwards.