I am trying to debug a query that runs faster the more records it returns but performance severely degrades (>10x slower) with smaller returns (i.e. <10 rows) using small LIMIT (ie 10). Example: Fast query with 5 results out of…
I have a table in Postgres with a column that has distinct alphanumeric values in the pattern 1234P001. However, due to some bug, there are duplicate values in the column, like 1234P001 appearing thrice. I want to replace duplicate 1234P001's…
I'm using postgresql to calculate if different points are inside a specific range (calculated using pythagoras). The thing is that I would like to get the results ordered by the proximity instead of randomly. This is my query: select *…
I am trying to execute the same SQL but with different values for the where clause. One query is taking significantly longer time to process than the other. I have also observed that the execution plan for the two queries…
Trying to format the number as per the given format and culture. Given: -4059587.225000, --Value '#,##0.00;(#,##0.00)' --Format 'en-US' --Culture Will have many patterns, the given one is for example. Expected output: (4,059,587.23) In SQL Server we have format() function, what's…
I am using bitnami/postgresql-repmgr docker image for two database containers. In case that both containers running in one server and connecting to each other with my local docker network, they are working with no problem and the replication is done…
I have two tables named property and equipment_type. CREATE TABLE IF NOT EXISTS equipment_type ( class_code class_code NOT NULL, major_code character(2) NOT NULL, minor_code character(2) NOT NULL, estimated_useful_life integer NOT NULL, -- in years PRIMARY KEY (class_code, major_code, minor_code) );…
t1: AccountName Date Amount A1 2022-06-30 2 A2 2022-06-30 1 A3 2022-06-30 A1 2022-07-31 4 A2 2022-07-31 5 A3 2022-07-31 I want to do a transformation on this table such that I fill in the "Amount" column of all rows…
I was wondering if there was any way to check if, in a column, there were all values between a range. Example: i have an INTEGER column with values 0 1 2 3 5 6 i want to check if…
I have a Postgres DB, In which I am storing some analytical data in a table like a user id, city, country, source(referer), device_type(web, ios, android), etc. I wanted to show insights based on the data in the above table…