![]() ![]() 25 as decimal( 26, 6)) as cpu_rated_score - Modify this based on the percentage that should be allocated to the cost cpu_rated_score + disk_io_rated_score + execution_rated_score = 1 Sum of rated score should be equivalent to 1 013 as decimal( 26, 6)) as concurrency_price_per_second - Check , 24 as daily_operation_hour - Modify this based on the number of hours the Amazon Redshift cluster is available (default is 24 hours if using a Reserved instance) 26 as price_per_node_per_hour - Modify this based on the price per hour of the compute node (Check ) Check the pricing based on the AWS region in which the Amazon Redshift cluster is located Otherwise, the column contains 0 (result cache was not used) Used_result_caching - A value that indicates whether the query used result caching this column contains 1. Otherwise, the column contains 0 (query ran on the main cluster) Used_concurrency_scaling - A value that indicates whether the query ran on the concurrency scaling cluster, this column contains 1. Redshift_storage_utilization - A snapshot view of the percentage of disk space used by the Amazon Redshift cluster Redshift_compute_utilization - A snapshot view of the percentage of compute used by the Amazon Redshift cluster Total_rated_spectrum_scan_size_mb - The total amount of data, in MB, scanned by Amazon Redshift Spectrum in Amazon S3 that is set at 10MB minimum per query and used for the Spectrum billing Total_burst_cluster_execution_time_secs - Total elapsed execution time for all queries that ran in completion (in seconds) in the concurrency scaling cluster Total_main_cluster_disk_io_mb - Total Number of 1 MB blocks for all queries that ran in completion (in seconds) Total_main_cluster_execution_time_secs - Total elapsed execution time for all queries that ran in completion (in seconds) in the main cluster Total_main_cluster_cpu_time_secs - Total CPU time for all queries that ran in completion (in seconds) Redshift_query_cost - The estimated compute cost (in USD) of query being executed Redshift_spectrum_price_per_tb - The price per terabyte of data scanned in using Amazon Redshift Spectrum Redshift_spectrum_cost - The estimated cost (in USD) of Amazon Redshift Spectrum query being executed based on the rated Amazon Redshift Spectrum scan size Rated_spectrum_scan_size_mb - The amount of data, in MB, scanned by Amazon Redshift Spectrum in Amazon S3 that is set at 10MB minimum per query and used for the Spectrum billing Query_disk_io_ratio - The decimal form of the percent of number of 1 MB blocks used by the queryĪctual_spectrum_scan_size_mb - The amount of data, in MB, scanned by Amazon Redshift Spectrum in Amazon S3 Query_disk_io_mb - Number of 1 MB blocks read by the query including the amount of disk space used by a query to write intermediate results Query_execution_time_ratio - The decimal form of the percent of execution time used by the queryĭaily_redshift_compute_cost - The estimated compute cost (in USD) of the Amazon Redshift cluster for the day ![]() Execution time doesn’t include time spent waiting in a queue Query_execution_time_secs - Elapsed execution time for a query (in seconds). Query_cpu_time_ratio - The decimal form of the percent of CPU time used by the query Query_cpu_time_secs - CPU time used by the query, in seconds Not applicable if the query used result caching Queue_name - The name of the service class. The query_id column can be used to join other system tables and views Query_id - ID of the Amazon Redshift Spectrum query. Query_type - A value that indicates the type of query being executed Label - Contains either the name of the file or the query group used to run the query or can be repurposed to define the application name or job nameĭatabase_name - The name of the database the user was connected to when the query was issued Is_superuser - A value that indicates whether the user is a superuser Purpose: View to get information about the estimated compute cost (in USD) of each query executionĬolumns: db_user_id - ID of the user who executed the queryĭb_username - Username of the user who executed the query
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |