What is the deprecated classic Queries and Loads page?

Question

Hi,
I'd like to understand the warning in https://eu-west-1.console.aws.amazon.com/redshiftv2/:

```
Switch to the new Queries and Loads page for enhanced security, 7-days query history, and [query profiler ](https://docs.aws.amazon.com/redshift/latest/mgmt/using-query-plan-profiler.html)
. Follow the steps [here](https://docs.aws.amazon.com/redshift/latest/mgmt/metrics-enhanced-query-monitoring.html) 
to grant necessary access and permissions.
The classic Queries and Loads page will be unavailable after Dec 31st, 2025.
```

When I switch off "Enhanced monitoring view" I can still monitor and cancel queries as I did last year, so what was the change here exactly?
Maybe you could post a link to what is meant by "classic Queries and Loads page"?

Cheers,
joe

re:Post Agent · Answer

Based on the information available, it appears that Amazon Redshift is transitioning from a "classic" Queries and Loads page to an enhanced version with additional features.

The classic Queries and Loads page displays the longest running queries in the system, up to 100 queries, and allows you to view query details and terminate running queries. You access it through the AWS Management Console by navigating to the Amazon Redshift console and selecting "Queries and loads" from the navigation menu.

The new enhanced version offers several improvements:

1. Enhanced security
2. Extended query history (7 days instead of the previous 24 hours)
3. Query profiler functionality

When you connect to a database with the proper permissions (sys:operator or sys:monitor roles), the enhanced version provides additional filtering capabilities by database, username, or SQL statement type. The information is populated from Amazon Redshift system tables (SYS_* views).

The classic Queries and Loads page will be deprecated and unavailable after December 31, 2025. This is separate from the announcement about Python UDFs no longer being supported for creation after November 1, 2025.

When you toggle the "Enhanced monitoring view" setting, you're switching between these two versions of the Queries and Loads page.  
**Sources**  
[Viewing queries and loads - Amazon Redshift](https://docs.aws.amazon.com/redshift/latest/mgmt/performance-metrics-queries.html)  
[Viewing and analyzing query details - Amazon Redshift](https://docs.aws.amazon.com/redshift/latest/mgmt/performance-metrics-query-execution-details.html)  
[Viewing queries and loads for Multi-AZ data warehouses - Amazon Redshift](https://docs.aws.amazon.com/redshift/latest/mgmt/viewing-multi-az-queries-loads.html)

joe · Answer

> When you toggle the "Enhanced monitoring view" setting, you're switching between these two versions of the Queries and Loads page.

That doesn't make sense to me for two reasons.
First the "classic" page is said no longer to be available so why would it be possible to still use it?
Second we did not follow the instructions in the warning that let us use the new version as I understand it.

What is the deprecated classic Queries and Loads page?

Add your answer

Relevant content