|
0 min
10%
|
31 ms
|
662
systemic
|
DO $BODY$
DECLARE
-- INJECT N8N DATA HERE
-- We use $val$ wrappers to safely handle the text input from N8n
p_shop_phone text := $val$+441234567890$val$;
p_cust_phone text := $val$+447700900000$val$;
-- Variables for logic
v_schema text;
v_timezone text;
v_result json;
BEGIN
-- 1. FIND THE CLIENT
SELECT db_schema, timezone
INTO v_schema, v_timezone
FROM public.client_registry
WHERE twilio_number = p_shop_phone;
-- 2. EXECUTE LOGIC
IF v_schema IS NOT NULL THEN
-- We use %I for Schema (Identifier) and %L for Values (Literals)
-- This constructs the query safely without needing a complex USING clause
EXECUTE format(
'SELECT row_to_json(c) FROM %I.get_call_context(%L, %L, %L) c',
v_schema, p_shop_phone, p_cust_phone, v_timezone
)
INTO v_result;
ELSE
v_result := json_build_object('error', 'Client not found');
END IF;
PERFORM set_config('n8n.response', COALESCE(v_result, '[]'::json)::text, true);
END $BODY$
|
|
0 min
9%
|
30 ms
|
662
systemic
|
DO $BODY$
DECLARE
-- INPUTS: Safe handling of n8n data using $val$ wrappers
p_shop_phone text := $val$+441234567890$val$;
p_cust_phone text := $val$+447700900000$val$;
p_tool_name text := $val$reorder_usual$val$;
p_args jsonb := $val${}$val$::jsonb;
-- SYSTEM VARIABLES
v_schema text; v_radius numeric; v_shop_pc text; v_result json; v_order_id int;
v_clean_input_pc text; v_clean_shop_pc text;
-- CALCULATION VARIABLES
v_cust_id int; v_saved_pc text;
cust_lat numeric; cust_lon numeric; shop_lat numeric; shop_lon numeric; dist_miles numeric;
BEGIN
-- 1. IDENTIFY TENANT (Fast Registry Lookup)
SELECT db_schema, delivery_radius_miles, shop_postcode
INTO v_schema, v_radius, v_shop_pc
FROM public.client_registry
WHERE twilio_number = p_shop_phone;
IF v_schema IS NULL THEN
v_result := json_build_object('error', 'Shop not found');
ELSE
CASE p_tool_name
-- A. SEARCH MENU
WHEN 'search_menu' THEN
EXECUTE format(
'SELECT json_agg(t) FROM (
SELECT i.name, i.description, v.price
FROM %I.items i
JOIN %I.item_variants v ON i.id = v.item_id
WHERE i.name ILIKE $1 OR i.description ILIKE $1
LIMIT 5
) t', v_schema, v_schema
) INTO v_result USING '%' || (p_args->>'query') || '%';
-- B. CHECK DELIVERY ZONE
WHEN 'check_delivery_zone' THEN
v_clean_input_pc := UPPER(REPLACE(p_args->>'address', ' ', ''));
v_clean_shop_pc := UPPER(REPLACE(v_shop_pc, ' ', ''));
EXECUTE format('SELECT id, postcode FROM %I.customers WHERE phone = $1', v_schema)
INTO v_cust_id, v_saved_pc USING p_cust_phone;
IF v_cust_id IS NOT NULL AND v_saved_pc = v_clean_input_pc THEN
v_result := json_build_object('in_range', true, 'message', 'Yes, that is your registered address.');
ELSE
SELECT latitude, longitude INTO cust_lat, cust_lon FROM public.uk_postcodes WHERE postcode = v_clean_input_pc;
SELECT latitude, longitude INTO shop_lat, shop_lon FROM public.uk_postcodes WHERE postcode = v_clean_shop_pc;
IF cust_lat IS NULL OR shop_lat IS NULL THEN
v_result := json_build_object(
'in_range', false,
'error', 'Postcode not found',
'details', json_build_object('shop_pc', v_clean_shop_pc, 'cust_pc', v_clean_input_pc)
);
ELSE
dist_miles := 3963 * acos(
cos(radians(shop_lat)) * cos(radians(cust_lat)) *
cos(radians(cust_lon) - radians(shop_lon)) +
sin(radians(shop_lat)) * sin(radians(cust_lat))
);
IF dist_miles <= v_radius THEN
v_result := json_build_object('in_range', true, 'distance', round(dist_miles, 2), 'message', 'Yes, we deliver.');
IF v_cust_id IS NULL THEN
EXECUTE format('INSERT INTO %I.customers (phone, postcode, first_name) VALUES ($1, $2, ''Guest'')', v_schema)
USING p_cust_phone, v_clean_input_pc;
END IF;
ELSE
v_result := json_build_object('in_range', false, 'distance', round(dist_miles, 2), 'message', 'Too far.');
END IF;
END IF;
END IF;
-- C. PLACE ORDER
WHEN 'place_order' THEN
EXECUTE format('INSERT INTO %I.customers (phone, first_name) VALUES ($1, ''Guest'') ON CONFLICT (phone) DO NOTHING', v_schema) USING p_cust_phone;
EXECUTE format(
'INSERT INTO %I.orders (customer_id, order_type, payment_method, total_amount, delivery_address, status)
SELECT id, $1, $2, $3, $4, ''pending'' FROM %I.customers WHERE phone = $5 RETURNING id',
v_schema, v_schema
) INTO v_order_id USING p_args->>'order_type', p_args->>'payment_method', (p_args->>'total')::numeric, p_args->>'address', p_cust_phone;
EXECUTE format(
'INSERT INTO %I.order_items (order_id, item_name, quantity, unit_price, total_price)
SELECT $1, name, quantity, price, (quantity * price)
FROM jsonb_to_recordset($2) AS x(name text, quantity int, price numeric)',
v_schema
) USING v_order_id, (p_args->'items');
v_result := json_build_object('order_id', v_order_id, 'message', 'Order placed successfully');
-- D. RE-ORDER USUAL (One-sentence ordering)
-- Positioned BEFORE the ELSE catch-all to ensure reachability
WHEN 'reorder_usual' THEN
EXECUTE format(
'WITH last_order AS (
SELECT id, delivery_address, total_amount, order_type, payment_method
FROM %I.orders
WHERE customer_id = (SELECT id FROM %I.customers WHERE phone = $1)
ORDER BY created_at DESC LIMIT 1
)
SELECT json_build_object(
''items'', (SELECT json_agg(json_build_object(''name'', item_name, ''quantity'', quantity, ''price'', unit_price))
FROM %I.order_items WHERE order_id = last_order.id),
''address'', delivery_address,
''total'', total_amount,
''order_type'', order_type,
''payment_method'', payment_method
) FROM last_order', v_schema, v_schema, v_schema
) INTO v_result USING p_cust_phone;
-- Validation: Ensure items exist before duplicating
IF v_result IS NOT NULL AND (v_result->>'items') IS NOT NULL THEN
EXECUTE format(
'INSERT INTO %I.orders (customer_id, order_type, payment_method, total_amount, delivery_address, status)
SELECT id, $1, $2, $3, $4, ''pending'' FROM %I.customers WHERE phone = $5 RETURNING id',
v_schema, v_schema
) INTO v_order_id USING v_result->>'order_type', v_result->>'payment_method', (v_result->>'total')::numeric, v_result->>'address', p_cust_phone;
EXECUTE format(
'INSERT INTO %I.order_items (order_id, item_name, quantity, unit_price, total_price)
SELECT $1, (x->>''name''), (x->>''quantity'')::int, (x->>''price'')::numeric, ((x->>''quantity'')::int * (x->>''price'')::numeric)
FROM json_array_elements($2) AS x',
v_schema
) USING v_order_id, (v_result->'items');
v_result := json_build_object('order_id', v_order_id, 'message', 'Your usual order has been placed successfully.');
ELSE
v_result := json_build_object('error', 'No previous order found to replicate.');
END IF;
-- Catch-all for undefined tools
ELSE
v_result := json_build_object('error', 'Tool not implemented');
END CASE;
END IF;
PERFORM set_config('n8n.response', COALESCE(v_result, '[]'::json)::text, true);
END $BODY$
|
|
0 min
9%
|
28 ms
|
662
systemic
|
SELECT row_to_json(c) FROM kebab_king.get_call_context($1, $2, $3) c
|
|
0 min
7%
|
2 ms
|
9,946
systemic
|
SELECT "ExecutionEntity"."id" AS "ExecutionEntity_id", "ExecutionEntity"."finished" AS "ExecutionEntity_finished", "ExecutionEntity"."mode" AS "ExecutionEntity_mode", "ExecutionEntity"."retryOf" AS "ExecutionEntity_retryOf", "ExecutionEntity"."retrySuccessId" AS "ExecutionEntity_retrySuccessId", "ExecutionEntity"."status" AS "ExecutionEntity_status", "ExecutionEntity"."createdAt" AS "ExecutionEntity_createdAt", "ExecutionEntity"."startedAt" AS "ExecutionEntity_startedAt", "ExecutionEntity"."stoppedAt" AS "ExecutionEntity_stoppedAt", "ExecutionEntity"."deletedAt" AS "ExecutionEntity_deletedAt", "ExecutionEntity"."workflowId" AS "ExecutionEntity_workflowId", "ExecutionEntity"."waitTill" AS "ExecutionEntity_waitTill", "ExecutionEntity__ExecutionEntity_executionData"."data" AS "ExecutionEntity__ExecutionEntity_executionData_data", "ExecutionEntity__ExecutionEntity_executionData"."workflowData" AS "ExecutionEntity__ExecutionEntity_executionData_workflowData", "ExecutionEntity__ExecutionEntity_executionData"."executionId" AS "ExecutionEntity__ExecutionEntity_executionData_executionId", "ExecutionEntity__ExecutionEntity_executionData"."workflowVersionId" AS "3e30e424d9845e27b0de0df637c25fce34204985", "ExecutionEntity__ExecutionEntity_metadata"."id" AS "ExecutionEntity__ExecutionEntity_metadata_id", "ExecutionEntity__ExecutionEntity_metadata"."executionId" AS "ExecutionEntity__ExecutionEntity_metadata_executionId", "ExecutionEntity__ExecutionEntity_metadata"."key" AS "ExecutionEntity__ExecutionEntity_metadata_key", "ExecutionEntity__ExecutionEntity_metadata"."value" AS "ExecutionEntity__ExecutionEntity_metadata_value" FROM "public"."execution_entity" "ExecutionEntity" LEFT JOIN "public"."execution_data" "ExecutionEntity__ExecutionEntity_executionData" ON "ExecutionEntity__ExecutionEntity_executionData"."executionId"="ExecutionEntity"."id" LEFT JOIN "public"."execution_metadata" "ExecutionEntity__ExecutionEntity_metadata" ON "ExecutionEntity__ExecutionEntity_metadata"."executionId"="ExecutionEntity"."id" WHERE ( (("ExecutionEntity"."id" = $1)) ) AND ( "ExecutionEntity"."deletedAt" IS NULL ) AND ( "ExecutionEntity"."id" IN ($2) )
|
|
0 min
7%
|
4 ms
|
3,310
systemic
|
SELECT "WorkflowEntity"."updatedAt" AS "WorkflowEntity_updatedAt", "WorkflowEntity"."createdAt" AS "WorkflowEntity_createdAt", "WorkflowEntity"."id" AS "WorkflowEntity_id", "WorkflowEntity"."name" AS "WorkflowEntity_name", "WorkflowEntity"."description" AS "WorkflowEntity_description", "WorkflowEntity"."active" AS "WorkflowEntity_active", "WorkflowEntity"."isArchived" AS "WorkflowEntity_isArchived", "WorkflowEntity"."nodes" AS "WorkflowEntity_nodes", "WorkflowEntity"."connections" AS "WorkflowEntity_connections", "WorkflowEntity"."settings" AS "WorkflowEntity_settings", "WorkflowEntity"."staticData" AS "WorkflowEntity_staticData", "WorkflowEntity"."meta" AS "WorkflowEntity_meta", "WorkflowEntity"."pinData" AS "WorkflowEntity_pinData", "WorkflowEntity"."versionId" AS "WorkflowEntity_versionId", "WorkflowEntity"."activeVersionId" AS "WorkflowEntity_activeVersionId", "WorkflowEntity"."versionCounter" AS "WorkflowEntity_versionCounter", "WorkflowEntity"."triggerCount" AS "WorkflowEntity_triggerCount", "WorkflowEntity"."parentFolderId" AS "WorkflowEntity_parentFolderId", "WorkflowEntity__WorkflowEntity_activeVersion"."updatedAt" AS "WorkflowEntity__WorkflowEntity_activeVersion_updatedAt", "WorkflowEntity__WorkflowEntity_activeVersion"."createdAt" AS "WorkflowEntity__WorkflowEntity_activeVersion_createdAt", "WorkflowEntity__WorkflowEntity_activeVersion"."versionId" AS "WorkflowEntity__WorkflowEntity_activeVersion_versionId", "WorkflowEntity__WorkflowEntity_activeVersion"."workflowId" AS "WorkflowEntity__WorkflowEntity_activeVersion_workflowId", "WorkflowEntity__WorkflowEntity_activeVersion"."nodes" AS "WorkflowEntity__WorkflowEntity_activeVersion_nodes", "WorkflowEntity__WorkflowEntity_activeVersion"."connections" AS "WorkflowEntity__WorkflowEntity_activeVersion_connections", "WorkflowEntity__WorkflowEntity_activeVersion"."authors" AS "WorkflowEntity__WorkflowEntity_activeVersion_authors", "WorkflowEntity__WorkflowEntity_activeVersion"."name" AS "WorkflowEntity__WorkflowEntity_activeVersion_name", "WorkflowEntity__WorkflowEntity_activeVersion"."description" AS "WorkflowEntity__WorkflowEntity_activeVersion_description", "WorkflowEntity__WorkflowEntity_activeVersion"."autosaved" AS "WorkflowEntity__WorkflowEntity_activeVersion_autosaved", "WorkflowEntity__WorkflowEntity_shared"."updatedAt" AS "WorkflowEntity__WorkflowEntity_shared_updatedAt", "WorkflowEntity__WorkflowEntity_shared"."createdAt" AS "WorkflowEntity__WorkflowEntity_shared_createdAt", "WorkflowEntity__WorkflowEntity_shared"."role" AS "WorkflowEntity__WorkflowEntity_shared_role", "WorkflowEntity__WorkflowEntity_shared"."workflowId" AS "WorkflowEntity__WorkflowEntity_shared_workflowId", "WorkflowEntity__WorkflowEntity_shared"."projectId" AS "WorkflowEntity__WorkflowEntity_shared_projectId", "6da0e527aac0b6fa1d01a2b055fa2c411cde87d3"."updatedAt" AS "6da0e527aac0b6fa1d01a2b055fa2c411cde87d3_updatedAt", "6da0e527aac0b6fa1d01a2b055fa2c411cde87d3"."createdAt" AS "6da0e527aac0b6fa1d01a2b055fa2c411cde87d3_createdAt", "6da0e527aac0b6fa1d01a2b055fa2c411cde87d3"."id" AS "6da0e527aac0b6fa1d01a2b055fa2c411cde87d3_id", "6da0e527aac0b6fa1d01a2b055fa2c411cde87d3"."name" AS "6da0e527aac0b6fa1d01a2b055fa2c411cde87d3_name", "6da0e527aac0b6fa1d01a2b055fa2c411cde87d3"."type" AS "6da0e527aac0b6fa1d01a2b055fa2c411cde87d3_type", "6da0e527aac0b6fa1d01a2b055fa2c411cde87d3"."icon" AS "6da0e527aac0b6fa1d01a2b055fa2c411cde87d3_icon", "6da0e527aac0b6fa1d01a2b055fa2c411cde87d3"."description" AS "6da0e527aac0b6fa1d01a2b055fa2c411cde87d3_description", "6da0e527aac0b6fa1d01a2b055fa2c411cde87d3"."creatorId" AS "6da0e527aac0b6fa1d01a2b055fa2c411cde87d3_creatorId", "d6f609b4290db51264ee33f3c1aef17bd40a52f7"."updatedAt" AS "d6f609b4290db51264ee33f3c1aef17bd40a52f7_updatedAt", "d6f609b4290db51264ee33f3c1aef17bd40a52f7"."createdAt" AS "d6f609b4290db51264ee33f3c1aef17bd40a52f7_createdAt", "d6f609b4290db51264ee33f3c1aef17bd40a52f7"."userId" AS "d6f609b4290db51264ee33f3c1aef17bd40a52f7_userId", "d6f609b4290db51264ee33f3c1aef17bd40a52f7"."projectId" AS "d6f609b4290db51264ee33f3c1aef17bd40a52f7_projectId", "d6f609b4290db51264ee33f3c1aef17bd40a52f7"."role" AS "d6f609b4290db51264ee33f3c1aef17bd40a52f7_role" FROM "public"."workflow_entity" "WorkflowEntity" LEFT JOIN "public"."workflow_history" "WorkflowEntity__WorkflowEntity_activeVersion" ON "WorkflowEntity__WorkflowEntity_activeVersion"."versionId"="WorkflowEntity"."activeVersionId" LEFT JOIN "public"."shared_workflow" "WorkflowEntity__WorkflowEntity_shared" ON "WorkflowEntity__WorkflowEntity_shared"."workflowId"="WorkflowEntity"."id" LEFT JOIN "public"."project" "6da0e527aac0b6fa1d01a2b055fa2c411cde87d3" ON "6da0e527aac0b6fa1d01a2b055fa2c411cde87d3"."id"="WorkflowEntity__WorkflowEntity_shared"."projectId" LEFT JOIN "public"."project_relation" "d6f609b4290db51264ee33f3c1aef17bd40a52f7" ON "d6f609b4290db51264ee33f3c1aef17bd40a52f7"."projectId"="6da0e527aac0b6fa1d01a2b055fa2c411cde87d3"."id" WHERE ( (("WorkflowEntity"."id" = $1)) ) AND ( "WorkflowEntity"."id" IN ($2) )
|
|
0 min
6%
|
20 ms
|
662
systemic
|
SELECT
EXISTS (
SELECT $14 FROM kebab_king.business_hours
WHERE day_of_week = v_now_day
AND v_now_time >= open_time
AND v_now_time <= close_time
AND is_closed = $15
) as is_open,
(SELECT r.client_name FROM public.client_registry r WHERE r.twilio_number = p_to_phone) as client_name,
c.first_name as customer_name,
c.postcode,
-- CORRECTED LOGIC: Get the most recent item name from order_items
(SELECT oi.item_name ::TEXT
FROM kebab_king.orders o
JOIN kebab_king.order_items oi ON o.id = oi.order_id
WHERE o.customer_id = c.id
ORDER BY o.created_at DESC
LIMIT $16
) as usual_order,
$17 as is_existing
FROM kebab_king.customers c
WHERE c.phone = p_from_phone
UNION ALL
-- Query 2: New Customer (Fallback)
SELECT
EXISTS (
SELECT $18 FROM kebab_king.business_hours
WHERE day_of_week = v_now_day
AND v_now_time >= open_time
AND v_now_time <= close_time
AND is_closed = $19
),
(SELECT r.client_name FROM public.client_registry r WHERE r.twilio_number = p_to_phone),
$20, $21, $22::TEXT, $23
WHERE NOT EXISTS (SELECT $24 FROM kebab_king.customers WHERE phone = p_from_phone)
|
|
0 min
5%
|
18 ms
|
662
systemic
|
DO $BODY$
DECLARE
-- INPUTS: Safe handling of n8n data using $val$ wrappers
p_shop_phone text := $val$+441234567890$val$;
p_cust_phone text := $val$+447700900000$val$;
p_tool_name text := $val$search_menu$val$;
p_args jsonb := $val${"query":"kebab"}$val$::jsonb;
-- SYSTEM VARIABLES
v_schema text; v_radius numeric; v_shop_pc text; v_result json; v_order_id int;
v_clean_input_pc text; v_clean_shop_pc text;
-- CALCULATION VARIABLES
v_cust_id int; v_saved_pc text;
cust_lat numeric; cust_lon numeric; shop_lat numeric; shop_lon numeric; dist_miles numeric;
BEGIN
-- 1. IDENTIFY TENANT (Fast Registry Lookup)
SELECT db_schema, delivery_radius_miles, shop_postcode
INTO v_schema, v_radius, v_shop_pc
FROM public.client_registry
WHERE twilio_number = p_shop_phone;
IF v_schema IS NULL THEN
v_result := json_build_object('error', 'Shop not found');
ELSE
CASE p_tool_name
-- A. SEARCH MENU
WHEN 'search_menu' THEN
EXECUTE format(
'SELECT json_agg(t) FROM (
SELECT i.name, i.description, v.price
FROM %I.items i
JOIN %I.item_variants v ON i.id = v.item_id
WHERE i.name ILIKE $1 OR i.description ILIKE $1
LIMIT 5
) t', v_schema, v_schema
) INTO v_result USING '%' || (p_args->>'query') || '%';
-- B. CHECK DELIVERY ZONE
WHEN 'check_delivery_zone' THEN
v_clean_input_pc := UPPER(REPLACE(p_args->>'address', ' ', ''));
v_clean_shop_pc := UPPER(REPLACE(v_shop_pc, ' ', ''));
EXECUTE format('SELECT id, postcode FROM %I.customers WHERE phone = $1', v_schema)
INTO v_cust_id, v_saved_pc USING p_cust_phone;
IF v_cust_id IS NOT NULL AND v_saved_pc = v_clean_input_pc THEN
v_result := json_build_object('in_range', true, 'message', 'Yes, that is your registered address.');
ELSE
SELECT latitude, longitude INTO cust_lat, cust_lon FROM public.uk_postcodes WHERE postcode = v_clean_input_pc;
SELECT latitude, longitude INTO shop_lat, shop_lon FROM public.uk_postcodes WHERE postcode = v_clean_shop_pc;
IF cust_lat IS NULL OR shop_lat IS NULL THEN
v_result := json_build_object(
'in_range', false,
'error', 'Postcode not found',
'details', json_build_object('shop_pc', v_clean_shop_pc, 'cust_pc', v_clean_input_pc)
);
ELSE
dist_miles := 3963 * acos(
cos(radians(shop_lat)) * cos(radians(cust_lat)) *
cos(radians(cust_lon) - radians(shop_lon)) +
sin(radians(shop_lat)) * sin(radians(cust_lat))
);
IF dist_miles <= v_radius THEN
v_result := json_build_object('in_range', true, 'distance', round(dist_miles, 2), 'message', 'Yes, we deliver.');
IF v_cust_id IS NULL THEN
EXECUTE format('INSERT INTO %I.customers (phone, postcode, first_name) VALUES ($1, $2, ''Guest'')', v_schema)
USING p_cust_phone, v_clean_input_pc;
END IF;
ELSE
v_result := json_build_object('in_range', false, 'distance', round(dist_miles, 2), 'message', 'Too far.');
END IF;
END IF;
END IF;
-- C. PLACE ORDER
WHEN 'place_order' THEN
EXECUTE format('INSERT INTO %I.customers (phone, first_name) VALUES ($1, ''Guest'') ON CONFLICT (phone) DO NOTHING', v_schema) USING p_cust_phone;
EXECUTE format(
'INSERT INTO %I.orders (customer_id, order_type, payment_method, total_amount, delivery_address, status)
SELECT id, $1, $2, $3, $4, ''pending'' FROM %I.customers WHERE phone = $5 RETURNING id',
v_schema, v_schema
) INTO v_order_id USING p_args->>'order_type', p_args->>'payment_method', (p_args->>'total')::numeric, p_args->>'address', p_cust_phone;
EXECUTE format(
'INSERT INTO %I.order_items (order_id, item_name, quantity, unit_price, total_price)
SELECT $1, name, quantity, price, (quantity * price)
FROM jsonb_to_recordset($2) AS x(name text, quantity int, price numeric)',
v_schema
) USING v_order_id, (p_args->'items');
v_result := json_build_object('order_id', v_order_id, 'message', 'Order placed successfully');
-- D. RE-ORDER USUAL (One-sentence ordering)
-- Positioned BEFORE the ELSE catch-all to ensure reachability
WHEN 'reorder_usual' THEN
EXECUTE format(
'WITH last_order AS (
SELECT id, delivery_address, total_amount, order_type, payment_method
FROM %I.orders
WHERE customer_id = (SELECT id FROM %I.customers WHERE phone = $1)
ORDER BY created_at DESC LIMIT 1
)
SELECT json_build_object(
''items'', (SELECT json_agg(json_build_object(''name'', item_name, ''quantity'', quantity, ''price'', unit_price))
FROM %I.order_items WHERE order_id = last_order.id),
''address'', delivery_address,
''total'', total_amount,
''order_type'', order_type,
''payment_method'', payment_method
) FROM last_order', v_schema, v_schema, v_schema
) INTO v_result USING p_cust_phone;
-- Validation: Ensure items exist before duplicating
IF v_result IS NOT NULL AND (v_result->>'items') IS NOT NULL THEN
EXECUTE format(
'INSERT INTO %I.orders (customer_id, order_type, payment_method, total_amount, delivery_address, status)
SELECT id, $1, $2, $3, $4, ''pending'' FROM %I.customers WHERE phone = $5 RETURNING id',
v_schema, v_schema
) INTO v_order_id USING v_result->>'order_type', v_result->>'payment_method', (v_result->>'total')::numeric, v_result->>'address', p_cust_phone;
EXECUTE format(
'INSERT INTO %I.order_items (order_id, item_name, quantity, unit_price, total_price)
SELECT $1, (x->>''name''), (x->>''quantity'')::int, (x->>''price'')::numeric, ((x->>''quantity'')::int * (x->>''price'')::numeric)
FROM json_array_elements($2) AS x',
v_schema
) USING v_order_id, (v_result->'items');
v_result := json_build_object('order_id', v_order_id, 'message', 'Your usual order has been placed successfully.');
ELSE
v_result := json_build_object('error', 'No previous order found to replicate.');
END IF;
-- Catch-all for undefined tools
ELSE
v_result := json_build_object('error', 'Tool not implemented');
END CASE;
END IF;
PERFORM set_config('n8n.response', COALESCE(v_result, '[]'::json)::text, true);
END $BODY$
|
|
0 min
5%
|
15 ms
|
662
systemic
|
DO $BODY$
DECLARE
-- INPUTS: Safe handling of n8n data using $val$ wrappers
p_shop_phone text := $val$+441234567890$val$;
p_cust_phone text := $val$+447700900000$val$;
p_tool_name text := $val$check_delivery_zone$val$;
p_args jsonb := $val${"address":"G741AA"}$val$::jsonb;
-- SYSTEM VARIABLES
v_schema text; v_radius numeric; v_shop_pc text; v_result json; v_order_id int;
v_clean_input_pc text; v_clean_shop_pc text;
-- CALCULATION VARIABLES
v_cust_id int; v_saved_pc text;
cust_lat numeric; cust_lon numeric; shop_lat numeric; shop_lon numeric; dist_miles numeric;
BEGIN
-- 1. IDENTIFY TENANT (Fast Registry Lookup)
SELECT db_schema, delivery_radius_miles, shop_postcode
INTO v_schema, v_radius, v_shop_pc
FROM public.client_registry
WHERE twilio_number = p_shop_phone;
IF v_schema IS NULL THEN
v_result := json_build_object('error', 'Shop not found');
ELSE
CASE p_tool_name
-- A. SEARCH MENU
WHEN 'search_menu' THEN
EXECUTE format(
'SELECT json_agg(t) FROM (
SELECT i.name, i.description, v.price
FROM %I.items i
JOIN %I.item_variants v ON i.id = v.item_id
WHERE i.name ILIKE $1 OR i.description ILIKE $1
LIMIT 5
) t', v_schema, v_schema
) INTO v_result USING '%' || (p_args->>'query') || '%';
-- B. CHECK DELIVERY ZONE
WHEN 'check_delivery_zone' THEN
v_clean_input_pc := UPPER(REPLACE(p_args->>'address', ' ', ''));
v_clean_shop_pc := UPPER(REPLACE(v_shop_pc, ' ', ''));
EXECUTE format('SELECT id, postcode FROM %I.customers WHERE phone = $1', v_schema)
INTO v_cust_id, v_saved_pc USING p_cust_phone;
IF v_cust_id IS NOT NULL AND v_saved_pc = v_clean_input_pc THEN
v_result := json_build_object('in_range', true, 'message', 'Yes, that is your registered address.');
ELSE
SELECT latitude, longitude INTO cust_lat, cust_lon FROM public.uk_postcodes WHERE postcode = v_clean_input_pc;
SELECT latitude, longitude INTO shop_lat, shop_lon FROM public.uk_postcodes WHERE postcode = v_clean_shop_pc;
IF cust_lat IS NULL OR shop_lat IS NULL THEN
v_result := json_build_object(
'in_range', false,
'error', 'Postcode not found',
'details', json_build_object('shop_pc', v_clean_shop_pc, 'cust_pc', v_clean_input_pc)
);
ELSE
dist_miles := 3963 * acos(
cos(radians(shop_lat)) * cos(radians(cust_lat)) *
cos(radians(cust_lon) - radians(shop_lon)) +
sin(radians(shop_lat)) * sin(radians(cust_lat))
);
IF dist_miles <= v_radius THEN
v_result := json_build_object('in_range', true, 'distance', round(dist_miles, 2), 'message', 'Yes, we deliver.');
IF v_cust_id IS NULL THEN
EXECUTE format('INSERT INTO %I.customers (phone, postcode, first_name) VALUES ($1, $2, ''Guest'')', v_schema)
USING p_cust_phone, v_clean_input_pc;
END IF;
ELSE
v_result := json_build_object('in_range', false, 'distance', round(dist_miles, 2), 'message', 'Too far.');
END IF;
END IF;
END IF;
-- C. PLACE ORDER
WHEN 'place_order' THEN
EXECUTE format('INSERT INTO %I.customers (phone, first_name) VALUES ($1, ''Guest'') ON CONFLICT (phone) DO NOTHING', v_schema) USING p_cust_phone;
EXECUTE format(
'INSERT INTO %I.orders (customer_id, order_type, payment_method, total_amount, delivery_address, status)
SELECT id, $1, $2, $3, $4, ''pending'' FROM %I.customers WHERE phone = $5 RETURNING id',
v_schema, v_schema
) INTO v_order_id USING p_args->>'order_type', p_args->>'payment_method', (p_args->>'total')::numeric, p_args->>'address', p_cust_phone;
EXECUTE format(
'INSERT INTO %I.order_items (order_id, item_name, quantity, unit_price, total_price)
SELECT $1, name, quantity, price, (quantity * price)
FROM jsonb_to_recordset($2) AS x(name text, quantity int, price numeric)',
v_schema
) USING v_order_id, (p_args->'items');
v_result := json_build_object('order_id', v_order_id, 'message', 'Order placed successfully');
-- D. RE-ORDER USUAL (One-sentence ordering)
-- Positioned BEFORE the ELSE catch-all to ensure reachability
WHEN 'reorder_usual' THEN
EXECUTE format(
'WITH last_order AS (
SELECT id, delivery_address, total_amount, order_type, payment_method
FROM %I.orders
WHERE customer_id = (SELECT id FROM %I.customers WHERE phone = $1)
ORDER BY created_at DESC LIMIT 1
)
SELECT json_build_object(
''items'', (SELECT json_agg(json_build_object(''name'', item_name, ''quantity'', quantity, ''price'', unit_price))
FROM %I.order_items WHERE order_id = last_order.id),
''address'', delivery_address,
''total'', total_amount,
''order_type'', order_type,
''payment_method'', payment_method
) FROM last_order', v_schema, v_schema, v_schema
) INTO v_result USING p_cust_phone;
-- Validation: Ensure items exist before duplicating
IF v_result IS NOT NULL AND (v_result->>'items') IS NOT NULL THEN
EXECUTE format(
'INSERT INTO %I.orders (customer_id, order_type, payment_method, total_amount, delivery_address, status)
SELECT id, $1, $2, $3, $4, ''pending'' FROM %I.customers WHERE phone = $5 RETURNING id',
v_schema, v_schema
) INTO v_order_id USING v_result->>'order_type', v_result->>'payment_method', (v_result->>'total')::numeric, v_result->>'address', p_cust_phone;
EXECUTE format(
'INSERT INTO %I.order_items (order_id, item_name, quantity, unit_price, total_price)
SELECT $1, (x->>''name''), (x->>''quantity'')::int, (x->>''price'')::numeric, ((x->>''quantity'')::int * (x->>''price'')::numeric)
FROM json_array_elements($2) AS x',
v_schema
) USING v_order_id, (v_result->'items');
v_result := json_build_object('order_id', v_order_id, 'message', 'Your usual order has been placed successfully.');
ELSE
v_result := json_build_object('error', 'No previous order found to replicate.');
END IF;
-- Catch-all for undefined tools
ELSE
v_result := json_build_object('error', 'Tool not implemented');
END CASE;
END IF;
PERFORM set_config('n8n.response', COALESCE(v_result, '[]'::json)::text, true);
END $BODY$
|
|
0 min
4%
|
14 ms
|
662
systemic
|
DO $BODY$
DECLARE
-- INPUTS: Safe handling of n8n data using $val$ wrappers
p_shop_phone text := $val$+441234567890$val$;
p_cust_phone text := $val$+447700900000$val$;
p_tool_name text := $val$place_order$val$;
p_args jsonb := $val${"order_type":"delivery","payment_method":"cash","total":25.5,"address":"123 Test St, G741AA","items":[{"name":"Donner Kebab","quantity":1,"price":9.5}]}$val$::jsonb;
-- SYSTEM VARIABLES
v_schema text; v_radius numeric; v_shop_pc text; v_result json; v_order_id int;
v_clean_input_pc text; v_clean_shop_pc text;
-- CALCULATION VARIABLES
v_cust_id int; v_saved_pc text;
cust_lat numeric; cust_lon numeric; shop_lat numeric; shop_lon numeric; dist_miles numeric;
BEGIN
-- 1. IDENTIFY TENANT (Fast Registry Lookup)
SELECT db_schema, delivery_radius_miles, shop_postcode
INTO v_schema, v_radius, v_shop_pc
FROM public.client_registry
WHERE twilio_number = p_shop_phone;
IF v_schema IS NULL THEN
v_result := json_build_object('error', 'Shop not found');
ELSE
CASE p_tool_name
-- A. SEARCH MENU
WHEN 'search_menu' THEN
EXECUTE format(
'SELECT json_agg(t) FROM (
SELECT i.name, i.description, v.price
FROM %I.items i
JOIN %I.item_variants v ON i.id = v.item_id
WHERE i.name ILIKE $1 OR i.description ILIKE $1
LIMIT 5
) t', v_schema, v_schema
) INTO v_result USING '%' || (p_args->>'query') || '%';
-- B. CHECK DELIVERY ZONE
WHEN 'check_delivery_zone' THEN
v_clean_input_pc := UPPER(REPLACE(p_args->>'address', ' ', ''));
v_clean_shop_pc := UPPER(REPLACE(v_shop_pc, ' ', ''));
EXECUTE format('SELECT id, postcode FROM %I.customers WHERE phone = $1', v_schema)
INTO v_cust_id, v_saved_pc USING p_cust_phone;
IF v_cust_id IS NOT NULL AND v_saved_pc = v_clean_input_pc THEN
v_result := json_build_object('in_range', true, 'message', 'Yes, that is your registered address.');
ELSE
SELECT latitude, longitude INTO cust_lat, cust_lon FROM public.uk_postcodes WHERE postcode = v_clean_input_pc;
SELECT latitude, longitude INTO shop_lat, shop_lon FROM public.uk_postcodes WHERE postcode = v_clean_shop_pc;
IF cust_lat IS NULL OR shop_lat IS NULL THEN
v_result := json_build_object(
'in_range', false,
'error', 'Postcode not found',
'details', json_build_object('shop_pc', v_clean_shop_pc, 'cust_pc', v_clean_input_pc)
);
ELSE
dist_miles := 3963 * acos(
cos(radians(shop_lat)) * cos(radians(cust_lat)) *
cos(radians(cust_lon) - radians(shop_lon)) +
sin(radians(shop_lat)) * sin(radians(cust_lat))
);
IF dist_miles <= v_radius THEN
v_result := json_build_object('in_range', true, 'distance', round(dist_miles, 2), 'message', 'Yes, we deliver.');
IF v_cust_id IS NULL THEN
EXECUTE format('INSERT INTO %I.customers (phone, postcode, first_name) VALUES ($1, $2, ''Guest'')', v_schema)
USING p_cust_phone, v_clean_input_pc;
END IF;
ELSE
v_result := json_build_object('in_range', false, 'distance', round(dist_miles, 2), 'message', 'Too far.');
END IF;
END IF;
END IF;
-- C. PLACE ORDER
WHEN 'place_order' THEN
EXECUTE format('INSERT INTO %I.customers (phone, first_name) VALUES ($1, ''Guest'') ON CONFLICT (phone) DO NOTHING', v_schema) USING p_cust_phone;
EXECUTE format(
'INSERT INTO %I.orders (customer_id, order_type, payment_method, total_amount, delivery_address, status)
SELECT id, $1, $2, $3, $4, ''pending'' FROM %I.customers WHERE phone = $5 RETURNING id',
v_schema, v_schema
) INTO v_order_id USING p_args->>'order_type', p_args->>'payment_method', (p_args->>'total')::numeric, p_args->>'address', p_cust_phone;
EXECUTE format(
'INSERT INTO %I.order_items (order_id, item_name, quantity, unit_price, total_price)
SELECT $1, name, quantity, price, (quantity * price)
FROM jsonb_to_recordset($2) AS x(name text, quantity int, price numeric)',
v_schema
) USING v_order_id, (p_args->'items');
v_result := json_build_object('order_id', v_order_id, 'message', 'Order placed successfully');
-- D. RE-ORDER USUAL (One-sentence ordering)
-- Positioned BEFORE the ELSE catch-all to ensure reachability
WHEN 'reorder_usual' THEN
EXECUTE format(
'WITH last_order AS (
SELECT id, delivery_address, total_amount, order_type, payment_method
FROM %I.orders
WHERE customer_id = (SELECT id FROM %I.customers WHERE phone = $1)
ORDER BY created_at DESC LIMIT 1
)
SELECT json_build_object(
''items'', (SELECT json_agg(json_build_object(''name'', item_name, ''quantity'', quantity, ''price'', unit_price))
FROM %I.order_items WHERE order_id = last_order.id),
''address'', delivery_address,
''total'', total_amount,
''order_type'', order_type,
''payment_method'', payment_method
) FROM last_order', v_schema, v_schema, v_schema
) INTO v_result USING p_cust_phone;
-- Validation: Ensure items exist before duplicating
IF v_result IS NOT NULL AND (v_result->>'items') IS NOT NULL THEN
EXECUTE format(
'INSERT INTO %I.orders (customer_id, order_type, payment_method, total_amount, delivery_address, status)
SELECT id, $1, $2, $3, $4, ''pending'' FROM %I.customers WHERE phone = $5 RETURNING id',
v_schema, v_schema
) INTO v_order_id USING v_result->>'order_type', v_result->>'payment_method', (v_result->>'total')::numeric, v_result->>'address', p_cust_phone;
EXECUTE format(
'INSERT INTO %I.order_items (order_id, item_name, quantity, unit_price, total_price)
SELECT $1, (x->>''name''), (x->>''quantity'')::int, (x->>''price'')::numeric, ((x->>''quantity'')::int * (x->>''price'')::numeric)
FROM json_array_elements($2) AS x',
v_schema
) USING v_order_id, (v_result->'items');
v_result := json_build_object('order_id', v_order_id, 'message', 'Your usual order has been placed successfully.');
ELSE
v_result := json_build_object('error', 'No previous order found to replicate.');
END IF;
-- Catch-all for undefined tools
ELSE
v_result := json_build_object('error', 'Tool not implemented');
END CASE;
END IF;
PERFORM set_config('n8n.response', COALESCE(v_result, '[]'::json)::text, true);
END $BODY$
|
|
0 min
4%
|
0 ms
|
355,664
systemic
|
SET search_path TO public
|
|
0 min
4%
|
2 ms
|
3,337
systemic
|
UPDATE "public"."execution_data" SET "workflowData" = $1, "data" = $2 WHERE "executionId" = $3
|
|
0 min
4%
|
11 ms
|
662
systemic
|
WITH last_order AS (
SELECT id, delivery_address, total_amount, order_type, payment_method
FROM kebab_king.orders
WHERE customer_id = (SELECT id FROM kebab_king.customers WHERE phone = $1)
ORDER BY created_at DESC LIMIT $2
)
SELECT json_build_object(
$3, (SELECT json_agg(json_build_object($4, item_name, $5, quantity, $6, unit_price))
FROM kebab_king.order_items WHERE order_id = last_order.id),
$7, delivery_address,
$8, total_amount,
$9, order_type,
$10, payment_method
) FROM last_order
|
|
0 min
3%
|
82 ms
|
86
systemic
|
SELECT schemaname AS schema, t.relname AS table, ix.relname AS name, regexp_replace(pg_get_indexdef(i.indexrelid), $1, $2) AS columns, regexp_replace(pg_get_indexdef(i.indexrelid), $3, $4) AS using, indisunique AS unique, indisprimary AS primary, indisvalid AS valid, indexprs::text, indpred::text, pg_get_indexdef(i.indexrelid) AS definition FROM pg_index i INNER JOIN pg_class t ON t.oid = i.indrelid INNER JOIN pg_class ix ON ix.oid = i.indexrelid LEFT JOIN pg_stat_user_indexes ui ON ui.indexrelid = i.indexrelid WHERE schemaname IS NOT NULL ORDER BY 1, 2 /*pghero*/
|
|
0 min
3%
|
2 ms
|
3,310
systemic
|
INSERT INTO "public"."execution_data"("data", "workflowData", "executionId", "workflowVersionId") VALUES ($1, $2, $3, $4)
|
|
0 min
3%
|
2 ms
|
3,330
systemic
|
DELETE FROM "public"."execution_entity" WHERE (("id" = $1))
|
|
0 min
2%
|
1 ms
|
3,338
systemic
|
INSERT INTO "workflow_statistics" ("count", "rootCount", "name", "workflowId", "latestEvent")
VALUES ($5, $1, $2, $3, CURRENT_TIMESTAMP)
ON CONFLICT ("name", "workflowId")
DO UPDATE SET
"count" = "workflow_statistics"."count" + $6,
"rootCount" = "workflow_statistics"."rootCount" + $4,
"latestEvent" = CURRENT_TIMESTAMP
RETURNING *
|
|
0 min
2%
|
0 ms
|
292,699
systemic
|
SELECT $1
|
|
0 min
1%
|
0 ms
|
20,425
systemic
|
SELECT DISTINCT "distinctAlias"."ExecutionEntity_id" AS "ids_ExecutionEntity_id" FROM (SELECT "ExecutionEntity"."id" AS "ExecutionEntity_id", "ExecutionEntity"."finished" AS "ExecutionEntity_finished", "ExecutionEntity"."mode" AS "ExecutionEntity_mode", "ExecutionEntity"."retryOf" AS "ExecutionEntity_retryOf", "ExecutionEntity"."retrySuccessId" AS "ExecutionEntity_retrySuccessId", "ExecutionEntity"."status" AS "ExecutionEntity_status", "ExecutionEntity"."createdAt" AS "ExecutionEntity_createdAt", "ExecutionEntity"."startedAt" AS "ExecutionEntity_startedAt", "ExecutionEntity"."stoppedAt" AS "ExecutionEntity_stoppedAt", "ExecutionEntity"."deletedAt" AS "ExecutionEntity_deletedAt", "ExecutionEntity"."workflowId" AS "ExecutionEntity_workflowId", "ExecutionEntity"."waitTill" AS "ExecutionEntity_waitTill", "ExecutionEntity__ExecutionEntity_executionData"."data" AS "ExecutionEntity__ExecutionEntity_executionData_data", "ExecutionEntity__ExecutionEntity_executionData"."workflowData" AS "ExecutionEntity__ExecutionEntity_executionData_workflowData", "ExecutionEntity__ExecutionEntity_executionData"."executionId" AS "ExecutionEntity__ExecutionEntity_executionData_executionId", "ExecutionEntity__ExecutionEntity_executionData"."workflowVersionId" AS "3e30e424d9845e27b0de0df637c25fce34204985", "ExecutionEntity__ExecutionEntity_metadata"."id" AS "ExecutionEntity__ExecutionEntity_metadata_id", "ExecutionEntity__ExecutionEntity_metadata"."executionId" AS "ExecutionEntity__ExecutionEntity_metadata_executionId", "ExecutionEntity__ExecutionEntity_metadata"."key" AS "ExecutionEntity__ExecutionEntity_metadata_key", "ExecutionEntity__ExecutionEntity_metadata"."value" AS "ExecutionEntity__ExecutionEntity_metadata_value" FROM "public"."execution_entity" "ExecutionEntity" LEFT JOIN "public"."execution_data" "ExecutionEntity__ExecutionEntity_executionData" ON "ExecutionEntity__ExecutionEntity_executionData"."executionId"="ExecutionEntity"."id" LEFT JOIN "public"."execution_metadata" "ExecutionEntity__ExecutionEntity_metadata" ON "ExecutionEntity__ExecutionEntity_metadata"."executionId"="ExecutionEntity"."id" WHERE ( (("ExecutionEntity"."id" = $1)) ) AND ( "ExecutionEntity"."deletedAt" IS NULL )) "distinctAlias" ORDER BY "ExecutionEntity_id" ASC LIMIT $2
|
|
0 min
1.0%
|
3 ms
|
662
systemic
|
SELECT json_agg(t) FROM (
SELECT i.name, i.description, v.price
FROM kebab_king.items i
JOIN kebab_king.item_variants v ON i.id = v.item_id
WHERE i.name ILIKE $1 OR i.description ILIKE $1
LIMIT $2
) t
|
|
0 min
0.9%
|
1 ms
|
1,324
systemic
|
INSERT INTO kebab_king.orders (customer_id, order_type, payment_method, total_amount, delivery_address, status)
SELECT id, $1, $2, $3, $4, $6 FROM kebab_king.customers WHERE phone = $5 RETURNING id
|
|
0 min
0.7%
|
0 ms
|
3,310
systemic
|
INSERT INTO "public"."execution_entity"("finished", "mode", "retryOf", "retrySuccessId", "status", "createdAt", "startedAt", "stoppedAt", "deletedAt", "workflowId", "waitTill") VALUES ($1, $2, DEFAULT, DEFAULT, $3, $4, DEFAULT, DEFAULT, DEFAULT, $5, DEFAULT) RETURNING "id", "deletedAt"
|
|
0 min
0.7%
|
0 ms
|
3,310
systemic
|
UPDATE "public"."execution_entity" SET "mode" = $1, "finished" = $2, "stoppedAt" = $3, "status" = $4 WHERE "id" = $5
|
|
0 min
0.7%
|
17 ms
|
84
systemic
|
WITH query_stats AS ( SELECT LEFT(query, $1) AS query, queryid AS query_hash, rolname AS user, ((total_plan_time + total_exec_time) / $2 / $3) AS total_minutes, ((total_plan_time + total_exec_time) / calls) AS average_time, calls FROM pg_stat_statements INNER JOIN pg_database ON pg_database.oid = pg_stat_statements.dbid INNER JOIN pg_roles ON pg_roles.oid = pg_stat_statements.userid WHERE calls > $4 AND pg_database.datname = current_database() ) SELECT query, query AS explainable_query, query_hash, query_stats.user, total_minutes, average_time, calls, total_minutes * $5 / (SELECT SUM(total_minutes) FROM query_stats) AS total_percent, (SELECT SUM(total_minutes) FROM query_stats) AS all_queries_total_minutes FROM query_stats ORDER BY "total_minutes" DESC LIMIT $6 /*pghero*/
|
|
0 min
0.7%
|
142 ms
|
10
systemic
|
INSERT INTO "public"."insights_raw"("metaId", "type", "value", "timestamp") VALUES ($1, $2, $3, $4), ($5, $6, $7, $8), ($9, $10, $11, $12), ($13, $14, $15, $16), ($17, $18, $19, $20), ($21, $22, $23, $24), ($25, $26, $27, $28), ($29, $30, $31, $32), ($33, $34, $35, $36), ($37, $38, $39, $40), ($41, $42, $43, $44), ($45, $46, $47, $48), ($49, $50, $51, $52), ($53, $54, $55, $56), ($57, $58, $59, $60), ($61, $62, $63, $64), ($65, $66, $67, $68), ($69, $70, $71, $72), ($73, $74, $75, $76), ($77, $78, $79, $80), ($81, $82, $83, $84), ($85, $86, $87, $88), ($89, $90, $91, $92), ($93, $94, $95, $96), ($97, $98, $99, $100), ($101, $102, $103, $104), ($105, $106, $107, $108), ($109, $110, $111, $112), ($113, $114, $115, $116), ($117, $118, $119, $120), ($121, $122, $123, $124), ($125, $126, $127, $128), ($129, $130, $131, $132), ($133, $134, $135, $136), ($137, $138, $139, $140), ($141, $142, $143, $144), ($145, $146, $147, $148), ($149, $150, $151, $152), ($153, $154, $155, $156), ($157, $158, $159, $160), ($161, $162, $163, $164), ($165, $166, $167, $168), ($169, $170, $171, $172), ($173, $174, $175, $176), ($177, $178, $179, $180), ($181, $182, $183, $184), ($185, $186, $187, $188), ($189, $190, $191, $192), ($193, $194, $195, $196), ($197, $198, $199, $200), ($201, $202, $203, $204), ($205, $206, $207, $208), ($209, $210, $211, $212), ($213, $214, $215, $216), ($217, $218, $219, $220), ($221, $222, $223, $224), ($225, $226, $227, $228), ($229, $230, $231, $232), ($233, $234, $235, $236), ($237, $238, $239, $240), ($241, $242, $243, $244), ($245, $246, $247, $248), ($249, $250, $251, $252), ($253, $254, $255, $256), ($257, $258, $259, $260), ($261, $262, $263, $264), ($265, $266, $267, $268), ($269, $270, $271, $272), ($273, $274, $275, $276), ($277, $278, $279, $280), ($281, $282, $283, $284), ($285, $286, $287, $288), ($289, $290, $291, $292), ($293, $294, $295, $296), ($297, $298, $299, $300), ($301, $302, $303, $304), ($305, $306, $307, $308), ($309, $310, $311, $312), ($313, $314, $315, $316), ($317, $318, $319, $320), ($321, $322, $323, $324), ($325, $326, $327, $328), ($329, $330, $331, $332), ($333, $334, $335, $336), ($337, $338, $339, $340), ($341, $342, $343, $344), ($345, $346, $347, $348), ($349, $350, $351, $352), ($353, $354, $355, $356), ($357, $358, $359, $360), ($361, $362, $363, $364), ($365, $366, $367, $368), ($369, $370, $371, $372), ($373, $374, $375, $376), ($377, $378, $379, $380), ($381, $382, $383, $384), ($385, $386, $387, $388), ($389, $390, $391, $392), ($393, $394, $395, $396), ($397, $398, $399, $400), ($401, $402, $403, $404), ($405, $406, $407, $408), ($409, $410, $411, $412), ($413, $414, $415, $416), ($417, $418, $419, $420), ($421, $422, $423, $424), ($425, $426, $427, $428), ($429, $430, $431, $432), ($433, $434, $435, $436), ($437, $438, $439, $440), ($441, $442, $443, $444), ($445, $446, $447, $448), ($449, $450, $451, $452), ($453, $454, $455, $456), ($457, $458, $459, $460), ($461, $462, $463, $464), ($465, $466, $467, $468), ($469, $470, $471, $472), ($473, $474, $475, $476), ($477, $478, $479, $480), ($481, $482, $483, $484), ($485, $486, $487, $488), ($489, $490, $491, $492), ($493, $494, $495, $496), ($497, $498, $499, $500), ($501, $502, $503, $504), ($505, $506, $507, $508), ($509, $510, $511, $512), ($513, $514, $515, $516), ($517, $518, $519, $520), ($521, $522, $523, $524), ($525, $526, $527, $528), ($529, $530, $531, $532), ($533, $534, $535, $536), ($537, $538, $539, $540), ($541, $542, $543, $544), ($545, $546, $547, $548), ($549, $550, $551, $552), ($553, $554, $555, $556), ($557, $558, $559, $560), ($561, $562, $563, $564), ($565, $566, $567, $568), ($569, $570, $571, $572), ($573, $574, $575, $576), ($577, $578, $579, $580), ($581, $582, $583, $584), ($585, $586, $587, $588), ($589, $590, $591, $592), ($593, $594, $595, $596), ($597, $598, $599, $600), ($601, $602, $603, $604), ($605, $606, $607, $608), ($609, $610, $611, $612), ($613, $614, $615, $616), ($617, $618, $619, $620), ($621, $622, $623, $624), ($625, $626, $627, $628), ($629, $630, $631, $632), ($633, $634, $635, $636), ($637, $638, $639, $640), ($641, $642, $643, $644), ($645, $646, $647, $648), ($649, $650, $651, $652), ($653, $654, $655, $656), ($657, $658, $659, $660), ($661, $662, $663, $664), ($665, $666, $667, $668), ($669, $670, $671, $672), ($673, $674, $675, $676), ($677, $678, $679, $680), ($681, $682, $683, $684), ($685, $686, $687, $688), ($689, $690, $691, $692), ($693, $694, $695, $696), ($697, $698, $699, $700), ($701, $702, $703, $704), ($705, $706, $707, $708), ($709, $710, $711, $712), ($713, $714, $715, $716), ($717, $718, $719, $720), ($721, $722, $723, $724), ($725, $726, $727, $728), ($729, $730, $731, $732), ($733, $734, $735, $736), ($737, $738, $739, $740), ($741, $742, $743, $744), ($745, $746, $747, $748), ($749, $750, $751, $752), ($753, $754, $755, $756), ($757, $758, $759, $760), ($761, $762, $763, $764), ($765, $766, $767, $768), ($769, $770, $771, $772), ($773, $774, $775, $776), ($777, $778, $779, $780), ($781, $782, $783, $784), ($785, $786, $787, $788), ($789, $790, $791, $792), ($793, $794, $795, $796), ($797, $798, $799, $800), ($801, $802, $803, $804), ($805, $806, $807, $808), ($809, $810, $811, $812), ($813, $814, $815, $816), ($817, $818, $819, $820), ($821, $822, $823, $824), ($825, $826, $827, $828), ($829, $830, $831, $832), ($833, $834, $835, $836), ($837, $838, $839, $840), ($841, $842, $843, $844), ($845, $846, $847, $848), ($849, $850, $851, $852), ($853, $854, $855, $856), ($857, $858, $859, $860), ($861, $862, $863, $864), ($865, $866, $867, $868), ($869, $870, $871, $872), ($873, $874, $875, $876), ($877, $878, $879, $880), ($881, $882, $883, $884), ($885, $886, $887, $888), ($889, $890, $891, $892), ($893, $894, $895, $896), ($897, $898, $899, $900), ($901, $902, $903, $904), ($905, $906, $907, $908), ($909, $910, $911, $912), ($913, $914, $915, $916), ($917, $918, $919, $920), ($921, $922, $923, $924), ($925, $926, $927, $928), ($929, $930, $931, $932), ($933, $934, $935, $936), ($937, $938, $939, $940), ($941, $942, $943, $944), ($945, $946, $947, $948), ($949, $950, $951, $952), ($953, $954, $955, $956), ($957, $958, $959, $960), ($961, $962, $963, $964), ($965, $966, $967, $968), ($969, $970, $971, $972), ($973, $974, $975, $976), ($977, $978, $979, $980), ($981, $982, $983, $984), ($985, $986, $987, $988), ($989, $990, $991, $992), ($993, $994, $995, $996), ($997, $998, $999, $1000), ($1001, $1002, $1003, $1004), ($1005, $1006, $1007, $1008), ($1009, $1010, $1011, $1012), ($1013, $1014, $1015, $1016), ($1017, $1018, $1019, $1020), ($1021, $1022, $1023, $1024), ($1025, $1026, $1027, $1028), ($1029, $1030, $1031, $1032), ($1033, $1034, $1035, $1036), ($1037, $1038, $1039, $1040), ($1041, $1042, $1043, $1044), ($1045, $1046, $1047, $1048), ($1049, $1050, $1051, $1052), ($1053, $1054, $1055, $1056), ($1057, $1058, $1059, $1060), ($1061, $1062, $1063, $1064), ($1065, $1066, $1067, $1068), ($1069, $1070, $1071, $1072), ($1073, $1074, $1075, $1076), ($1077, $1078, $1079, $1080), ($1081, $1082, $1083, $1084), ($1085, $1086, $1087, $1088), ($1089, $1090, $1091, $1092), ($1093, $1094, $1095, $1096), ($1097, $1098, $1099, $1100), ($1101, $1102, $1103, $1104), ($1105, $1106, $1107, $1108), ($1109, $1110, $1111, $1112), ($1113, $1114, $1115, $1116), ($1117, $1118, $1119, $1120), ($1121, $1122, $1123, $1124), ($1125, $1126, $1127, $1128), ($1129, $1130, $1131, $1132), ($1133, $1134, $1135, $1136), ($1137, $1138, $1139, $1140), ($1141, $1142, $1143, $1144), ($1145, $1146, $1147, $1148), ($1149, $1150, $1151, $1152), ($1153, $1154, $1155, $1156), ($1157, $1158, $1159, $1160), ($1161, $1162, $1163, $1164), ($1165, $1166, $1167, $1168), ($1169, $1170, $1171, $1172), ($1173, $1174, $1175, $1176), ($1177, $1178, $1179, $1180), ($1181, $1182, $1183, $1184), ($1185, $1186, $1187, $1188), ($1189, $1190, $1191, $1192), ($1193, $1194, $1195, $1196), ($1197, $1198, $1199, $1200), ($1201, $1202, $1203, $1204), ($1205, $1206, $1207, $1208), ($1209, $1210, $1211, $1212), ($1213, $1214, $1215, $1216), ($1217, $1218, $1219, $1220), ($1221, $1222, $1223, $1224), ($1225, $1226, $1227, $1228), ($1229, $1230, $1231, $1232), ($1233, $1234, $1235, $1236), ($1237, $1238, $1239, $1240), ($1241, $1242, $1243, $1244), ($1245, $1246, $1247, $1248), ($1249, $1250, $1251, $1252), ($1253, $1254, $1255, $1256), ($1257, $1258, $1259, $1260), ($1261, $1262, $1263, $1264), ($1265, $1266, $1267, $1268), ($1269, $1270, $1271, $1272), ($1273, $1274, $1275, $1276), ($1277, $1278, $1279, $1280), ($1281, $1282, $1283, $1284), ($1285, $1286, $1287, $1288), ($1289, $1290, $1291, $1292), ($1293, $1294, $1295, $1296), ($1297, $1298, $1299, $1300), ($1301, $1302, $1303, $1304), ($1305, $1306, $1307, $1308), ($1309, $1310, $1311, $1312), ($1313, $1314, $1315, $1316), ($1317, $1318, $1319, $1320), ($1321, $1322, $1323, $1324), ($1325, $1326, $1327, $1328), ($1329, $1330, $1331, $1332), ($1333, $1334, $1335, $1336), ($1337, $1338, $1339, $1340), ($1341, $1342, $1343, $1344), ($1345, $1346, $1347, $1348), ($1349, $1350, $1351, $1352), ($1353, $1354, $1355, $1356), ($1357, $1358, $1359, $1360), ($1361, $1362, $1363, $1364), ($1365, $1366, $1367, $1368), ($1369, $1370, $1371, $1372), ($1373, $1374, $1375, $1376), ($1377, $1378, $1379, $1380), ($1381, $1382, $1383, $1384), ($1385, $1386, $1387, $1388), ($1389, $1390, $1391, $1392), ($1393, $1394, $1395, $1396), ($1397, $1398, $1399, $1400), ($1401, $1402, $1403, $1404), ($1405, $1406, $1407, $1408), ($1409, $1410, $1411, $1412), ($1413, $1414, $1415, $1416), ($1417, $1418, $1419, $1420), ($1421, $1422, $1423, $1424), ($1425, $1426, $1427, $1428), ($1429, $1430, $1431, $1432), ($1433, $1434, $1435, $1436), ($1437, $1438, $1439, $1440), ($1441, $1442, $1443, $1444), ($1445, $1446, $1447, $1448), ($1449, $1450, $1451, $1452), ($1453, $1454, $1455, $1456), ($1457, $1458, $1459, $1460), ($1461, $1462, $1463, $1464), ($1465, $1466, $1467, $1468), ($1469, $1470,
|
|
0 min
0.6%
|
0 ms
|
3,310
systemic
|
SELECT DISTINCT "distinctAlias"."WorkflowEntity_id" AS "ids_WorkflowEntity_id" FROM (SELECT "WorkflowEntity"."updatedAt" AS "WorkflowEntity_updatedAt", "WorkflowEntity"."createdAt" AS "WorkflowEntity_createdAt", "WorkflowEntity"."id" AS "WorkflowEntity_id", "WorkflowEntity"."name" AS "WorkflowEntity_name", "WorkflowEntity"."description" AS "WorkflowEntity_description", "WorkflowEntity"."active" AS "WorkflowEntity_active", "WorkflowEntity"."isArchived" AS "WorkflowEntity_isArchived", "WorkflowEntity"."nodes" AS "WorkflowEntity_nodes", "WorkflowEntity"."connections" AS "WorkflowEntity_connections", "WorkflowEntity"."settings" AS "WorkflowEntity_settings", "WorkflowEntity"."staticData" AS "WorkflowEntity_staticData", "WorkflowEntity"."meta" AS "WorkflowEntity_meta", "WorkflowEntity"."pinData" AS "WorkflowEntity_pinData", "WorkflowEntity"."versionId" AS "WorkflowEntity_versionId", "WorkflowEntity"."activeVersionId" AS "WorkflowEntity_activeVersionId", "WorkflowEntity"."versionCounter" AS "WorkflowEntity_versionCounter", "WorkflowEntity"."triggerCount" AS "WorkflowEntity_triggerCount", "WorkflowEntity"."parentFolderId" AS "WorkflowEntity_parentFolderId", "WorkflowEntity__WorkflowEntity_activeVersion"."updatedAt" AS "WorkflowEntity__WorkflowEntity_activeVersion_updatedAt", "WorkflowEntity__WorkflowEntity_activeVersion"."createdAt" AS "WorkflowEntity__WorkflowEntity_activeVersion_createdAt", "WorkflowEntity__WorkflowEntity_activeVersion"."versionId" AS "WorkflowEntity__WorkflowEntity_activeVersion_versionId", "WorkflowEntity__WorkflowEntity_activeVersion"."workflowId" AS "WorkflowEntity__WorkflowEntity_activeVersion_workflowId", "WorkflowEntity__WorkflowEntity_activeVersion"."nodes" AS "WorkflowEntity__WorkflowEntity_activeVersion_nodes", "WorkflowEntity__WorkflowEntity_activeVersion"."connections" AS "WorkflowEntity__WorkflowEntity_activeVersion_connections", "WorkflowEntity__WorkflowEntity_activeVersion"."authors" AS "WorkflowEntity__WorkflowEntity_activeVersion_authors", "WorkflowEntity__WorkflowEntity_activeVersion"."name" AS "WorkflowEntity__WorkflowEntity_activeVersion_name", "WorkflowEntity__WorkflowEntity_activeVersion"."description" AS "WorkflowEntity__WorkflowEntity_activeVersion_description", "WorkflowEntity__WorkflowEntity_activeVersion"."autosaved" AS "WorkflowEntity__WorkflowEntity_activeVersion_autosaved", "WorkflowEntity__WorkflowEntity_shared"."updatedAt" AS "WorkflowEntity__WorkflowEntity_shared_updatedAt", "WorkflowEntity__WorkflowEntity_shared"."createdAt" AS "WorkflowEntity__WorkflowEntity_shared_createdAt", "WorkflowEntity__WorkflowEntity_shared"."role" AS "WorkflowEntity__WorkflowEntity_shared_role", "WorkflowEntity__WorkflowEntity_shared"."workflowId" AS "WorkflowEntity__WorkflowEntity_shared_workflowId", "WorkflowEntity__WorkflowEntity_shared"."projectId" AS "WorkflowEntity__WorkflowEntity_shared_projectId", "6da0e527aac0b6fa1d01a2b055fa2c411cde87d3"."updatedAt" AS "6da0e527aac0b6fa1d01a2b055fa2c411cde87d3_updatedAt", "6da0e527aac0b6fa1d01a2b055fa2c411cde87d3"."createdAt" AS "6da0e527aac0b6fa1d01a2b055fa2c411cde87d3_createdAt", "6da0e527aac0b6fa1d01a2b055fa2c411cde87d3"."id" AS "6da0e527aac0b6fa1d01a2b055fa2c411cde87d3_id", "6da0e527aac0b6fa1d01a2b055fa2c411cde87d3"."name" AS "6da0e527aac0b6fa1d01a2b055fa2c411cde87d3_name", "6da0e527aac0b6fa1d01a2b055fa2c411cde87d3"."type" AS "6da0e527aac0b6fa1d01a2b055fa2c411cde87d3_type", "6da0e527aac0b6fa1d01a2b055fa2c411cde87d3"."icon" AS "6da0e527aac0b6fa1d01a2b055fa2c411cde87d3_icon", "6da0e527aac0b6fa1d01a2b055fa2c411cde87d3"."description" AS "6da0e527aac0b6fa1d01a2b055fa2c411cde87d3_description", "6da0e527aac0b6fa1d01a2b055fa2c411cde87d3"."creatorId" AS "6da0e527aac0b6fa1d01a2b055fa2c411cde87d3_creatorId", "d6f609b4290db51264ee33f3c1aef17bd40a52f7"."updatedAt" AS "d6f609b4290db51264ee33f3c1aef17bd40a52f7_updatedAt", "d6f609b4290db51264ee33f3c1aef17bd40a52f7"."createdAt" AS "d6f609b4290db51264ee33f3c1aef17bd40a52f7_createdAt", "d6f609b4290db51264ee33f3c1aef17bd40a52f7"."userId" AS "d6f609b4290db51264ee33f3c1aef17bd40a52f7_userId", "d6f609b4290db51264ee33f3c1aef17bd40a52f7"."projectId" AS "d6f609b4290db51264ee33f3c1aef17bd40a52f7_projectId", "d6f609b4290db51264ee33f3c1aef17bd40a52f7"."role" AS "d6f609b4290db51264ee33f3c1aef17bd40a52f7_role" FROM "public"."workflow_entity" "WorkflowEntity" LEFT JOIN "public"."workflow_history" "WorkflowEntity__WorkflowEntity_activeVersion" ON "WorkflowEntity__WorkflowEntity_activeVersion"."versionId"="WorkflowEntity"."activeVersionId" LEFT JOIN "public"."shared_workflow" "WorkflowEntity__WorkflowEntity_shared" ON "WorkflowEntity__WorkflowEntity_shared"."workflowId"="WorkflowEntity"."id" LEFT JOIN "public"."project" "6da0e527aac0b6fa1d01a2b055fa2c411cde87d3" ON "6da0e527aac0b6fa1d01a2b055fa2c411cde87d3"."id"="WorkflowEntity__WorkflowEntity_shared"."projectId" LEFT JOIN "public"."project_relation" "d6f609b4290db51264ee33f3c1aef17bd40a52f7" ON "d6f609b4290db51264ee33f3c1aef17bd40a52f7"."projectId"="6da0e527aac0b6fa1d01a2b055fa2c411cde87d3"."id" WHERE (("WorkflowEntity"."id" = $1))) "distinctAlias" ORDER BY "WorkflowEntity_id" ASC LIMIT $2
|
|
0 min
0.5%
|
0 ms
|
3,310
systemic
|
DELETE FROM ONLY "public"."execution_data" WHERE $1 OPERATOR(pg_catalog.=) "executionId"
|
|
0 min
0.5%
|
0 ms
|
3,310
systemic
|
UPDATE "public"."execution_entity" SET "status" = $1, "startedAt" = $2 WHERE "id" = $3
|
|
0 min
0.5%
|
2 ms
|
557
systemic
|
SELECT "User"."updatedAt" AS "User_updatedAt", "User"."createdAt" AS "User_createdAt", "User"."id" AS "User_id", "User"."email" AS "User_email", "User"."firstName" AS "User_firstName", "User"."lastName" AS "User_lastName", "User"."password" AS "User_password", "User"."personalizationAnswers" AS "User_personalizationAnswers", "User"."settings" AS "User_settings", "User"."disabled" AS "User_disabled", "User"."mfaEnabled" AS "User_mfaEnabled", "User"."mfaSecret" AS "User_mfaSecret", "User"."mfaRecoveryCodes" AS "User_mfaRecoveryCodes", "User"."lastActiveAt" AS "User_lastActiveAt", "User"."roleSlug" AS "User_roleSlug", "User__User_role"."updatedAt" AS "User__User_role_updatedAt", "User__User_role"."createdAt" AS "User__User_role_createdAt", "User__User_role"."slug" AS "User__User_role_slug", "User__User_role"."displayName" AS "User__User_role_displayName", "User__User_role"."description" AS "User__User_role_description", "User__User_role"."systemRole" AS "User__User_role_systemRole", "User__User_role"."roleType" AS "User__User_role_roleType", "User__User_role__User__User_role_scopes"."slug" AS "User__User_role__User__User_role_scopes_slug", "User__User_role__User__User_role_scopes"."displayName" AS "User__User_role__User__User_role_scopes_displayName", "User__User_role__User__User_role_scopes"."description" AS "User__User_role__User__User_role_scopes_description" FROM "public"."user" "User" LEFT JOIN "public"."role" "User__User_role" ON "User__User_role"."slug"="User"."roleSlug" LEFT JOIN "public"."role_scope" "User__User_role_User__User_role__User__User_role_scopes" ON "User__User_role_User__User_role__User__User_role_scopes"."roleSlug"="User__User_role"."slug" LEFT JOIN "public"."scope" "User__User_role__User__User_role_scopes" ON "User__User_role__User__User_role_scopes"."slug"="User__User_role_User__User_role__User__User_role_scopes"."scopeSlug" WHERE ( (("User"."id" = $1)) ) AND ( "User"."id" IN ($2) )
|
|
0 min
0.4%
|
1 ms
|
662
systemic
|
INSERT INTO kebab_king.order_items (order_id, item_name, quantity, unit_price, total_price)
SELECT $1, (x->>$3), (x->>$4)::int, (x->>$5)::numeric, ((x->>$6)::int * (x->>$7)::numeric)
FROM json_array_elements($2) AS x
|
|
0 min
0.4%
|
1 ms
|
662
systemic
|
INSERT INTO kebab_king.order_items (order_id, item_name, quantity, unit_price, total_price)
SELECT $1, name, quantity, price, (quantity * price)
FROM jsonb_to_recordset($2) AS x(name text, quantity int, price numeric)
|
|
0 min
0.3%
|
0 ms
|
9,981
systemic
|
SELECT $2 FROM ONLY "public"."insights_metadata" x WHERE "metaId" OPERATOR(pg_catalog.=) $1 FOR KEY SHARE OF x
|
|
0 min
0.3%
|
8 ms
|
80
systemic
|
SELECT n.nspname AS table_schema, c.relname AS table, attname AS column, format_type(a.atttypid, a.atttypmod) AS column_type, pg_get_expr(d.adbin, d.adrelid) AS default_value FROM pg_catalog.pg_attribute a INNER JOIN pg_catalog.pg_class c ON c.oid = a.attrelid INNER JOIN pg_catalog.pg_namespace n ON n.oid = c.relnamespace INNER JOIN pg_catalog.pg_attrdef d ON (a.attrelid, a.attnum) = (d.adrelid, d.adnum) WHERE NOT a.attisdropped AND a.attnum > $1 AND pg_get_expr(d.adbin, d.adrelid) LIKE $2 AND n.nspname NOT LIKE $3 /*pghero*/
|
|
0 min
0.3%
|
11 ms
|
57
systemic
|
CREATE TEMPORARY TABLE rows_to_compact AS
SELECT "id", "metaId", "type", "value", timestamp AS "periodStart" FROM "public"."insights_raw" "insightsRaw" ORDER BY timestamp ASC LIMIT $1
|
|
0 min
0.3%
|
0 ms
|
3,319
systemic
|
SELECT "CredentialsEntity"."updatedAt" AS "CredentialsEntity_updatedAt", "CredentialsEntity"."createdAt" AS "CredentialsEntity_createdAt", "CredentialsEntity"."id" AS "CredentialsEntity_id", "CredentialsEntity"."name" AS "CredentialsEntity_name", "CredentialsEntity"."data" AS "CredentialsEntity_data", "CredentialsEntity"."type" AS "CredentialsEntity_type", "CredentialsEntity"."isManaged" AS "CredentialsEntity_isManaged", "CredentialsEntity"."isGlobal" AS "CredentialsEntity_isGlobal", "CredentialsEntity"."isResolvable" AS "CredentialsEntity_isResolvable", "CredentialsEntity"."resolvableAllowFallback" AS "CredentialsEntity_resolvableAllowFallback", "CredentialsEntity"."resolverId" AS "CredentialsEntity_resolverId" FROM "public"."credentials_entity" "CredentialsEntity" WHERE (("CredentialsEntity"."id" = $1) AND ("CredentialsEntity"."type" = $2)) LIMIT $3
|
|
0 min
0.2%
|
0 ms
|
3,310
systemic
|
SELECT $2 FROM ONLY "public"."execution_entity" x WHERE "id" OPERATOR(pg_catalog.=) $1 FOR KEY SHARE OF x
|
|
0 min
0.2%
|
3 ms
|
140
systemic
|
SELECT t.oid, t.typname, t.typelem, t.typdelim, t.typinput, r.rngsubtype, t.typtype, t.typbasetype
FROM pg_type as t
LEFT JOIN pg_range as r ON oid = rngtypid
WHERE
t.typname IN ($1, $2, $3, $4, $5, $6, $7, $8, $9, $10, $11, $12, $13, $14, $15, $16, $17, $18, $19, $20, $21, $22, $23, $24, $25, $26, $27, $28, $29, $30, $31, $32, $33, $34, $35, $36, $37, $38, $39, $40)
|
|
0 min
0.2%
|
0 ms
|
3,302
systemic
|
DELETE FROM "public"."binary_data" WHERE ("sourceType" = $1 AND "sourceId" IN ($2))
|
|
0 min
0.1%
|
0 ms
|
662
systemic
|
INSERT INTO kebab_king.customers (phone, first_name) VALUES ($1, $2) ON CONFLICT (phone) DO NOTHING
|
|
0 min
0.1%
|
0 ms
|
1,324
systemic
|
SELECT $2 FROM ONLY "kebab_king"."customers" x WHERE "id" OPERATOR(pg_catalog.=) $1 FOR KEY SHARE OF x
|
|
0 min
0.1%
|
0 ms
|
662
systemic
|
SELECT latitude, longitude FROM public.uk_postcodes WHERE postcode = v_clean_input_pc
Covered by index on (postcode)
Rows: 2720556
Row progression: 2720556, 1
Row estimates
- postcode (=): 1
Existing indexes
- postcode PRIMARY
- postcode
- postcode) INCLUDE (latitude, longitude
|
|
0 min
0.1%
|
0 ms
|
1,324
systemic
|
SELECT $2 FROM ONLY "kebab_king"."orders" x WHERE "id" OPERATOR(pg_catalog.=) $1 FOR KEY SHARE OF x
|
|
0 min
0.1%
|
0 ms
|
3,310
systemic
|
SELECT "WorkflowStatistics"."count" AS "WorkflowStatistics_count", "WorkflowStatistics"."rootCount" AS "WorkflowStatistics_rootCount", "WorkflowStatistics"."latestEvent" AS "WorkflowStatistics_latestEvent", "WorkflowStatistics"."name" AS "WorkflowStatistics_name", "WorkflowStatistics"."workflowId" AS "WorkflowStatistics_workflowId" FROM "public"."workflow_statistics" "WorkflowStatistics" WHERE (("WorkflowStatistics"."workflowId" = $1) AND ("WorkflowStatistics"."name" = $2)) LIMIT $3
|
|
0 min
0.1%
|
2 ms
|
101
systemic
|
DROP TABLE rows_to_compact
|
|
0 min
< 0.1%
|
0 ms
|
3,310
systemic
|
DELETE FROM ONLY "public"."execution_metadata" WHERE $1 OPERATOR(pg_catalog.=) "executionId"
|
|
0 min
< 0.1%
|
0 ms
|
3,310
systemic
|
DELETE FROM ONLY "public"."execution_annotations" WHERE $1 OPERATOR(pg_catalog.=) "executionId"
|
|
0 min
< 0.1%
|
0 ms
|
2,648
systemic
|
SELECT db_schema, delivery_radius_miles, shop_postcode
FROM public.client_registry
WHERE twilio_number = p_shop_phone
|
|
0 min
< 0.1%
|
0 ms
|
1,430
systemic
|
SELECT "ExecutionEntity"."id" AS "ExecutionEntity_id", "ExecutionEntity"."waitTill" AS "ExecutionEntity_waitTill" FROM "public"."execution_entity" "ExecutionEntity" WHERE ( (("ExecutionEntity"."waitTill" <= $1) AND ("ExecutionEntity"."status" != $2)) ) AND ( "ExecutionEntity"."deletedAt" IS NULL ) ORDER BY "ExecutionEntity_waitTill" ASC
|
|
0 min
< 0.1%
|
48 ms
|
4
systemic
|
SELECT n.nspname AS schema, c.relname AS relation, CASE c.relkind WHEN $1 THEN $2 WHEN $3 then $4 ELSE $5 END AS type, pg_table_size(c.oid) AS size_bytes FROM pg_class c LEFT JOIN pg_namespace n ON n.oid = c.relnamespace WHERE n.nspname NOT IN ($6, $7) AND n.nspname !~ $8 AND c.relkind IN ($9, $10, $11) ORDER BY pg_table_size(c.oid) DESC, 2 ASC /*pghero*/
|
|
0 min
< 0.1%
|
0 ms
|
3,310
systemic
|
SELECT "WorkflowEntity"."id" AS "WorkflowEntity_id", "WorkflowEntity"."staticData" AS "WorkflowEntity_staticData" FROM "public"."workflow_entity" "WorkflowEntity" WHERE (("WorkflowEntity"."id" = $1)) LIMIT $2
|
|
0 min
< 0.1%
|
0 ms
|
3,319
systemic
|
SELECT $2 FROM ONLY "public"."workflow_entity" x WHERE "id"::pg_catalog.text OPERATOR(pg_catalog.=) $1::pg_catalog.text FOR KEY SHARE OF x
|
|
0 min
< 0.1%
|
0 ms
|
1,273
systemic
|
SELECT COUNT($1) AS "cnt" FROM "public"."workflow_entity" "WorkflowEntity" WHERE ((NOT("WorkflowEntity"."activeVersionId" IS NULL)))
|
|
0 min
< 0.1%
|
0 ms
|
662
systemic
|
SELECT id, postcode FROM kebab_king.customers WHERE phone = $1
|
|
0 min
< 0.1%
|
0 ms
|
2,648
systemic
|
SELECT set_config($10, COALESCE(v_result, $11::json)::text, $12)
|
|
0 min
< 0.1%
|
1 ms
|
125
systemic
|
SELECT "SharedWorkflow"."updatedAt" AS "SharedWorkflow_updatedAt", "SharedWorkflow"."createdAt" AS "SharedWorkflow_createdAt", "SharedWorkflow"."role" AS "SharedWorkflow_role", "SharedWorkflow"."workflowId" AS "SharedWorkflow_workflowId", "SharedWorkflow"."projectId" AS "SharedWorkflow_projectId", "SharedWorkflow__SharedWorkflow_workflow"."updatedAt" AS "SharedWorkflow__SharedWorkflow_workflow_updatedAt", "SharedWorkflow__SharedWorkflow_workflow"."createdAt" AS "SharedWorkflow__SharedWorkflow_workflow_createdAt", "SharedWorkflow__SharedWorkflow_workflow"."id" AS "SharedWorkflow__SharedWorkflow_workflow_id", "SharedWorkflow__SharedWorkflow_workflow"."name" AS "SharedWorkflow__SharedWorkflow_workflow_name", "SharedWorkflow__SharedWorkflow_workflow"."description" AS "SharedWorkflow__SharedWorkflow_workflow_description", "SharedWorkflow__SharedWorkflow_workflow"."active" AS "SharedWorkflow__SharedWorkflow_workflow_active", "SharedWorkflow__SharedWorkflow_workflow"."isArchived" AS "SharedWorkflow__SharedWorkflow_workflow_isArchived", "SharedWorkflow__SharedWorkflow_workflow"."nodes" AS "SharedWorkflow__SharedWorkflow_workflow_nodes", "SharedWorkflow__SharedWorkflow_workflow"."connections" AS "SharedWorkflow__SharedWorkflow_workflow_connections", "SharedWorkflow__SharedWorkflow_workflow"."settings" AS "SharedWorkflow__SharedWorkflow_workflow_settings", "SharedWorkflow__SharedWorkflow_workflow"."staticData" AS "SharedWorkflow__SharedWorkflow_workflow_staticData", "SharedWorkflow__SharedWorkflow_workflow"."meta" AS "SharedWorkflow__SharedWorkflow_workflow_meta", "SharedWorkflow__SharedWorkflow_workflow"."pinData" AS "SharedWorkflow__SharedWorkflow_workflow_pinData", "SharedWorkflow__SharedWorkflow_workflow"."versionId" AS "SharedWorkflow__SharedWorkflow_workflow_versionId", "SharedWorkflow__SharedWorkflow_workflow"."activeVersionId" AS "SharedWorkflow__SharedWorkflow_workflow_activeVersionId", "SharedWorkflow__SharedWorkflow_workflow"."versionCounter" AS "SharedWorkflow__SharedWorkflow_workflow_versionCounter", "SharedWorkflow__SharedWorkflow_workflow"."triggerCount" AS "SharedWorkflow__SharedWorkflow_workflow_triggerCount", "SharedWorkflow__SharedWorkflow_workflow"."parentFolderId" AS "SharedWorkflow__SharedWorkflow_workflow_parentFolderId", "1a765f2a4ba6f3a5767ba217be5f8ff59e61a83d"."updatedAt" AS "1a765f2a4ba6f3a5767ba217be5f8ff59e61a83d_updatedAt", "1a765f2a4ba6f3a5767ba217be5f8ff59e61a83d"."createdAt" AS "1a765f2a4ba6f3a5767ba217be5f8ff59e61a83d_createdAt", "1a765f2a4ba6f3a5767ba217be5f8ff59e61a83d"."role" AS "1a765f2a4ba6f3a5767ba217be5f8ff59e61a83d_role", "1a765f2a4ba6f3a5767ba217be5f8ff59e61a83d"."workflowId" AS "1a765f2a4ba6f3a5767ba217be5f8ff59e61a83d_workflowId", "1a765f2a4ba6f3a5767ba217be5f8ff59e61a83d"."projectId" AS "1a765f2a4ba6f3a5767ba217be5f8ff59e61a83d_projectId", "1b870ba2cbdf81fe474cddbb86cf37ee3b6345c9"."updatedAt" AS "1b870ba2cbdf81fe474cddbb86cf37ee3b6345c9_updatedAt", "1b870ba2cbdf81fe474cddbb86cf37ee3b6345c9"."createdAt" AS "1b870ba2cbdf81fe474cddbb86cf37ee3b6345c9_createdAt", "1b870ba2cbdf81fe474cddbb86cf37ee3b6345c9"."id" AS "1b870ba2cbdf81fe474cddbb86cf37ee3b6345c9_id", "1b870ba2cbdf81fe474cddbb86cf37ee3b6345c9"."name" AS "1b870ba2cbdf81fe474cddbb86cf37ee3b6345c9_name", "1b870ba2cbdf81fe474cddbb86cf37ee3b6345c9"."type" AS "1b870ba2cbdf81fe474cddbb86cf37ee3b6345c9_type", "1b870ba2cbdf81fe474cddbb86cf37ee3b6345c9"."icon" AS "1b870ba2cbdf81fe474cddbb86cf37ee3b6345c9_icon", "1b870ba2cbdf81fe474cddbb86cf37ee3b6345c9"."description" AS "1b870ba2cbdf81fe474cddbb86cf37ee3b6345c9_description", "1b870ba2cbdf81fe474cddbb86cf37ee3b6345c9"."creatorId" AS "1b870ba2cbdf81fe474cddbb86cf37ee3b6345c9_creatorId", "4dc6db3add1f4f8704eb03bb2704fb68228f5db2"."updatedAt" AS "4dc6db3add1f4f8704eb03bb2704fb68228f5db2_updatedAt", "4dc6db3add1f4f8704eb03bb2704fb68228f5db2"."createdAt" AS "4dc6db3add1f4f8704eb03bb2704fb68228f5db2_createdAt", "4dc6db3add1f4f8704eb03bb2704fb68228f5db2"."userId" AS "4dc6db3add1f4f8704eb03bb2704fb68228f5db2_userId", "4dc6db3add1f4f8704eb03bb2704fb68228f5db2"."projectId" AS "4dc6db3add1f4f8704eb03bb2704fb68228f5db2_projectId", "4dc6db3add1f4f8704eb03bb2704fb68228f5db2"."role" AS "4dc6db3add1f4f8704eb03bb2704fb68228f5db2_role", "18f5279f1dc113df741ab97abe65174b499d0e40"."updatedAt" AS "18f5279f1dc113df741ab97abe65174b499d0e40_updatedAt", "18f5279f1dc113df741ab97abe65174b499d0e40"."createdAt" AS "18f5279f1dc113df741ab97abe65174b499d0e40_createdAt", "18f5279f1dc113df741ab97abe65174b499d0e40"."id" AS "18f5279f1dc113df741ab97abe65174b499d0e40_id", "18f5279f1dc113df741ab97abe65174b499d0e40"."email" AS "18f5279f1dc113df741ab97abe65174b499d0e40_email", "18f5279f1dc113df741ab97abe65174b499d0e40"."firstName" AS "18f5279f1dc113df741ab97abe65174b499d0e40_firstName", "18f5279f1dc113df741ab97abe65174b499d0e40"."lastName" AS "18f5279f1dc113df741ab97abe65174b499d0e40_lastName", "18f5279f1dc113df741ab97abe65174b499d0e40"."password" AS "18f5279f1dc113df741ab97abe65174b499d0e40_password", "18f5279f1dc113df741ab97abe65174b499d0e40"."personalizationAnswers" AS "18f5279f1dc113df741ab97abe65174b499d0e40_personalizationAnswers", "18f5279f1dc113df741ab97abe65174b499d0e40"."settings" AS "18f5279f1dc113df741ab97abe65174b499d0e40_settings", "18f5279f1dc113df741ab97abe65174b499d0e40"."disabled" AS "18f5279f1dc113df741ab97abe65174b499d0e40_disabled", "18f5279f1dc113df741ab97abe65174b499d0e40"."mfaEnabled" AS "18f5279f1dc113df741ab97abe65174b499d0e40_mfaEnabled", "18f5279f1dc113df741ab97abe65174b499d0e40"."mfaSecret" AS "18f5279f1dc113df741ab97abe65174b499d0e40_mfaSecret", "18f5279f1dc113df741ab97abe65174b499d0e40"."mfaRecoveryCodes" AS "18f5279f1dc113df741ab97abe65174b499d0e40_mfaRecoveryCodes", "18f5279f1dc113df741ab97abe65174b499d0e40"."lastActiveAt" AS "18f5279f1dc113df741ab97abe65174b499d0e40_lastActiveAt", "18f5279f1dc113df741ab97abe65174b499d0e40"."roleSlug" AS "18f5279f1dc113df741ab97abe65174b499d0e40_roleSlug" FROM "public"."shared_workflow" "SharedWorkflow" LEFT JOIN "public"."workflow_entity" "SharedWorkflow__SharedWorkflow_workflow" ON "SharedWorkflow__SharedWorkflow_workflow"."id"="SharedWorkflow"."workflowId" LEFT JOIN "public"."shared_workflow" "1a765f2a4ba6f3a5767ba217be5f8ff59e61a83d" ON "1a765f2a4ba6f3a5767ba217be5f8ff59e61a83d"."workflowId"="SharedWorkflow__SharedWorkflow_workflow"."id" LEFT JOIN "public"."project" "1b870ba2cbdf81fe474cddbb86cf37ee3b6345c9" ON "1b870ba2cbdf81fe474cddbb86cf37ee3b6345c9"."id"="1a765f2a4ba6f3a5767ba217be5f8ff59e61a83d"."projectId" LEFT JOIN "public"."project_relation" "4dc6db3add1f4f8704eb03bb2704fb68228f5db2" ON "4dc6db3add1f4f8704eb03bb2704fb68228f5db2"."projectId"="1b870ba2cbdf81fe474cddbb86cf37ee3b6345c9"."id" LEFT JOIN "public"."user" "18f5279f1dc113df741ab97abe65174b499d0e40" ON "18f5279f1dc113df741ab97abe65174b499d0e40"."id"="4dc6db3add1f4f8704eb03bb2704fb68228f5db2"."userId" WHERE ( (("SharedWorkflow"."workflowId" = $1)) ) AND ( "SharedWorkflow"."workflowId"=$2 AND "SharedWorkflow"."projectId"=$3 )
|
|
0 min
< 0.1%
|
3 ms
|
45
systemic
|
SELECT "Role"."slug" AS "Role_slug", "Role"."displayName" AS "Role_displayName", "Role"."description" AS "Role_description", "Role"."systemRole" AS "Role_systemRole", "Role"."roleType" AS "Role_roleType", "Role__scopes"."slug" AS "Role__scopes_slug", "Role__scopes"."displayName" AS "Role__scopes_displayName", "Role__scopes"."description" AS "Role__scopes_description" FROM "public"."role" "Role" LEFT JOIN "public"."role_scope" "Role_Role__scopes" ON "Role_Role__scopes"."roleSlug"="Role"."slug" LEFT JOIN "public"."scope" "Role__scopes" ON "Role__scopes"."slug"="Role_Role__scopes"."scopeSlug" WHERE (("Role"."systemRole" = $1))
|
|
0 min
< 0.1%
|
0 ms
|
3,310
systemic
|
SELECT "WebhookEntity"."method" AS "WebhookEntity_method", "WebhookEntity"."webhookPath" AS "WebhookEntity_webhookPath" FROM "public"."webhook_entity" "WebhookEntity" WHERE (("WebhookEntity"."webhookPath" = $1))
|
|
0 min
< 0.1%
|
0 ms
|
662
systemic
|
SELECT latitude, longitude FROM public.uk_postcodes WHERE postcode = v_clean_shop_pc
Covered by index on (postcode)
Rows: 2720556
Row progression: 2720556, 1
Row estimates
- postcode (=): 1
Existing indexes
- postcode PRIMARY
- postcode
- postcode) INCLUDE (latitude, longitude
|
|
0 min
< 0.1%
|
1 ms
|
80
systemic
|
SELECT last_value FROM "public"."migrations_id_seq" UNION ALL SELECT last_value FROM "public"."client_registry_id_seq" UNION ALL SELECT last_value FROM "public"."execution_entity_id_seq" UNION ALL SELECT last_value FROM "public"."auth_provider_sync_history_id_seq" UNION ALL SELECT last_value FROM "public"."execution_metadata_temp_id_seq" UNION ALL SELECT last_value FROM "public"."execution_annotations_id_seq" UNION ALL SELECT last_value FROM "kebab_king"."categories_id_seq" UNION ALL SELECT last_value FROM "kebab_king"."items_id_seq" UNION ALL SELECT last_value FROM "kebab_king"."item_variants_id_seq" UNION ALL SELECT last_value FROM "kebab_king"."item_options_id_seq" UNION ALL SELECT last_value FROM "kebab_king"."item_tags_id_seq" UNION ALL SELECT last_value FROM "kebab_king"."item_components_id_seq" UNION ALL SELECT last_value FROM "kebab_king"."customers_id_seq" UNION ALL SELECT last_value FROM "kebab_king"."orders_id_seq" UNION ALL SELECT last_value FROM "kebab_king"."order_items_id_seq" UNION ALL SELECT last_value FROM "kebab_king"."business_hours_id_seq" /*pghero*/
|
|
0 min
< 0.1%
|
98 ms
|
1
systemic
|
INSERT INTO "public"."insights_raw"("metaId", "type", "value", "timestamp") VALUES ($1, $2, $3, $4), ($5, $6, $7, $8), ($9, $10, $11, $12), ($13, $14, $15, $16), ($17, $18, $19, $20), ($21, $22, $23, $24), ($25, $26, $27, $28), ($29, $30, $31, $32), ($33, $34, $35, $36), ($37, $38, $39, $40), ($41, $42, $43, $44), ($45, $46, $47, $48), ($49, $50, $51, $52), ($53, $54, $55, $56), ($57, $58, $59, $60), ($61, $62, $63, $64), ($65, $66, $67, $68), ($69, $70, $71, $72), ($73, $74, $75, $76), ($77, $78, $79, $80), ($81, $82, $83, $84), ($85, $86, $87, $88), ($89, $90, $91, $92), ($93, $94, $95, $96), ($97, $98, $99, $100), ($101, $102, $103, $104), ($105, $106, $107, $108), ($109, $110, $111, $112), ($113, $114, $115, $116), ($117, $118, $119, $120), ($121, $122, $123, $124), ($125, $126, $127, $128), ($129, $130, $131, $132), ($133, $134, $135, $136), ($137, $138, $139, $140), ($141, $142, $143, $144), ($145, $146, $147, $148), ($149, $150, $151, $152), ($153, $154, $155, $156), ($157, $158, $159, $160), ($161, $162, $163, $164), ($165, $166, $167, $168), ($169, $170, $171, $172), ($173, $174, $175, $176), ($177, $178, $179, $180), ($181, $182, $183, $184), ($185, $186, $187, $188), ($189, $190, $191, $192), ($193, $194, $195, $196), ($197, $198, $199, $200), ($201, $202, $203, $204), ($205, $206, $207, $208), ($209, $210, $211, $212), ($213, $214, $215, $216), ($217, $218, $219, $220), ($221, $222, $223, $224), ($225, $226, $227, $228), ($229, $230, $231, $232), ($233, $234, $235, $236), ($237, $238, $239, $240), ($241, $242, $243, $244), ($245, $246, $247, $248), ($249, $250, $251, $252), ($253, $254, $255, $256), ($257, $258, $259, $260), ($261, $262, $263, $264), ($265, $266, $267, $268), ($269, $270, $271, $272), ($273, $274, $275, $276), ($277, $278, $279, $280), ($281, $282, $283, $284), ($285, $286, $287, $288), ($289, $290, $291, $292), ($293, $294, $295, $296), ($297, $298, $299, $300), ($301, $302, $303, $304), ($305, $306, $307, $308), ($309, $310, $311, $312), ($313, $314, $315, $316), ($317, $318, $319, $320), ($321, $322, $323, $324), ($325, $326, $327, $328), ($329, $330, $331, $332), ($333, $334, $335, $336), ($337, $338, $339, $340), ($341, $342, $343, $344), ($345, $346, $347, $348), ($349, $350, $351, $352), ($353, $354, $355, $356), ($357, $358, $359, $360), ($361, $362, $363, $364), ($365, $366, $367, $368), ($369, $370, $371, $372), ($373, $374, $375, $376), ($377, $378, $379, $380), ($381, $382, $383, $384), ($385, $386, $387, $388), ($389, $390, $391, $392), ($393, $394, $395, $396), ($397, $398, $399, $400), ($401, $402, $403, $404), ($405, $406, $407, $408), ($409, $410, $411, $412), ($413, $414, $415, $416), ($417, $418, $419, $420), ($421, $422, $423, $424), ($425, $426, $427, $428), ($429, $430, $431, $432), ($433, $434, $435, $436), ($437, $438, $439, $440), ($441, $442, $443, $444), ($445, $446, $447, $448), ($449, $450, $451, $452), ($453, $454, $455, $456), ($457, $458, $459, $460), ($461, $462, $463, $464), ($465, $466, $467, $468), ($469, $470, $471, $472), ($473, $474, $475, $476), ($477, $478, $479, $480), ($481, $482, $483, $484), ($485, $486, $487, $488), ($489, $490, $491, $492), ($493, $494, $495, $496), ($497, $498, $499, $500), ($501, $502, $503, $504), ($505, $506, $507, $508), ($509, $510, $511, $512), ($513, $514, $515, $516), ($517, $518, $519, $520), ($521, $522, $523, $524), ($525, $526, $527, $528), ($529, $530, $531, $532), ($533, $534, $535, $536), ($537, $538, $539, $540), ($541, $542, $543, $544), ($545, $546, $547, $548), ($549, $550, $551, $552), ($553, $554, $555, $556), ($557, $558, $559, $560), ($561, $562, $563, $564), ($565, $566, $567, $568), ($569, $570, $571, $572), ($573, $574, $575, $576), ($577, $578, $579, $580), ($581, $582, $583, $584), ($585, $586, $587, $588), ($589, $590, $591, $592), ($593, $594, $595, $596), ($597, $598, $599, $600), ($601, $602, $603, $604), ($605, $606, $607, $608), ($609, $610, $611, $612), ($613, $614, $615, $616), ($617, $618, $619, $620), ($621, $622, $623, $624), ($625, $626, $627, $628), ($629, $630, $631, $632), ($633, $634, $635, $636), ($637, $638, $639, $640), ($641, $642, $643, $644), ($645, $646, $647, $648), ($649, $650, $651, $652), ($653, $654, $655, $656), ($657, $658, $659, $660), ($661, $662, $663, $664), ($665, $666, $667, $668), ($669, $670, $671, $672), ($673, $674, $675, $676), ($677, $678, $679, $680), ($681, $682, $683, $684), ($685, $686, $687, $688), ($689, $690, $691, $692), ($693, $694, $695, $696), ($697, $698, $699, $700), ($701, $702, $703, $704), ($705, $706, $707, $708), ($709, $710, $711, $712), ($713, $714, $715, $716), ($717, $718, $719, $720), ($721, $722, $723, $724), ($725, $726, $727, $728), ($729, $730, $731, $732), ($733, $734, $735, $736), ($737, $738, $739, $740), ($741, $742, $743, $744), ($745, $746, $747, $748), ($749, $750, $751, $752), ($753, $754, $755, $756), ($757, $758, $759, $760), ($761, $762, $763, $764), ($765, $766, $767, $768), ($769, $770, $771, $772), ($773, $774, $775, $776), ($777, $778, $779, $780), ($781, $782, $783, $784), ($785, $786, $787, $788), ($789, $790, $791, $792), ($793, $794, $795, $796), ($797, $798, $799, $800), ($801, $802, $803, $804), ($805, $806, $807, $808), ($809, $810, $811, $812), ($813, $814, $815, $816), ($817, $818, $819, $820), ($821, $822, $823, $824), ($825, $826, $827, $828), ($829, $830, $831, $832), ($833, $834, $835, $836), ($837, $838, $839, $840), ($841, $842, $843, $844), ($845, $846, $847, $848), ($849, $850, $851, $852), ($853, $854, $855, $856), ($857, $858, $859, $860), ($861, $862, $863, $864), ($865, $866, $867, $868), ($869, $870, $871, $872), ($873, $874, $875, $876), ($877, $878, $879, $880), ($881, $882, $883, $884), ($885, $886, $887, $888), ($889, $890, $891, $892), ($893, $894, $895, $896), ($897, $898, $899, $900), ($901, $902, $903, $904), ($905, $906, $907, $908), ($909, $910, $911, $912), ($913, $914, $915, $916), ($917, $918, $919, $920), ($921, $922, $923, $924), ($925, $926, $927, $928), ($929, $930, $931, $932), ($933, $934, $935, $936), ($937, $938, $939, $940), ($941, $942, $943, $944), ($945, $946, $947, $948), ($949, $950, $951, $952), ($953, $954, $955, $956), ($957, $958, $959, $960), ($961, $962, $963, $964), ($965, $966, $967, $968), ($969, $970, $971, $972), ($973, $974, $975, $976), ($977, $978, $979, $980), ($981, $982, $983, $984), ($985, $986, $987, $988), ($989, $990, $991, $992), ($993, $994, $995, $996), ($997, $998, $999, $1000), ($1001, $1002, $1003, $1004), ($1005, $1006, $1007, $1008), ($1009, $1010, $1011, $1012), ($1013, $1014, $1015, $1016), ($1017, $1018, $1019, $1020), ($1021, $1022, $1023, $1024), ($1025, $1026, $1027, $1028), ($1029, $1030, $1031, $1032), ($1033, $1034, $1035, $1036), ($1037, $1038, $1039, $1040), ($1041, $1042, $1043, $1044), ($1045, $1046, $1047, $1048), ($1049, $1050, $1051, $1052), ($1053, $1054, $1055, $1056), ($1057, $1058, $1059, $1060), ($1061, $1062, $1063, $1064), ($1065, $1066, $1067, $1068), ($1069, $1070, $1071, $1072), ($1073, $1074, $1075, $1076), ($1077, $1078, $1079, $1080), ($1081, $1082, $1083, $1084), ($1085, $1086, $1087, $1088), ($1089, $1090, $1091, $1092), ($1093, $1094, $1095, $1096), ($1097, $1098, $1099, $1100), ($1101, $1102, $1103, $1104), ($1105, $1106, $1107, $1108), ($1109, $1110, $1111, $1112), ($1113, $1114, $1115, $1116), ($1117, $1118, $1119, $1120), ($1121, $1122, $1123, $1124), ($1125, $1126, $1127, $1128), ($1129, $1130, $1131, $1132), ($1133, $1134, $1135, $1136), ($1137, $1138, $1139, $1140), ($1141, $1142, $1143, $1144), ($1145, $1146, $1147, $1148), ($1149, $1150, $1151, $1152), ($1153, $1154, $1155, $1156), ($1157, $1158, $1159, $1160), ($1161, $1162, $1163, $1164), ($1165, $1166, $1167, $1168), ($1169, $1170, $1171, $1172), ($1173, $1174, $1175, $1176), ($1177, $1178, $1179, $1180), ($1181, $1182, $1183, $1184), ($1185, $1186, $1187, $1188), ($1189, $1190, $1191, $1192), ($1193, $1194, $1195, $1196), ($1197, $1198, $1199, $1200), ($1201, $1202, $1203, $1204), ($1205, $1206, $1207, $1208), ($1209, $1210, $1211, $1212), ($1213, $1214, $1215, $1216), ($1217, $1218, $1219, $1220), ($1221, $1222, $1223, $1224), ($1225, $1226, $1227, $1228), ($1229, $1230, $1231, $1232), ($1233, $1234, $1235, $1236), ($1237, $1238, $1239, $1240), ($1241, $1242, $1243, $1244), ($1245, $1246, $1247, $1248), ($1249, $1250, $1251, $1252), ($1253, $1254, $1255, $1256), ($1257, $1258, $1259, $1260), ($1261, $1262, $1263, $1264), ($1265, $1266, $1267, $1268), ($1269, $1270, $1271, $1272), ($1273, $1274, $1275, $1276), ($1277, $1278, $1279, $1280), ($1281, $1282, $1283, $1284), ($1285, $1286, $1287, $1288), ($1289, $1290, $1291, $1292), ($1293, $1294, $1295, $1296), ($1297, $1298, $1299, $1300), ($1301, $1302, $1303, $1304), ($1305, $1306, $1307, $1308), ($1309, $1310, $1311, $1312), ($1313, $1314, $1315, $1316), ($1317, $1318, $1319, $1320), ($1321, $1322, $1323, $1324), ($1325, $1326, $1327, $1328), ($1329, $1330, $1331, $1332), ($1333, $1334, $1335, $1336), ($1337, $1338, $1339, $1340), ($1341, $1342, $1343, $1344), ($1345, $1346, $1347, $1348), ($1349, $1350, $1351, $1352), ($1353, $1354, $1355, $1356), ($1357, $1358, $1359, $1360), ($1361, $1362, $1363, $1364), ($1365, $1366, $1367, $1368), ($1369, $1370, $1371, $1372), ($1373, $1374, $1375, $1376), ($1377, $1378, $1379, $1380), ($1381, $1382, $1383, $1384), ($1385, $1386, $1387, $1388), ($1389, $1390, $1391, $1392), ($1393, $1394, $1395, $1396), ($1397, $1398, $1399, $1400), ($1401, $1402, $1403, $1404), ($1405, $1406, $1407, $1408), ($1409, $1410, $1411, $1412), ($1413, $1414, $1415, $1416), ($1417, $1418, $1419, $1420), ($1421, $1422, $1423, $1424), ($1425, $1426, $1427, $1428) RETURNING "id"
|
|
0 min
< 0.1%
|
2 ms
|
44
systemic
|
CREATE TEMPORARY TABLE rows_to_compact AS
SELECT "id", "metaId", "type", "periodStart", "value" FROM "public"."insights_by_period" "InsightsByPeriod" WHERE "periodUnit" = $1 AND "periodStart" < CURRENT_DATE - INTERVAL $2 ORDER BY "periodStart" ASC LIMIT $3
|
|
0 min
< 0.1%
|
24 ms
|
4
systemic
|
SELECT schemaname AS schema, relname AS table, indexrelname AS index, pg_relation_size(i.indexrelid) AS size_bytes, idx_scan as index_scans FROM pg_stat_user_indexes ui INNER JOIN pg_index i ON ui.indexrelid = i.indexrelid WHERE NOT indisunique AND idx_scan <= $1 ORDER BY pg_relation_size(i.indexrelid) DESC, relname ASC /*pghero*/
|
|
0 min
< 0.1%
|
0 ms
|
3,310
systemic
|
-- 4. READ THE VARIABLE
SELECT current_setting($1)::json as n8n_output
|
|
0 min
< 0.1%
|
1 ms
|
80
systemic
|
SELECT n.nspname AS schema, c.relname AS table, $1 - GREATEST(AGE(c.relfrozenxid), AGE(t.relfrozenxid)) AS transactions_left FROM pg_class c INNER JOIN pg_catalog.pg_namespace n ON n.oid = c.relnamespace LEFT JOIN pg_class t ON c.reltoastrelid = t.oid WHERE c.relkind = $2 AND ($3 - GREATEST(AGE(c.relfrozenxid), AGE(t.relfrozenxid))) < $4 ORDER BY 3, 1, 2 /*pghero*/
|
|
0 min
< 0.1%
|
1 ms
|
140
systemic
|
SELECT t.oid, t.typname, t.typelem, t.typdelim, t.typinput, r.rngsubtype, t.typtype, t.typbasetype
FROM pg_type as t
LEFT JOIN pg_range as r ON oid = rngtypid
WHERE
t.typelem IN ($1, $2, $3, $4, $5, $6, $7, $8, $9, $10, $11, $12, $13, $14, $15, $16, $17, $18, $19, $20, $21, $22, $23, $24, $25, $26, $27, $28, $29, $30, $31, $32, $33, $34, $35, $36, $37, $38, $39, $40, $41, $42, $43, $44, $45, $46, $47, $48)
|
|
0 min
< 0.1%
|
1 ms
|
140
systemic
|
SELECT t.oid, t.typname
FROM pg_type as t
WHERE t.typname IN ($1, $2, $3, $4, $5, $6, $7, $8, $9, $10, $11)
|
|
0 min
< 0.1%
|
3 ms
|
23
systemic
|
SELECT "SharedWorkflow"."updatedAt" AS "SharedWorkflow_updatedAt", "SharedWorkflow"."createdAt" AS "SharedWorkflow_createdAt", "SharedWorkflow"."role" AS "SharedWorkflow_role", "SharedWorkflow"."workflowId" AS "SharedWorkflow_workflowId", "SharedWorkflow"."projectId" AS "SharedWorkflow_projectId", "SharedWorkflow__SharedWorkflow_workflow"."updatedAt" AS "SharedWorkflow__SharedWorkflow_workflow_updatedAt", "SharedWorkflow__SharedWorkflow_workflow"."createdAt" AS "SharedWorkflow__SharedWorkflow_workflow_createdAt", "SharedWorkflow__SharedWorkflow_workflow"."id" AS "SharedWorkflow__SharedWorkflow_workflow_id", "SharedWorkflow__SharedWorkflow_workflow"."name" AS "SharedWorkflow__SharedWorkflow_workflow_name", "SharedWorkflow__SharedWorkflow_workflow"."description" AS "SharedWorkflow__SharedWorkflow_workflow_description", "SharedWorkflow__SharedWorkflow_workflow"."active" AS "SharedWorkflow__SharedWorkflow_workflow_active", "SharedWorkflow__SharedWorkflow_workflow"."isArchived" AS "SharedWorkflow__SharedWorkflow_workflow_isArchived", "SharedWorkflow__SharedWorkflow_workflow"."nodes" AS "SharedWorkflow__SharedWorkflow_workflow_nodes", "SharedWorkflow__SharedWorkflow_workflow"."connections" AS "SharedWorkflow__SharedWorkflow_workflow_connections", "SharedWorkflow__SharedWorkflow_workflow"."settings" AS "SharedWorkflow__SharedWorkflow_workflow_settings", "SharedWorkflow__SharedWorkflow_workflow"."staticData" AS "SharedWorkflow__SharedWorkflow_workflow_staticData", "SharedWorkflow__SharedWorkflow_workflow"."meta" AS "SharedWorkflow__SharedWorkflow_workflow_meta", "SharedWorkflow__SharedWorkflow_workflow"."pinData" AS "SharedWorkflow__SharedWorkflow_workflow_pinData", "SharedWorkflow__SharedWorkflow_workflow"."versionId" AS "SharedWorkflow__SharedWorkflow_workflow_versionId", "SharedWorkflow__SharedWorkflow_workflow"."activeVersionId" AS "SharedWorkflow__SharedWorkflow_workflow_activeVersionId", "SharedWorkflow__SharedWorkflow_workflow"."versionCounter" AS "SharedWorkflow__SharedWorkflow_workflow_versionCounter", "SharedWorkflow__SharedWorkflow_workflow"."triggerCount" AS "SharedWorkflow__SharedWorkflow_workflow_triggerCount", "SharedWorkflow__SharedWorkflow_workflow"."parentFolderId" AS "SharedWorkflow__SharedWorkflow_workflow_parentFolderId", "1a765f2a4ba6f3a5767ba217be5f8ff59e61a83d"."updatedAt" AS "1a765f2a4ba6f3a5767ba217be5f8ff59e61a83d_updatedAt", "1a765f2a4ba6f3a5767ba217be5f8ff59e61a83d"."createdAt" AS "1a765f2a4ba6f3a5767ba217be5f8ff59e61a83d_createdAt", "1a765f2a4ba6f3a5767ba217be5f8ff59e61a83d"."role" AS "1a765f2a4ba6f3a5767ba217be5f8ff59e61a83d_role", "1a765f2a4ba6f3a5767ba217be5f8ff59e61a83d"."workflowId" AS "1a765f2a4ba6f3a5767ba217be5f8ff59e61a83d_workflowId", "1a765f2a4ba6f3a5767ba217be5f8ff59e61a83d"."projectId" AS "1a765f2a4ba6f3a5767ba217be5f8ff59e61a83d_projectId", "1b870ba2cbdf81fe474cddbb86cf37ee3b6345c9"."updatedAt" AS "1b870ba2cbdf81fe474cddbb86cf37ee3b6345c9_updatedAt", "1b870ba2cbdf81fe474cddbb86cf37ee3b6345c9"."createdAt" AS "1b870ba2cbdf81fe474cddbb86cf37ee3b6345c9_createdAt", "1b870ba2cbdf81fe474cddbb86cf37ee3b6345c9"."id" AS "1b870ba2cbdf81fe474cddbb86cf37ee3b6345c9_id", "1b870ba2cbdf81fe474cddbb86cf37ee3b6345c9"."name" AS "1b870ba2cbdf81fe474cddbb86cf37ee3b6345c9_name", "1b870ba2cbdf81fe474cddbb86cf37ee3b6345c9"."type" AS "1b870ba2cbdf81fe474cddbb86cf37ee3b6345c9_type", "1b870ba2cbdf81fe474cddbb86cf37ee3b6345c9"."icon" AS "1b870ba2cbdf81fe474cddbb86cf37ee3b6345c9_icon", "1b870ba2cbdf81fe474cddbb86cf37ee3b6345c9"."description" AS "1b870ba2cbdf81fe474cddbb86cf37ee3b6345c9_description", "1b870ba2cbdf81fe474cddbb86cf37ee3b6345c9"."creatorId" AS "1b870ba2cbdf81fe474cddbb86cf37ee3b6345c9_creatorId", "4dc6db3add1f4f8704eb03bb2704fb68228f5db2"."updatedAt" AS "4dc6db3add1f4f8704eb03bb2704fb68228f5db2_updatedAt", "4dc6db3add1f4f8704eb03bb2704fb68228f5db2"."createdAt" AS "4dc6db3add1f4f8704eb03bb2704fb68228f5db2_createdAt", "4dc6db3add1f4f8704eb03bb2704fb68228f5db2"."userId" AS "4dc6db3add1f4f8704eb03bb2704fb68228f5db2_userId", "4dc6db3add1f4f8704eb03bb2704fb68228f5db2"."projectId" AS "4dc6db3add1f4f8704eb03bb2704fb68228f5db2_projectId", "4dc6db3add1f4f8704eb03bb2704fb68228f5db2"."role" AS "4dc6db3add1f4f8704eb03bb2704fb68228f5db2_role", "18f5279f1dc113df741ab97abe65174b499d0e40"."updatedAt" AS "18f5279f1dc113df741ab97abe65174b499d0e40_updatedAt", "18f5279f1dc113df741ab97abe65174b499d0e40"."createdAt" AS "18f5279f1dc113df741ab97abe65174b499d0e40_createdAt", "18f5279f1dc113df741ab97abe65174b499d0e40"."id" AS "18f5279f1dc113df741ab97abe65174b499d0e40_id", "18f5279f1dc113df741ab97abe65174b499d0e40"."email" AS "18f5279f1dc113df741ab97abe65174b499d0e40_email", "18f5279f1dc113df741ab97abe65174b499d0e40"."firstName" AS "18f5279f1dc113df741ab97abe65174b499d0e40_firstName", "18f5279f1dc113df741ab97abe65174b499d0e40"."lastName" AS "18f5279f1dc113df741ab97abe65174b499d0e40_lastName", "18f5279f1dc113df741ab97abe65174b499d0e40"."password" AS "18f5279f1dc113df741ab97abe65174b499d0e40_password", "18f5279f1dc113df741ab97abe65174b499d0e40"."personalizationAnswers" AS "18f5279f1dc113df741ab97abe65174b499d0e40_personalizationAnswers", "18f5279f1dc113df741ab97abe65174b499d0e40"."settings" AS "18f5279f1dc113df741ab97abe65174b499d0e40_settings", "18f5279f1dc113df741ab97abe65174b499d0e40"."disabled" AS "18f5279f1dc113df741ab97abe65174b499d0e40_disabled", "18f5279f1dc113df741ab97abe65174b499d0e40"."mfaEnabled" AS "18f5279f1dc113df741ab97abe65174b499d0e40_mfaEnabled", "18f5279f1dc113df741ab97abe65174b499d0e40"."mfaSecret" AS "18f5279f1dc113df741ab97abe65174b499d0e40_mfaSecret", "18f5279f1dc113df741ab97abe65174b499d0e40"."mfaRecoveryCodes" AS "18f5279f1dc113df741ab97abe65174b499d0e40_mfaRecoveryCodes", "18f5279f1dc113df741ab97abe65174b499d0e40"."lastActiveAt" AS "18f5279f1dc113df741ab97abe65174b499d0e40_lastActiveAt", "18f5279f1dc113df741ab97abe65174b499d0e40"."roleSlug" AS "18f5279f1dc113df741ab97abe65174b499d0e40_roleSlug", "2a3c8fb003125249c561d0c4cab6725e2be40123"."updatedAt" AS "2a3c8fb003125249c561d0c4cab6725e2be40123_updatedAt", "2a3c8fb003125249c561d0c4cab6725e2be40123"."createdAt" AS "2a3c8fb003125249c561d0c4cab6725e2be40123_createdAt", "2a3c8fb003125249c561d0c4cab6725e2be40123"."id" AS "2a3c8fb003125249c561d0c4cab6725e2be40123_id", "2a3c8fb003125249c561d0c4cab6725e2be40123"."name" AS "2a3c8fb003125249c561d0c4cab6725e2be40123_name", "7a9439c803f435861ec57b09619a667b46f04ca0"."updatedAt" AS "7a9439c803f435861ec57b09619a667b46f04ca0_updatedAt", "7a9439c803f435861ec57b09619a667b46f04ca0"."createdAt" AS "7a9439c803f435861ec57b09619a667b46f04ca0_createdAt", "7a9439c803f435861ec57b09619a667b46f04ca0"."id" AS "7a9439c803f435861ec57b09619a667b46f04ca0_id", "7a9439c803f435861ec57b09619a667b46f04ca0"."name" AS "7a9439c803f435861ec57b09619a667b46f04ca0_name", "7a9439c803f435861ec57b09619a667b46f04ca0"."parentFolderId" AS "7a9439c803f435861ec57b09619a667b46f04ca0_parentFolderId", "7a9439c803f435861ec57b09619a667b46f04ca0"."projectId" AS "7a9439c803f435861ec57b09619a667b46f04ca0_projectId", "5d10c4c683272fb8559ce544dc3bb984b1bdae0a"."updatedAt" AS "5d10c4c683272fb8559ce544dc3bb984b1bdae0a_updatedAt", "5d10c4c683272fb8559ce544dc3bb984b1bdae0a"."createdAt" AS "5d10c4c683272fb8559ce544dc3bb984b1bdae0a_createdAt", "5d10c4c683272fb8559ce544dc3bb984b1bdae0a"."versionId" AS "5d10c4c683272fb8559ce544dc3bb984b1bdae0a_versionId", "5d10c4c683272fb8559ce544dc3bb984b1bdae0a"."workflowId" AS "5d10c4c683272fb8559ce544dc3bb984b1bdae0a_workflowId", "5d10c4c683272fb8559ce544dc3bb984b1bdae0a"."nodes" AS "5d10c4c683272fb8559ce544dc3bb984b1bdae0a_nodes", "5d10c4c683272fb8559ce544dc3bb984b1bdae0a"."connections" AS "5d10c4c683272fb8559ce544dc3bb984b1bdae0a_connections", "5d10c4c683272fb8559ce544dc3bb984b1bdae0a"."authors" AS "5d10c4c683272fb8559ce544dc3bb984b1bdae0a_authors", "5d10c4c683272fb8559ce544dc3bb984b1bdae0a"."name" AS "5d10c4c683272fb8559ce544dc3bb984b1bdae0a_name", "5d10c4c683272fb8559ce544dc3bb984b1bdae0a"."description" AS "5d10c4c683272fb8559ce544dc3bb984b1bdae0a_description", "5d10c4c683272fb8559ce544dc3bb984b1bdae0a"."autosaved" AS "5d10c4c683272fb8559ce544dc3bb984b1bdae0a_autosaved", "83e89939c59ff92341a99b35ba81c6469f97a15e"."createdAt" AS "83e89939c59ff92341a99b35ba81c6469f97a15e_createdAt", "83e89939c59ff92341a99b35ba81c6469f97a15e"."id" AS "83e89939c59ff92341a99b35ba81c6469f97a15e_id", "83e89939c59ff92341a99b35ba81c6469f97a15e"."workflowId" AS "83e89939c59ff92341a99b35ba81c6469f97a15e_workflowId", "83e89939c59ff92341a99b35ba81c6469f97a15e"."versionId" AS "83e89939c59ff92341a99b35ba81c6469f97a15e_versionId", "83e89939c59ff92341a99b35ba81c6469f97a15e"."event" AS "83e89939c59ff92341a99b35ba81c6469f97a15e_event", "83e89939c59ff92341a99b35ba81c6469f97a15e"."userId" AS "83e89939c59ff92341a99b35ba81c6469f97a15e_userId" FROM "public"."shared_workflow" "SharedWorkflow" LEFT JOIN "public"."workflow_entity" "SharedWorkflow__SharedWorkflow_workflow" ON "SharedWorkflow__SharedWorkflow_workflow"."id"="SharedWorkflow"."workflowId" LEFT JOIN "public"."shared_workflow" "1a765f2a4ba6f3a5767ba217be5f8ff59e61a83d" ON "1a765f2a4ba6f3a5767ba217be5f8ff59e61a83d"."workflowId"="SharedWorkflow__SharedWorkflow_workflow"."id" LEFT JOIN "public"."project" "1b870ba2cbdf81fe474cddbb86cf37ee3b6345c9" ON "1b870ba2cbdf81fe474cddbb86cf37ee3b6345c9"."id"="1a765f2a4ba6f3a5767ba217be5f8ff59e61a83d"."projectId" LEFT JOIN "public"."project_relation" "4dc6db3add1f4f8704eb03bb2704fb68228f5db2" ON "4dc6db3add1f4f8704eb03bb2704fb68228f5db2"."projectId"="1b870ba2cbdf81fe474cddbb86cf37ee3b6345c9"."id" LEFT JOIN "public"."user" "18f5279f1dc113df741ab97abe65174b499d0e40" ON "18f5279f1dc113df741ab97abe65174b499d0e40"."id"="4dc6db3add1f4f8704eb03bb2704fb68228f5db2"."userId" LEFT JOIN "public"."workflows_tags" "589d6467e801fa2df8a75a0cc8fba4dbc7fed576" ON "589d6467e801fa2df8a75a0cc8fba4dbc7fed576"."workflowId"="SharedWorkflow__SharedWorkflow_workflow"."id" LEFT JOIN "public"."tag_entity" "2a3c8fb003125249c561d0c4cab6725e2be40123" ON "2a3c8fb003125249c561d0c4cab6725e2be40123".
|
|
0 min
< 0.1%
|
1 ms
|
80
systemic
|
SELECT pid, state, application_name AS source, age(NOW(), COALESCE(query_start, xact_start)) AS duration, (wait_event IS NOT NULL) AS waiting, query, COALESCE(query_start, xact_start) AS started_at, EXTRACT($1 FROM NOW() - COALESCE(query_start, xact_start)) * $2 AS duration_ms, usename AS user, backend_type FROM pg_stat_activity WHERE state <> $3 AND pid <> pg_backend_pid() AND datname = current_database() AND NOW() - COALESCE(query_start, xact_start) > interval $4 AND query <> $5 ORDER BY COALESCE(query_start, xact_start) DESC /*pghero*/
|
|
0 min
< 0.1%
|
1 ms
|
94
systemic
|
SELECT COUNT(DISTINCT("WorkflowStatistics"."name", "WorkflowStatistics"."workflowId")) AS "cnt" FROM "public"."workflow_statistics" "WorkflowStatistics" LEFT JOIN "public"."workflow_entity" "WorkflowStatistics__WorkflowStatistics_workflow" ON "WorkflowStatistics__WorkflowStatistics_workflow"."id"="WorkflowStatistics"."workflowId" LEFT JOIN "public"."shared_workflow" "904429856b72afea919af10d60c33164166edf5b" ON "904429856b72afea919af10d60c33164166edf5b"."workflowId"="WorkflowStatistics__WorkflowStatistics_workflow"."id" LEFT JOIN "public"."project" "cdcbdaee0c56450fa88673f0a2be8eab814aa950" ON "cdcbdaee0c56450fa88673f0a2be8eab814aa950"."id"="904429856b72afea919af10d60c33164166edf5b"."projectId" LEFT JOIN "public"."project_relation" "27d637213b4ab1fb0512689d3d625e14f2d0b0b1" ON "27d637213b4ab1fb0512689d3d625e14f2d0b0b1"."projectId"="cdcbdaee0c56450fa88673f0a2be8eab814aa950"."id" LEFT JOIN "public"."role" "9d4eaf11cfee2dc1ad704498097565593aed28bb" ON "9d4eaf11cfee2dc1ad704498097565593aed28bb"."slug"="27d637213b4ab1fb0512689d3d625e14f2d0b0b1"."role" WHERE (((((("904429856b72afea919af10d60c33164166edf5b"."role" = $1) AND ((((("27d637213b4ab1fb0512689d3d625e14f2d0b0b1"."userId" = $2) AND ((("9d4eaf11cfee2dc1ad704498097565593aed28bb"."slug" = $3))))))))) AND (NOT("WorkflowStatistics__WorkflowStatistics_workflow"."activeVersionId" IS NULL)))) AND ("WorkflowStatistics"."name" = $4) AND ("WorkflowStatistics"."count" >= $5))
|
|
0 min
< 0.1%
|
1 ms
|
140
systemic
|
SELECT t.oid, t.typname, t.typelem, t.typdelim, t.typinput, r.rngsubtype, t.typtype, t.typbasetype
FROM pg_type as t
LEFT JOIN pg_range as r ON oid = rngtypid
WHERE
t.typtype IN ($1, $2, $3)
|
|
0 min
< 0.1%
|
3 ms
|
24
systemic
|
SELECT "WorkflowEntity"."updatedAt" AS "WorkflowEntity_updatedAt", "WorkflowEntity"."createdAt" AS "WorkflowEntity_createdAt", "WorkflowEntity"."id" AS "WorkflowEntity_id", "WorkflowEntity"."name" AS "WorkflowEntity_name", "WorkflowEntity"."description" AS "WorkflowEntity_description", "WorkflowEntity"."active" AS "WorkflowEntity_active", "WorkflowEntity"."isArchived" AS "WorkflowEntity_isArchived", "WorkflowEntity"."nodes" AS "WorkflowEntity_nodes", "WorkflowEntity"."connections" AS "WorkflowEntity_connections", "WorkflowEntity"."settings" AS "WorkflowEntity_settings", "WorkflowEntity"."staticData" AS "WorkflowEntity_staticData", "WorkflowEntity"."meta" AS "WorkflowEntity_meta", "WorkflowEntity"."pinData" AS "WorkflowEntity_pinData", "WorkflowEntity"."versionId" AS "WorkflowEntity_versionId", "WorkflowEntity"."activeVersionId" AS "WorkflowEntity_activeVersionId", "WorkflowEntity"."versionCounter" AS "WorkflowEntity_versionCounter", "WorkflowEntity"."triggerCount" AS "WorkflowEntity_triggerCount", "WorkflowEntity"."parentFolderId" AS "WorkflowEntity_parentFolderId", "WorkflowEntity__WorkflowEntity_shared"."updatedAt" AS "WorkflowEntity__WorkflowEntity_shared_updatedAt", "WorkflowEntity__WorkflowEntity_shared"."createdAt" AS "WorkflowEntity__WorkflowEntity_shared_createdAt", "WorkflowEntity__WorkflowEntity_shared"."role" AS "WorkflowEntity__WorkflowEntity_shared_role", "WorkflowEntity__WorkflowEntity_shared"."workflowId" AS "WorkflowEntity__WorkflowEntity_shared_workflowId", "WorkflowEntity__WorkflowEntity_shared"."projectId" AS "WorkflowEntity__WorkflowEntity_shared_projectId", "6da0e527aac0b6fa1d01a2b055fa2c411cde87d3"."updatedAt" AS "6da0e527aac0b6fa1d01a2b055fa2c411cde87d3_updatedAt", "6da0e527aac0b6fa1d01a2b055fa2c411cde87d3"."createdAt" AS "6da0e527aac0b6fa1d01a2b055fa2c411cde87d3_createdAt", "6da0e527aac0b6fa1d01a2b055fa2c411cde87d3"."id" AS "6da0e527aac0b6fa1d01a2b055fa2c411cde87d3_id", "6da0e527aac0b6fa1d01a2b055fa2c411cde87d3"."name" AS "6da0e527aac0b6fa1d01a2b055fa2c411cde87d3_name", "6da0e527aac0b6fa1d01a2b055fa2c411cde87d3"."type" AS "6da0e527aac0b6fa1d01a2b055fa2c411cde87d3_type", "6da0e527aac0b6fa1d01a2b055fa2c411cde87d3"."icon" AS "6da0e527aac0b6fa1d01a2b055fa2c411cde87d3_icon", "6da0e527aac0b6fa1d01a2b055fa2c411cde87d3"."description" AS "6da0e527aac0b6fa1d01a2b055fa2c411cde87d3_description", "6da0e527aac0b6fa1d01a2b055fa2c411cde87d3"."creatorId" AS "6da0e527aac0b6fa1d01a2b055fa2c411cde87d3_creatorId", "d6f609b4290db51264ee33f3c1aef17bd40a52f7"."updatedAt" AS "d6f609b4290db51264ee33f3c1aef17bd40a52f7_updatedAt", "d6f609b4290db51264ee33f3c1aef17bd40a52f7"."createdAt" AS "d6f609b4290db51264ee33f3c1aef17bd40a52f7_createdAt", "d6f609b4290db51264ee33f3c1aef17bd40a52f7"."userId" AS "d6f609b4290db51264ee33f3c1aef17bd40a52f7_userId", "d6f609b4290db51264ee33f3c1aef17bd40a52f7"."projectId" AS "d6f609b4290db51264ee33f3c1aef17bd40a52f7_projectId", "d6f609b4290db51264ee33f3c1aef17bd40a52f7"."role" AS "d6f609b4290db51264ee33f3c1aef17bd40a52f7_role", "WorkflowEntity__WorkflowEntity_activeVersion"."updatedAt" AS "WorkflowEntity__WorkflowEntity_activeVersion_updatedAt", "WorkflowEntity__WorkflowEntity_activeVersion"."createdAt" AS "WorkflowEntity__WorkflowEntity_activeVersion_createdAt", "WorkflowEntity__WorkflowEntity_activeVersion"."versionId" AS "WorkflowEntity__WorkflowEntity_activeVersion_versionId", "WorkflowEntity__WorkflowEntity_activeVersion"."workflowId" AS "WorkflowEntity__WorkflowEntity_activeVersion_workflowId", "WorkflowEntity__WorkflowEntity_activeVersion"."nodes" AS "WorkflowEntity__WorkflowEntity_activeVersion_nodes", "WorkflowEntity__WorkflowEntity_activeVersion"."connections" AS "WorkflowEntity__WorkflowEntity_activeVersion_connections", "WorkflowEntity__WorkflowEntity_activeVersion"."authors" AS "WorkflowEntity__WorkflowEntity_activeVersion_authors", "WorkflowEntity__WorkflowEntity_activeVersion"."name" AS "WorkflowEntity__WorkflowEntity_activeVersion_name", "WorkflowEntity__WorkflowEntity_activeVersion"."description" AS "WorkflowEntity__WorkflowEntity_activeVersion_description", "WorkflowEntity__WorkflowEntity_activeVersion"."autosaved" AS "WorkflowEntity__WorkflowEntity_activeVersion_autosaved" FROM "public"."workflow_entity" "WorkflowEntity" LEFT JOIN "public"."shared_workflow" "WorkflowEntity__WorkflowEntity_shared" ON "WorkflowEntity__WorkflowEntity_shared"."workflowId"="WorkflowEntity"."id" LEFT JOIN "public"."project" "6da0e527aac0b6fa1d01a2b055fa2c411cde87d3" ON "6da0e527aac0b6fa1d01a2b055fa2c411cde87d3"."id"="WorkflowEntity__WorkflowEntity_shared"."projectId" LEFT JOIN "public"."project_relation" "d6f609b4290db51264ee33f3c1aef17bd40a52f7" ON "d6f609b4290db51264ee33f3c1aef17bd40a52f7"."projectId"="6da0e527aac0b6fa1d01a2b055fa2c411cde87d3"."id" LEFT JOIN "public"."workflow_history" "WorkflowEntity__WorkflowEntity_activeVersion" ON "WorkflowEntity__WorkflowEntity_activeVersion"."versionId"="WorkflowEntity"."activeVersionId" WHERE ( (("WorkflowEntity"."id" = $1)) ) AND ( "WorkflowEntity"."id" IN ($2) )
|
|
0 min
< 0.1%
|
6 ms
|
11
systemic
|
SELECT * FROM pg_stat_statements LIMIT $1 /*pghero*/
|
|
0 min
< 0.1%
|
3 ms
|
24
systemic
|
UPDATE "public"."workflow_entity" SET "triggerCount" = $1, "updatedAt" = "updatedAt" WHERE "id" = $2
|
|
0 min
< 0.1%
|
7 ms
|
8
systemic
|
SELECT "ProjectRelation"."updatedAt" AS "ProjectRelation_updatedAt", "ProjectRelation"."createdAt" AS "ProjectRelation_createdAt", "ProjectRelation"."userId" AS "ProjectRelation_userId", "ProjectRelation"."projectId" AS "ProjectRelation_projectId", "ProjectRelation"."role" AS "ProjectRelation_role", "ProjectRelation__ProjectRelation_user"."updatedAt" AS "ProjectRelation__ProjectRelation_user_updatedAt", "ProjectRelation__ProjectRelation_user"."createdAt" AS "ProjectRelation__ProjectRelation_user_createdAt", "ProjectRelation__ProjectRelation_user"."id" AS "ProjectRelation__ProjectRelation_user_id", "ProjectRelation__ProjectRelation_user"."email" AS "ProjectRelation__ProjectRelation_user_email", "ProjectRelation__ProjectRelation_user"."firstName" AS "ProjectRelation__ProjectRelation_user_firstName", "ProjectRelation__ProjectRelation_user"."lastName" AS "ProjectRelation__ProjectRelation_user_lastName", "ProjectRelation__ProjectRelation_user"."password" AS "ProjectRelation__ProjectRelation_user_password", "ProjectRelation__ProjectRelation_user"."personalizationAnswers" AS "ProjectRelation__ProjectRelation_user_personalizationAnswers", "ProjectRelation__ProjectRelation_user"."settings" AS "ProjectRelation__ProjectRelation_user_settings", "ProjectRelation__ProjectRelation_user"."disabled" AS "ProjectRelation__ProjectRelation_user_disabled", "ProjectRelation__ProjectRelation_user"."mfaEnabled" AS "ProjectRelation__ProjectRelation_user_mfaEnabled", "ProjectRelation__ProjectRelation_user"."mfaSecret" AS "ProjectRelation__ProjectRelation_user_mfaSecret", "ProjectRelation__ProjectRelation_user"."mfaRecoveryCodes" AS "ProjectRelation__ProjectRelation_user_mfaRecoveryCodes", "ProjectRelation__ProjectRelation_user"."lastActiveAt" AS "ProjectRelation__ProjectRelation_user_lastActiveAt", "ProjectRelation__ProjectRelation_user"."roleSlug" AS "ProjectRelation__ProjectRelation_user_roleSlug", "e21c4d38299ff8fa55bc8668005906fdc5f5c3bb"."updatedAt" AS "e21c4d38299ff8fa55bc8668005906fdc5f5c3bb_updatedAt", "e21c4d38299ff8fa55bc8668005906fdc5f5c3bb"."createdAt" AS "e21c4d38299ff8fa55bc8668005906fdc5f5c3bb_createdAt", "e21c4d38299ff8fa55bc8668005906fdc5f5c3bb"."slug" AS "e21c4d38299ff8fa55bc8668005906fdc5f5c3bb_slug", "e21c4d38299ff8fa55bc8668005906fdc5f5c3bb"."displayName" AS "e21c4d38299ff8fa55bc8668005906fdc5f5c3bb_displayName", "e21c4d38299ff8fa55bc8668005906fdc5f5c3bb"."description" AS "e21c4d38299ff8fa55bc8668005906fdc5f5c3bb_description", "e21c4d38299ff8fa55bc8668005906fdc5f5c3bb"."systemRole" AS "e21c4d38299ff8fa55bc8668005906fdc5f5c3bb_systemRole", "e21c4d38299ff8fa55bc8668005906fdc5f5c3bb"."roleType" AS "e21c4d38299ff8fa55bc8668005906fdc5f5c3bb_roleType", "c880a20e92eda55c4873cddfe8317665ad1819c4"."slug" AS "c880a20e92eda55c4873cddfe8317665ad1819c4_slug", "c880a20e92eda55c4873cddfe8317665ad1819c4"."displayName" AS "c880a20e92eda55c4873cddfe8317665ad1819c4_displayName", "c880a20e92eda55c4873cddfe8317665ad1819c4"."description" AS "c880a20e92eda55c4873cddfe8317665ad1819c4_description" FROM "public"."project_relation" "ProjectRelation" LEFT JOIN "public"."user" "ProjectRelation__ProjectRelation_user" ON "ProjectRelation__ProjectRelation_user"."id"="ProjectRelation"."userId" LEFT JOIN "public"."role" "e21c4d38299ff8fa55bc8668005906fdc5f5c3bb" ON "e21c4d38299ff8fa55bc8668005906fdc5f5c3bb"."slug"="ProjectRelation__ProjectRelation_user"."roleSlug" LEFT JOIN "public"."role_scope" "c4c001e6f81580d2e569028b42f1d14e8ee9f471" ON "c4c001e6f81580d2e569028b42f1d14e8ee9f471"."roleSlug"="e21c4d38299ff8fa55bc8668005906fdc5f5c3bb"."slug" LEFT JOIN "public"."scope" "c880a20e92eda55c4873cddfe8317665ad1819c4" ON "c880a20e92eda55c4873cddfe8317665ad1819c4"."slug"="c4c001e6f81580d2e569028b42f1d14e8ee9f471"."scopeSlug" LEFT JOIN "public"."role" "ProjectRelation__ProjectRelation_role" ON "ProjectRelation__ProjectRelation_role"."slug"="ProjectRelation"."role" WHERE (("ProjectRelation"."projectId" IN ($1)) AND ((("ProjectRelation__ProjectRelation_role"."slug" = $2))))
|
|
0 min
< 0.1%
|
1 ms
|
92
systemic
|
SELECT "ProjectRelation"."updatedAt" AS "ProjectRelation_updatedAt", "ProjectRelation"."createdAt" AS "ProjectRelation_createdAt", "ProjectRelation"."userId" AS "ProjectRelation_userId", "ProjectRelation"."projectId" AS "ProjectRelation_projectId", "ProjectRelation"."role" AS "ProjectRelation_role", "ProjectRelation__ProjectRelation_project"."updatedAt" AS "ProjectRelation__ProjectRelation_project_updatedAt", "ProjectRelation__ProjectRelation_project"."createdAt" AS "ProjectRelation__ProjectRelation_project_createdAt", "ProjectRelation__ProjectRelation_project"."id" AS "ProjectRelation__ProjectRelation_project_id", "ProjectRelation__ProjectRelation_project"."name" AS "ProjectRelation__ProjectRelation_project_name", "ProjectRelation__ProjectRelation_project"."type" AS "ProjectRelation__ProjectRelation_project_type", "ProjectRelation__ProjectRelation_project"."icon" AS "ProjectRelation__ProjectRelation_project_icon", "ProjectRelation__ProjectRelation_project"."description" AS "ProjectRelation__ProjectRelation_project_description", "ProjectRelation__ProjectRelation_project"."creatorId" AS "ProjectRelation__ProjectRelation_project_creatorId", "ProjectRelation__ProjectRelation_role"."updatedAt" AS "ProjectRelation__ProjectRelation_role_updatedAt", "ProjectRelation__ProjectRelation_role"."createdAt" AS "ProjectRelation__ProjectRelation_role_createdAt", "ProjectRelation__ProjectRelation_role"."slug" AS "ProjectRelation__ProjectRelation_role_slug", "ProjectRelation__ProjectRelation_role"."displayName" AS "ProjectRelation__ProjectRelation_role_displayName", "ProjectRelation__ProjectRelation_role"."description" AS "ProjectRelation__ProjectRelation_role_description", "ProjectRelation__ProjectRelation_role"."systemRole" AS "ProjectRelation__ProjectRelation_role_systemRole", "ProjectRelation__ProjectRelation_role"."roleType" AS "ProjectRelation__ProjectRelation_role_roleType", "bebc85c85b90954c31fd92de07d8c8c8ed741d56"."slug" AS "bebc85c85b90954c31fd92de07d8c8c8ed741d56_slug", "bebc85c85b90954c31fd92de07d8c8c8ed741d56"."displayName" AS "bebc85c85b90954c31fd92de07d8c8c8ed741d56_displayName", "bebc85c85b90954c31fd92de07d8c8c8ed741d56"."description" AS "bebc85c85b90954c31fd92de07d8c8c8ed741d56_description" FROM "public"."project_relation" "ProjectRelation" LEFT JOIN "public"."project" "ProjectRelation__ProjectRelation_project" ON "ProjectRelation__ProjectRelation_project"."id"="ProjectRelation"."projectId" LEFT JOIN "public"."role" "ProjectRelation__ProjectRelation_role" ON "ProjectRelation__ProjectRelation_role"."slug"="ProjectRelation"."role" LEFT JOIN "public"."role_scope" "2cd2861b89635964d24aa8f311d71abf1c431ebf" ON "2cd2861b89635964d24aa8f311d71abf1c431ebf"."roleSlug"="ProjectRelation__ProjectRelation_role"."slug" LEFT JOIN "public"."scope" "bebc85c85b90954c31fd92de07d8c8c8ed741d56" ON "bebc85c85b90954c31fd92de07d8c8c8ed741d56"."slug"="2cd2861b89635964d24aa8f311d71abf1c431ebf"."scopeSlug" WHERE (("ProjectRelation"."userId" = $1))
|
|
0 min
< 0.1%
|
0 ms
|
557
systemic
|
SELECT DISTINCT "distinctAlias"."User_id" AS "ids_User_id" FROM (SELECT "User"."updatedAt" AS "User_updatedAt", "User"."createdAt" AS "User_createdAt", "User"."id" AS "User_id", "User"."email" AS "User_email", "User"."firstName" AS "User_firstName", "User"."lastName" AS "User_lastName", "User"."password" AS "User_password", "User"."personalizationAnswers" AS "User_personalizationAnswers", "User"."settings" AS "User_settings", "User"."disabled" AS "User_disabled", "User"."mfaEnabled" AS "User_mfaEnabled", "User"."mfaSecret" AS "User_mfaSecret", "User"."mfaRecoveryCodes" AS "User_mfaRecoveryCodes", "User"."lastActiveAt" AS "User_lastActiveAt", "User"."roleSlug" AS "User_roleSlug", "User__User_role"."updatedAt" AS "User__User_role_updatedAt", "User__User_role"."createdAt" AS "User__User_role_createdAt", "User__User_role"."slug" AS "User__User_role_slug", "User__User_role"."displayName" AS "User__User_role_displayName", "User__User_role"."description" AS "User__User_role_description", "User__User_role"."systemRole" AS "User__User_role_systemRole", "User__User_role"."roleType" AS "User__User_role_roleType", "User__User_role__User__User_role_scopes"."slug" AS "User__User_role__User__User_role_scopes_slug", "User__User_role__User__User_role_scopes"."displayName" AS "User__User_role__User__User_role_scopes_displayName", "User__User_role__User__User_role_scopes"."description" AS "User__User_role__User__User_role_scopes_description" FROM "public"."user" "User" LEFT JOIN "public"."role" "User__User_role" ON "User__User_role"."slug"="User"."roleSlug" LEFT JOIN "public"."role_scope" "User__User_role_User__User_role__User__User_role_scopes" ON "User__User_role_User__User_role__User__User_role_scopes"."roleSlug"="User__User_role"."slug" LEFT JOIN "public"."scope" "User__User_role__User__User_role_scopes" ON "User__User_role__User__User_role_scopes"."slug"="User__User_role_User__User_role__User__User_role_scopes"."scopeSlug" WHERE (("User"."id" = $1))) "distinctAlias" ORDER BY "User_id" ASC LIMIT $2
|
|
0 min
< 0.1%
|
55 ms
|
1
systemic
|
INSERT INTO "public"."insights_raw"("metaId", "type", "value", "timestamp") VALUES ($1, $2, $3, $4), ($5, $6, $7, $8), ($9, $10, $11, $12), ($13, $14, $15, $16), ($17, $18, $19, $20), ($21, $22, $23, $24), ($25, $26, $27, $28), ($29, $30, $31, $32), ($33, $34, $35, $36), ($37, $38, $39, $40), ($41, $42, $43, $44), ($45, $46, $47, $48), ($49, $50, $51, $52), ($53, $54, $55, $56), ($57, $58, $59, $60), ($61, $62, $63, $64), ($65, $66, $67, $68), ($69, $70, $71, $72), ($73, $74, $75, $76), ($77, $78, $79, $80), ($81, $82, $83, $84), ($85, $86, $87, $88), ($89, $90, $91, $92), ($93, $94, $95, $96), ($97, $98, $99, $100), ($101, $102, $103, $104), ($105, $106, $107, $108), ($109, $110, $111, $112), ($113, $114, $115, $116), ($117, $118, $119, $120), ($121, $122, $123, $124), ($125, $126, $127, $128), ($129, $130, $131, $132), ($133, $134, $135, $136), ($137, $138, $139, $140), ($141, $142, $143, $144), ($145, $146, $147, $148), ($149, $150, $151, $152), ($153, $154, $155, $156), ($157, $158, $159, $160), ($161, $162, $163, $164), ($165, $166, $167, $168), ($169, $170, $171, $172), ($173, $174, $175, $176), ($177, $178, $179, $180), ($181, $182, $183, $184), ($185, $186, $187, $188), ($189, $190, $191, $192), ($193, $194, $195, $196), ($197, $198, $199, $200), ($201, $202, $203, $204), ($205, $206, $207, $208), ($209, $210, $211, $212), ($213, $214, $215, $216), ($217, $218, $219, $220), ($221, $222, $223, $224), ($225, $226, $227, $228), ($229, $230, $231, $232), ($233, $234, $235, $236), ($237, $238, $239, $240), ($241, $242, $243, $244), ($245, $246, $247, $248), ($249, $250, $251, $252), ($253, $254, $255, $256), ($257, $258, $259, $260), ($261, $262, $263, $264), ($265, $266, $267, $268), ($269, $270, $271, $272), ($273, $274, $275, $276), ($277, $278, $279, $280), ($281, $282, $283, $284), ($285, $286, $287, $288), ($289, $290, $291, $292), ($293, $294, $295, $296), ($297, $298, $299, $300), ($301, $302, $303, $304), ($305, $306, $307, $308), ($309, $310, $311, $312), ($313, $314, $315, $316), ($317, $318, $319, $320), ($321, $322, $323, $324), ($325, $326, $327, $328), ($329, $330, $331, $332), ($333, $334, $335, $336), ($337, $338, $339, $340), ($341, $342, $343, $344), ($345, $346, $347, $348), ($349, $350, $351, $352), ($353, $354, $355, $356), ($357, $358, $359, $360) RETURNING "id"
|
|
0 min
< 0.1%
|
3 ms
|
17
systemic
|
SELECT "User"."updatedAt" AS "User_updatedAt", "User"."createdAt" AS "User_createdAt", "User"."id" AS "User_id", "User"."email" AS "User_email", "User"."firstName" AS "User_firstName", "User"."lastName" AS "User_lastName", "User"."password" AS "User_password", "User"."personalizationAnswers" AS "User_personalizationAnswers", "User"."settings" AS "User_settings", "User"."disabled" AS "User_disabled", "User"."mfaEnabled" AS "User_mfaEnabled", "User"."mfaSecret" AS "User_mfaSecret", "User"."mfaRecoveryCodes" AS "User_mfaRecoveryCodes", "User"."lastActiveAt" AS "User_lastActiveAt", "User"."roleSlug" AS "User_roleSlug", "User__User_role"."updatedAt" AS "User__User_role_updatedAt", "User__User_role"."createdAt" AS "User__User_role_createdAt", "User__User_role"."slug" AS "User__User_role_slug", "User__User_role"."displayName" AS "User__User_role_displayName", "User__User_role"."description" AS "User__User_role_description", "User__User_role"."systemRole" AS "User__User_role_systemRole", "User__User_role"."roleType" AS "User__User_role_roleType", "User__User_role__User__User_role_scopes"."slug" AS "User__User_role__User__User_role_scopes_slug", "User__User_role__User__User_role_scopes"."displayName" AS "User__User_role__User__User_role_scopes_displayName", "User__User_role__User__User_role_scopes"."description" AS "User__User_role__User__User_role_scopes_description" FROM "public"."user" "User" LEFT JOIN "public"."role" "User__User_role" ON "User__User_role"."slug"="User"."roleSlug" LEFT JOIN "public"."role_scope" "User__User_role_User__User_role__User__User_role_scopes" ON "User__User_role_User__User_role__User__User_role_scopes"."roleSlug"="User__User_role"."slug" LEFT JOIN "public"."scope" "User__User_role__User__User_role_scopes" ON "User__User_role__User__User_role_scopes"."slug"="User__User_role_User__User_role__User__User_role_scopes"."scopeSlug" LEFT JOIN "public"."project_relation" "User__User_projectRelations" ON "User__User_projectRelations"."userId"="User"."id" LEFT JOIN "public"."role" "User__User_projectRelations__User__User_projectRelations_role" ON "User__User_projectRelations__User__User_projectRelations_role"."slug"="User__User_projectRelations"."role" LEFT JOIN "public"."project" "8fbb1aa6768ac8e553b5c5691bb57d8216459587" ON "8fbb1aa6768ac8e553b5c5691bb57d8216459587"."id"="User__User_projectRelations"."projectId" LEFT JOIN "public"."shared_workflow" "fa2521dd67b22b87644d542c636fe2a1df064983" ON "fa2521dd67b22b87644d542c636fe2a1df064983"."projectId"="8fbb1aa6768ac8e553b5c5691bb57d8216459587"."id" WHERE ( (((((("User__User_projectRelations__User__User_projectRelations_role"."slug" IN ($1, $2)))) AND ((("8fbb1aa6768ac8e553b5c5691bb57d8216459587"."type" = $3) AND (NOT("8fbb1aa6768ac8e553b5c5691bb57d8216459587"."creatorId" IS NULL)) AND ((("fa2521dd67b22b87644d542c636fe2a1df064983"."workflowId" = $4) AND ("fa2521dd67b22b87644d542c636fe2a1df064983"."role" = $5)))))))) ) AND ( "User"."id" IN ($6) )
|
|
0 min
< 0.1%
|
0 ms
|
3,310
systemic
|
UPDATE ONLY "public"."test_case_execution" SET "executionId" = $2 WHERE $1 OPERATOR(pg_catalog.=) "executionId"
|
|
0 min
< 0.1%
|
1 ms
|
80
systemic
|
SELECT n.nspname AS schema, c.relname AS sequence, has_sequence_privilege(c.oid, $1) AS readable FROM pg_class c INNER JOIN pg_catalog.pg_namespace n ON n.oid = c.relnamespace WHERE c.relkind = $2 AND n.nspname NOT IN ($3, $4) /*pghero*/
|
|
0 min
< 0.1%
|
1 ms
|
80
systemic
|
SELECT state, COUNT(*) AS connections FROM pg_stat_activity GROUP BY 1 ORDER BY 2 DESC, 1 /*pghero*/
|
|
0 min
< 0.1%
|
8 ms
|
5
systemic
|
SELECT nspname AS schema, relname AS table, reltuples::bigint AS estimated_rows, pg_total_relation_size(pg_class.oid) AS size_bytes FROM pg_class INNER JOIN pg_namespace ON pg_namespace.oid = pg_class.relnamespace WHERE relkind = $1 AND nspname = $2 AND relname IN ($3, $4, $5, $6, $7, $8, $9, $10, $11, $12, $13, $14, $15, $16, $17, $18, $19, $20, $21, $22) ORDER BY 1, 2 /*pghero*/
|
|
0 min
< 0.1%
|
0 ms
|
6,757
systemic
|
COMMIT
|
|
0 min
< 0.1%
|
0 ms
|
662
systemic
|
SELECT db_schema, timezone
FROM public.client_registry
WHERE twilio_number = p_shop_phone
|
|
0 min
< 0.1%
|
37 ms
|
1
systemic
|
INSERT INTO "public"."insights_raw"("metaId", "type", "value", "timestamp") VALUES ($1, $2, $3, $4), ($5, $6, $7, $8), ($9, $10, $11, $12), ($13, $14, $15, $16), ($17, $18, $19, $20), ($21, $22, $23, $24), ($25, $26, $27, $28), ($29, $30, $31, $32), ($33, $34, $35, $36), ($37, $38, $39, $40), ($41, $42, $43, $44), ($45, $46, $47, $48), ($49, $50, $51, $52), ($53, $54, $55, $56), ($57, $58, $59, $60), ($61, $62, $63, $64), ($65, $66, $67, $68), ($69, $70, $71, $72), ($73, $74, $75, $76), ($77, $78, $79, $80), ($81, $82, $83, $84), ($85, $86, $87, $88), ($89, $90, $91, $92), ($93, $94, $95, $96), ($97, $98, $99, $100), ($101, $102, $103, $104), ($105, $106, $107, $108), ($109, $110, $111, $112), ($113, $114, $115, $116), ($117, $118, $119, $120), ($121, $122, $123, $124), ($125, $126, $127, $128), ($129, $130, $131, $132), ($133, $134, $135, $136), ($137, $138, $139, $140), ($141, $142, $143, $144), ($145, $146, $147, $148), ($149, $150, $151, $152), ($153, $154, $155, $156) RETURNING "id"
|
|
0 min
< 0.1%
|
8 ms
|
4
systemic
|
SELECT pg_database_size(current_database()) /*pghero*/
|
|
0 min
< 0.1%
|
1 ms
|
45
systemic
|
CREATE EXTENSION IF NOT EXISTS "uuid-ossp"
|
|
0 min
< 0.1%
|
0 ms
|
125
systemic
|
SELECT DISTINCT "distinctAlias"."SharedWorkflow_workflowId" AS "ids_SharedWorkflow_workflowId", "distinctAlias"."SharedWorkflow_projectId" AS "ids_SharedWorkflow_projectId" FROM (SELECT "SharedWorkflow"."updatedAt" AS "SharedWorkflow_updatedAt", "SharedWorkflow"."createdAt" AS "SharedWorkflow_createdAt", "SharedWorkflow"."role" AS "SharedWorkflow_role", "SharedWorkflow"."workflowId" AS "SharedWorkflow_workflowId", "SharedWorkflow"."projectId" AS "SharedWorkflow_projectId", "SharedWorkflow__SharedWorkflow_workflow"."updatedAt" AS "SharedWorkflow__SharedWorkflow_workflow_updatedAt", "SharedWorkflow__SharedWorkflow_workflow"."createdAt" AS "SharedWorkflow__SharedWorkflow_workflow_createdAt", "SharedWorkflow__SharedWorkflow_workflow"."id" AS "SharedWorkflow__SharedWorkflow_workflow_id", "SharedWorkflow__SharedWorkflow_workflow"."name" AS "SharedWorkflow__SharedWorkflow_workflow_name", "SharedWorkflow__SharedWorkflow_workflow"."description" AS "SharedWorkflow__SharedWorkflow_workflow_description", "SharedWorkflow__SharedWorkflow_workflow"."active" AS "SharedWorkflow__SharedWorkflow_workflow_active", "SharedWorkflow__SharedWorkflow_workflow"."isArchived" AS "SharedWorkflow__SharedWorkflow_workflow_isArchived", "SharedWorkflow__SharedWorkflow_workflow"."nodes" AS "SharedWorkflow__SharedWorkflow_workflow_nodes", "SharedWorkflow__SharedWorkflow_workflow"."connections" AS "SharedWorkflow__SharedWorkflow_workflow_connections", "SharedWorkflow__SharedWorkflow_workflow"."settings" AS "SharedWorkflow__SharedWorkflow_workflow_settings", "SharedWorkflow__SharedWorkflow_workflow"."staticData" AS "SharedWorkflow__SharedWorkflow_workflow_staticData", "SharedWorkflow__SharedWorkflow_workflow"."meta" AS "SharedWorkflow__SharedWorkflow_workflow_meta", "SharedWorkflow__SharedWorkflow_workflow"."pinData" AS "SharedWorkflow__SharedWorkflow_workflow_pinData", "SharedWorkflow__SharedWorkflow_workflow"."versionId" AS "SharedWorkflow__SharedWorkflow_workflow_versionId", "SharedWorkflow__SharedWorkflow_workflow"."activeVersionId" AS "SharedWorkflow__SharedWorkflow_workflow_activeVersionId", "SharedWorkflow__SharedWorkflow_workflow"."versionCounter" AS "SharedWorkflow__SharedWorkflow_workflow_versionCounter", "SharedWorkflow__SharedWorkflow_workflow"."triggerCount" AS "SharedWorkflow__SharedWorkflow_workflow_triggerCount", "SharedWorkflow__SharedWorkflow_workflow"."parentFolderId" AS "SharedWorkflow__SharedWorkflow_workflow_parentFolderId", "1a765f2a4ba6f3a5767ba217be5f8ff59e61a83d"."updatedAt" AS "1a765f2a4ba6f3a5767ba217be5f8ff59e61a83d_updatedAt", "1a765f2a4ba6f3a5767ba217be5f8ff59e61a83d"."createdAt" AS "1a765f2a4ba6f3a5767ba217be5f8ff59e61a83d_createdAt", "1a765f2a4ba6f3a5767ba217be5f8ff59e61a83d"."role" AS "1a765f2a4ba6f3a5767ba217be5f8ff59e61a83d_role", "1a765f2a4ba6f3a5767ba217be5f8ff59e61a83d"."workflowId" AS "1a765f2a4ba6f3a5767ba217be5f8ff59e61a83d_workflowId", "1a765f2a4ba6f3a5767ba217be5f8ff59e61a83d"."projectId" AS "1a765f2a4ba6f3a5767ba217be5f8ff59e61a83d_projectId", "1b870ba2cbdf81fe474cddbb86cf37ee3b6345c9"."updatedAt" AS "1b870ba2cbdf81fe474cddbb86cf37ee3b6345c9_updatedAt", "1b870ba2cbdf81fe474cddbb86cf37ee3b6345c9"."createdAt" AS "1b870ba2cbdf81fe474cddbb86cf37ee3b6345c9_createdAt", "1b870ba2cbdf81fe474cddbb86cf37ee3b6345c9"."id" AS "1b870ba2cbdf81fe474cddbb86cf37ee3b6345c9_id", "1b870ba2cbdf81fe474cddbb86cf37ee3b6345c9"."name" AS "1b870ba2cbdf81fe474cddbb86cf37ee3b6345c9_name", "1b870ba2cbdf81fe474cddbb86cf37ee3b6345c9"."type" AS "1b870ba2cbdf81fe474cddbb86cf37ee3b6345c9_type", "1b870ba2cbdf81fe474cddbb86cf37ee3b6345c9"."icon" AS "1b870ba2cbdf81fe474cddbb86cf37ee3b6345c9_icon", "1b870ba2cbdf81fe474cddbb86cf37ee3b6345c9"."description" AS "1b870ba2cbdf81fe474cddbb86cf37ee3b6345c9_description", "1b870ba2cbdf81fe474cddbb86cf37ee3b6345c9"."creatorId" AS "1b870ba2cbdf81fe474cddbb86cf37ee3b6345c9_creatorId", "4dc6db3add1f4f8704eb03bb2704fb68228f5db2"."updatedAt" AS "4dc6db3add1f4f8704eb03bb2704fb68228f5db2_updatedAt", "4dc6db3add1f4f8704eb03bb2704fb68228f5db2"."createdAt" AS "4dc6db3add1f4f8704eb03bb2704fb68228f5db2_createdAt", "4dc6db3add1f4f8704eb03bb2704fb68228f5db2"."userId" AS "4dc6db3add1f4f8704eb03bb2704fb68228f5db2_userId", "4dc6db3add1f4f8704eb03bb2704fb68228f5db2"."projectId" AS "4dc6db3add1f4f8704eb03bb2704fb68228f5db2_projectId", "4dc6db3add1f4f8704eb03bb2704fb68228f5db2"."role" AS "4dc6db3add1f4f8704eb03bb2704fb68228f5db2_role", "18f5279f1dc113df741ab97abe65174b499d0e40"."updatedAt" AS "18f5279f1dc113df741ab97abe65174b499d0e40_updatedAt", "18f5279f1dc113df741ab97abe65174b499d0e40"."createdAt" AS "18f5279f1dc113df741ab97abe65174b499d0e40_createdAt", "18f5279f1dc113df741ab97abe65174b499d0e40"."id" AS "18f5279f1dc113df741ab97abe65174b499d0e40_id", "18f5279f1dc113df741ab97abe65174b499d0e40"."email" AS "18f5279f1dc113df741ab97abe65174b499d0e40_email", "18f5279f1dc113df741ab97abe65174b499d0e40"."firstName" AS "18f5279f1dc113df741ab97abe65174b499d0e40_firstName", "18f5279f1dc113df741ab97abe65174b499d0e40"."lastName" AS "18f5279f1dc113df741ab97abe65174b499d0e40_lastName", "18f5279f1dc113df741ab97abe65174b499d0e40"."password" AS "18f5279f1dc113df741ab97abe65174b499d0e40_password", "18f5279f1dc113df741ab97abe65174b499d0e40"."personalizationAnswers" AS "18f5279f1dc113df741ab97abe65174b499d0e40_personalizationAnswers", "18f5279f1dc113df741ab97abe65174b499d0e40"."settings" AS "18f5279f1dc113df741ab97abe65174b499d0e40_settings", "18f5279f1dc113df741ab97abe65174b499d0e40"."disabled" AS "18f5279f1dc113df741ab97abe65174b499d0e40_disabled", "18f5279f1dc113df741ab97abe65174b499d0e40"."mfaEnabled" AS "18f5279f1dc113df741ab97abe65174b499d0e40_mfaEnabled", "18f5279f1dc113df741ab97abe65174b499d0e40"."mfaSecret" AS "18f5279f1dc113df741ab97abe65174b499d0e40_mfaSecret", "18f5279f1dc113df741ab97abe65174b499d0e40"."mfaRecoveryCodes" AS "18f5279f1dc113df741ab97abe65174b499d0e40_mfaRecoveryCodes", "18f5279f1dc113df741ab97abe65174b499d0e40"."lastActiveAt" AS "18f5279f1dc113df741ab97abe65174b499d0e40_lastActiveAt", "18f5279f1dc113df741ab97abe65174b499d0e40"."roleSlug" AS "18f5279f1dc113df741ab97abe65174b499d0e40_roleSlug" FROM "public"."shared_workflow" "SharedWorkflow" LEFT JOIN "public"."workflow_entity" "SharedWorkflow__SharedWorkflow_workflow" ON "SharedWorkflow__SharedWorkflow_workflow"."id"="SharedWorkflow"."workflowId" LEFT JOIN "public"."shared_workflow" "1a765f2a4ba6f3a5767ba217be5f8ff59e61a83d" ON "1a765f2a4ba6f3a5767ba217be5f8ff59e61a83d"."workflowId"="SharedWorkflow__SharedWorkflow_workflow"."id" LEFT JOIN "public"."project" "1b870ba2cbdf81fe474cddbb86cf37ee3b6345c9" ON "1b870ba2cbdf81fe474cddbb86cf37ee3b6345c9"."id"="1a765f2a4ba6f3a5767ba217be5f8ff59e61a83d"."projectId" LEFT JOIN "public"."project_relation" "4dc6db3add1f4f8704eb03bb2704fb68228f5db2" ON "4dc6db3add1f4f8704eb03bb2704fb68228f5db2"."projectId"="1b870ba2cbdf81fe474cddbb86cf37ee3b6345c9"."id" LEFT JOIN "public"."user" "18f5279f1dc113df741ab97abe65174b499d0e40" ON "18f5279f1dc113df741ab97abe65174b499d0e40"."id"="4dc6db3add1f4f8704eb03bb2704fb68228f5db2"."userId" WHERE (("SharedWorkflow"."workflowId" = $1))) "distinctAlias" ORDER BY "SharedWorkflow_workflowId" ASC, "SharedWorkflow_projectId" ASC LIMIT $2
|
|
0 min
< 0.1%
|
1 ms
|
45
systemic
|
SELECT "Scope"."slug" AS "Scope_slug", "Scope"."displayName" AS "Scope_displayName", "Scope"."description" AS "Scope_description" FROM "public"."scope" "Scope"
|
|
0 min
< 0.1%
|
1 ms
|
45
systemic
|
SELECT * FROM "public"."migrations" "migrations" ORDER BY "id" DESC
|
|
0 min
< 0.1%
|
0 ms
|
6,757
systemic
|
START TRANSACTION
|
|
0 min
< 0.1%
|
7 ms
|
4
systemic
|
INSERT INTO "public"."insights_metadata"("workflowId", "projectId", "workflowName", "projectName") VALUES ($1, $2, $3, $4) ON CONFLICT ( "workflowId" ) DO UPDATE SET "workflowId" = EXCLUDED."workflowId", "projectId" = EXCLUDED."projectId", "workflowName" = EXCLUDED."workflowName", "projectName" = EXCLUDED."projectName" RETURNING "metaId"
|
|
0 min
< 0.1%
|
28 ms
|
1
systemic
|
INSERT INTO "public"."insights_raw"("metaId", "type", "value", "timestamp") VALUES ($1, $2, $3, $4), ($5, $6, $7, $8), ($9, $10, $11, $12), ($13, $14, $15, $16), ($17, $18, $19, $20), ($21, $22, $23, $24), ($25, $26, $27, $28), ($29, $30, $31, $32), ($33, $34, $35, $36), ($37, $38, $39, $40), ($41, $42, $43, $44), ($45, $46, $47, $48), ($49, $50, $51, $52), ($53, $54, $55, $56), ($57, $58, $59, $60), ($61, $62, $63, $64), ($65, $66, $67, $68), ($69, $70, $71, $72), ($73, $74, $75, $76), ($77, $78, $79, $80), ($81, $82, $83, $84), ($85, $86, $87, $88), ($89, $90, $91, $92), ($93, $94, $95, $96), ($97, $98, $99, $100), ($101, $102, $103, $104), ($105, $106, $107, $108), ($109, $110, $111, $112), ($113, $114, $115, $116), ($117, $118, $119, $120), ($121, $122, $123, $124), ($125, $126, $127, $128), ($129, $130, $131, $132), ($133, $134, $135, $136), ($137, $138, $139, $140), ($141, $142, $143, $144), ($145, $146, $147, $148), ($149, $150, $151, $152), ($153, $154, $155, $156), ($157, $158, $159, $160), ($161, $162, $163, $164), ($165, $166, $167, $168), ($169, $170, $171, $172), ($173, $174, $175, $176), ($177, $178, $179, $180), ($181, $182, $183, $184), ($185, $186, $187, $188), ($189, $190, $191, $192), ($193, $194, $195, $196), ($197, $198, $199, $200), ($201, $202, $203, $204), ($205, $206, $207, $208), ($209, $210, $211, $212), ($213, $214, $215, $216), ($217, $218, $219, $220), ($221, $222, $223, $224), ($225, $226, $227, $228), ($229, $230, $231, $232), ($233, $234, $235, $236), ($237, $238, $239, $240), ($241, $242, $243, $244), ($245, $246, $247, $248), ($249, $250, $251, $252), ($253, $254, $255, $256), ($257, $258, $259, $260), ($261, $262, $263, $264), ($265, $266, $267, $268), ($269, $270, $271, $272), ($273, $274, $275, $276), ($277, $278, $279, $280), ($281, $282, $283, $284), ($285, $286, $287, $288), ($289, $290, $291, $292), ($293, $294, $295, $296), ($297, $298, $299, $300), ($301, $302, $303, $304), ($305, $306, $307, $308), ($309, $310, $311, $312), ($313, $314, $315, $316), ($317, $318, $319, $320), ($321, $322, $323, $324), ($325, $326, $327, $328), ($329, $330, $331, $332), ($333, $334, $335, $336), ($337, $338, $339, $340), ($341, $342, $343, $344), ($345, $346, $347, $348), ($349, $350, $351, $352), ($353, $354, $355, $356), ($357, $358, $359, $360), ($361, $362, $363, $364), ($365, $366, $367, $368), ($369, $370, $371, $372), ($373, $374, $375, $376), ($377, $378, $379, $380), ($381, $382, $383, $384), ($385, $386, $387, $388), ($389, $390, $391, $392), ($393, $394, $395, $396), ($397, $398, $399, $400), ($401, $402, $403, $404), ($405, $406, $407, $408), ($409, $410, $411, $412), ($413, $414, $415, $416), ($417, $418, $419, $420), ($421, $422, $423, $424), ($425, $426, $427, $428), ($429, $430, $431, $432), ($433, $434, $435, $436), ($437, $438, $439, $440), ($441, $442, $443, $444), ($445, $446, $447, $448), ($449, $450, $451, $452), ($453, $454, $455, $456), ($457, $458, $459, $460), ($461, $462, $463, $464), ($465, $466, $467, $468), ($469, $470, $471, $472), ($473, $474, $475, $476), ($477, $478, $479, $480), ($481, $482, $483, $484), ($485, $486, $487, $488), ($489, $490, $491, $492), ($493, $494, $495, $496), ($497, $498, $499, $500), ($501, $502, $503, $504), ($505, $506, $507, $508), ($509, $510, $511, $512), ($513, $514, $515, $516), ($517, $518, $519, $520), ($521, $522, $523, $524), ($525, $526, $527, $528), ($529, $530, $531, $532), ($533, $534, $535, $536), ($537, $538, $539, $540), ($541, $542, $543, $544), ($545, $546, $547, $548), ($549, $550, $551, $552), ($553, $554, $555, $556), ($557, $558, $559, $560), ($561, $562, $563, $564), ($565, $566, $567, $568), ($569, $570, $571, $572), ($573, $574, $575, $576), ($577, $578, $579, $580), ($581, $582, $583, $584), ($585, $586, $587, $588), ($589, $590, $591, $592), ($593, $594, $595, $596), ($597, $598, $599, $600), ($601, $602, $603, $604), ($605, $606, $607, $608), ($609, $610, $611, $612), ($613, $614, $615, $616), ($617, $618, $619, $620), ($621, $622, $623, $624), ($625, $626, $627, $628), ($629, $630, $631, $632), ($633, $634, $635, $636), ($637, $638, $639, $640), ($641, $642, $643, $644), ($645, $646, $647, $648), ($649, $650, $651, $652), ($653, $654, $655, $656), ($657, $658, $659, $660), ($661, $662, $663, $664), ($665, $666, $667, $668), ($669, $670, $671, $672), ($673, $674, $675, $676), ($677, $678, $679, $680), ($681, $682, $683, $684), ($685, $686, $687, $688), ($689, $690, $691, $692), ($693, $694, $695, $696), ($697, $698, $699, $700), ($701, $702, $703, $704), ($705, $706, $707, $708), ($709, $710, $711, $712), ($713, $714, $715, $716), ($717, $718, $719, $720), ($721, $722, $723, $724), ($725, $726, $727, $728), ($729, $730, $731, $732), ($733, $734, $735, $736), ($737, $738, $739, $740), ($741, $742, $743, $744), ($745, $746, $747, $748), ($749, $750, $751, $752), ($753, $754, $755, $756), ($757, $758, $759, $760), ($761, $762, $763, $764), ($765, $766, $767, $768), ($769, $770, $771, $772), ($773, $774, $775, $776), ($777, $778, $779, $780), ($781, $782, $783, $784), ($785, $786, $787, $788), ($789, $790, $791, $792), ($793, $794, $795, $796), ($797, $798, $799, $800), ($801, $802, $803, $804), ($805, $806, $807, $808), ($809, $810, $811, $812), ($813, $814, $815, $816), ($817, $818, $819, $820), ($821, $822, $823, $824), ($825, $826, $827, $828), ($829, $830, $831, $832), ($833, $834, $835, $836), ($837, $838, $839, $840), ($841, $842, $843, $844), ($845, $846, $847, $848), ($849, $850, $851, $852), ($853, $854, $855, $856), ($857, $858, $859, $860), ($861, $862, $863, $864), ($865, $866, $867, $868), ($869, $870, $871, $872), ($873, $874, $875, $876), ($877, $878, $879, $880), ($881, $882, $883, $884), ($885, $886, $887, $888), ($889, $890, $891, $892), ($893, $894, $895, $896), ($897, $898, $899, $900), ($901, $902, $903, $904), ($905, $906, $907, $908), ($909, $910, $911, $912), ($913, $914, $915, $916), ($917, $918, $919, $920), ($921, $922, $923, $924), ($925, $926, $927, $928), ($929, $930, $931, $932), ($933, $934, $935, $936), ($937, $938, $939, $940), ($941, $942, $943, $944), ($945, $946, $947, $948), ($949, $950, $951, $952), ($953, $954, $955, $956), ($957, $958, $959, $960), ($961, $962, $963, $964), ($965, $966, $967, $968), ($969, $970, $971, $972), ($973, $974, $975, $976), ($977, $978, $979, $980), ($981, $982, $983, $984), ($985, $986, $987, $988), ($989, $990, $991, $992), ($993, $994, $995, $996), ($997, $998, $999, $1000), ($1001, $1002, $1003, $1004), ($1005, $1006, $1007, $1008), ($1009, $1010, $1011, $1012), ($1013, $1014, $1015, $1016), ($1017, $1018, $1019, $1020), ($1021, $1022, $1023, $1024), ($1025, $1026, $1027, $1028), ($1029, $1030, $1031, $1032), ($1033, $1034, $1035, $1036), ($1037, $1038, $1039, $1040), ($1041, $1042, $1043, $1044), ($1045, $1046, $1047, $1048), ($1049, $1050, $1051, $1052), ($1053, $1054, $1055, $1056), ($1057, $1058, $1059, $1060), ($1061, $1062, $1063, $1064), ($1065, $1066, $1067, $1068), ($1069, $1070, $1071, $1072), ($1073, $1074, $1075, $1076), ($1077, $1078, $1079, $1080), ($1081, $1082, $1083, $1084), ($1085, $1086, $1087, $1088), ($1089, $1090, $1091, $1092), ($1093, $1094, $1095, $1096), ($1097, $1098, $1099, $1100), ($1101, $1102, $1103, $1104), ($1105, $1106, $1107, $1108), ($1109, $1110, $1111, $1112), ($1113, $1114, $1115, $1116), ($1117, $1118, $1119, $1120), ($1121, $1122, $1123, $1124), ($1125, $1126, $1127, $1128), ($1129, $1130, $1131, $1132), ($1133, $1134, $1135, $1136), ($1137, $1138, $1139, $1140), ($1141, $1142, $1143, $1144), ($1145, $1146, $1147, $1148), ($1149, $1150, $1151, $1152), ($1153, $1154, $1155, $1156), ($1157, $1158, $1159, $1160), ($1161, $1162, $1163, $1164), ($1165, $1166, $1167, $1168), ($1169, $1170, $1171, $1172), ($1173, $1174, $1175, $1176), ($1177, $1178, $1179, $1180), ($1181, $1182, $1183, $1184), ($1185, $1186, $1187, $1188), ($1189, $1190, $1191, $1192), ($1193, $1194, $1195, $1196), ($1197, $1198, $1199, $1200), ($1201, $1202, $1203, $1204), ($1205, $1206, $1207, $1208), ($1209, $1210, $1211, $1212), ($1213, $1214, $1215, $1216), ($1217, $1218, $1219, $1220), ($1221, $1222, $1223, $1224), ($1225, $1226, $1227, $1228), ($1229, $1230, $1231, $1232), ($1233, $1234, $1235, $1236), ($1237, $1238, $1239, $1240), ($1241, $1242, $1243, $1244), ($1245, $1246, $1247, $1248), ($1249, $1250, $1251, $1252), ($1253, $1254, $1255, $1256), ($1257, $1258, $1259, $1260), ($1261, $1262, $1263, $1264), ($1265, $1266, $1267, $1268), ($1269, $1270, $1271, $1272), ($1273, $1274, $1275, $1276), ($1277, $1278, $1279, $1280), ($1281, $1282, $1283, $1284), ($1285, $1286, $1287, $1288), ($1289, $1290, $1291, $1292), ($1293, $1294, $1295, $1296), ($1297, $1298, $1299, $1300), ($1301, $1302, $1303, $1304), ($1305, $1306, $1307, $1308), ($1309, $1310, $1311, $1312), ($1313, $1314, $1315, $1316), ($1317, $1318, $1319, $1320), ($1321, $1322, $1323, $1324), ($1325, $1326, $1327, $1328), ($1329, $1330, $1331, $1332), ($1333, $1334, $1335, $1336), ($1337, $1338, $1339, $1340), ($1341, $1342, $1343, $1344), ($1345, $1346, $1347, $1348), ($1349, $1350, $1351, $1352), ($1353, $1354, $1355, $1356), ($1357, $1358, $1359, $1360), ($1361, $1362, $1363, $1364), ($1365, $1366, $1367, $1368), ($1369, $1370, $1371, $1372), ($1373, $1374, $1375, $1376), ($1377, $1378, $1379, $1380), ($1381, $1382, $1383, $1384), ($1385, $1386, $1387, $1388), ($1389, $1390, $1391, $1392), ($1393, $1394, $1395, $1396), ($1397, $1398, $1399, $1400), ($1401, $1402, $1403, $1404), ($1405, $1406, $1407, $1408), ($1409, $1410, $1411, $1412), ($1413, $1414, $1415, $1416), ($1417, $1418, $1419, $1420), ($1421, $1422, $1423, $1424), ($1425, $1426, $1427, $1428), ($1429, $1430, $1431, $1432), ($1433, $1434, $1435, $1436), ($1437, $1438, $1439, $1440), ($1441, $1442, $1443, $1444), ($1445, $1446, $1447, $1448), ($1449, $1450, $1451, $1452) RETURNING "id"
|
|
0 min
< 0.1%
|
1 ms
|
19
systemic
|
SELECT "user"."updatedAt" AS "user_updatedAt", "user"."createdAt" AS "user_createdAt", "user"."id" AS "user_id", "user"."email" AS "user_email", "user"."firstName" AS "user_firstName", "user"."lastName" AS "user_lastName", "user"."password" AS "user_password", "user"."personalizationAnswers" AS "user_personalizationAnswers", "user"."settings" AS "user_settings", "user"."disabled" AS "user_disabled", "user"."mfaEnabled" AS "user_mfaEnabled", "user"."mfaSecret" AS "user_mfaSecret", "user"."mfaRecoveryCodes" AS "user_mfaRecoveryCodes", "user"."lastActiveAt" AS "user_lastActiveAt", "user"."roleSlug" AS "user_roleSlug", "authIdentities"."updatedAt" AS "authIdentities_updatedAt", "authIdentities"."createdAt" AS "authIdentities_createdAt", "authIdentities"."userId" AS "authIdentities_userId", "authIdentities"."providerId" AS "authIdentities_providerId", "authIdentities"."providerType" AS "authIdentities_providerType", "role"."updatedAt" AS "role_updatedAt", "role"."createdAt" AS "role_createdAt", "role"."slug" AS "role_slug", "role"."displayName" AS "role_displayName", "role"."description" AS "role_description", "role"."systemRole" AS "role_systemRole", "role"."roleType" AS "role_roleType", "scopes"."slug" AS "scopes_slug", "scopes"."displayName" AS "scopes_displayName", "scopes"."description" AS "scopes_description" FROM "public"."user" "user" LEFT JOIN "public"."auth_identity" "authIdentities" ON "authIdentities"."userId"="user"."id" LEFT JOIN "public"."role" "role" ON "role"."slug"="user"."roleSlug" LEFT JOIN "public"."role_scope" "role_scopes" ON "role_scopes"."roleSlug"="role"."slug" LEFT JOIN "public"."scope" "scopes" ON "scopes"."slug"="role_scopes"."scopeSlug"
|