Skip to content

Instantly share code, notes, and snippets.

View xydinesh's full-sized avatar

Dinesh Weerapura xydinesh

29 followers · 113 following
View GitHub Profile
@xydinesh
xydinesh / tblsize.sql
Created February 9, 2015 21:38
Output top tables sizes
SELECT nspname || '.' || relname AS "relation",
pg_size_pretty(pg_relation_size(C.oid)) AS "size"
FROM pg_class C
LEFT JOIN pg_namespace N ON (N.oid = C.relnamespace)
WHERE nspname NOT IN ('pg_catalog', 'information_schema')
ORDER BY pg_relation_size(C.oid) DESC
LIMIT 20;
@xydinesh
xydinesh / dbsize.sql
Created February 9, 2015 18:31
size of postgres databases
SELECT d.datname AS Name, pg_catalog.pg_get_userbyid(d.datdba) AS Owner,
CASE WHEN pg_catalog.has_database_privilege(d.datname, 'CONNECT')
THEN pg_catalog.pg_size_pretty(pg_catalog.pg_database_size(d.datname))
ELSE 'No Access'
END AS Size
FROM pg_catalog.pg_database d
ORDER BY
CASE WHEN pg_catalog.has_database_privilege(d.datname, 'CONNECT')
THEN pg_catalog.pg_database_size(d.datname)
ELSE NULL
@xydinesh
xydinesh / docker.bash
Created February 3, 2015 20:13
Docker command to link two containers and mount volume from source to destination
sudo docker run -ti --name gis -v /opt/hosts:$PWD --link gisbox:gis xydinesh/pg_util /bin/bash
@xydinesh
xydinesh / theme.el
Created January 28, 2015 18:59
Theme name for black background
(load-theme 'misterioso)
@xydinesh
xydinesh / postgres.md
Last active August 29, 2015 14:13

Delete

StackOverFlow

DELETE 
FROM m_productprice
WHERE m_pricelist_version_id='1000020' AND 
      m_product_id IN (SELECT m_product_id 
                       FROM m_product 
                       WHERE upc = '7094');
@xydinesh
xydinesh / __init__.py
Last active August 29, 2015 14:12 — forked from anonymous/__init__.py
# Empty
@xydinesh
xydinesh / gist:348185311a19ce3dc44c
Last active August 29, 2015 14:12 — forked from sontek/gist:1420255
import unittest
from pyramid import testing
from paste.deploy.loadwsgi import appconfig
from webtest import TestApp
from mock import Mock
from sqlalchemy import engine_from_config
from sqlalchemy.orm import sessionmaker
from app.db import Session
@xydinesh
xydinesh / nginx-cors.conf
Last active August 29, 2015 14:07 — forked from a4180p/nginx-cors.conf
location / {
more_set_headers 'Access-Control-Allow-Origin: $http_origin' 'Access-Control-Allow-Credentials: true';
if ($request_method = 'OPTIONS') {
add_header 'Access-Control-Max-Age' 1728000;
add_header 'Access-Control-Allow-Methods' 'GET, POST, OPTIONS, DELETE, PUT';
add_header 'Access-Control-Allow-Headers' 'Authorization,Content-Type,Accept,Origin,User-Agent,DNT,Cache-Control,X-Mx-ReqToken,Keep-Alive,X-Requested-With,If-Modified-Since';
add_header 'Content-Length' 0;
add_header 'Content-Type' 'text/plain charset=UTF-8';
@xydinesh
xydinesh / docker_cheat.md
Created July 31, 2014 17:59 — forked from wsargent/docker_cheat.md
@xydinesh
xydinesh / docker_cheat.md
Created July 18, 2014 18:08 — forked from wsargent/docker_cheat.md