Skip to content

Instantly share code, notes, and snippets.

@syntaxTerr0r
syntaxTerr0r / pg_search_slow.psql
Last active October 28, 2016 01:14
pg_search slow query on RDS
SELECT "pg_search_documents".*
FROM "pg_search_documents"
INNER JOIN (
SELECT "pg_search_documents"."id" AS pg_search_id, (ts_rank((to_tsvector('simple',
unaccent(coalesce("pg_search_documents"."content"::text, '')))), (to_tsquery('simple', ''' ' || unaccent('XXX') || ' ''' ||
':*')), 0)) AS rank
FROM "pg_search_documents"
WHERE (((to_tsvector('simple', unaccent(coalesce("pg_search_documents"."content"::text, '')))) @@ (to_tsquery('simple', ''' ' || unaccent('XXX') || ' ''' || ':*'))))
) AS pg_search_ce9b9dd18c5c0023f2116f
ON "pg_search_documents"."id" = pg_search_ce9b9dd18c5c0023f2116f.pg_search_id
@syntaxTerr0r
syntaxTerr0r / heroku.md
Last active April 30, 2024 07:58
Heroku

heroku run "rake adhoc:migrate_deprecated_maintenance_periods_to_exceptional_periods" -r heroku heroku run 'rake "adhoc:migrate_stevinus_unit[606, 2521]"' -r heroku

@syntaxTerr0r
syntaxTerr0r / inventoryManagement.erd.json
Last active May 20, 2024 16:02
InventoryManagementErd
{
"$schema": "https://raw.githubusercontent.com/dineug/erd-editor/main/json-schema/schema.json",
"version": "3.0.0",
"settings": {
"width": 2500,
"height": 2500,
"scrollTop": -387.8466,
"scrollLeft": -243.048,
"zoomLevel": 0.8,
"show": 511,