steviesteve

davemackintosh / map-to-json.js

Last active August 7, 2023 15:49

Convert ES6 `Map`s to a standard JSON object without effing Babel.

	/**
	* Convert a `Map` to a standard
	* JS object recursively.
	*
	* @param {Map} map to convert.
	* @returns {Object} converted object.
	*/
	function map_to_object(map) {
	const out = Object.create(null)
	map.forEach((value, key) => {

voxxit / download-slow-query-log.sh

Last active October 31, 2023 16:13

Downloads RDS slow query logs for the last 24 hours using the AWS CLI

	#!/bin/bash

	instanceID=$1
	date=$(date +%Y%m%d)

	function downloadLog () {
	local log=$1

	aws rds download-db-log-file-portion \
	--output text \

rgreenjr / postgres_queries_and_commands.sql

Last active November 17, 2024 13:10

Useful PostgreSQL Queries and Commands

	-- show running queries (pre 9.2)
	SELECT procpid, age(clock_timestamp(), query_start), 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(clock_timestamp(), query_start), usename, query
	FROM pg_stat_activity
	WHERE query != '<IDLE>' AND query NOT ILIKE '%pg_stat_activity%'