Steve Chavez steve-chavez

There's no history in the database itself, if you're using psql you can use "\s" to see your command history there.

You can get future queries or other types of operations into the log files by setting log_statement in the postgresql.conf file. What you probably want instead is log_min_duration_statement, which if you set it to 0 will log all queries and their durations in the logs. That can be helpful once your apps goes live, if you set that to a higher value you'll only see the long running queries which can be helpful for optimization (you can run EXPLAIN ANALYZE on the queries you find there to figure out why they're slow).

Another handy thing to know in this area is that if you run psql and tell it "\timing", it will show how long every statement after that takes. So if you have a sql file that loo

	create table people (
	nconst text primary key,
	primary_name text not null,
	birth_year date
	);

	create table titles (
	tconst text primary key,
	primary_title text not null,
	runtime_minutes smallint

	CREATE TABLE accounts(
	id serial PRIMARY KEY,
	name VARCHAR(256) NOT NULL
	);

	CREATE TABLE entries(
	id serial PRIMARY KEY,
	description VARCHAR(1024) NOT NULL,
	amount NUMERIC(20, 2) NOT NULL CHECK (amount > 0.0),
	-- Every entry is a credit to one account...

	all: spi.so

	spi.so: spi.o makefile
	g++ -shared -o spi.so spi.o
	cp --remove-destination spi.so /var/lib/postgresql/spi.so

	spi.o: spi.cc makefile
	g++ -g -O2 -Wall -std=c++11 -fpic -c -o spi.o -I/usr/include/postgresql -I/usr/include/postgresql/9.4/server spi.cc

	clean:

	({ lib, newScope, stdenv, pkgs }: let

	# nicer aliases
	derive = stdenv.mkDerivation;
	concat = builtins.concatStringsSep " ";

	# vendored libuvc: don't build, just make sources available
	libuvc-src = derive {
	name = "libuvc-src";
	# using fetchgit instead fetchFromGitHub because


	-- This script was generated by the Schema Diff utility in pgAdmin 4
	-- For the circular dependencies, the order in which Schema Diff writes the objects is not very sophisticated
	-- and may require manual changes to the script to ensure changes are applied in the correct order.
	-- Please report an issue for any failure with the reproduction steps.

	BEGIN;

	-- Cast: money -> bigint

	{
	"success": 1,
	"errormsg": "",
	"info": "",
	"result": null,
	"data": [
	{
	"id": 326,
	"type": "cast",
	"label": "Casts",

	FROM postgres

	RUN metaDependencies="git \
	ca-certificates \
	build-essential" \
	&& apt-get update \
	&& apt-get install -y --no-install-recommends ${metaDependencies} \
	&& apt-get install -y build-essential \
	&& apt-get install make \
	&& cd /tmp \

	-- From
	-- + http://duspviz.mit.edu/tutorials/intro-postgis.php
	-- + http://duspviz.mit.edu/web-map-workshop/leaflet_nodejs_postgis/
	CREATE TABLE coffee_shops
	(
	id serial NOT NULL,
	name character varying(50),
	address character varying(50),
	city character varying(50),
	state character varying(50),

	# From: https://stevechavez.xyz/nixops-blog.html
	let
	region = "us-east-2";
	accessKeyId = "dev";
	in {
	network.description = "stevechavez.xyz";

	resources = {
	ec2KeyPairs.xyzKeyPair = { inherit region accessKeyId; };
	elasticIPs.xyzIP = { inherit region accessKeyId; };