Fetch the number of rows returned/affected by a SQL query
0
My use case is to fetch the number of rows returned/affected by a SQL query of Postgres/MYSQL RDS using the logs. Is there any configuration option?
asked a month ago13 views
1 Answers
0
This is an old school answer but you could do it with something like:
SELECT * FROM foo WHERE ... UNION ALL select count(*), NULL from foo WHERE ...;
The last row will contain the count of the query
answered a month ago
Relevant questions
Can I use the ID of my saved query to start query execution in Athena SDK?
asked a month agoIs there a limit on the number of QuickSight dashboards?
Accepted Answerasked 3 years agoIs there a limitation on the number of topics in IoT Core?
Accepted Answerasked 2 years agoFetch the number of rows returned/affected by a SQL query
asked a month agoNumber of concurrent AWS console users
Accepted Answerasked 2 months agoAws Opensearch not showing data properly also the sql plugin having a data limit of 10000 max records.
asked 2 months agoAthena Query timeout
asked 2 months agoIs there any limit to the number or age of events logged in CloudFormation event history?
Accepted Answerasked 8 months agoWhat's a MS SQL "named instance" ?
Accepted AnswerCloudWatch Metrics - Max time window exceeded for SQL query
Accepted Answerasked 4 months ago