amitsaxena · May 24, 2024 15:24 · amitsaxena · May 14, 2021 · amitsaxena · May 14, 2021
diff --git a/gistfile1.txt b/gistfile1.txt
 // Change SQL client timeout

 set statement_timeout = '0s';
 set statement_timeout = '10s';

 // Change timeout globally

 alter database mentimeter set statement_timeout = '10s';

 // Time queries

 \timing

 // Create multicolumn index concurrenty

 CREATE INDEX CONCURRENTLY vote_texts_multi_column ON vote_texts (question_id, identifier_id);

 // Drop index

 DROP INDEX CONCURRENTLY vote_texts_multi_column;

 // See all locks

 SELECT locktype, relation::regclass, mode, pid FROM pg_locks;

 // See all locks with relevant query

 SELECT
  S.pid,
  age(clock_timestamp(), query_start),
  query,
  L.mode,
  L.locktype,
  L.granted
 FROM pg_stat_activity S
 inner join pg_locks L on S.pid = L.pid
 order by L.granted, L.pid DESC;


 // List all tables of a specific schema

 \dt schema_name.*
	// Change SQL client timeout

	set statement_timeout = '0s';
	set statement_timeout = '10s';

	// Change timeout globally

	alter database mentimeter set statement_timeout = '10s';

	// Time queries

	\timing

	// Create multicolumn index concurrenty

	CREATE INDEX CONCURRENTLY vote_texts_multi_column ON vote_texts (question_id, identifier_id);

	// Drop index

	DROP INDEX CONCURRENTLY vote_texts_multi_column;

	// See all locks

	SELECT locktype, relation::regclass, mode, pid FROM pg_locks;

	// See all locks with relevant query

	SELECT
	S.pid,
	age(clock_timestamp(), query_start),
	query,
	L.mode,
	L.locktype,
	L.granted
	FROM pg_stat_activity S
	inner join pg_locks L on S.pid = L.pid
	order by L.granted, L.pid DESC;


	// List all tables of a specific schema

	\dt schema_name.*
No results found