I am running a simple join query, where the table incident_tracker_details is covered by a suitable index. The query is slow because it doesn`t use all the columns in Index Condition, but does use the column as a Filter leading…
I have a table and I am only interested in two columns to perform two actions (Ignore or Good), and based on actions I need to keep only "Good" rows. I have tried several SQL windows functions but not able…
I need to store data(float) from 20,000 sensors once a second. I originally wanted to create the following tableļ¼ time sensor 1 sensor 2 ... sensor 20000 2024-09-06 13:00:00 1.2 5.3 .... 2.0 But then I found a table cannot…
I'm creating a statistic reporting tool and facing an issue related to memory due to a high query result (application server not responding due to RAM is full). I can't restrict the query result by limit or where clause due…
Each row of my table tasks is a task, and I have N concurrently running task processors. tasks { creation_time: timestamp, processing_attempts: smallint, # ... <more fields related to the task> } The tasks are unsanitized user input, so I…
Example tables would be: object id name 0 obj0 1 obj1 2 obj2 attr id description 0 attr0 1 attr1 2 attr2 link o_id a_id 0 0 0 1 0 2 1 1 I now want to generate a SQL…
Let's say I have a function that returns type record: CREATE OR REPLACE FUNCTION pnh_row(myId integer) RETURNS RECORD AS $$ DECLARE myRow RECORD; BEGIN // blah blah return myRow; END; $$ language plpgsql; How can I insert and update this…
My requirement is similar to this question & answer PostgreSQL - Calculate SUM() of COUNT() But need the total by another column I have something similar to this create table Item ( ItemID INTEGER not null, ItemCode NCHAR(10) not null,…
I have two arrays as shown below, as i concat both the arrays - the ST key value in Array1 is replaced by values in ST key values in Array2, Array 1: {"ST": ["Bin", "No", "Comp"], "OSS": ["Class"]} Array 2:…
I have query like select billing_number, created, amount_total_sum, days, country, status, check_in_date, concat(elements->> 'isPossible', elements-> 'UTCDateFrom' ->> 'date', ' - ', elements-> 'UTCDateTo' ->> 'date' ) from (select o.billing_number, o.created, o.amount_total_sum, t.check_in_date, t.check_out_date - t.check_in_date as days, t.hotel_country as country,…