I have a sample query. I have tried to rewrite it with CTE but some errors occurred. Please check and solve the below query. actual query; select dt.population, dt.name, c.name from ( select distinct countrycode, name from city ) as…
I am having performance issues with a query, I have 21 million records across the table, and 2 of the tables I'm looking in here have 8 million each; individually, they are very quick. But I've done a query that,…
Given a database table events with columns: event_id, correlation_id, username, create_timestamp. It contains more than 1M records. There is a problem I am trying to solve: for each event of a particular user display its latest sibling event. Sibling events…
I have a posts table with a JSON column of an array with IDs. This column's data looks exactly like: [1, 3, 17, 19] These values are not quoted. To check if a user should see a post, I simply…
I have the below query that takes so much time >> table size 64.31GB are there any rewrite possible for this? SELECT MIN(ut.id) AS minUT, MAX(ut.id) AS maxUT FROM user_tasks ut JOIN user_tasks_metadata utm ON utm.user_task_id = ut.id JOIN ue_events_base…
I am trying to learn some postgres skills to help me building my flask application and I really care about performance but I faced some issues. I have the following table (Sessions) in postgres: SessionID Other columns Statics BDzQDeGr *…
We are trying to query millions of rows of data from 1 table (14 columns) in under 2 seconds if possible. This table is composed of more than 10 million records and is growing exponentially as live data is being…
The section fronts on a Wordpress site I help out with have just started loading slow, and I traced it to the SQL query that loads the posts for the page, and timed a few different queries to see what's…
I'm having problems with a slow SQL query running on the following system: Operating system: Debian 11 (bullseye) Database: MariaDB 10.5.15 (the version packaged for bullseye) The table schemas and some sample data (no DB Fiddle as it doesn't support…
I want to know if one of the promises fail how can i rollback or cancel already happened operations. and 2nd is there any other way to optimize code, it takes more time to resolve. As the number of joined…