HariSekhon / SQL-scripts
100+ SQL Scripts - PostgreSQL, MySQL, Google BigQuery, MariaDB, AWS Athena. DBA, Analytics, DevOps, performance engineering. Google BigQuery ML machine learning classification.
☆375Updated 2 weeks ago
Related projects: ⓘ
- PostgreSQL DBA scripts☆62Updated 3 years ago
- The missing set of useful tools for Postgres DBAs and all engineers☆1,038Updated last year
- PostgreSQL Monitoring, Metrics Collection and Alerting Resources from Crunchy Data☆563Updated this week
- Query Performance Monitoring Tool for PostgreSQL☆467Updated 3 weeks ago
- Collect and display information and stats from a running PostgreSQL server☆949Updated last month
- Queries to mesure statistical bloat in indexes and tables for PostgreSQL☆508Updated 2 years ago
- Scan PostgreSQL Instance for potential problems. pg_gather is a SQL-only script leveraging the built-in features of psql.☆125Updated last week
- PostgreSQL Remote Control☆452Updated 2 weeks ago
- This repository contains a number of UNIX scripts, and PostgreSQL queries. The author, Melvin Davidson, originally distributed them on th…☆46Updated 9 years ago
- PG Collector for Postgresql is a sql script that gathers valuable database information and presents it in a consolidated HTML file which …☆74Updated last week
- Command-line admin tool for observing and troubleshooting Postgres.☆1,539Updated 4 months ago
- Copy a Postgres database to a target Postgres server (pg_dump | pg_restore on steroids)☆1,142Updated last week
- A simple set of views to see ALL permissions in a PostgreSQL database☆144Updated 3 months ago
- A PostgreSQL logical decoder output plugin to deliver data as Protocol Buffers, used by Debezium (http://debezium.io). Please log issues …☆244Updated last week
- pganalyze statistics collector for gathering PostgreSQL metrics and log data☆333Updated last week
- PostgreSQL metrics monitor/dashboard☆1,796Updated this week
- Logical Replication extension for PostgreSQL 15, 14, 13, 12, 11, 10, 9.6, 9.5, 9.4 (Postgres), providing much faster replication than Slo…☆989Updated last month
- pg_timetable: Advanced scheduling for PostgreSQL☆1,076Updated last month
- The "orafce" project implements in Postgres some of the functions from the Oracle database that are missing (or behaving differently).Tho…☆483Updated 3 weeks ago
- PostgreSQL ASH Viewer (PASH Viewer) provides graphical view of active session history data within the PostgreSQL database☆119Updated 2 years ago
- Show query plans of all currently running SQL statements☆186Updated last week
- Presentation materials for the Annotated.Conf Tutorial☆260Updated 6 years ago
- PostgreSQL Audit Extension☆1,304Updated 2 weeks ago
- A PostgreSQL extension for automatic bloat cleanup☆453Updated 3 weeks ago
- pgquarrel compares PostgreSQL database schemas (DDL)☆389Updated last year
- Postgres features showcase (commented SQL samples) for beginners☆165Updated 4 years ago
- A curated list of awesome PostgreSQL software, libraries, tools and resources, forked from dhamaniasad/awesome-postgres☆133Updated 3 months ago
- A PostgreSQL extension for collecting statistics about predicates, helping find what indices are missing☆274Updated last month
- Backup and recovery manager for PostgreSQL☆706Updated last week
- A collection of useful little scripts for database analysis and administration, created by our team at PostgreSQL Experts.☆1,368Updated last year