What is bottleneck?

What depends on the slowness of drawing dashboards (or tables)?

CPU of the server? Memory of the server?
Number of records in the database?

Of course, I think it depends on the environment,but what about in general?

There is no general. Depends upon number of users, size of queries etc.

Hi @AndrewMBaines

There is only one user.

I tried the following:
・Improved the performance of metabase server.
・Reduced the number of data in the table.
・Check database(AWS RDS) performance

I want to check if there are other possible factors.

I want to display graphs faster.

Take the query from the question and run it in isolation. If it’s slow, then that’s a potential bottleneck. If possible, look at the table indexes to see if they can be improved.

Hi @AndrewMBaines

I think that the SQL that can be obtained from the question is a SQL statement that displays everything. ※1
Is the SQL statement the same when displaying on the dashboard?

※1 like this(The graph shows only one column, but the SQL statement is different)

That’s what your database will receive. Checks to see if the database is the bottleneck.

Take the query from the question and run it in isolation.

I thought this, but was it different?

Not sure what you mean - clicking that will show you the query that the report uses.

Hmm…

Take the query from the question and run it in isolation.

↑Could you tell me what to do specifically?

Depends upon your database. Use some other SQL tool (if MS SQL Server, use SQL Server Management Studio). Then run the query to see how long it takes.