Alex Chen alex-nexus

python, agile, data science & engineering, full stack, machine learning eng

alex-nexus / postgres_queries_and_commands.sql

Created July 12, 2017 05:25 — forked from rgreenjr/postgres_queries_and_commands.sql

Useful PostgreSQL Queries and Commands

	-- show running queries (pre 9.2)
	SELECT procpid, age(query_start, clock_timestamp()), usename, current_query
	FROM pg_stat_activity
	WHERE current_query != '<IDLE>' AND current_query NOT ILIKE '%pg_stat_activity%'
	ORDER BY query_start desc;

	-- show running queries (9.2)
	SELECT pid, age(query_start, clock_timestamp()), usename, query
	FROM pg_stat_activity
	WHERE query != '<IDLE>' AND query NOT ILIKE '%pg_stat_activity%'

alex-nexus / db.rake

Last active August 29, 2015 14:18 — forked from hopsoft/db.rake

	# lib/tasks/db.rake
	namespace :db do

	desc "Dumps the database to db/APP_NAME.dump"
	task :dump => :environment do
	cmd = nil
	with_config do \|app, host, db, user\|
	cmd = "pg_dump --host #{host} --username #{user} --verbose --clean --no-owner --no-acl --format=c #{db} > #{Rails.root}/db/#{app}.dump"
	end
	puts cmd

alex-nexus / pages_controller.rb

Created June 8, 2014 06:15 — forked from patrickberkeley/pages_controller.rb

	class PagesController < ApplicationController
	before_filter :login_required, :except => [ :show ]

	# GET /pages
	# GET /pages.xml
	def index
	@pages = Page.find(:all)

	respond_to do \|format\|
	format.html # index.html.erb