Path Lines of Code README.md 1 mysql/diag/sql/blocking-sessions.sql 27 mysql/diag/sql/gen-kill-queries-command.sql 28 mysql/diag/sql/gen-kill-sessions-command.sql 28 mysql/diag/sql/idx-btree-whr-not-unque-redundancy.sql 58 mysql/diag/sql/innodb-table-whr-tablespace.sql 10 mysql/diag/sql/space-allocation.sql 9 mysql/diag/sql/table-whr-pk-columns.sql 18 mysql/diag/sql/table-whr-pk-missing.sql 32 mysql/diag/sql/table-whr-pk.sql 29 mysql/diag/sql/tables-whr-autoincrement.sql 21 mysql/diag/sql/tables-whr-no-autoincrement.sql 21 oracle-ee/diag/sql/blocking-sessions-last-1-hour.sql 20 oracle-ee/diag/sql/session-sql-waits-last-1-hour.sql 20 oracle/diag/sql/blocking-sessions.sql 20 oracle/diag/sql/constraints-whr-table.sql 122 oracle/diag/sql/expensive-sql.sql 33 oracle/diag/sql/explain-sql-whr-sql_id.sql 6 oracle/diag/sql/gen-kill-command-whr-sid.sql 12 oracle/diag/sql/hello-world.sql 1 oracle/diag/sql/indexes-whr-table.sql 41 oracle/diag/sql/longops-whr-sid.sql 21 oracle/diag/sql/oracle-12-patch-list-verbose.sql 2 oracle/diag/sql/oracle-12-patch-list.sql 5 oracle/diag/sql/perm-tablespace-space.sql 20 oracle/diag/sql/recommend-redolog-size-count.sql 24 oracle/diag/sql/session-sql-waits.sql 21 oracle/diag/sql/session-wait-summary.sql 16 oracle/diag/sql/session-whr-sid.sql 25 oracle/diag/sql/sessions-using-temp-space.sql 29 oracle/diag/sql/sessions-whr-sql_id.sql 35 oracle/diag/sql/sessions-whr-username.sql 35 oracle/diag/sql/sessions-whr-wait_event.sql 35 oracle/diag/sql/sql-text-whr-sql_id.sql 14 oracle/diag/sql/temp-tablespace-space.sql 14 postgres/README.md 30 postgres/diag/sql/grants-whr-table.sql 4 postgres/diag/sql/list-all-settings.sql 3 postgres/diag/sql/list-btree-bloat.sql 67 postgres/diag/sql/list-databases-size.sql 20 postgres/diag/sql/list-functions.sql 32 postgres/diag/sql/list-lock-dependency-info.sql 37 postgres/diag/sql/list-roles.sql 13 postgres/diag/sql/list-sessions-blocking-others.sql 22 postgres/diag/sql/list-sessions.sql 18 postgres/diag/sql/list-tables-age.sql 25 postgres/diag/sql/list-tables-bloated.sql 50 postgres/diag/sql/list-tables-with-dead-tuples.sql 13 postgres/diag/sql/list-top10-lowest-buffer-hit-ratio-per-query.sql 8 postgres/diag/sql/repl-database-conflicts.sql 1 postgres/diag/sql/repl-session.sql 1 postgres/diag/sql/repl-slots.sql 1 postgres/diag/sql/repl-wal-receiver.sql 1 postgres/diag/sql/repl-xmin-from-activity.sql 1 postgres/diag/sql/stat-archiver.sql 1 postgres/diag/sql/top30-tables-with-low-hotupdates.sql 8 postgres/diag/stats_snapshot/README.md 65 postgres/diag/stats_snapshot/pg_stat_all_tables_history_track.sql 226 postgres/diag/stats_snapshot/reset.sql 2 postgres/diag/stats_snapshot/setup.sql 125 postgres/diag/stats_snapshot/views/vw_stat_all_indexes_history.sql 35 postgres/diag/stats_snapshot/views/vw_stat_all_tables_history.sql 121 postgres/diag/stats_snapshot/views/vw_stat_statement_history.sql 92 postgres/diag/stats_snapshot/views/vw_statio_all_indexes_history.sql 29 postgres/diag/stats_snapshot/views/vw_statio_all_tables_history.sql 60 postgres/img/pg_logo.svg 20 serverless/mysql-insert.sql 28 serverless/postgresql-insert.sql 11 serverless/serverless-query-cfn.json 184