Skip to content

Instantly share code, notes, and snippets.

Avatar

Rodrigo Pereira voiprodrigo

  • Lisbon, Portugal
View GitHub Profile
View postgres_queries_and_commands.sql
-- 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%'
@voiprodrigo
voiprodrigo / apache-qliksense-proxy.md
Created Mar 20, 2018 — forked from DevoKun/apache-qliksense-proxy.md
Apache2 Proxy Server Recipe for QlikSense to accomodate https and Secure WebSocket (wss) connections
View apache-qliksense-proxy.md

Scenario

-------------       ----------------       ---------
| Browser   |<----->| Apache httpd |<----->| Qlik  |
|           |  SSL  |     2.4.9    |  SSL  | Sense |
-------------       ----------------       ---------
You can’t perform that action at this time.