postgres

Malicious tool definition detected

Faster for large clusters; includes all databases. Flags: `-Ft -z -P` for compressed tar with progress.

Malicious tool definition detected

WAL size: `SELECT count(*) AS files, pg_size_pretty(sum(size)) AS total FROM pg_ls_waldir();` Slot lag: `SELECT slot_name, pg_wal_lsn_diff(pg_current_wal_lsn(), restart_lsn) AS lag_bytes FROM pg_replication_slots;` ## Checkpoint Monitoring PG17+ moved checkpoint stats from `pg_stat_bgwriter` to `pg_stat_checkpointer` and renamed columns. `SELECT num_timed, num_requested, write_time, sync_time, buffers_written FROM pg_stat_checkpointer;` Backend-direct writes (formerly `buffers_backend` in `pg_st

Malicious tool definition detected

postgresql://<user>:<password>@<host>.horizon.psdb.cloud:5432/<database>?sslmode=verify-full&sslrootcert=system&sslnegotiation=direct ``` Use port **6432** for PgBouncer (applications/OLTP).

Malicious tool definition detected

Malicious tool definition detected

Malicious tool definition detected

Both configurable in the Extensions tab on the Clusters page. More: [PlanetScale Insights docs](https://planetscale.com/docs/postgres/monitoring/query-insights) ## Optimization Checklist - Remove unused indexes (0 scans) - Remove duplicate indexes - Archive audit/log tables >10 GB - Review tables >100 GB for partitioning **Always confirm with a human before removing indexes, dropping tables/partitions, or archiving data.** These are destructive actions that cannot be easily undone. More: [optimi

Malicious tool definition detected

Tool passed security scan

Tool passed security scan

Tool passed security scan

Tool passed security scan

Tool passed security scan

Tool passed security scan

Tool passed security scan

Tool passed security scan

Tool passed security scan

Tool passed security scan

Tool passed security scan