All Questions
Tagged with query-optimization database
662 questions
1
vote
0
answers
54
views
How to efficiently query and aggregate time-series data in GridDB for a specific time window with a rolling sum?
I’m working with GridDB to store and query time-series data. The data represents sensor readings taken every minute and is stored in a container with the following structure:
CREATE TABLE ...
- 21
2
votes
0
answers
45
views
Impact of azure_pg_admin Role on Query Performance in Azure PostgreSQL Flexible Server
We’re using Azure PostgreSQL Flexible Server (v.13) and noticed a significant performance disparity between users that have the azure_pg_admin role and those that don’t.
For example, queries that ...
2
votes
1
answer
214
views
DB2 AS400 Table partitioning - execution plan for specific partition
Due to constantly increasing number of data stored in our system running on DB2 AS400 7.3 database we decided to introduce table partitioning on some tables. While creation of partitioned tables works ...
- 143
0
votes
2
answers
69
views
Postgre join query not using expected index
I have a very simple two-table set in Postgre 16.0:
CREATE TABLE fk_table (
fk_id INT PRIMARY KEY
, fk_name VARCHAR(50)
);
CREATE TABLE main_table (
id INT PRIMARY KEY
, date TIMESTAMP
, fk INT ...
- 2,564
1
vote
0
answers
88
views
PostgreSQL Update Query Taking Too Long Using CREATE TABLE UPDATE Approch
I have a PostgreSQL query that uses a CREATE TEMP TABLE approach to update a table, but it is taking much longer than expected to execute. The query is supposed to finish in around 15 minutes, but it'...
0
votes
2
answers
77
views
Query is extremely slow selecting data for last x events for racer
I have a table race_racer that contains time serialized logs for each racer in a race. I am trying to select the lastest record for a given racer in x number of races prior to a date. Basically ...
- 29
0
votes
1
answer
57
views
Why is PostgreSQL sorting a seemingly already sorted result set?
I'm trying to optimize the following query for a school assignment:
SELECT
DATE(b.book_date),
SUM(b.total_amount) revenue,
COUNT(DISTINCT(t.passenger_id)) count_passengers
FROM bookings b
...
- 45
0
votes
0
answers
52
views
Reduce query execution time with in 50 seconds
Below is my original postgresql materialize view code
-- public.reporting_user_activity_contents source
CREATE MATERIALIZED VIEW public.reporting_user_activity_contents
TABLESPACE pg_default
AS WITH ...
1
vote
1
answer
54
views
How to Optimize COUNT Query on a Bugs on a large Table with Existing Index Constraints?
I’m working on a query to count the number of bugs created on 2019-03-01 or later from a bugs table with the following schema:
bugs(id, token, title, category, device, reported_at, created_at, ...
- 21
0
votes
0
answers
46
views
Postgres SELECT hanging forever modifying the WHERE cause with only 1 minute difference
I have the problem exposed below.
I have got a table defined in this way:
CREATE TABLE opensearch.product (
id serial4 NOT NULL,
"timeStart" timestamp NOT NULL,
"timeEnd&...
- 93
0
votes
1
answer
54
views
Querying 3 tables that return 32 records took 11 seconds. How to improve query?
I am doing a database query using PHP and wordpress.
In the query below, it's taking too long to return the results.
(32 total, Query took 11.4666 seconds.)
The database server is returning a timeout ...
- 1
0
votes
0
answers
91
views
Postgresql query takes 9 minutes to execute, how can we reduce time to 60 seconds?
Below is my Postgresql query that is taking 9 minutes to execute. Please help me reduce the execution time to 60 seconds, so my API does not throw a timeout error.
SELECT DISTINCT
rdfg....
0
votes
0
answers
40
views
IS NULL performance issue in MySQL [duplicate]
We are experiencing performance issues in the production environment related to the following query.
Which update are recommended here to increase the execution speed.
How can we change where part ...
0
votes
1
answer
39
views
SQL Query to fetch final data for hierarchal configuration tables in a single query
I have two tables i.e. config_attr and config. I am working with MySQL 8.0.32.
config_attr -> This table has attribute name and its default value.
config -> This table has overriden or current ...
2
votes
0
answers
96
views
Optimizing Multilingual User Data Query
I hope you are doing well.
I have the following query to get the users with their translated names and country information which needs speed optimization:
SELECT users.*,
COALESCE(ANY_VALUE(...
- 619