René's URL Explorer Experiment


Title: GitHub - MygithubJN/pg_scripts: PostgreSQL queries and scripts

Open Graph Title: GitHub - MygithubJN/pg_scripts: PostgreSQL queries and scripts

X Title: GitHub - MygithubJN/pg_scripts: PostgreSQL queries and scripts

Description: PostgreSQL queries and scripts. Contribute to MygithubJN/pg_scripts development by creating an account on GitHub.

Open Graph Description: PostgreSQL queries and scripts. Contribute to MygithubJN/pg_scripts development by creating an account on GitHub.

X Description: PostgreSQL queries and scripts. Contribute to MygithubJN/pg_scripts development by creating an account on GitHub.

Opengraph URL: https://github.com/MygithubJN/pg_scripts

X: @github

direct link

Domain: patch-diff.githubusercontent.com

route-pattern/:user_id/:repository
route-controllerfiles
route-actiondisambiguate
fetch-noncev2:f30b0544-a2bb-2f9a-001c-7a5323d9f460
current-catalog-service-hashf3abb0cc802f3d7b95fc8762b94bdcb13bf39634c40c357301c4aa1d67a256fb
request-idDEC8:1AD266:1E04CE2:265EFED:69910157
html-safe-nonce11ceea8bd58098c125dc7ecba4c0a9a047641d1525d5ca3d2ca215aae6817ffa
visitor-payloadeyJyZWZlcnJlciI6IiIsInJlcXVlc3RfaWQiOiJERUM4OjFBRDI2NjoxRTA0Q0UyOjI2NUVGRUQ6Njk5MTAxNTciLCJ2aXNpdG9yX2lkIjoiMTQ3NDM2Njg1NzQ5NDQ2MjgwNyIsInJlZ2lvbl9lZGdlIjoiaWFkIiwicmVnaW9uX3JlbmRlciI6ImlhZCJ9
visitor-hmac83e060949845f8194cae25d616d1fd5cc4e59c8eecc2cd8ce10cf35eb040b4f2
hovercard-subject-tagrepository:950892134
github-keyboard-shortcutsrepository,copilot
google-site-verificationApib7-x98H0j5cPqHWwSMm6dNU4GmODRoqxLiDzdx9I
octolytics-urlhttps://collector.github.com/github/collect
analytics-location//
fb:app_id1401488693436528
apple-itunes-appapp-id=1477376905, app-argument=https://github.com/MygithubJN/pg_scripts
twitter:imagehttps://opengraph.githubassets.com/3eeeb1056c7103cb6eefea952eaff91d905bf601c2324bb091a55627161af371/MygithubJN/pg_scripts
twitter:cardsummary_large_image
og:imagehttps://opengraph.githubassets.com/3eeeb1056c7103cb6eefea952eaff91d905bf601c2324bb091a55627161af371/MygithubJN/pg_scripts
og:image:altPostgreSQL queries and scripts. Contribute to MygithubJN/pg_scripts development by creating an account on GitHub.
og:image:width1200
og:image:height600
og:site_nameGitHub
og:typeobject
hostnamegithub.com
expected-hostnamegithub.com
None42c603b9d642c4a9065a51770f75e5e27132fef0e858607f5c9cb7e422831a7b
turbo-cache-controlno-preview
go-importgithub.com/MygithubJN/pg_scripts git https://github.com/MygithubJN/pg_scripts.git
octolytics-dimension-user_id101418038
octolytics-dimension-user_loginMygithubJN
octolytics-dimension-repository_id950892134
octolytics-dimension-repository_nwoMygithubJN/pg_scripts
octolytics-dimension-repository_publictrue
octolytics-dimension-repository_is_forktrue
octolytics-dimension-repository_parent_id386403202
octolytics-dimension-repository_parent_nwoandyatkinson/pg_scripts
octolytics-dimension-repository_network_root_id386403202
octolytics-dimension-repository_network_root_nwoandyatkinson/pg_scripts
turbo-body-classeslogged-out env-production page-responsive
disable-turbofalse
browser-stats-urlhttps://api.github.com/_private/browser/stats
browser-errors-urlhttps://api.github.com/_private/browser/errors
release848bc6032dcc93a9a7301dcc3f379a72ba13b96e
ui-targetfull
theme-color#1e2327
color-schemelight dark

Links:

Skip to contenthttps://patch-diff.githubusercontent.com/MygithubJN/pg_scripts#start-of-content
https://patch-diff.githubusercontent.com/
Sign in https://patch-diff.githubusercontent.com/login?return_to=https%3A%2F%2Fgithub.com%2FMygithubJN%2Fpg_scripts
GitHub CopilotWrite better code with AIhttps://github.com/features/copilot
GitHub SparkBuild and deploy intelligent appshttps://github.com/features/spark
GitHub ModelsManage and compare promptshttps://github.com/features/models
MCP RegistryNewIntegrate external toolshttps://github.com/mcp
ActionsAutomate any workflowhttps://github.com/features/actions
CodespacesInstant dev environmentshttps://github.com/features/codespaces
IssuesPlan and track workhttps://github.com/features/issues
Code ReviewManage code changeshttps://github.com/features/code-review
GitHub Advanced SecurityFind and fix vulnerabilitieshttps://github.com/security/advanced-security
Code securitySecure your code as you buildhttps://github.com/security/advanced-security/code-security
Secret protectionStop leaks before they starthttps://github.com/security/advanced-security/secret-protection
Why GitHubhttps://github.com/why-github
Documentationhttps://docs.github.com
Bloghttps://github.blog
Changeloghttps://github.blog/changelog
Marketplacehttps://github.com/marketplace
View all featureshttps://github.com/features
Enterpriseshttps://github.com/enterprise
Small and medium teamshttps://github.com/team
Startupshttps://github.com/enterprise/startups
Nonprofitshttps://github.com/solutions/industry/nonprofits
App Modernizationhttps://github.com/solutions/use-case/app-modernization
DevSecOpshttps://github.com/solutions/use-case/devsecops
DevOpshttps://github.com/solutions/use-case/devops
CI/CDhttps://github.com/solutions/use-case/ci-cd
View all use caseshttps://github.com/solutions/use-case
Healthcarehttps://github.com/solutions/industry/healthcare
Financial serviceshttps://github.com/solutions/industry/financial-services
Manufacturinghttps://github.com/solutions/industry/manufacturing
Governmenthttps://github.com/solutions/industry/government
View all industrieshttps://github.com/solutions/industry
View all solutionshttps://github.com/solutions
AIhttps://github.com/resources/articles?topic=ai
Software Developmenthttps://github.com/resources/articles?topic=software-development
DevOpshttps://github.com/resources/articles?topic=devops
Securityhttps://github.com/resources/articles?topic=security
View all topicshttps://github.com/resources/articles
Customer storieshttps://github.com/customer-stories
Events & webinarshttps://github.com/resources/events
Ebooks & reportshttps://github.com/resources/whitepapers
Business insightshttps://github.com/solutions/executive-insights
GitHub Skillshttps://skills.github.com
Documentationhttps://docs.github.com
Customer supporthttps://support.github.com
Community forumhttps://github.com/orgs/community/discussions
Trust centerhttps://github.com/trust-center
Partnershttps://github.com/partners
GitHub SponsorsFund open source developershttps://github.com/sponsors
Security Labhttps://securitylab.github.com
Maintainer Communityhttps://maintainers.github.com
Acceleratorhttps://github.com/accelerator
Archive Programhttps://archiveprogram.github.com
Topicshttps://github.com/topics
Trendinghttps://github.com/trending
Collectionshttps://github.com/collections
Enterprise platformAI-powered developer platformhttps://github.com/enterprise
GitHub Advanced SecurityEnterprise-grade security featureshttps://github.com/security/advanced-security
Copilot for BusinessEnterprise-grade AI featureshttps://github.com/features/copilot/copilot-business
Premium SupportEnterprise-grade 24/7 supporthttps://github.com/premium-support
Pricinghttps://github.com/pricing
Search syntax tipshttps://docs.github.com/search-github/github-code-search/understanding-github-code-search-syntax
documentationhttps://docs.github.com/search-github/github-code-search/understanding-github-code-search-syntax
Sign in https://patch-diff.githubusercontent.com/login?return_to=https%3A%2F%2Fgithub.com%2FMygithubJN%2Fpg_scripts
Sign up https://patch-diff.githubusercontent.com/signup?ref_cta=Sign+up&ref_loc=header+logged+out&ref_page=%2F%3Cuser-name%3E%2F%3Crepo-name%3E&source=header-repo&source_repo=MygithubJN%2Fpg_scripts
Reloadhttps://patch-diff.githubusercontent.com/MygithubJN/pg_scripts
Reloadhttps://patch-diff.githubusercontent.com/MygithubJN/pg_scripts
Reloadhttps://patch-diff.githubusercontent.com/MygithubJN/pg_scripts
MygithubJN https://patch-diff.githubusercontent.com/MygithubJN
pg_scriptshttps://patch-diff.githubusercontent.com/MygithubJN/pg_scripts
andyatkinson/pg_scriptshttps://patch-diff.githubusercontent.com/andyatkinson/pg_scripts
Notifications https://patch-diff.githubusercontent.com/login?return_to=%2FMygithubJN%2Fpg_scripts
Fork 0 https://patch-diff.githubusercontent.com/login?return_to=%2FMygithubJN%2Fpg_scripts
Star 1 https://patch-diff.githubusercontent.com/login?return_to=%2FMygithubJN%2Fpg_scripts
andyatkinson.com/postgresql-tipshttps://andyatkinson.com/postgresql-tips
1 star https://patch-diff.githubusercontent.com/MygithubJN/pg_scripts/stargazers
24 forks https://patch-diff.githubusercontent.com/MygithubJN/pg_scripts/forks
Branches https://patch-diff.githubusercontent.com/MygithubJN/pg_scripts/branches
Tags https://patch-diff.githubusercontent.com/MygithubJN/pg_scripts/tags
Activity https://patch-diff.githubusercontent.com/MygithubJN/pg_scripts/activity
Star https://patch-diff.githubusercontent.com/login?return_to=%2FMygithubJN%2Fpg_scripts
Notifications https://patch-diff.githubusercontent.com/login?return_to=%2FMygithubJN%2Fpg_scripts
Code https://patch-diff.githubusercontent.com/MygithubJN/pg_scripts
Pull requests 0 https://patch-diff.githubusercontent.com/MygithubJN/pg_scripts/pulls
Actions https://patch-diff.githubusercontent.com/MygithubJN/pg_scripts/actions
Projects 0 https://patch-diff.githubusercontent.com/MygithubJN/pg_scripts/projects
Security 0 https://patch-diff.githubusercontent.com/MygithubJN/pg_scripts/security
Insights https://patch-diff.githubusercontent.com/MygithubJN/pg_scripts/pulse
Code https://patch-diff.githubusercontent.com/MygithubJN/pg_scripts
Pull requests https://patch-diff.githubusercontent.com/MygithubJN/pg_scripts/pulls
Actions https://patch-diff.githubusercontent.com/MygithubJN/pg_scripts/actions
Projects https://patch-diff.githubusercontent.com/MygithubJN/pg_scripts/projects
Security https://patch-diff.githubusercontent.com/MygithubJN/pg_scripts/security
Insights https://patch-diff.githubusercontent.com/MygithubJN/pg_scripts/pulse
Brancheshttps://patch-diff.githubusercontent.com/MygithubJN/pg_scripts/branches
Tagshttps://patch-diff.githubusercontent.com/MygithubJN/pg_scripts/tags
https://patch-diff.githubusercontent.com/MygithubJN/pg_scripts/branches
https://patch-diff.githubusercontent.com/MygithubJN/pg_scripts/tags
104 Commitshttps://patch-diff.githubusercontent.com/MygithubJN/pg_scripts/commits/main/
https://patch-diff.githubusercontent.com/MygithubJN/pg_scripts/commits/main/
administrationhttps://patch-diff.githubusercontent.com/MygithubJN/pg_scripts/tree/main/administration
administrationhttps://patch-diff.githubusercontent.com/MygithubJN/pg_scripts/tree/main/administration
backfillinghttps://patch-diff.githubusercontent.com/MygithubJN/pg_scripts/tree/main/backfilling
backfillinghttps://patch-diff.githubusercontent.com/MygithubJN/pg_scripts/tree/main/backfilling
.gitignorehttps://patch-diff.githubusercontent.com/MygithubJN/pg_scripts/blob/main/.gitignore
.gitignorehttps://patch-diff.githubusercontent.com/MygithubJN/pg_scripts/blob/main/.gitignore
README.mdhttps://patch-diff.githubusercontent.com/MygithubJN/pg_scripts/blob/main/README.md
README.mdhttps://patch-diff.githubusercontent.com/MygithubJN/pg_scripts/blob/main/README.md
approximate_count.sqlhttps://patch-diff.githubusercontent.com/MygithubJN/pg_scripts/blob/main/approximate_count.sql
approximate_count.sqlhttps://patch-diff.githubusercontent.com/MygithubJN/pg_scripts/blob/main/approximate_count.sql
cache_hit_rate.sqlhttps://patch-diff.githubusercontent.com/MygithubJN/pg_scripts/blob/main/cache_hit_rate.sql
cache_hit_rate.sqlhttps://patch-diff.githubusercontent.com/MygithubJN/pg_scripts/blob/main/cache_hit_rate.sql
cancel_backend.sqlhttps://patch-diff.githubusercontent.com/MygithubJN/pg_scripts/blob/main/cancel_backend.sql
cancel_backend.sqlhttps://patch-diff.githubusercontent.com/MygithubJN/pg_scripts/blob/main/cancel_backend.sql
concurrent_index_build_progress.sqlhttps://patch-diff.githubusercontent.com/MygithubJN/pg_scripts/blob/main/concurrent_index_build_progress.sql
concurrent_index_build_progress.sqlhttps://patch-diff.githubusercontent.com/MygithubJN/pg_scripts/blob/main/concurrent_index_build_progress.sql
constraint_definition_ddl.sqlhttps://patch-diff.githubusercontent.com/MygithubJN/pg_scripts/blob/main/constraint_definition_ddl.sql
constraint_definition_ddl.sqlhttps://patch-diff.githubusercontent.com/MygithubJN/pg_scripts/blob/main/constraint_definition_ddl.sql
create_index_create_statement.sqlhttps://patch-diff.githubusercontent.com/MygithubJN/pg_scripts/blob/main/create_index_create_statement.sql
create_index_create_statement.sqlhttps://patch-diff.githubusercontent.com/MygithubJN/pg_scripts/blob/main/create_index_create_statement.sql
detect_transaction_id_wraparound.sqlhttps://patch-diff.githubusercontent.com/MygithubJN/pg_scripts/blob/main/detect_transaction_id_wraparound.sql
detect_transaction_id_wraparound.sqlhttps://patch-diff.githubusercontent.com/MygithubJN/pg_scripts/blob/main/detect_transaction_id_wraparound.sql
find_dbid_database_oid.sqlhttps://patch-diff.githubusercontent.com/MygithubJN/pg_scripts/blob/main/find_dbid_database_oid.sql
find_dbid_database_oid.sqlhttps://patch-diff.githubusercontent.com/MygithubJN/pg_scripts/blob/main/find_dbid_database_oid.sql
find_hot_updates.sqlhttps://patch-diff.githubusercontent.com/MygithubJN/pg_scripts/blob/main/find_hot_updates.sql
find_hot_updates.sqlhttps://patch-diff.githubusercontent.com/MygithubJN/pg_scripts/blob/main/find_hot_updates.sql
find_indexed_columns_high_null_frac.sqlhttps://patch-diff.githubusercontent.com/MygithubJN/pg_scripts/blob/main/find_indexed_columns_high_null_frac.sql
find_indexed_columns_high_null_frac.sqlhttps://patch-diff.githubusercontent.com/MygithubJN/pg_scripts/blob/main/find_indexed_columns_high_null_frac.sql
find_missing_indexes.sqlhttps://patch-diff.githubusercontent.com/MygithubJN/pg_scripts/blob/main/find_missing_indexes.sql
find_missing_indexes.sqlhttps://patch-diff.githubusercontent.com/MygithubJN/pg_scripts/blob/main/find_missing_indexes.sql
find_replica_identity.sqlhttps://patch-diff.githubusercontent.com/MygithubJN/pg_scripts/blob/main/find_replica_identity.sql
find_replica_identity.sqlhttps://patch-diff.githubusercontent.com/MygithubJN/pg_scripts/blob/main/find_replica_identity.sql
find_unused_indexes.sqlhttps://patch-diff.githubusercontent.com/MygithubJN/pg_scripts/blob/main/find_unused_indexes.sql
find_unused_indexes.sqlhttps://patch-diff.githubusercontent.com/MygithubJN/pg_scripts/blob/main/find_unused_indexes.sql
foreign_keys.sqlhttps://patch-diff.githubusercontent.com/MygithubJN/pg_scripts/blob/main/foreign_keys.sql
foreign_keys.sqlhttps://patch-diff.githubusercontent.com/MygithubJN/pg_scripts/blob/main/foreign_keys.sql
generate_add_foreign_keys_ddl_to_target_table.sqlhttps://patch-diff.githubusercontent.com/MygithubJN/pg_scripts/blob/main/generate_add_foreign_keys_ddl_to_target_table.sql
generate_add_foreign_keys_ddl_to_target_table.sqlhttps://patch-diff.githubusercontent.com/MygithubJN/pg_scripts/blob/main/generate_add_foreign_keys_ddl_to_target_table.sql
generate_data.sqlhttps://patch-diff.githubusercontent.com/MygithubJN/pg_scripts/blob/main/generate_data.sql
generate_data.sqlhttps://patch-diff.githubusercontent.com/MygithubJN/pg_scripts/blob/main/generate_data.sql
idle_sessions_count.sqlhttps://patch-diff.githubusercontent.com/MygithubJN/pg_scripts/blob/main/idle_sessions_count.sql
idle_sessions_count.sqlhttps://patch-diff.githubusercontent.com/MygithubJN/pg_scripts/blob/main/idle_sessions_count.sql
idle_transactions.sqlhttps://patch-diff.githubusercontent.com/MygithubJN/pg_scripts/blob/main/idle_transactions.sql
idle_transactions.sqlhttps://patch-diff.githubusercontent.com/MygithubJN/pg_scripts/blob/main/idle_transactions.sql
index_analysis_and_bloat_estimate.sqlhttps://patch-diff.githubusercontent.com/MygithubJN/pg_scripts/blob/main/index_analysis_and_bloat_estimate.sql
index_analysis_and_bloat_estimate.sqlhttps://patch-diff.githubusercontent.com/MygithubJN/pg_scripts/blob/main/index_analysis_and_bloat_estimate.sql
index_size_usage_stats.sqlhttps://patch-diff.githubusercontent.com/MygithubJN/pg_scripts/blob/main/index_size_usage_stats.sql
index_size_usage_stats.sqlhttps://patch-diff.githubusercontent.com/MygithubJN/pg_scripts/blob/main/index_size_usage_stats.sql
insert_only_pg_stat_user_tables.sqlhttps://patch-diff.githubusercontent.com/MygithubJN/pg_scripts/blob/main/insert_only_pg_stat_user_tables.sql
insert_only_pg_stat_user_tables.sqlhttps://patch-diff.githubusercontent.com/MygithubJN/pg_scripts/blob/main/insert_only_pg_stat_user_tables.sql
last_tables_autovacuumed.sqlhttps://patch-diff.githubusercontent.com/MygithubJN/pg_scripts/blob/main/last_tables_autovacuumed.sql
last_tables_autovacuumed.sqlhttps://patch-diff.githubusercontent.com/MygithubJN/pg_scripts/blob/main/last_tables_autovacuumed.sql
list_10_largest_tables.sqlhttps://patch-diff.githubusercontent.com/MygithubJN/pg_scripts/blob/main/list_10_largest_tables.sql
list_10_largest_tables.sqlhttps://patch-diff.githubusercontent.com/MygithubJN/pg_scripts/blob/main/list_10_largest_tables.sql
list_10_worst_queries.sqlhttps://patch-diff.githubusercontent.com/MygithubJN/pg_scripts/blob/main/list_10_worst_queries.sql
list_10_worst_queries.sqlhttps://patch-diff.githubusercontent.com/MygithubJN/pg_scripts/blob/main/list_10_worst_queries.sql
list_all_sequences.sqlhttps://patch-diff.githubusercontent.com/MygithubJN/pg_scripts/blob/main/list_all_sequences.sql
list_all_sequences.sqlhttps://patch-diff.githubusercontent.com/MygithubJN/pg_scripts/blob/main/list_all_sequences.sql
list_all_sequences_column_owner.sqlhttps://patch-diff.githubusercontent.com/MygithubJN/pg_scripts/blob/main/list_all_sequences_column_owner.sql
list_all_sequences_column_owner.sqlhttps://patch-diff.githubusercontent.com/MygithubJN/pg_scripts/blob/main/list_all_sequences_column_owner.sql
list_collations.sqlhttps://patch-diff.githubusercontent.com/MygithubJN/pg_scripts/blob/main/list_collations.sql
list_collations.sqlhttps://patch-diff.githubusercontent.com/MygithubJN/pg_scripts/blob/main/list_collations.sql
list_comments.sqlhttps://patch-diff.githubusercontent.com/MygithubJN/pg_scripts/blob/main/list_comments.sql
list_comments.sqlhttps://patch-diff.githubusercontent.com/MygithubJN/pg_scripts/blob/main/list_comments.sql
list_db_views.sqlhttps://patch-diff.githubusercontent.com/MygithubJN/pg_scripts/blob/main/list_db_views.sql
list_db_views.sqlhttps://patch-diff.githubusercontent.com/MygithubJN/pg_scripts/blob/main/list_db_views.sql
list_enums.sqlhttps://patch-diff.githubusercontent.com/MygithubJN/pg_scripts/blob/main/list_enums.sql
list_enums.sqlhttps://patch-diff.githubusercontent.com/MygithubJN/pg_scripts/blob/main/list_enums.sql
list_indexes.sqlhttps://patch-diff.githubusercontent.com/MygithubJN/pg_scripts/blob/main/list_indexes.sql
list_indexes.sqlhttps://patch-diff.githubusercontent.com/MygithubJN/pg_scripts/blob/main/list_indexes.sql
list_long_running_queries.sqlhttps://patch-diff.githubusercontent.com/MygithubJN/pg_scripts/blob/main/list_long_running_queries.sql
list_long_running_queries.sqlhttps://patch-diff.githubusercontent.com/MygithubJN/pg_scripts/blob/main/list_long_running_queries.sql
list_partitioned_tables.sqlhttps://patch-diff.githubusercontent.com/MygithubJN/pg_scripts/blob/main/list_partitioned_tables.sql
list_partitioned_tables.sqlhttps://patch-diff.githubusercontent.com/MygithubJN/pg_scripts/blob/main/list_partitioned_tables.sql
list_schemata.sqlhttps://patch-diff.githubusercontent.com/MygithubJN/pg_scripts/blob/main/list_schemata.sql
list_schemata.sqlhttps://patch-diff.githubusercontent.com/MygithubJN/pg_scripts/blob/main/list_schemata.sql
list_single_column_multicolumn_index_counts.sqlhttps://patch-diff.githubusercontent.com/MygithubJN/pg_scripts/blob/main/list_single_column_multicolumn_index_counts.sql
list_single_column_multicolumn_index_counts.sqlhttps://patch-diff.githubusercontent.com/MygithubJN/pg_scripts/blob/main/list_single_column_multicolumn_index_counts.sql
list_table_object_dependencies.sqlhttps://patch-diff.githubusercontent.com/MygithubJN/pg_scripts/blob/main/list_table_object_dependencies.sql
list_table_object_dependencies.sqlhttps://patch-diff.githubusercontent.com/MygithubJN/pg_scripts/blob/main/list_table_object_dependencies.sql
list_tables_root_tables_no_fks.sqlhttps://patch-diff.githubusercontent.com/MygithubJN/pg_scripts/blob/main/list_tables_root_tables_no_fks.sql
list_tables_root_tables_no_fks.sqlhttps://patch-diff.githubusercontent.com/MygithubJN/pg_scripts/blob/main/list_tables_root_tables_no_fks.sql
list_tables_without_primary_key.sqlhttps://patch-diff.githubusercontent.com/MygithubJN/pg_scripts/blob/main/list_tables_without_primary_key.sql
list_tables_without_primary_key.sqlhttps://patch-diff.githubusercontent.com/MygithubJN/pg_scripts/blob/main/list_tables_without_primary_key.sql
lock_blocking_waiting_pg_locks.sqlhttps://patch-diff.githubusercontent.com/MygithubJN/pg_scripts/blob/main/lock_blocking_waiting_pg_locks.sql
lock_blocking_waiting_pg_locks.sqlhttps://patch-diff.githubusercontent.com/MygithubJN/pg_scripts/blob/main/lock_blocking_waiting_pg_locks.sql
max_connection.sqlhttps://patch-diff.githubusercontent.com/MygithubJN/pg_scripts/blob/main/max_connection.sql
max_connection.sqlhttps://patch-diff.githubusercontent.com/MygithubJN/pg_scripts/blob/main/max_connection.sql
multiple_row_updates.sqlhttps://patch-diff.githubusercontent.com/MygithubJN/pg_scripts/blob/main/multiple_row_updates.sql
multiple_row_updates.sqlhttps://patch-diff.githubusercontent.com/MygithubJN/pg_scripts/blob/main/multiple_row_updates.sql
per_table_options_reloptions_all_regular_tables.sqlhttps://patch-diff.githubusercontent.com/MygithubJN/pg_scripts/blob/main/per_table_options_reloptions_all_regular_tables.sql
per_table_options_reloptions_all_regular_tables.sqlhttps://patch-diff.githubusercontent.com/MygithubJN/pg_scripts/blob/main/per_table_options_reloptions_all_regular_tables.sql
percent_not_null.sqlhttps://patch-diff.githubusercontent.com/MygithubJN/pg_scripts/blob/main/percent_not_null.sql
percent_not_null.sqlhttps://patch-diff.githubusercontent.com/MygithubJN/pg_scripts/blob/main/percent_not_null.sql
pg_stat_activity_pg_locks.sqlhttps://patch-diff.githubusercontent.com/MygithubJN/pg_scripts/blob/main/pg_stat_activity_pg_locks.sql
pg_stat_activity_pg_locks.sqlhttps://patch-diff.githubusercontent.com/MygithubJN/pg_scripts/blob/main/pg_stat_activity_pg_locks.sql
pg_stat_database.sqlhttps://patch-diff.githubusercontent.com/MygithubJN/pg_scripts/blob/main/pg_stat_database.sql
pg_stat_database.sqlhttps://patch-diff.githubusercontent.com/MygithubJN/pg_scripts/blob/main/pg_stat_database.sql
pg_wait_sampling_queries.sqlhttps://patch-diff.githubusercontent.com/MygithubJN/pg_scripts/blob/main/pg_wait_sampling_queries.sql
pg_wait_sampling_queries.sqlhttps://patch-diff.githubusercontent.com/MygithubJN/pg_scripts/blob/main/pg_wait_sampling_queries.sql
pgbench_setup.shhttps://patch-diff.githubusercontent.com/MygithubJN/pg_scripts/blob/main/pgbench_setup.sh
pgbench_setup.shhttps://patch-diff.githubusercontent.com/MygithubJN/pg_scripts/blob/main/pgbench_setup.sh
psql_csv_output.txthttps://patch-diff.githubusercontent.com/MygithubJN/pg_scripts/blob/main/psql_csv_output.txt
psql_csv_output.txthttps://patch-diff.githubusercontent.com/MygithubJN/pg_scripts/blob/main/psql_csv_output.txt
random_between.sqlhttps://patch-diff.githubusercontent.com/MygithubJN/pg_scripts/blob/main/random_between.sql
random_between.sqlhttps://patch-diff.githubusercontent.com/MygithubJN/pg_scripts/blob/main/random_between.sql
readonly_table.sqlhttps://patch-diff.githubusercontent.com/MygithubJN/pg_scripts/blob/main/readonly_table.sql
readonly_table.sqlhttps://patch-diff.githubusercontent.com/MygithubJN/pg_scripts/blob/main/readonly_table.sql
relation_size.sqlhttps://patch-diff.githubusercontent.com/MygithubJN/pg_scripts/blob/main/relation_size.sql
relation_size.sqlhttps://patch-diff.githubusercontent.com/MygithubJN/pg_scripts/blob/main/relation_size.sql
relation_size_extended.sqlhttps://patch-diff.githubusercontent.com/MygithubJN/pg_scripts/blob/main/relation_size_extended.sql
relation_size_extended.sqlhttps://patch-diff.githubusercontent.com/MygithubJN/pg_scripts/blob/main/relation_size_extended.sql
relation_size_partitions_estimates.sqlhttps://patch-diff.githubusercontent.com/MygithubJN/pg_scripts/blob/main/relation_size_partitions_estimates.sql
relation_size_partitions_estimates.sqlhttps://patch-diff.githubusercontent.com/MygithubJN/pg_scripts/blob/main/relation_size_partitions_estimates.sql
scrub_email.sqlhttps://patch-diff.githubusercontent.com/MygithubJN/pg_scripts/blob/main/scrub_email.sql
scrub_email.sqlhttps://patch-diff.githubusercontent.com/MygithubJN/pg_scripts/blob/main/scrub_email.sql
scrub_email_batch.sqlhttps://patch-diff.githubusercontent.com/MygithubJN/pg_scripts/blob/main/scrub_email_batch.sql
scrub_email_batch.sqlhttps://patch-diff.githubusercontent.com/MygithubJN/pg_scripts/blob/main/scrub_email_batch.sql
show_server_version_num.sqlhttps://patch-diff.githubusercontent.com/MygithubJN/pg_scripts/blob/main/show_server_version_num.sql
show_server_version_num.sqlhttps://patch-diff.githubusercontent.com/MygithubJN/pg_scripts/blob/main/show_server_version_num.sql
soft_deletes_detection.sqlhttps://patch-diff.githubusercontent.com/MygithubJN/pg_scripts/blob/main/soft_deletes_detection.sql
soft_deletes_detection.sqlhttps://patch-diff.githubusercontent.com/MygithubJN/pg_scripts/blob/main/soft_deletes_detection.sql
table_bloat.sqlhttps://patch-diff.githubusercontent.com/MygithubJN/pg_scripts/blob/main/table_bloat.sql
table_bloat.sqlhttps://patch-diff.githubusercontent.com/MygithubJN/pg_scripts/blob/main/table_bloat.sql
table_stats.sqlhttps://patch-diff.githubusercontent.com/MygithubJN/pg_scripts/blob/main/table_stats.sql
table_stats.sqlhttps://patch-diff.githubusercontent.com/MygithubJN/pg_scripts/blob/main/table_stats.sql
table_with_column.sqlhttps://patch-diff.githubusercontent.com/MygithubJN/pg_scripts/blob/main/table_with_column.sql
table_with_column.sqlhttps://patch-diff.githubusercontent.com/MygithubJN/pg_scripts/blob/main/table_with_column.sql
tables_with_index_usage_counts.sqlhttps://patch-diff.githubusercontent.com/MygithubJN/pg_scripts/blob/main/tables_with_index_usage_counts.sql
tables_with_index_usage_counts.sqlhttps://patch-diff.githubusercontent.com/MygithubJN/pg_scripts/blob/main/tables_with_index_usage_counts.sql
terminate_backend.sqlhttps://patch-diff.githubusercontent.com/MygithubJN/pg_scripts/blob/main/terminate_backend.sql
terminate_backend.sqlhttps://patch-diff.githubusercontent.com/MygithubJN/pg_scripts/blob/main/terminate_backend.sql
top_10_tables_by_row_count.sqlhttps://patch-diff.githubusercontent.com/MygithubJN/pg_scripts/blob/main/top_10_tables_by_row_count.sql
top_10_tables_by_row_count.sqlhttps://patch-diff.githubusercontent.com/MygithubJN/pg_scripts/blob/main/top_10_tables_by_row_count.sql
top_10_tables_by_size.sqlhttps://patch-diff.githubusercontent.com/MygithubJN/pg_scripts/blob/main/top_10_tables_by_size.sql
top_10_tables_by_size.sqlhttps://patch-diff.githubusercontent.com/MygithubJN/pg_scripts/blob/main/top_10_tables_by_size.sql
top_updated_tables.sqlhttps://patch-diff.githubusercontent.com/MygithubJN/pg_scripts/blob/main/top_updated_tables.sql
top_updated_tables.sqlhttps://patch-diff.githubusercontent.com/MygithubJN/pg_scripts/blob/main/top_updated_tables.sql
vacuum_information_dead_tuples.sqlhttps://patch-diff.githubusercontent.com/MygithubJN/pg_scripts/blob/main/vacuum_information_dead_tuples.sql
vacuum_information_dead_tuples.sqlhttps://patch-diff.githubusercontent.com/MygithubJN/pg_scripts/blob/main/vacuum_information_dead_tuples.sql
view_extensions.sqlhttps://patch-diff.githubusercontent.com/MygithubJN/pg_scripts/blob/main/view_extensions.sql
view_extensions.sqlhttps://patch-diff.githubusercontent.com/MygithubJN/pg_scripts/blob/main/view_extensions.sql
waiting_queries.sqlhttps://patch-diff.githubusercontent.com/MygithubJN/pg_scripts/blob/main/waiting_queries.sql
waiting_queries.sqlhttps://patch-diff.githubusercontent.com/MygithubJN/pg_scripts/blob/main/waiting_queries.sql
READMEhttps://patch-diff.githubusercontent.com/MygithubJN/pg_scripts
https://patch-diff.githubusercontent.com/MygithubJN/pg_scripts#postgresql-scripts-pg_scripts
https://patch-diff.githubusercontent.com/MygithubJN/pg_scripts#general-tips
https://patch-diff.githubusercontent.com/MygithubJN/pg_scripts#psql
https://patch-diff.githubusercontent.com/MygithubJN/pg_scripts#names-and-descriptions
pg_stats docshttps://www.postgresql.org/docs/9.3/view-pg-stats.html
https://patch-diff.githubusercontent.com/MygithubJN/pg_scripts#links
Deep dive into postgres stats: pg_stat_all_tableshttps://dataegret.com/2017/04/deep-dive-into-postgres-stats-pg_stat_all_tables/
Flame explainhttps://flame-explain.com/visualize/input
pg_squeezehttps://github.com/cybertec-postgresql/pg_squeeze
Reduce disk bloat in PostgreSQLhttps://www.redpill-linpro.com/sysadvent/2017/12/08/pg_repack.html
Annotated.confhttps://github.com/jberkus/annotated.conf
Postgres Index stats and Query Optimizationhttps://sgerogia.github.io/Postgres-Index-And-Queries/
Some SQL Tricks of an Application DBAhttps://hakibenita.com/sql-tricks-application-dba
Lessons Learned From 5 Years of Scaling PostgreSQLhttps://onesignal.com/blog/lessons-learned-from-5-years-of-scaling-postgresql/
Understanding PostgreSQL Query Performancehttps://pgdash.io/blog/understanding-postgres-query-performance.html
The Unexpected Find That Freed 20GB of Unused Index Spacehttps://hakibenita.com/postgresql-unused-index-size#clearing-bloat-in-indexes
https://patch-diff.githubusercontent.com/MygithubJN/pg_scripts#write-rate
Crunchy Data Postgres Tipshttps://www.crunchydata.com/postgres-tips
https://patch-diff.githubusercontent.com/MygithubJN/pg_scripts#other-misc-tips
https://patch-diff.githubusercontent.com/MygithubJN/pg_scripts#administration
administrationhttps://patch-diff.githubusercontent.com/MygithubJN/pg_scripts/blob/main/administration
andyatkinson.com/postgresql-tipshttps://andyatkinson.com/postgresql-tips
Readme https://patch-diff.githubusercontent.com/MygithubJN/pg_scripts#readme-ov-file
Please reload this pagehttps://patch-diff.githubusercontent.com/MygithubJN/pg_scripts
Activityhttps://patch-diff.githubusercontent.com/MygithubJN/pg_scripts/activity
1 starhttps://patch-diff.githubusercontent.com/MygithubJN/pg_scripts/stargazers
0 watchinghttps://patch-diff.githubusercontent.com/MygithubJN/pg_scripts/watchers
0 forkshttps://patch-diff.githubusercontent.com/MygithubJN/pg_scripts/forks
Report repository https://patch-diff.githubusercontent.com/contact/report-content?content_url=https%3A%2F%2Fgithub.com%2FMygithubJN%2Fpg_scripts&report=MygithubJN+%28user%29
Releaseshttps://patch-diff.githubusercontent.com/MygithubJN/pg_scripts/releases
Packages 0https://patch-diff.githubusercontent.com/users/MygithubJN/packages?repo_name=pg_scripts
https://github.com
Termshttps://docs.github.com/site-policy/github-terms/github-terms-of-service
Privacyhttps://docs.github.com/site-policy/privacy-policies/github-privacy-statement
Securityhttps://github.com/security
Statushttps://www.githubstatus.com/
Communityhttps://github.community/
Docshttps://docs.github.com/
Contacthttps://support.github.com?tags=dotcom-footer

Viewport: width=device-width

URLs of crawlers that visited me.