drticcz

## Edit_Repack_ISO_tutorial.md

      
              2 files
            
          
              0 forks
            
          
                0 comments
              
            
              0 stars
            
          
                drticcz
                / Edit_Repack_ISO_tutorial.md
            
            
              Created
              June 22, 2020 07:42
                — forked from AkdM/Edit_Repack_ISO_tutorial.md
            
              
                Edit and repack .iso bootable image
              
          
    On Linux

Installing mkisofs

apt-get install mkisofs
Editing ISO image

mkdir /tmp/custom_iso

  
## psql_internals_cheatsheet.sql
# long running queries:
SELECT
  pid,
  now() - pg_stat_activity.query_start AS duration,
  query,
  state
FROM pg_stat_activity
WHERE (now() - pg_stat_activity.query_start) > interval '5 minutes';

## active queries and killing them:

## MC Cheat Sheet
Note for newcomers:

In the shortcuts below, "C" stands for CTRL and "A" stands for "ALT". This is a convention
used in the Midnight Commander documentation and was kept here.

You can also use "ESC" instead of "ALT", which is useful on Macbooks.

Main View
---------------------------------------------------------------
- File/directory operations
	# long running queries:
	SELECT
	pid,
	now() - pg_stat_activity.query_start AS duration,
	query,
	state
	FROM pg_stat_activity
	WHERE (now() - pg_stat_activity.query_start) > interval '5 minutes';

	## active queries and killing them:
	Note for newcomers:

	In the shortcuts below, "C" stands for CTRL and "A" stands for "ALT". This is a convention
	used in the Midnight Commander documentation and was kept here.

	You can also use "ESC" instead of "ALT", which is useful on Macbooks.

	Main View
	---------------------------------------------------------------
	- File/directory operations