Skip to main content

Questions tagged [slow-query]

The tag has no usage guidance.

Filter by
Sorted by
Tagged with
0 votes
1 answer
56 views

My postgresql indexes are read slowly from disk

I have a database of sufficient size that it does not fit entirely in RAM, including indexes that also exceed RAM capacity. When performing queries, I observe significant differences in processing ...
Doe Jowns's user avatar
0 votes
1 answer
22 views

MariaDB: Writing even 25MB of data into a LONGBLOB is very slow

We recently added MariaDB as a storage option for our tool. Before that we only allowed sqlite. Among other tables I have a very simple temporary file storage table: create table tmp_file_storage ( ...
Tekay37's user avatar
  • 101
0 votes
1 answer
68 views

Extremely slow query whenever using ORDER BY, even when an index is present

I've been trying to debug a particularly slow query that never completes (it takes forever and eventually timeout), and found out that it's down to the ORDER BY statement: if it's there, it never ...
laurent's user avatar
  • 191
1 vote
2 answers
113 views

Why is this query running so slowly?

My system (OpenMage / Magento 1) is running some queries like the following and even though it's not using any large tables it seems that they take an abnormally high amount of time to execute. ...
gabtzi's user avatar
  • 161
0 votes
0 answers
54 views

Sql Server migration from old server to new very slow SQLEXPRESS

Hope someone can assist me. I think I might know what the problem is but this is not really resolving the issue and was wondering if it is even a valid conclusion. I am not a Guru at all with SQL. ...
Eduard's user avatar
  • 1
0 votes
1 answer
102 views

Techniques for increasing speed of simple select query using DBI R package to MS SQL server where ASYNC_NETWORK_IO is the bottleneck

I am executing a simple select query similar to: DBI::dbGetQuery(db, "SELECT date, x, y, FROM table") where the table contains a large amount of financial data. The db is a MS SQL server ...
nvt's user avatar
  • 1
0 votes
0 answers
71 views

How to fix high px deq slave session stats in Oracle RDS

We are seeing some high percentage of "px deq slave session stats" waits in our Production database.(this maintained on AWS RDS). Due to which outage is happening many times from searching ...
Arun's user avatar
  • 13
0 votes
1 answer
601 views

How can I speed up my query that involves `max(timestamp)` in a huge table? I already added an index to every field

I have a huge table that has fields ip, mac, and timestamp. Neither of the three fields is unique, but the combination of all three is. Table is automatically populated, with newer records added all ...
Granny Aching's user avatar
7 votes
1 answer
4k views

Why is the 'DELETE' operation on a PostgreSQL database table unusually very slow?

I have encountered a significant performance issue when executing the 'DELETE' operation on a PostgreSQL database table. The execution time for deleting 15488 records was 79423.768 ms which is very ...
ShwetaJ's user avatar
  • 173