SimpleBackups

The SimpleBackups Blog

News, tips, guides and tools by the creators of SimpleBackups web

How to find long-running queries in PostgreSQL

Latest Post

How to find long-running queries in PostgreSQL

November 23, 2023

Find long-running PostgreSQL queries with pg_stat_activity, inspect the locks and execution plans behind them, then cancel or terminate them safely.

Read more →

How to List Indexes in PostgreSQL and Related Commands

How to List Indexes in PostgreSQL and Related Commands

November 23, 2023

List PostgreSQL indexes from psql or with SQL queries on pg_indexes: filter by table, read each index definition, and check how much space an index uses.

How to List Schemas in PostgreSQL and Related Commands

How to List Schemas in PostgreSQL and Related Commands

November 22, 2023

Three ways to list schemas in PostgreSQL, with psql, a catalog query and pgAdmin, plus how to read a single table's structure and check schema sizes.

Understanding Postgres Roles & Privileges

Understanding Postgres Roles & Privileges

November 21, 2023

How PostgreSQL roles differ from users, the split between user roles and group roles, how to grant and revoke privileges, and how inheritance resolves them.

How to check PostgreSQL version

How to check PostgreSQL version

November 21, 2023

Check your PostgreSQL version on Linux, macOS, Windows or in pgAdmin, with the commands for each and what to do when psql is not on your PATH.

 The Latest Trends in Database Backup and Recovery Solutions

The Latest Trends in Database Backup and Recovery Solutions

November 17, 2023

Where database backup and recovery is heading: AI and machine learning inside the backup process, and what changes as data sources grow in volume and variety.

Understanding RTO and RPO in Backup Strategies

Understanding RTO and RPO in Backup Strategies

November 17, 2023

RTO is how fast you get a process back. RPO is how much data you can afford to lose. What the difference means in practice, and how to set each of them.

MongoDB vs MySQL: A Comprehensive Comparison

MongoDB vs MySQL: A Comprehensive Comparison

November 16, 2023

MongoDB and MySQL compared: BSON documents in schema-less collections against tables, rows and JOINs, MQL against SQL, and which fits which workload.

5 Best MySQL GUI Tools in 2024

5 Best MySQL GUI Tools in 2024

November 16, 2023

Five MySQL GUI tools compared, from MySQL Workbench to Sequel Pro, with the strengths and drawbacks of each for queries, schema design and administration.

MySQL vs PostgreSQL: A Comprehensive Comparison of the Most Popular Databases

MySQL vs PostgreSQL: A Comprehensive Comparison of the Most Popular Databases

November 14, 2023

MySQL is relational, PostgreSQL is object-relational. What that changes for arrays, JSON and custom types, and how the two compare on the rest of the ground.