I'm using a postgresql (15.5) database with the following logic: We have "meters" who measure electrical consumption. We have "computer meters" who are calculation of the measurements of different meters. For exemple "computedMeterA" = "meterA" + "meterB" I have classical…
So I have this query which is extremely slow to run - SELECT "conversation".*, "teamBotLocation"."id" AS "teamBotLocation.id", "teamBotLocation"."name" AS "teamBotLocation.name" FROM "conversation" AS "conversation" LEFT OUTER JOIN "teamBotLocation" AS "teamBotLocation" ON "conversation"."teamBotLocationId" = "teamBotLocation"."id" WHERE "conversation"."teamBotId" = 'some_id' AND "conversation"."teamBotLocationId"…
I want to improve performance of my queries using GIN index on jsonb column for pattern matching For example, I have a table defined as: CREATE TABLE my_table ( uuid text, doc jsonb ); In every row of table doc…
I have two tables "Tasks"(300k rows) and "TaskAssignedRoles"(500k rows). CREATE TABLE public."Tasks" ( "ID" uuid NOT NULL, "RowID" uuid NOT NULL, "Planned" timestamptz NOT NULL, CONSTRAINT "pk_Tasks" PRIMARY KEY ("RowID") ); CREATE INDEX "idx_Tasks_ID" ON public."Tasks" USING btree ("ID"); CREATE…
Will an index be automatically be updated if I change a function that is used in it. e.g. CREATE OR REPLACE FUNCTION add_test_prefix(input_text VARCHAR) RETURNS VARCHAR AS $$ BEGIN RETURN 'test_' || input_text; END; $$ LANGUAGE plpgsql; then create an…
Im trying to make a simple webpage that shows random quotes. These are in Russian. I also want to show the translation in a separate box. The quotes are being picked at random. How do I link the index of…
I'm using Mysql 8.0.33. I created a composite index with the expression column_name is not null and can't get the index to be used. What am I doing wrong? CREATE TABLE appointments ( id INT AUTO_INCREMENT PRIMARY KEY, user_id INT…
I am trying to make a component in react where there is an image of a body anatomy and on that image there are names and lines pointing to the relating body part and when you click on the name…
I have a MongoDB collection that stores some test submissions. The highlevel schema looks as follows. { "lessonType": "quiz", "userId": "639cb6d9513a420026eddca1" "courseId": "639cb6d9513a420026eddca2", "lessonId": "639cb6d9513a420026eddca3", ...some_more_fields } Now there are two indexes on this collection. first one: { courseId: 1,…
I'm writing a query in MySQL for a Grafana dashboard, but the performance of only this particular query is very poor. This is the query: SELECT br.reading ,CONCAT(ino.project,"_",SUBSTRING_INDEX(br.sensor,"_",-1)) AS new_metric ,ino.vessel ,ADDTIME(DATE('2023-01-01'),-TIMEDIFF(ino.date,br.datetime)) AS norm_date ,br.sensor FROM db.milestones br INNER JOIN…