Stephen Nancekivell stephennancekivell

Running queries

SELECT pid, age(clock_timestamp(), query_start), usename, state, query 
FROM pg_stat_activity 
WHERE query != '<IDLE>' AND query NOT ILIKE '%pg_stat_activity%' 
ORDER BY query_start desc;

Blocked pids

Insert data

insert.sql

\set id random(1, 100000 * :scale)
\set uuid gen_random_uuid()


insert into my_table (id, uuid)
values

	#!/usr/bin/env bash

	IP=$(curl ifconfig.me)
	echo "ip is $IP"

	MSG="{
	\"Changes\": [
	{
	\"Action\": \"UPSERT\",
	\"ResourceRecordSet\": {

	terraform {
	required_providers {
	http = {
	source = "terraform-aws-modules/http"
	version = "2.4.1"
	}
	}
	required_version = ">= 0.13"
	}