start.psql

\ir warmup.psql
\echo '\033[1;35mMenu:\033[0m'
\echo '   0 – Node and current database information: primary/replica, lag, database size, temporary files, etc.'
\echo '   1 – Databases: size, stats'
\echo '   2 – Tables: table/index/TOAST size, number of rows'
\echo '   3 – Table Stats'
\echo '  a1 – Current activity: count of current connections grouped by database, username, state'
\echo '  a2 – Queries running more than "N" seconds (Type the number of seconds)'
\echo '  a3 – Connection capacity: usage, remaining slots and reserved slots'
\echo '  a4 – Risky sessions: blocked, active >30s, transaction >5m or idle-in-transaction >1m'
\echo '  b1 – Table bloat (estimated)'
\echo '  b2 – B-tree index bloat (estimated)'
\echo '  b3 – Table bloat (requires pgstattuple; expensive)'
\echo '  b4 – B-tree indexes bloat (requires pgstattuple; expensive)'
\echo '  b5 – Tables and columns without stats (so bloat cannot be estimated)'
\echo '  b6 – Table bloat, approximate (requires pgstattuple; moderate cost)'
\echo '  e1 – Extensions installed in current database'
\echo '  i1 – Unused and rarely used indexes'
\echo '  i2 – Redundant indexes'
\echo '  i3 – Duplicate indexes'
\echo '  i4 – Invalid indexes'
\echo '  i5 – Cleanup unused and redundant indexes – DO & UNDO migration DDL'
\echo '  i6 – Foreign keys with missing or bad indexes'
\echo '  i7 – Tables without primary keys, ordered by total size'
\echo '  k1 – Cancel Statement (pg_cancel_backend)'
\echo '  k2 – Terminate Session (pg_terminate_backend)'
\echo '  l1 – Lock trees (lightweight)'
\echo '  l2 – Lock trees, detailed (based on pg_blocking_pids())'
\echo '  p1 – Index (re)creation progress (CREATE INDEX / REINDEX)'
\echo '  r1 – Replication status for primary or replica'
\echo '  r2 – Replication slots: state, retained WAL and transaction horizons'
\echo '  s1 – Slowest queries by total time (PG 9.6+; requires pg_stat_statements)'
\echo '  s2 – Slowest queries report (PG 9.6+; requires pg_stat_statements)'
\echo '  t1 – Postgres parameters'
\echo '  t2 – Storage parameters explicitly set on relations'
\echo '  u1 – Create user with random password (interactive)'
\echo '  u2 – Alter user with random password (interactive)'
\echo '  v1 – Vacuum: running operations (detailed progress)'
\echo '  v2 – VACUUM progress and autovacuum queue'
\echo '  v3 – Transaction ID wraparound risk by database and table'
\echo '  x1 – Alignment padding: bytes saved by reordering columns'
\echo '   q – Quit'
\echo
\echo Type your choice and press <Enter>:
\prompt d_step_unq
\set d_stp '\'' :d_step_unq '\''
select
:d_stp::text = '0' as d_step_is_0,
:d_stp::text = '1' as d_step_is_1,
:d_stp::text = '2' as d_step_is_2,
:d_stp::text = '3' as d_step_is_3,
:d_stp::text = 'a1' as d_step_is_a1,
:d_stp::text = 'a2' as d_step_is_a2,
:d_stp::text = 'a3' as d_step_is_a3,
:d_stp::text = 'a4' as d_step_is_a4,
:d_stp::text = 'b1' as d_step_is_b1,
:d_stp::text = 'b2' as d_step_is_b2,
:d_stp::text = 'b3' as d_step_is_b3,
:d_stp::text = 'b4' as d_step_is_b4,
:d_stp::text = 'b5' as d_step_is_b5,
:d_stp::text = 'b6' as d_step_is_b6,
:d_stp::text = 'e1' as d_step_is_e1,
:d_stp::text = 'i1' as d_step_is_i1,
:d_stp::text = 'i2' as d_step_is_i2,
:d_stp::text = 'i3' as d_step_is_i3,
:d_stp::text = 'i4' as d_step_is_i4,
:d_stp::text = 'i5' as d_step_is_i5,
:d_stp::text = 'i6' as d_step_is_i6,
:d_stp::text = 'i7' as d_step_is_i7,
:d_stp::text = 'k1' as d_step_is_k1,
:d_stp::text = 'k2' as d_step_is_k2,
:d_stp::text = 'l1' as d_step_is_l1,
:d_stp::text = 'l2' as d_step_is_l2,
:d_stp::text = 'p1' as d_step_is_p1,
:d_stp::text = 'r1' as d_step_is_r1,
:d_stp::text = 'r2' as d_step_is_r2,
:d_stp::text = 's1' as d_step_is_s1,
:d_stp::text = 's2' as d_step_is_s2,
:d_stp::text = 't1' as d_step_is_t1,
:d_stp::text = 't2' as d_step_is_t2,
:d_stp::text = 'u1' as d_step_is_u1,
:d_stp::text = 'u2' as d_step_is_u2,
:d_stp::text = 'v1' as d_step_is_v1,
:d_stp::text = 'v2' as d_step_is_v2,
:d_stp::text = 'v3' as d_step_is_v3,
:d_stp::text = 'x1' as d_step_is_x1,
:d_stp::text = 'q' as d_step_is_q \gset
\if :d_step_is_q
  \echo 'Bye!'
  \echo
\elif :d_step_is_0
  \ir ./sql/0_node.sql
  \prompt 'Press <Enter> to continue…' d_dummy
  \ir ./start.psql
\elif :d_step_is_1
  \ir ./sql/1_databases.sql
  \prompt 'Press <Enter> to continue…' d_dummy
  \ir ./start.psql
\elif :d_step_is_2
  \ir ./sql/2_table_sizes.sql
  \prompt 'Press <Enter> to continue…' d_dummy
  \ir ./start.psql
\elif :d_step_is_3
  \ir ./sql/3_table_stats.sql
  \prompt 'Press <Enter> to continue…' d_dummy
  \ir ./start.psql
\elif :d_step_is_a1
  \ir ./sql/a1_activity.sql
  \prompt 'Press <Enter> to continue…' d_dummy
  \ir ./start.psql
\elif :d_step_is_a2
  \ir ./sql/a2_queries_runing_n_seconds.sql
  \prompt 'Press <Enter> to continue…' d_dummy
  \ir ./start.psql
\elif :d_step_is_a3
  \ir ./sql/a3_connection_capacity.sql
  \prompt 'Press <Enter> to continue…' d_dummy
  \ir ./start.psql
\elif :d_step_is_a4
  \ir ./sql/a4_session_risks.sql
  \prompt 'Press <Enter> to continue…' d_dummy
  \ir ./start.psql
\elif :d_step_is_b1
  \ir ./sql/b1_table_estimation.sql
  \prompt 'Press <Enter> to continue…' d_dummy
  \ir ./start.psql
\elif :d_step_is_b2
  \ir ./sql/b2_btree_estimation.sql
  \prompt 'Press <Enter> to continue…' d_dummy
  \ir ./start.psql
\elif :d_step_is_b3
  \ir ./sql/b3_table_pgstattuple.sql
  \prompt 'Press <Enter> to continue…' d_dummy
  \ir ./start.psql
\elif :d_step_is_b4
  \ir ./sql/b4_btree_pgstattuple.sql
  \prompt 'Press <Enter> to continue…' d_dummy
  \ir ./start.psql
\elif :d_step_is_b5
  \ir ./sql/b5_tables_no_stats.sql
  \prompt 'Press <Enter> to continue…' d_dummy
  \ir ./start.psql
\elif :d_step_is_b6
  \ir ./sql/b6_table_bloat_approx.sql
  \prompt 'Press <Enter> to continue…' d_dummy
  \ir ./start.psql
\elif :d_step_is_e1
  \ir ./sql/e1_extensions.sql
  \prompt 'Press <Enter> to continue…' d_dummy
  \ir ./start.psql
\elif :d_step_is_i1
  \ir ./sql/i1_rare_indexes.sql
  \prompt 'Press <Enter> to continue…' d_dummy
  \ir ./start.psql
\elif :d_step_is_i2
  \ir ./sql/i2_redundant_indexes.sql
  \prompt 'Press <Enter> to continue…' d_dummy
  \ir ./start.psql
\elif :d_step_is_i3
  \ir ./sql/i3_duplicate_indexes.sql
  \prompt 'Press <Enter> to continue…' d_dummy
  \ir ./start.psql
\elif :d_step_is_i4
  \ir ./sql/i4_invalid_indexes.sql
  \prompt 'Press <Enter> to continue…' d_dummy
  \ir ./start.psql
\elif :d_step_is_i5
  \ir ./sql/i5_indexes_migration.sql
  \prompt 'Press <Enter> to continue…' d_dummy
  \ir ./start.psql
\elif :d_step_is_i6
  \ir ./sql/i6_non_indexed_fks.sql
  \prompt 'Press <Enter> to continue…' d_dummy
  \ir ./start.psql
\elif :d_step_is_i7
  \ir ./sql/i7_tables_without_primary_keys.sql
  \prompt 'Press <Enter> to continue…' d_dummy
  \ir ./start.psql
\elif :d_step_is_k1
  \ir ./sql/k1_cancel_pid.sql
  \prompt 'Press <Enter> to continue…' d_dummy
  \ir ./start.psql
\elif :d_step_is_k2
  \ir ./sql/k2_terminate_pid.sql
  \prompt 'Press <Enter> to continue…' d_dummy
  \ir ./start.psql
\elif :d_step_is_l1
  \ir ./sql/l1_lock_trees.sql
  \prompt 'Press <Enter> to continue…' d_dummy
  \ir ./start.psql
\elif :d_step_is_l2
  \ir ./sql/l2_lock_trees.sql
  \prompt 'Press <Enter> to continue…' d_dummy
  \ir ./start.psql
\elif :d_step_is_p1
  \ir ./sql/p1_index_create_progress.sql
  \prompt 'Press <Enter> to continue…' d_dummy
  \ir ./start.psql
\elif :d_step_is_r1
  \ir ./sql/r1_replication_status.sql
  \prompt 'Press <Enter> to continue…' d_dummy
  \ir ./start.psql
\elif :d_step_is_r2
  \ir ./sql/r2_replication_slots.sql
  \prompt 'Press <Enter> to continue…' d_dummy
  \ir ./start.psql
\elif :d_step_is_s1
  \ir ./sql/s1_pg_stat_statements_top_total.sql
  \prompt 'Press <Enter> to continue…' d_dummy
  \ir ./start.psql
\elif :d_step_is_s2
  \ir ./sql/s2_pg_stat_statements_report.sql
  \prompt 'Press <Enter> to continue…' d_dummy
  \ir ./start.psql
\elif :d_step_is_t1
  \ir ./sql/t1_parameters.sql
  \prompt 'Press <Enter> to continue…' d_dummy
  \ir ./start.psql
\elif :d_step_is_t2
  \ir ./sql/t2_storage_parameters.sql
  \prompt 'Press <Enter> to continue…' d_dummy
  \ir ./start.psql
\elif :d_step_is_u1
  \ir ./sql/u1_create_user_with_random_password.sql
  \prompt 'Press <Enter> to continue…' d_dummy
  \ir ./start.psql
\elif :d_step_is_u2
  \ir ./sql/u2_alter_user_with_random_password.sql
  \prompt 'Press <Enter> to continue…' d_dummy
  \ir ./start.psql
\elif :d_step_is_v1
  \ir ./sql/v1_vacuum_activity.sql
  \prompt 'Press <Enter> to continue…' d_dummy
  \ir ./start.psql
\elif :d_step_is_v2
  \ir ./sql/v2_autovacuum_progress_and_queue.sql
  \prompt 'Press <Enter> to continue…' d_dummy
  \ir ./start.psql
\elif :d_step_is_v3
  \ir ./sql/v3_wraparound_risk.sql
  \prompt 'Press <Enter> to continue…' d_dummy
  \ir ./start.psql
\elif :d_step_is_x1
  \ir ./sql/x1_alignment_padding.sql
  \prompt 'Press <Enter> to continue…' d_dummy
  \ir ./start.psql
\else
  \echo
  \echo '\033[1;31mError:\033[0m Unknown option! Try again.'
  \echo
  \ir ./start.psql
\endif