1 réponse
- Le plus récent
- Le plus de votes
- La plupart des commentaires
0
Hi nmakb,
I believe you can construct query or view for what you're looking by basing a query off of a UNION of query system log table pg_catalog.stl_scan jointed to a few other table for all table in Redshift storage UNIONEed with a query of svl_s3query smilarly joined to a few other tables to get the query text and the table and schema name.
Basically stl_scan tracks all table scan operators against table in Redshift storage for in all query plans and svl_s3query effectively does the same because all Spectrum sub-queries are single table in nature and produce equivalent scan results returned to the slices from the Spectrum layer.
I hope this helps you develop the result set you're looking for.
Regards,
-Kurt
répondu il y a 5 ans
Contenus pertinents
- demandé il y a un mois
- demandé il y a un an
- demandé il y a un an
- demandé il y a 8 mois
- AWS OFFICIELA mis à jour il y a 2 ans
- AWS OFFICIELA mis à jour il y a 4 mois