Arsham Shirvani arsham

## list_ssh_tunnels
sudo lsof -i -n | egrep '\<ssh\>'

## purge_queue.sh
manage.py celery amqp queue.purge <QUEUE_NAME>

## IP.sh
/sbin/ifconfig NET_NAME | grep 'inet ' | tr -s " " | cut -d " " -f3

## s3_mv
s3cmd mv s3://SOURCE_BUCKET/foo s3://DESTINATION_BUCKET/bar --recursive

## purge-celery-queue.sh
./manage.py celery amqp queue.purge <queue_name>

## Build a large index on postgres
set work_mem = '56GB';
commit;
-- Do your work here.
-- Then be a good neighbour.
set work_mem = default;
commit;

## redirect output.sql
-- To enable
\o output_file
SELECT * FROM .....;

-- TO disable
\o

## table io stats.sql
select relname         as "table",
       heap_blks_read  as "heap from disc",
       heap_blks_hit   as "heap from cache",
       idx_blks_read   as "index from disc",
       idx_blks_hit    as "index from cache",
       toast_blks_read as "toast from disc",
       toast_blks_hit  as "toast from cache",
       tidx_blks_read  as "toast index disc",
       tidx_blks_hit   as "toast index cache"
  from pg_statio_user_tables

## activity stats.sql
select relname         as "table",
       seq_scan        as "table scans",
       idx_scan        as "index lookups"
  from pg_stat_user_tables
 where relname = 'TABLE_NAME';

## table-activities.sql
select relname         as "table",
       seq_scan        as "table scans",
       seq_tup_read    as "tuples scanned",
       idx_scan        as "index lookups",
       idx_tup_fetch   as "tuples fetched via index"
  from pg_stat_user_tables
 where relname = 'TABLE_NAME';
	set work_mem = '56GB';
	commit;
	-- Do your work here.
	-- Then be a good neighbour.
	set work_mem = default;
	commit;
	-- To enable
	\o output_file
	SELECT * FROM .....;

	-- TO disable
	\o
	select relname as "table",
	heap_blks_read as "heap from disc",
	heap_blks_hit as "heap from cache",
	idx_blks_read as "index from disc",
	idx_blks_hit as "index from cache",
	toast_blks_read as "toast from disc",
	toast_blks_hit as "toast from cache",
	tidx_blks_read as "toast index disc",
	tidx_blks_hit as "toast index cache"
	from pg_statio_user_tables
	select relname as "table",
	seq_scan as "table scans",
	idx_scan as "index lookups"
	from pg_stat_user_tables
	where relname = 'TABLE_NAME';
	select relname as "table",
	seq_scan as "table scans",
	seq_tup_read as "tuples scanned",
	idx_scan as "index lookups",
	idx_tup_fetch as "tuples fetched via index"
	from pg_stat_user_tables
	where relname = 'TABLE_NAME';