Skip to content

Instantly share code, notes, and snippets.

@bsy
bsy / postgres_queries_and_commands.sql
Created July 17, 2018 19:06 — forked from rgreenjr/postgres_queries_and_commands.sql
Useful PostgreSQL Queries and Commands
-- 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%'
@bsy
bsy / TS Lint Rules
Last active September 18, 2019 06:00
{
"extends": [
"tslint:recommended",
"tslint-eslint-rules",
"tslint-config-prettier",
"tslint-jasmine-rules"
],
"rulesDirectory": [
"node_modules/codelyzer",
"node_modules/@nrwl/workspace/src/tslint"

stateDiagram-v2 [] --> Importing Importing --> Tagging: import_file Tagging --> Processing: tagging_complete Processing --> Verifying: predictions_processed Processing --> Completed: complete_file_seeded Verifying --> Completing: verification_complete Completing --> Completed: verified_answers_written_to_new_file Completed --> []

@bsy
bsy / sq.md
Created November 9, 2022 02:02

stateDiagram-v2 [*] --> Importing Importing --> Tag: file_imported Tag --> Processing: tagging_completed ErrorProcessingSeed --> Processing: tagging_completed ErrorProcessingPredictions --> Processing: tagging_completed Processing --> Verify: predictions_processed Processing --> ProcessingSeed: seed_processing_started ProcessingSeed --> ErrorProcessingSeed: seed_processing_failed ProcessingSeed --> ErrorProcessingPredictions: seed_processing_failed