pg

const ActiveConnectionsQuery = `
/*dbtune*/
SELECT COUNT(*) AS active_connections
FROM pg_stat_activity
WHERE state = 'active'
`

const AlterDatabaseQuery = `
/*dbtune*/
ALTER DATABASE %s SET %s = %s;
`

const AlterSystemQuery = `
/*dbtune*/
ALTER SYSTEM SET %s = %s;
`

const AutovacuumQuery = `
/*dbtune*/
SELECT COUNT(*) FROM pg_stat_activity WHERE query LIKE 'autovacuum:%';
`

const BufferCacheHitRatioQuery = `
/*dbtune*/
SELECT blks_hit, blks_read
FROM pg_stat_database 
WHERE datname = current_database();
`

const (
	DEFAULT_CONFIG_KEY = "postgresql"
)

const DataDirectoryQuery = `
/*dbtune*/
SHOW data_directory;
`

const DatabaseSizeQuery = `
/*dbtune*/
SELECT sum(pg_database_size(datname)) as total_size_bytes FROM pg_database;
`

const MaxConnectionsQuery = `
/*dbtune*/
SELECT setting::integer FROM pg_settings WHERE  name = 'max_connections';
`

const PGVersionQuery = `
/*dbtune*/
SELECT version();
`

const PgStatStatementsQuery = `` /* 322-byte string literal not displayed */

const ReloadConfigQuery = `
/*dbtune*/
SELECT pg_reload_conf();
`

const SELECT_NON_NUMERIC_SETTINGS = `
	/*dbtune*/
	SELECT name, setting, unit, vartype, context 
	FROM pg_settings 
	WHERE vartype NOT IN ('real', 'integer');
`

const SELECT_NUMERIC_SETTINGS = `` /* 138-byte string literal not displayed */

const Select1Query = `
/*dbtune*/
SELECT 1;
`

const TransactionsPerSecondQuery = `
/*dbtune*/
SELECT SUM(xact_commit)::bigint
AS server_xact_commits
FROM pg_stat_database;
`

const UptimeMinutesQuery = `
/*dbtune*/
SELECT EXTRACT(EPOCH FROM (current_timestamp - pg_postmaster_start_time())) / 60 as uptime_minutes;
`

const WaitEventsQuery = `` /* 690-byte string literal not displayed */