AWS aurora-dsql documentation change
Summary
Restructured documentation to emphasize efficient metadata queries, added guidance on getting estimated row counts without full table scans
Security assessment
The changes focus on query optimization and documentation organization. While promoting efficient queries improves performance, there's no evidence of addressing security vulnerabilities or documenting security features.
Diff
diff --git a/aurora-dsql/latest/userguide/working-with-systems-tables.md b/aurora-dsql/latest/userguide/working-with-systems-tables.md index e46ad22a9..d5fea6f3e 100644 --- a//aurora-dsql/latest/userguide/working-with-systems-tables.md +++ b//aurora-dsql/latest/userguide/working-with-systems-tables.md @@ -5 +5 @@ -System tablesThe ANALYZE command +System tablesUseful system queriesThe ANALYZE command @@ -209 +209 @@ The view `sys.iam_pg_role_mappings` provides information about the permissions g -### The pg_class table +## Useful system metadata queries @@ -211 +211,5 @@ The view `sys.iam_pg_role_mappings` provides information about the permissions g -The `pg_class` table stores metadata about database objects. To get the approximate count of how many rows are in a table, run the following command. +Use these queries to get table statistics and metadata without performing expensive operations like full table scans. + +### Get estimated row count for a table + +To get the approximate count of rows in a table without performing a full table scan, use the following query: @@ -216 +220 @@ The `pg_class` table stores metadata about database objects. To get the approxim -The command returns output similar to the following. +The command returns output similar to the following: @@ -222,0 +227,2 @@ The command returns output similar to the following. +This approach is more efficient than `SELECT COUNT(*)` for large tables in Aurora DSQL. +