Postgres Scripts
open-menu closeme
Home
About
Contact Us
Privacy Satement
🌐
English Português
rss
  • Keep Your PostgreSQL Database Clean, Identify Idle Connections

    calendar Apr 7, 2024 / Sep 14, 2025 · 3 min read · pg_stat_activity postgresql database performance  ·
    Share on: twitter facebook linkedin copy

    Identify Idle PostgreSQL Connections: Keep Your Database Clean This blog post equips you with the knowledge to identify and potentially terminate stale connections within your PostgreSQL database. We'll delve into the provided SQL code, explain its purpose, and offer valuable insights for maintaining optimal database …


    Read More
  • Optimize Your PostgreSQL Queries, Index Cardinality

    calendar Apr 6, 2024 / Sep 14, 2025 · 3 min read · pg_class postgresql database performance indexing  ·
    Share on: twitter facebook linkedin copy

    PostgreSQL Index Cardinality: A Guide to Understanding Index Efficiency This blog post delves into the world of PostgreSQL index cardinality, a crucial metric for optimizing database performance. We'll dissect the provided SQL code, explain its purpose, and equip you with valuable insights to make informed decisions …


    Read More
  • Unveiling Your PostgreSQL Server - A Diagnostic Powerhouse

    calendar Apr 4, 2024 / Sep 14, 2025 · 6 min read · postgresql database server administration monitoring  ·
    Share on: twitter facebook linkedin copy

    Unveiling Your PostgreSQL Server: A Treasure Trove of Information This comprehensive PostgreSQL script delves into the inner workings of your database server, revealing valuable details about its version, configuration, connections, users, and more. It empowers database administrators and developers with insights to …


    Read More
  • Identify Underutilized Columns in PostgreSQL for Schema Optimization

    calendar Apr 3, 2024 / Sep 14, 2025 · 4 min read · PostgreSQL Database Administration Database Schema pg_class pg_namespace pg_attribute pg_type pg_statistic  ·
    Share on: twitter facebook linkedin copy

    Identifying Underutilized Columns in Your PostgreSQL Database Keeping your PostgreSQL database clean and efficient is crucial for optimal performance. One way to achieve this is by identifying and potentially removing "useless" columns – those that hold minimal or redundant data. This article explores a PostgreSQL code …


    Read More
  • Assess PostgreSQL Database Sizes Quickly and Easily

    calendar Apr 2, 2024 / Sep 14, 2025 · 2 min read · PostgreSQL Database Administration Performance Optimization Storage Management pg_database_size pg_size_pretty  ·
    Share on: twitter facebook linkedin copy

    Quickly Assess Your PostgreSQL Database Landscape by Size Managing multiple PostgreSQL databases requires an understanding of their storage footprint. This article introduces a simple yet effective PostgreSQL code snippet that helps you quickly determine the size of each database in your system, ordered by their …


    Read More
  • List and Organize Your PostgreSQL Databases by Size (With Access Check)

    calendar Apr 1, 2024 / Sep 14, 2025 · 3 min read · postgresql database optimization query pg_database  ·
    Share on: twitter facebook linkedin copy

    List Your PostgreSQL Databases by Size (With Access Check) Keeping your PostgreSQL database server organized is crucial for optimal performance and manageability. A critical aspect of this organization is understanding the storage footprint of each database. This SQL code snippet empowers you to efficiently retrieve a …


    Read More
  • Identifying Blocking PostgreSQL Queries using pg_stat_activity

    calendar Mar 25, 2024 / Sep 14, 2025 · 3 min read · pg_blocking_pids pg_stat_activity postgresql locks database performance database administration  ·
    Share on: twitter facebook linkedin copy

    Identifying Blocking PostgreSQL Queries: A Guide for Database Administrators This article explores a PostgreSQL query designed to identify currently blocked database queries and the processes (identified by PIDs) responsible for blocking them. This information is crucial for database administrators troubleshooting …


    Read More
  • PostgreSQL query to find columns containing only NULL values

    calendar Mar 24, 2024 / Sep 14, 2025 · 3 min read · postgresql database optimization database schema design database administration pg_class pg_namespace pg_attribute pg_type pg_statistic  ·
    Share on: twitter facebook linkedin copy

    Identifying Null-Only Columns in PostgreSQL This article explores a valuable PostgreSQL query for database administrators. It helps identify columns within your database tables that exclusively contain NULL values. Uncovering these "null-only" columns can be a key step in optimizing storage usage and streamlining your …


    Read More
  • Monitoring Active Queries in PostgreSQL for Performance Optimization

    calendar Mar 22, 2024 / Sep 14, 2025 · 3 min read · postgresql performance monitoring optimization database pg_stat_activity  ·
    Share on: twitter facebook linkedin copy

    Monitoring Active Queries in PostgreSQL for Performance Optimization Introduction Ensuring smooth database performance is crucial for modern applications. In PostgreSQL, the number of active queries can significantly impact responsiveness. This article explores a PostgreSQL query that effectively counts active queries, …


    Read More
  • Identify Blocking Queries in PostgreSQL & Keep Your Database Running Smoothly using pg_stat_activity

    calendar Mar 21, 2024 / Sep 14, 2025 · 3 min read · postgresql performance optimization troubleshooting pg_stat_activity  ·
    Share on: twitter facebook linkedin copy

    Identifying Blocking Queries in PostgreSQL: Keeping Your Database Running Smoothly Have you ever encountered sluggish performance in your PostgreSQL database? One culprit could be blocking queries. These are queries that are waiting on resources held by other queries, creating a chain reaction that slows everything …


    Read More
    • ««
    • «
    • 1
    • 2
    • 3
    • 4
    • »
    • »»

PostgresScripts.com

Your Source for PostgreSQL Database SQL Scripts
Read More

Recent Posts

  • PostgreSQL Authentication Settings Query for Admins
  • Understanding PostgreSQL pg_settings and pg_file_settings with Practical Examples
  • Monitoring PostgreSQL Active Sessions with pg_stat_activity Explained
  • Monitor Running Queries in PostgreSQL using pg_stat_activity
  • Restarting All PostgreSQL Sequences with SQL Script using Alter Sequence and pg_class
  • How to Identify and Monitor Slow Queries in PostgreSQL: A Practical Guide
  • How to Analyze PostgreSQL Query Cache-Hit Ratio Using pg_stat_statements
  • PostgreSQL Lock Monitoring Uncover Query Details and Lock Age

Categories

SCRIPTS 37 ADMINISTRATION STATUS 21 ADMINISTRATION SESSION 9 PERFORMANCE QUERY TUNING 5 PERFORMANCE LOCKS DDL 4 PERFORMANCE LOCKS DML 4 PERFORMANCE STATISTICS 4 STRUCTURE INDEXES 4 PERFORMANCE MONITORING 3 POSTGRESQL COMMANDS 3 POSTGRESQL STRUCTURE INDEXES 3 ADMINISTRATION INIT PARAMETERS 1 BACKUP AND RECOVERY 1 BACKUP IMPORT EXPORT 1
All Categories
ADMINISTRATION INIT PARAMETERS1 ADMINISTRATION SESSION9 ADMINISTRATION STATUS21 BACKUP AND RECOVERY1 BACKUP IMPORT EXPORT1 BACKUP PG_DUMP1 PEFORMANCE MEMORY1 PERFORMANCE GENERAL1 PERFORMANCE LOCKS DDL4 PERFORMANCE LOCKS DML4 PERFORMANCE MEMORY1 PERFORMANCE MONITORING3 PERFORMANCE QUERY TUNING5 PERFORMANCE STATISTICS4 PERFORMANCE STATSTICS1 POSTGRESQL COMMANDS3 POSTGRESQL STRUCTURE INDEXES3 SCRIPTS37 STRUCTURE INDEXES4
[A~Z][0~9]

Series

ADMIN-GUIDE 3

Tags

POSTGRESQL 35 DATABASE 28 PERFORMANCE 22 OPTIMIZATION 13 SQL 13 PG_STAT_ACTIVITY 11 MONITORING 7 DATABASE ADMINISTRATION 5 PG_CLASS 5 INDEXING 4 PG_LOCKS 4 TROUBLESHOOTING 4 ADMINISTRATION 3 DATABASE PERFORMANCE 3
All Tags
ADMINISTRATION3 ANALYZE1 AUTHENTICATION1 AUTOMATION1 BACKUP1 CACHING1 COMMAND-LINE1 CONFIGURATION1 DATABASE28 DATABASE ADMINISTRATION5 DATABASE MANAGEMENT1 DATABASE OPTIMIZATION1 DATABASE PERFORMANCE3 DATABASE SCHEMA1 DATABASE SCHEMA DESIGN1 DATABASE-MAINTENANCE1 DATABASE-TUNING1 DBA-TIPS1 IMPORT1 INDEXING4 LOCKS2 MONITOR RUNNING QUERIES2 MONITORING7 OPTIMIZATION13 PERFORMANCE22 PERFORMANCE OPTIMIZATION2 PG_ATTRIBUTE2 PG_BACKUP_START_TIME1 PG_BLOCKING_PIDS1 PG_CATALOG1 PG_CLASS5 PG_DATABASE1 PG_DATABASE_SIZE1 PG_DUMP1 PG_FILE_SETTINGS1 PG_INDEXES1 PG_IS_IN_BACKUP1 PG_IS_IN_RECOVERY1 PG_LOCKS4 PG_NAMESPACE2 PG_SETTINGS2 PG_SIZE_PRETTY1 PG_STAT_ACTIVITY11 PG_STAT_ALL_INDEXES1 PG_STAT_DATABASE1 PG_STAT_STATEMENTS3 PG_STAT_USER_TABLES3 PG_STATIO_USER_INDEXES1 PG_STATISTIC2 PG_TABLESPACE1 PG_TYPE2 POSTGRES CONFIGURATION1 POSTGRES-SEQUENCES1 POSTGRESQL35 POSTGRESQL LOCKS1 POSTGRESQL-SCRIPTING1 PSQL1 QUERIES2 QUERY2 RECOVERY1 SECURITY1 SERVER1 SHOW1 SQL13 SQL SCRIPTS1 STORAGE1 STORAGE MANAGEMENT1 TROUBLESHOOTING4 TUNING2 VACUUM1
[A~Z][0~9]
PostgresScripts.com

Copyright  POSTGRESSCRIPTS.COM. All Rights Reserved

to-top