SQL-scripts



	.circleci
	.github
	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_user_sid_serial_status.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
	test.sh

Files

Contents

History

Name	Last change	Commits


.circleci	May 10, 2022	a421f972updated URLs Hari Sekhon
.github	Jun 2, 2023	e11486ebupdated yaml.yaml Hari Sekhon
analytics	Oct 10, 2024	73153057updated bigquery_ml_classification_logistic_regression_predict_with_model2.sql 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	Sep 3, 2024	71fa9843added .mdl.rb Hari Sekhon
.mdlrc	Sep 3, 2024	7901a38fadded .mdlrc Hari Sekhon
.pre-commit-config.yaml	Sep 3, 2024	6e4f333dupdated .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	290217d2updated 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 10, 2024	99551091updated oracle_checkpoints.sql Hari Sekhon
oracle_datafiles_checkpoint_change.sql	Oct 10, 2024	cd2f8155added oracle_datafiles_checkpoint_change.sql Hari Sekhon
oracle_datafiles_checkpoint_time.sql	Oct 10, 2024	f6087ad2renamed oracle_checkpoint_datafiles.sql to oracle_datafiles_checkpoint_time.sql Hari Sekhon
oracle_datafiles_lastchanged.sql	Oct 10, 2024	126a606dadded oracle_datafiles_lastchanged.sql Hari Sekhon
oracle_datafiles_unrecoverable_change.sql	Oct 10, 2024	47e2e7afadded oracle_datafiles_unrecoverable_change.sql Hari Sekhon
oracle_user_sid_serial_status.sql	Oct 10, 2024	290ea56eadded oracle_user_sid_serial_status.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	08a5c5b8updated postgres_databases_by_size_if_accessible.sql Hari Sekhon
postgres_databases_by_size.sql	Oct 10, 2024	2f5c4333updated postgres_databases_by_size.sql Hari Sekhon
postgres_dirs_pre10.sql	Oct 10, 2024	79173161updated postgres_dirs_pre10.sql Hari Sekhon
postgres_dirs_pre11.9.sql	Oct 10, 2024	67e61f9fupdated postgres_dirs_pre11.9.sql Hari Sekhon
postgres_dirs.sql	Oct 10, 2024	3cf3f73eupdated 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	7e729f5aupdated postgres_idle_sessions_current_db_kill_pre92.sql Hari Sekhon
postgres_idle_sessions_current_db_kill.sql	Oct 10, 2024	0ae2f242updated postgres_idle_sessions_current_db_kill.sql Hari Sekhon
postgres_idle_sessions_kill.sql	Oct 10, 2024	c9bcc070updated postgres_idle_sessions_kill.sql Hari Sekhon
postgres_idle_sessions_pre92.sql	Oct 10, 2024	0fac32beupdated postgres_idle_sessions_pre92.sql Hari Sekhon
postgres_idle_sessions.sql	Oct 10, 2024	1637e938updated postgres_idle_sessions.sql Hari Sekhon
postgres_index_cardinality_with_schema_name.sql	Oct 10, 2024	ec82e8b4updated postgres_index_cardinality_with_schema_name.sql Hari Sekhon
postgres_index_cardinality.sql	Oct 10, 2024	ccd462c8updated postgres_index_cardinality.sql Hari Sekhon
postgres_indexes_cache_hit_ratio.sql	Oct 10, 2024	8e8fb596updated postgres_indexes_cache_hit_ratio.sql Hari Sekhon
postgres_indexes_unused.sql	Oct 10, 2024	55099dc7updated postgres_indexes_unused.sql Hari Sekhon
postgres_info_pre10.sql	Oct 10, 2024	d15f8bbfupdated postgres_info_pre10.sql Hari Sekhon
postgres_info.sql	Oct 10, 2024	250df92aupdated postgres_info.sql Hari Sekhon
postgres_last_analyze_pre94.sql	Oct 10, 2024	87bedc94updated postgres_last_analyze_pre94.sql Hari Sekhon
postgres_last_analyze.sql	Oct 10, 2024	b857e252updated postgres_last_analyze.sql Hari Sekhon
postgres_last_vacuum_analyze_pre94.sql	Oct 10, 2024	09b69f4bupdated postgres_last_vacuum_analyze_pre94.sql Hari Sekhon
postgres_last_vacuum_analyze.sql	Oct 10, 2024	3e961e22updated postgres_last_vacuum_analyze.sql Hari Sekhon
postgres_last_vacuum_pre91.sql	Oct 10, 2024	651baae4updated postgres_last_vacuum_pre91.sql Hari Sekhon
postgres_last_vacuum.sql	Oct 10, 2024	98af58c4updated postgres_last_vacuum.sql Hari Sekhon
postgres_locks_blocked_application.sql	Oct 10, 2024	3af29450updated postgres_locks_blocked_application.sql Hari Sekhon
postgres_locks_blocked.sql	Oct 10, 2024	12996f6aupdated postgres_locks_blocked.sql Hari Sekhon
postgres_locks_query_age_pre92.sql	Oct 10, 2024	bedc38c7updated postgres_locks_query_age_pre92.sql Hari Sekhon
postgres_locks_query_age.sql	Oct 10, 2024	825c09f1updated postgres_locks_query_age.sql Hari Sekhon
postgres_locks.sql	Oct 10, 2024	26ca9d64updated postgres_locks.sql Hari Sekhon
postgres_queries_slow_pre92.sql	Oct 10, 2024	29b0e40aupdated postgres_queries_slow_pre92.sql Hari Sekhon
postgres_queries_slow_pre96.sql	Oct 10, 2024	4fd964b0updated postgres_queries_slow_pre96.sql Hari Sekhon
postgres_queries_slow.sql	Oct 10, 2024	5d07c98bupdated postgres_queries_slow.sql Hari Sekhon
postgres_query_cache_hit_ratio.sql	Oct 10, 2024	fef4b93aupdated postgres_query_cache_hit_ratio.sql Hari Sekhon
postgres_query_times_pre13.sql	Oct 10, 2024	af5b737eupdated postgres_query_times_pre13.sql Hari Sekhon
postgres_query_times_pre95.sql	Oct 10, 2024	2085d5f7updated postgres_query_times_pre95.sql Hari Sekhon
postgres_query_times.sql	Oct 10, 2024	48011266updated postgres_query_times.sql Hari Sekhon
postgres_recovery.sql	Oct 10, 2024	eba185abupdated postgres_recovery.sql Hari Sekhon
postgres_running_queries_pre92.sql	Oct 10, 2024	d249e7f3updated postgres_running_queries_pre92.sql Hari Sekhon
postgres_running_queries.sql	Oct 10, 2024	804eeef3updated postgres_running_queries.sql Hari Sekhon
postgres_sequences_restart_all.sql	Oct 10, 2024	b64c445fupdated postgres_sequences_restart_all.sql Hari Sekhon
postgres_sessions_pre10.sql	Oct 10, 2024	ceb6970aupdated postgres_sessions_pre10.sql Hari Sekhon
postgres_sessions_state_count.sql	Oct 10, 2024	bc0eccadupdated postgres_sessions_state_count.sql Hari Sekhon
postgres_sessions.sql	Oct 10, 2024	22f47a9fupdated postgres_sessions.sql Hari Sekhon
postgres_settings_auth.sql	Oct 10, 2024	0c955ca1updated postgres_settings_auth.sql Hari Sekhon
postgres_settings_autovacuum.sql	Oct 10, 2024	ebcce200updated postgres_settings_autovacuum.sql Hari Sekhon
postgres_settings_client_connection.sql	Oct 10, 2024	0bd74069updated postgres_settings_client_connection.sql Hari Sekhon
postgres_settings_compatibility.sql	Oct 10, 2024	f4edb2b4updated postgres_settings_compatibility.sql Hari Sekhon
postgres_settings_connections.sql	Oct 10, 2024	967f0e4fupdated postgres_settings_connections.sql Hari Sekhon
postgres_settings_developer.sql	Oct 10, 2024	06a0fba6updated postgres_settings_developer.sql Hari Sekhon
postgres_settings_error_handling.sql	Oct 10, 2024	b09e923bupdated postgres_settings_error_handling.sql Hari Sekhon
postgres_settings_files.sql	Oct 10, 2024	c1232325updated postgres_settings_files.sql Hari Sekhon
postgres_settings_locking.sql	Oct 10, 2024	e32962aaupdated postgres_settings_locking.sql Hari Sekhon
postgres_settings_logging.sql	Oct 10, 2024	54e43261updated postgres_settings_logging.sql Hari Sekhon
postgres_settings_memory.sql	Oct 10, 2024	714e2a05updated postgres_settings_memory.sql Hari Sekhon
postgres_settings_misc.sql	Oct 10, 2024	1b9ce729updated postgres_settings_misc.sql Hari Sekhon
postgres_settings_preset.sql	Oct 10, 2024	22a06d52updated postgres_settings_preset.sql Hari Sekhon
postgres_settings_query_planning.sql	Oct 10, 2024	90991205updated postgres_settings_query_planning.sql Hari Sekhon
postgres_settings_replication.sql	Oct 10, 2024	1536f170updated postgres_settings_replication.sql Hari Sekhon
postgres_settings_resources.sql	Oct 10, 2024	dcd97b55updated postgres_settings_resources.sql Hari Sekhon
postgres_settings_ssl.sql	Oct 10, 2024	133509b6updated postgres_settings_ssl.sql Hari Sekhon
postgres_settings_statistics.sql	Oct 10, 2024	688210fdupdated postgres_settings_statistics.sql Hari Sekhon
postgres_settings_wal.sql	Oct 10, 2024	a586d2c0updated postgres_settings_wal.sql Hari Sekhon
postgres_settings.sql	Oct 10, 2024	24d51a7bupdated postgres_settings.sql Hari Sekhon
postgres_tables_by_size_2.sql	Oct 10, 2024	10dc2e2aupdated postgres_tables_by_size_2.sql Hari Sekhon
postgres_tables_by_size.sql	Oct 10, 2024	8cf455b6updated postgres_tables_by_size.sql Hari Sekhon
postgres_tables_cache_hit_ratio.sql	Oct 10, 2024	b8d1c95cupdated postgres_tables_cache_hit_ratio.sql Hari Sekhon
postgres_tables_index_usage.sql	Oct 10, 2024	2946c3e8updated postgres_tables_index_usage.sql Hari Sekhon
postgres_tables_row_estimates.sql	Oct 10, 2024	36796b8bupdated postgres_tables_row_estimates.sql Hari Sekhon
README.md	Sep 4, 2024	b30bede5updated README Hari Sekhon
test.sh	May 10, 2022	a1b6071cupdated URLs Hari Sekhon