magnobiet · August 24, 2018 19:09
diff --git a/db_running_queries.sql b/db_running_queries.sql
 -- PostgreSQL
 SELECT
  datname,
  usename,
  query,
  waiting,
  state,
  backend_start,
  xact_start,
  query_start,
  state_Change,
  client_addr || ':' || client_port AS client
 FROM pg_stat_activity;

 -- MySQL
 SHOW PROCESSLIST;
diff --git a/db_version.sql b/db_version.sql
 -- PostgreSQL and MySQL
 SELECT version();
diff --git a/tables_row_count.sql b/tables_row_count.sql
 -- PostgreSQL
 SELECT
  schemaname,
  relname,
  n_live_tup
 FROM pg_stat_user_tables
 ORDER BY n_live_tup DESC;
	-- PostgreSQL
	SELECT
	datname,
	usename,
	query,
	waiting,
	state,
	backend_start,
	xact_start,
	query_start,
	state_Change,
	client_addr \|\| ':' \|\| client_port AS client
	FROM pg_stat_activity;

	-- MySQL
	SHOW PROCESSLIST;