André Freitas andrefreitas

Find if a query is blocked by another

select pid,
       usename,
       pg_blocking_pids(pid) as blocked_by,
       query as blocked_query
from pg_stat_activity
where cardinality(pg_blocking_pids(pid)) > 0;

Keybase proof

I hereby claim:

I am andrefreitas on github.
I am andrefreitas (https://keybase.io/andrefreitas) on keybase.
I have a public key ASCNA3WqPj9-mrU8gYxaUg-OmgeaF9sl8rJdvLPSIf3QXwo

To claim this, I am signing this object:

	#include <stdio.h>

	float computeAverage(int *notes, int length) {
	float sum = 0;

	for(int i = 0; i < length; i++) {
	sum += notes[i];
	}

	return sum / length;

	defmodule EventsProducer do
	use GenStage

	def init(min) do
	{:producer, min}
	end

	def handle_demand(demand, min) when demand > 0 do
	events = Enum.to_list(1..min+demand)

	py.test
	======================================================================= test session starts =======================================================================
	platform linux2 -- Python 2.7.9, pytest-2.8.2, py-1.4.30, pluggy-0.3.1
	rootdir: /code, inifile: setup.cfg
	plugins: cov-2.2.0
	collected 76 items

	bugimporters/tests/test_bugzilla.py .............
	bugimporters/tests/test_github.py ....
	bugimporters/tests/test_google.py ..F.F.F.F..........

	redis:
	image: redis

	postgres:
	image: postgres
	environment:
	- POSTGRES_PASSWORD=sentry
	- POSTGRES_USER=sentry
	volumes:
	- /var/lib/postgresql/data

	cmake_minimum_required(VERSION 3.1)
	project(hello)

	set(CMAKE_CXX_FLAGS "${CMAKE_CXX_FLAGS} -std=c++14")

	set(SOURCE_FILES
	hello.h
	hello.cpp
	main.cpp
	)

	// Use Gists to store code you would like to remember later on
	console.log(window); // log the "window" object to the console