Skip to main contentAzure DevOps
harisekhon
/
GitHub
/
Repos
/
Files
/
Sign in to your account
Sign in
GitHub
Overview
Boards
ReposFilesCommitsBranchesTagsPull requests
Pipelines
Artifacts
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
More actions
.circleci
May 10, 2022
a421f972updated URLs Hari Sekhon
.github
Jun 2, 2023
e11486ebupdated yaml.yaml Hari Sekhon
analytics
May 10, 2022
a1b6071cupdated URLs 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
ea031dc0updated bigquery_billing_commonly_charged_units_of_measure.sql Hari Sekhon
bigquery_billing_latest_100_charges.sql
Oct 10, 2024
a4e7c59dupdated bigquery_billing_latest_100_charges.sql Hari Sekhon
bigquery_billing_products_most_frequently_used.sql
Oct 10, 2024
5a2cd8f8updated bigquery_billing_products_most_frequently_used.sql Hari Sekhon
bigquery_billing_products_with_highest_aggregate_cost.sql
Oct 10, 2024
31b280f7updated bigquery_billing_products_with_highest_aggregate_cost.sql Hari Sekhon
bigquery_billing_products_with_most_billing_records.sql
Oct 10, 2024
72fc0f29updated bigquery_billing_products_with_most_billing_records.sql Hari Sekhon
bigquery_info_biggest_public_tables_by_row_count.sql
Oct 10, 2024
3516e76dupdated bigquery_info_biggest_public_tables_by_row_count.sql Hari Sekhon
bigquery_info_columns_partitioned_clustered.sql
Oct 10, 2024
c6813c9eupdated bigquery_info_columns_partitioned_clustered.sql Hari Sekhon
bigquery_info_columns.sql
Oct 10, 2024
019d1d01updated bigquery_info_columns.sql Hari Sekhon
bigquery_info_datasets.sql
Oct 10, 2024
7b839d31updated bigquery_info_datasets.sql Hari Sekhon
bigquery_info_tables.sql
Oct 10, 2024
4597752aupdated 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
09794142updated mysql_databases_by_size.sql Hari Sekhon
mysql_host_summary.sql
Oct 10, 2024
81eb24fbupdated mysql_host_summary.sql Hari Sekhon
mysql_indexes_unused.sql
Oct 10, 2024
e6e43e8dupdated mysql_indexes_unused.sql Hari Sekhon
mysql_info.sql
Oct 10, 2024
d4921796updated mysql_info.sql Hari Sekhon
mysql_memory_by_host.sql
Oct 10, 2024
f3218722updated mysql_memory_by_host.sql Hari Sekhon
mysql_memory_by_user.sql
Oct 10, 2024
26754be0updated mysql_memory_by_user.sql Hari Sekhon
mysql_sessions.sql
Oct 10, 2024
ac4d9021updated mysql_sessions.sql Hari Sekhon
mysql_statement_latency_by_host.sql
Oct 10, 2024
f59129eaupdated mysql_statement_latency_by_host.sql Hari Sekhon
mysql_statement_latency_by_user.sql
Oct 10, 2024
4953ee66updated mysql_statement_latency_by_user.sql Hari Sekhon
mysql_tables_nonsystem.sql
Oct 10, 2024
1a92ee21updated mysql_tables_nonsystem.sql Hari Sekhon
mysql_tables.sql
Oct 10, 2024
2555984aupdated mysql_tables.sql Hari Sekhon
mysql_user_summary.sql
Oct 10, 2024
22da43ccupdated mysql_user_summary.sql Hari Sekhon
mysql_user.sql
Oct 10, 2024
fff3b9acupdated mysql_user.sql Hari Sekhon
mysql_users_pre56.sql
Oct 10, 2024
6aec5e86updated mysql_users_pre56.sql Hari Sekhon
mysql_users_pre8.sql
Oct 10, 2024
6b554485updated mysql_users_pre8.sql Hari Sekhon
mysql_users.sql
Oct 10, 2024
594e2c34updated mysql_users.sql Hari Sekhon
mysql_views_system.sql
Oct 10, 2024
68566c6dupdated mysql_views_system.sql Hari Sekhon
mysql_views.sql
Oct 10, 2024
993b162cupdated 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
06e42fb1updated postgres_backends_per_database.sql Hari Sekhon
postgres_blocked_queries.sql
Oct 10, 2024
b5d3e8b4updated postgres_blocked_queries.sql Hari Sekhon
postgres_columns_null.sql
Oct 10, 2024
0bb7fad6updated postgres_columns_null.sql Hari Sekhon
postgres_columns_useless.sql
Oct 10, 2024
ca5f494cupdated 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
May 10, 2022
a1b6071cupdated URLs Hari Sekhon
postgres_idle_sessions_current_db_kill.sql
May 10, 2022
a1b6071cupdated URLs Hari Sekhon
postgres_idle_sessions_kill.sql
May 10, 2022
a1b6071cupdated URLs Hari Sekhon
postgres_idle_sessions_pre92.sql
May 10, 2022
a1b6071cupdated URLs Hari Sekhon
postgres_idle_sessions.sql
May 10, 2022
a1b6071cupdated URLs Hari Sekhon
postgres_index_cardinality_with_schema_name.sql
May 10, 2022
a1b6071cupdated URLs Hari Sekhon
postgres_index_cardinality.sql
May 10, 2022
a1b6071cupdated URLs Hari Sekhon
postgres_indexes_cache_hit_ratio.sql
May 10, 2022
a1b6071cupdated URLs Hari Sekhon
postgres_indexes_unused.sql
May 10, 2022
a1b6071cupdated URLs Hari Sekhon
postgres_info_pre10.sql
May 10, 2022
a1b6071cupdated URLs Hari Sekhon
postgres_info.sql
May 10, 2022
a1b6071cupdated URLs Hari Sekhon
postgres_last_analyze_pre94.sql
May 10, 2022
a1b6071cupdated URLs Hari Sekhon
postgres_last_analyze.sql
May 10, 2022
a1b6071cupdated URLs Hari Sekhon
postgres_last_vacuum_analyze_pre94.sql
May 10, 2022
a1b6071cupdated URLs Hari Sekhon
postgres_last_vacuum_analyze.sql
May 10, 2022
a1b6071cupdated URLs Hari Sekhon
postgres_last_vacuum_pre91.sql
May 10, 2022
a1b6071cupdated URLs Hari Sekhon
postgres_last_vacuum.sql
May 10, 2022
a1b6071cupdated URLs Hari Sekhon
postgres_locks_blocked_application.sql
May 10, 2022
a1b6071cupdated URLs Hari Sekhon
postgres_locks_blocked.sql
May 10, 2022
a1b6071cupdated URLs Hari Sekhon
postgres_locks_query_age_pre92.sql
May 10, 2022
a1b6071cupdated URLs Hari Sekhon
postgres_locks_query_age.sql
May 10, 2022
a1b6071cupdated URLs Hari Sekhon
postgres_locks.sql
May 10, 2022
a1b6071cupdated URLs Hari Sekhon
postgres_queries_slow_pre92.sql
May 10, 2022
a1b6071cupdated URLs Hari Sekhon
postgres_queries_slow_pre96.sql
May 10, 2022
a1b6071cupdated URLs Hari Sekhon
postgres_queries_slow.sql
May 10, 2022
a1b6071cupdated URLs Hari Sekhon
postgres_query_cache_hit_ratio.sql
May 10, 2022
a1b6071cupdated URLs Hari Sekhon
postgres_query_times_pre13.sql
May 10, 2022
a1b6071cupdated URLs Hari Sekhon
postgres_query_times_pre95.sql
May 10, 2022
a1b6071cupdated URLs Hari Sekhon
postgres_query_times.sql
May 10, 2022
a1b6071cupdated URLs Hari Sekhon
postgres_recovery.sql
May 10, 2022
a1b6071cupdated URLs Hari Sekhon
postgres_running_queries_pre92.sql
May 10, 2022
a1b6071cupdated URLs Hari Sekhon
postgres_running_queries.sql
May 10, 2022
a1b6071cupdated URLs Hari Sekhon
postgres_sequences_restart_all.sql
May 10, 2022
a1b6071cupdated URLs Hari Sekhon
postgres_sessions_pre10.sql
May 10, 2022
a1b6071cupdated URLs Hari Sekhon
postgres_sessions_state_count.sql
May 10, 2022
a1b6071cupdated URLs Hari Sekhon
postgres_sessions.sql
May 10, 2022
a1b6071cupdated URLs Hari Sekhon
postgres_settings_auth.sql
May 10, 2022
a1b6071cupdated URLs Hari Sekhon
postgres_settings_autovacuum.sql
May 10, 2022
a1b6071cupdated URLs Hari Sekhon
postgres_settings_client_connection.sql
May 10, 2022
a1b6071cupdated URLs Hari Sekhon
postgres_settings_compatibility.sql
May 10, 2022
a1b6071cupdated URLs Hari Sekhon
postgres_settings_connections.sql
May 10, 2022
a1b6071cupdated URLs Hari Sekhon
postgres_settings_developer.sql
May 10, 2022
a1b6071cupdated URLs Hari Sekhon
postgres_settings_error_handling.sql
May 10, 2022
a1b6071cupdated URLs Hari Sekhon
postgres_settings_files.sql
May 10, 2022
a1b6071cupdated URLs Hari Sekhon
postgres_settings_locking.sql
May 10, 2022
a1b6071cupdated URLs Hari Sekhon
postgres_settings_logging.sql
May 10, 2022
a1b6071cupdated URLs Hari Sekhon
postgres_settings_memory.sql
May 10, 2022
a1b6071cupdated URLs Hari Sekhon
postgres_settings_misc.sql
May 10, 2022
a1b6071cupdated URLs Hari Sekhon
postgres_settings_preset.sql
May 10, 2022
a1b6071cupdated URLs Hari Sekhon
postgres_settings_query_planning.sql
May 10, 2022
a1b6071cupdated URLs Hari Sekhon
postgres_settings_replication.sql
May 10, 2022
a1b6071cupdated URLs Hari Sekhon
postgres_settings_resources.sql
May 10, 2022
a1b6071cupdated URLs Hari Sekhon
postgres_settings_ssl.sql
May 10, 2022
a1b6071cupdated URLs Hari Sekhon
postgres_settings_statistics.sql
May 10, 2022
a1b6071cupdated URLs Hari Sekhon
postgres_settings_wal.sql
May 10, 2022
a1b6071cupdated URLs Hari Sekhon
postgres_settings.sql
May 10, 2022
a1b6071cupdated URLs Hari Sekhon
postgres_tables_by_size_2.sql
Oct 10, 2024
2a905064added postgres_tables_by_size_2.sql Hari Sekhon
postgres_tables_by_size.sql
May 10, 2022
a1b6071cupdated URLs Hari Sekhon
postgres_tables_cache_hit_ratio.sql
May 10, 2022
a1b6071cupdated URLs Hari Sekhon
postgres_tables_index_usage.sql
May 10, 2022
a1b6071cupdated URLs Hari Sekhon
postgres_tables_row_estimates.sql
May 10, 2022
a1b6071cupdated URLs Hari Sekhon
README.md
Sep 4, 2024
b30bede5updated README Hari Sekhon
test.sh
May 10, 2022
a1b6071cupdated URLs Hari Sekhon