SQL-scripts



	.circleci
	.github
	.sonarlint
	analytics
	setup
	.checkov.yaml
	.editorconfig
	.envrc
	.envrc-python
	.mdl.rb
	.mdlrc
	.pre-commit-config.yaml
	.travis.yml
	aws_athena_cloudtrail_ddl.sql
	bigquery_billing_commonly_charged_units_of_measure.sql
	bigquery_billing_latest_100_charges.sql
	bigquery_billing_products_most_frequently_used.sql
	bigquery_billing_products_with_highest_aggregate_cost.sql
	bigquery_billing_products_with_most_billing_records.sql
	bigquery_info_biggest_public_tables_by_row_count.sql
	bigquery_info_columns_partitioned_clustered.sql
	bigquery_info_columns.sql
	bigquery_info_datasets.sql
	bigquery_info_tables.sql
	LICENSE
	Makefile
	mysql_databases_by_size.sql
	mysql_host_summary.sql
	mysql_indexes_unused.sql
	mysql_info.sql
	mysql_memory_by_host.sql
	mysql_memory_by_user.sql
	mysql_sessions.sql
	mysql_statement_latency_by_host.sql
	mysql_statement_latency_by_user.sql
	mysql_tables_nonsystem.sql
	mysql_tables.sql
	mysql_user_summary.sql
	mysql_user.sql
	mysql_users_pre56.sql
	mysql_users_pre8.sql
	mysql_users.sql
	mysql_views_system.sql
	mysql_views.sql
	oracle_checkpoints.sql
	oracle_datafiles_checkpoint_change.sql
	oracle_datafiles_checkpoint_time.sql
	oracle_datafiles_lastchanged.sql
	oracle_datafiles_unrecoverable_change.sql
	oracle_rds_ddl_tablespace.sql
	oracle_recent_queries.sql
	oracle_show_dba_recyclebin.sql
	oracle_show_sessions_using_temp_tablespace.sql
	oracle_table_segments_for_schema.sql
	oracle_table_shrink_candidates.sql
	oracle_table_space_for_schema.sql
	oracle_table_space.sql
	oracle_tablespace_datafiles_sum_vs_max_autoextend_temp.sql
	oracle_tablespace_datafiles_sum_vs_max_autoextend.sql
	oracle_tablespace_space.sql
	oracle_tablespace_space2.sql
	oracle_tablespace_undo_space.sql
	oracle_user_sessions.sql
	postgres_active_query_count.sql
	postgres_backends_per_database.sql
	postgres_blocked_queries.sql
	postgres_columns_null.sql
	postgres_columns_useless.sql
	postgres_databases_by_size_if_accessible.sql
	postgres_databases_by_size.sql
	postgres_dirs_pre10.sql
	postgres_dirs_pre11.9.sql
	postgres_dirs.sql
	postgres_grant_select_all_tables.sql
	postgres_idle_sessions_current_db_kill_pre92.sql
	postgres_idle_sessions_current_db_kill.sql
	postgres_idle_sessions_kill.sql
	postgres_idle_sessions_pre92.sql
	postgres_idle_sessions.sql
	postgres_index_cardinality_with_schema_name.sql
	postgres_index_cardinality.sql
	postgres_indexes_cache_hit_ratio.sql
	postgres_indexes_unused.sql
	postgres_info_pre10.sql
	postgres_info.sql
	postgres_last_analyze_pre94.sql
	postgres_last_analyze.sql
	postgres_last_vacuum_analyze_pre94.sql
	postgres_last_vacuum_analyze.sql
	postgres_last_vacuum_pre91.sql
	postgres_last_vacuum.sql
	postgres_locks_blocked_application.sql
	postgres_locks_blocked.sql
	postgres_locks_query_age_pre92.sql
	postgres_locks_query_age.sql
	postgres_locks.sql
	postgres_queries_slow_pre92.sql
	postgres_queries_slow_pre96.sql
	postgres_queries_slow.sql
	postgres_query_cache_hit_ratio.sql
	postgres_query_times_pre13.sql
	postgres_query_times_pre95.sql
	postgres_query_times.sql
	postgres_recovery.sql
	postgres_running_queries_pre92.sql
	postgres_running_queries.sql
	postgres_sequences_restart_all.sql
	postgres_sessions_pre10.sql
	postgres_sessions_state_count.sql
	postgres_sessions.sql
	postgres_settings_auth.sql
	postgres_settings_autovacuum.sql
	postgres_settings_client_connection.sql
	postgres_settings_compatibility.sql
	postgres_settings_connections.sql
	postgres_settings_developer.sql
	postgres_settings_error_handling.sql
	postgres_settings_files.sql
	postgres_settings_locking.sql
	postgres_settings_logging.sql
	postgres_settings_memory.sql
	postgres_settings_misc.sql
	postgres_settings_preset.sql
	postgres_settings_query_planning.sql
	postgres_settings_replication.sql
	postgres_settings_resources.sql
	postgres_settings_ssl.sql
	postgres_settings_statistics.sql
	postgres_settings_wal.sql
	postgres_settings.sql
	postgres_tables_by_size_2.sql
	postgres_tables_by_size.sql
	postgres_tables_cache_hit_ratio.sql
	postgres_tables_index_usage.sql
	postgres_tables_row_estimates.sql
	README.md
	sonar-project.properties
	test.sh

Files

Set up build

Contents

History

Name	Last change	Commits


.circleci	May 10, 2022	a421f972updated URLs Hari Sekhon
.github	Feb 25	024a2886updated yaml.yaml Hari Sekhon
.sonarlint	Feb 26	ee8ff3f3added connectedMode.json Hari Sekhon
analytics	Oct 12, 2024	9da740f4updated README.md Hari Sekhon
setup	Aug 4, 2022	fa0a59caremoved setup/ci_git_set_dir_safe.sh Hari Sekhon
.checkov.yaml	Feb 22, 2022	58ae406dadded .checkov.yaml Hari Sekhon
.editorconfig	Aug 9, 2024	b60b975aupdated .editorconfig Hari Sekhon
.envrc	Sep 23, 2024	f098c727updated .envrc Hari Sekhon
.envrc-python	Aug 8, 2024	34599ce1added .envrc-python Hari Sekhon
.mdl.rb	Oct 12, 2024	d04d5cdfupdated .mdl.rb Hari Sekhon
.mdlrc	Oct 12, 2024	d2d3df44updated .mdlrc Hari Sekhon
.pre-commit-config.yaml	Nov 22, 2024	8ab1204aupdated .pre-commit-config.yaml Hari Sekhon
.travis.yml	Jun 1, 2022	819913f7updated URLs Hari Sekhon
aws_athena_cloudtrail_ddl.sql	May 10, 2022	a1b6071cupdated URLs Hari Sekhon
bigquery_billing_commonly_charged_units_of_measure.sql	Oct 10, 2024	a050e744updated bigquery_billing_commonly_charged_units_of_measure.sql Hari Sekhon
bigquery_billing_latest_100_charges.sql	Oct 10, 2024	1e6f6e0dupdated bigquery_billing_latest_100_charges.sql Hari Sekhon
bigquery_billing_products_most_frequently_used.sql	Oct 10, 2024	d397751cupdated bigquery_billing_products_most_frequently_used.sql Hari Sekhon
bigquery_billing_products_with_highest_aggregate_cost.sql	Oct 10, 2024	f5aeca99updated bigquery_billing_products_with_highest_aggregate_cost.sql Hari Sekhon
bigquery_billing_products_with_most_billing_records.sql	Oct 10, 2024	00d91c4cupdated bigquery_billing_products_with_most_billing_records.sql Hari Sekhon
bigquery_info_biggest_public_tables_by_row_count.sql	Oct 10, 2024	bd1226eeupdated bigquery_info_biggest_public_tables_by_row_count.sql Hari Sekhon
bigquery_info_columns_partitioned_clustered.sql	Oct 10, 2024	3657a069updated bigquery_info_columns_partitioned_clustered.sql Hari Sekhon
bigquery_info_columns.sql	Oct 10, 2024	ae48fab8updated bigquery_info_columns.sql Hari Sekhon
bigquery_info_datasets.sql	Oct 10, 2024	b1b3f67bupdated bigquery_info_datasets.sql Hari Sekhon
bigquery_info_tables.sql	Oct 10, 2024	a1eabd87updated bigquery_info_tables.sql Hari Sekhon
LICENSE	Feb 8, 2022	0abec710updated LICENSE Hari Sekhon
Makefile	May 10, 2022	a421f972updated URLs Hari Sekhon
mysql_databases_by_size.sql	Oct 10, 2024	ba181943updated mysql_databases_by_size.sql Hari Sekhon
mysql_host_summary.sql	Oct 10, 2024	017f9fbaupdated mysql_host_summary.sql Hari Sekhon
mysql_indexes_unused.sql	Oct 10, 2024	f4a17ae7updated mysql_indexes_unused.sql Hari Sekhon
mysql_info.sql	Oct 10, 2024	151b4946updated mysql_info.sql Hari Sekhon
mysql_memory_by_host.sql	Oct 10, 2024	fad3c15aupdated mysql_memory_by_host.sql Hari Sekhon
mysql_memory_by_user.sql	Oct 10, 2024	7b1a1ec5updated mysql_memory_by_user.sql Hari Sekhon
mysql_sessions.sql	Oct 10, 2024	e3b08d3aupdated mysql_sessions.sql Hari Sekhon
mysql_statement_latency_by_host.sql	Oct 10, 2024	755a1830updated mysql_statement_latency_by_host.sql Hari Sekhon
mysql_statement_latency_by_user.sql	Oct 10, 2024	8b3c3516updated mysql_statement_latency_by_user.sql Hari Sekhon
mysql_tables_nonsystem.sql	Oct 10, 2024	8de17975updated mysql_tables_nonsystem.sql Hari Sekhon
mysql_tables.sql	Oct 10, 2024	7ed52352updated mysql_tables.sql Hari Sekhon
mysql_user_summary.sql	Oct 10, 2024	d833585bupdated mysql_user_summary.sql Hari Sekhon
mysql_user.sql	Oct 10, 2024	c9fc8f9eupdated mysql_user.sql Hari Sekhon
mysql_users_pre56.sql	Oct 10, 2024	38464542updated mysql_users_pre56.sql Hari Sekhon
mysql_users_pre8.sql	Oct 10, 2024	ab1ebb6bupdated mysql_users_pre8.sql Hari Sekhon
mysql_users.sql	Oct 10, 2024	0e717c81updated mysql_users.sql Hari Sekhon
mysql_views_system.sql	Oct 10, 2024	24b136a4updated mysql_views_system.sql Hari Sekhon
mysql_views.sql	Oct 10, 2024	dc0547edupdated mysql_views.sql Hari Sekhon
oracle_checkpoints.sql	Oct 17, 2024	872f79caupdated oracle_checkpoints.sql Hari Sekhon
oracle_datafiles_checkpoint_change.sql	Oct 12, 2024	782ca736updated oracle_datafiles_checkpoint_change.sql Hari Sekhon
oracle_datafiles_checkpoint_time.sql	Oct 12, 2024	55de5c5eupdated oracle_datafiles_checkpoint_time.sql Hari Sekhon
oracle_datafiles_lastchanged.sql	Oct 12, 2024	2d5453c9updated oracle_datafiles_lastchanged.sql Hari Sekhon
oracle_datafiles_unrecoverable_change.sql	Oct 12, 2024	98d6ef51updated oracle_datafiles_unrecoverable_change.sql Hari Sekhon
oracle_rds_ddl_tablespace.sql	Oct 17, 2024	26429705added oracle_rds_ddl_tablespace.sql Hari Sekhon
oracle_recent_queries.sql	Oct 12, 2024	fa10258fupdated oracle_recent_queries.sql Hari Sekhon
oracle_show_dba_recyclebin.sql	Oct 12, 2024	067963c9updated oracle_show_dba_recyclebin.sql Hari Sekhon
oracle_show_sessions_using_temp_tablespace.sql	Oct 17, 2024	c322b0e5added oracle_show_sessions_using_temp_tablespace.sql Hari Sekhon
oracle_table_segments_for_schema.sql	Oct 17, 2024	e1ad429eadded oracle_table_segments_for_schema.sql Hari Sekhon
oracle_table_shrink_candidates.sql	Oct 18, 2024	de9dd5edupdated oracle_table_shrink_candidates.sql Hari Sekhon
oracle_table_space_for_schema.sql	Oct 17, 2024	c2675bc2updated oracle_table_space_for_schema.sql Hari Sekhon
oracle_table_space.sql	Oct 17, 2024	6a243220updated oracle_table_space.sql Hari Sekhon
oracle_tablespace_datafiles_sum_vs_max_autoextend_temp.sql	Oct 17, 2024	ae76d264added oracle_tablespace_datafiles_sum_vs_max_autoextend_temp.sql Hari Sekhon
oracle_tablespace_datafiles_sum_vs_max_autoextend.sql	Oct 17, 2024	ac9afa8dadded oracle_tablespace_datafiles_sum_vs_max_autoextend.sql Hari Sekhon
oracle_tablespace_space.sql	Oct 17, 2024	b65b0af3updated oracle_tablespace_space.sql Hari Sekhon
oracle_tablespace_space2.sql	Oct 17, 2024	d32cf419updated oracle_tablespace_space2.sql Hari Sekhon
oracle_tablespace_undo_space.sql	Oct 18, 2024	f887525eadded oracle_tablespace_undo_space.sql Hari Sekhon
oracle_user_sessions.sql	Oct 12, 2024	d6ad6dd1renamed oracle_user_sid_serial_status.sql to oracle_user_sessions.sql Hari Sekhon
postgres_active_query_count.sql	Oct 10, 2024	e6b73070updated postgres_active_query_count.sql Hari Sekhon
postgres_backends_per_database.sql	Oct 10, 2024	c3801858updated postgres_backends_per_database.sql Hari Sekhon
postgres_blocked_queries.sql	Oct 10, 2024	c54208fcupdated postgres_blocked_queries.sql Hari Sekhon
postgres_columns_null.sql	Oct 10, 2024	746212f5updated postgres_columns_null.sql Hari Sekhon
postgres_columns_useless.sql	Oct 10, 2024	b41758caupdated postgres_columns_useless.sql Hari Sekhon
postgres_databases_by_size_if_accessible.sql	Oct 10, 2024	9eb66a3cupdated postgres_databases_by_size_if_accessible.sql Hari Sekhon
postgres_databases_by_size.sql	Oct 10, 2024	a65755deupdated postgres_databases_by_size.sql Hari Sekhon
postgres_dirs_pre10.sql	Oct 10, 2024	1434ac7cupdated postgres_dirs_pre10.sql Hari Sekhon
postgres_dirs_pre11.9.sql	Oct 10, 2024	f09011f2updated postgres_dirs_pre11.9.sql Hari Sekhon
postgres_dirs.sql	Oct 10, 2024	3d5ea068updated postgres_dirs.sql Hari Sekhon
postgres_grant_select_all_tables.sql	Oct 10, 2024	4c4ef518updated postgres_grant_select_all_tables.sql Hari Sekhon
postgres_idle_sessions_current_db_kill_pre92.sql	Oct 10, 2024	4b0722cbupdated postgres_idle_sessions_current_db_kill_pre92.sql Hari Sekhon
postgres_idle_sessions_current_db_kill.sql	Oct 10, 2024	ba1d84bbupdated postgres_idle_sessions_current_db_kill.sql Hari Sekhon
postgres_idle_sessions_kill.sql	Oct 10, 2024	60e4bd68updated postgres_idle_sessions_kill.sql Hari Sekhon
postgres_idle_sessions_pre92.sql	Oct 10, 2024	1f36eda4updated postgres_idle_sessions_pre92.sql Hari Sekhon
postgres_idle_sessions.sql	Oct 10, 2024	2b8f367fupdated postgres_idle_sessions.sql Hari Sekhon
postgres_index_cardinality_with_schema_name.sql	Oct 10, 2024	e1ddebdeupdated postgres_index_cardinality_with_schema_name.sql Hari Sekhon
postgres_index_cardinality.sql	Oct 10, 2024	752ba82dupdated postgres_index_cardinality.sql Hari Sekhon
postgres_indexes_cache_hit_ratio.sql	Oct 10, 2024	61dab0b9updated postgres_indexes_cache_hit_ratio.sql Hari Sekhon
postgres_indexes_unused.sql	Oct 10, 2024	87457e33updated postgres_indexes_unused.sql Hari Sekhon
postgres_info_pre10.sql	Oct 10, 2024	2a8c14deupdated postgres_info_pre10.sql Hari Sekhon
postgres_info.sql	Oct 10, 2024	f071662eupdated postgres_info.sql Hari Sekhon
postgres_last_analyze_pre94.sql	Oct 10, 2024	46eb2bcaupdated postgres_last_analyze_pre94.sql Hari Sekhon
postgres_last_analyze.sql	Oct 10, 2024	913961b2updated postgres_last_analyze.sql Hari Sekhon
postgres_last_vacuum_analyze_pre94.sql	Oct 10, 2024	1befa15aupdated postgres_last_vacuum_analyze_pre94.sql Hari Sekhon
postgres_last_vacuum_analyze.sql	Oct 10, 2024	29f7b037updated postgres_last_vacuum_analyze.sql Hari Sekhon
postgres_last_vacuum_pre91.sql	Oct 10, 2024	9f8d38e5updated postgres_last_vacuum_pre91.sql Hari Sekhon
postgres_last_vacuum.sql	Oct 10, 2024	de70dcadupdated postgres_last_vacuum.sql Hari Sekhon
postgres_locks_blocked_application.sql	Oct 10, 2024	a0f6c4ddupdated postgres_locks_blocked_application.sql Hari Sekhon
postgres_locks_blocked.sql	Oct 10, 2024	bdc2c7e7updated postgres_locks_blocked.sql Hari Sekhon
postgres_locks_query_age_pre92.sql	Oct 10, 2024	1db6d6beupdated postgres_locks_query_age_pre92.sql Hari Sekhon
postgres_locks_query_age.sql	Oct 10, 2024	6fa71b0dupdated postgres_locks_query_age.sql Hari Sekhon
postgres_locks.sql	Oct 10, 2024	badb53f1updated postgres_locks.sql Hari Sekhon
postgres_queries_slow_pre92.sql	Oct 10, 2024	f1032d1dupdated postgres_queries_slow_pre92.sql Hari Sekhon
postgres_queries_slow_pre96.sql	Oct 10, 2024	73feef41updated postgres_queries_slow_pre96.sql Hari Sekhon
postgres_queries_slow.sql	Oct 10, 2024	5c748c95updated postgres_queries_slow.sql Hari Sekhon
postgres_query_cache_hit_ratio.sql	Oct 10, 2024	86557e38updated postgres_query_cache_hit_ratio.sql Hari Sekhon
postgres_query_times_pre13.sql	Oct 10, 2024	025f18beupdated postgres_query_times_pre13.sql Hari Sekhon
postgres_query_times_pre95.sql	Oct 10, 2024	4e435c57updated postgres_query_times_pre95.sql Hari Sekhon
postgres_query_times.sql	Oct 10, 2024	db56705aupdated postgres_query_times.sql Hari Sekhon
postgres_recovery.sql	Oct 10, 2024	4cc082c8updated postgres_recovery.sql Hari Sekhon
postgres_running_queries_pre92.sql	Oct 10, 2024	52d0f57bupdated postgres_running_queries_pre92.sql Hari Sekhon
postgres_running_queries.sql	Oct 10, 2024	19ee0cefupdated postgres_running_queries.sql Hari Sekhon
postgres_sequences_restart_all.sql	Oct 10, 2024	c0240ea9updated postgres_sequences_restart_all.sql Hari Sekhon
postgres_sessions_pre10.sql	Oct 10, 2024	261b1bd2updated postgres_sessions_pre10.sql Hari Sekhon
postgres_sessions_state_count.sql	Oct 10, 2024	1ce5e78eupdated postgres_sessions_state_count.sql Hari Sekhon
postgres_sessions.sql	Oct 10, 2024	71c6d8b0updated postgres_sessions.sql Hari Sekhon
postgres_settings_auth.sql	Oct 10, 2024	3b8ba63bupdated postgres_settings_auth.sql Hari Sekhon
postgres_settings_autovacuum.sql	Oct 10, 2024	1745db68updated postgres_settings_autovacuum.sql Hari Sekhon
postgres_settings_client_connection.sql	Oct 10, 2024	6c0a9fd2updated postgres_settings_client_connection.sql Hari Sekhon
postgres_settings_compatibility.sql	Oct 10, 2024	64be255aupdated postgres_settings_compatibility.sql Hari Sekhon
postgres_settings_connections.sql	Oct 10, 2024	4e78b8faupdated postgres_settings_connections.sql Hari Sekhon
postgres_settings_developer.sql	Oct 10, 2024	74b2028fupdated postgres_settings_developer.sql Hari Sekhon
postgres_settings_error_handling.sql	Oct 10, 2024	b4a70876updated postgres_settings_error_handling.sql Hari Sekhon
postgres_settings_files.sql	Oct 10, 2024	41ff6070updated postgres_settings_files.sql Hari Sekhon
postgres_settings_locking.sql	Oct 10, 2024	dc8f1051updated postgres_settings_locking.sql Hari Sekhon
postgres_settings_logging.sql	Oct 10, 2024	8e1eb2b8updated postgres_settings_logging.sql Hari Sekhon
postgres_settings_memory.sql	Oct 10, 2024	67072686updated postgres_settings_memory.sql Hari Sekhon
postgres_settings_misc.sql	Oct 10, 2024	8f875f5bupdated postgres_settings_misc.sql Hari Sekhon
postgres_settings_preset.sql	Oct 10, 2024	d3ca5b7fupdated postgres_settings_preset.sql Hari Sekhon
postgres_settings_query_planning.sql	Oct 10, 2024	2cde4213updated postgres_settings_query_planning.sql Hari Sekhon
postgres_settings_replication.sql	Oct 10, 2024	b5da2f10updated postgres_settings_replication.sql Hari Sekhon
postgres_settings_resources.sql	Oct 10, 2024	0db49c17updated postgres_settings_resources.sql Hari Sekhon
postgres_settings_ssl.sql	Oct 10, 2024	ab170adbupdated postgres_settings_ssl.sql Hari Sekhon
postgres_settings_statistics.sql	Oct 10, 2024	1fb53381updated postgres_settings_statistics.sql Hari Sekhon
postgres_settings_wal.sql	Oct 10, 2024	03d68a19updated postgres_settings_wal.sql Hari Sekhon
postgres_settings.sql	Oct 10, 2024	49ef67cdupdated postgres_settings.sql Hari Sekhon
postgres_tables_by_size_2.sql	Oct 10, 2024	710e7eb5updated postgres_tables_by_size_2.sql Hari Sekhon
postgres_tables_by_size.sql	Oct 10, 2024	7e300383updated postgres_tables_by_size.sql Hari Sekhon
postgres_tables_cache_hit_ratio.sql	Oct 10, 2024	1721e9a0updated postgres_tables_cache_hit_ratio.sql Hari Sekhon
postgres_tables_index_usage.sql	Oct 10, 2024	7e7848bdupdated postgres_tables_index_usage.sql Hari Sekhon
postgres_tables_row_estimates.sql	Oct 10, 2024	304fdc18updated postgres_tables_row_estimates.sql Hari Sekhon
README.md	Feb 6	c331a88eupdated README.md Hari Sekhon
sonar-project.properties	Feb 25	b9f5c62fadded sonar-project.properties Hari Sekhon
test.sh	May 10, 2022	a1b6071cupdated URLs Hari Sekhon