Skip to content

Instantly share code, notes, and snippets.

View syntaxTerr0r's full-sized avatar

Sébastien syntaxTerr0r

8 followers · 5 following
View GitHub Profile
@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 September 12, 2024 15:26
InventoryManagementErd
{
"$schema": "https://raw.githubusercontent.com/dineug/erd-editor/main/json-schema/schema.json",
"version": "3.0.0",
"settings": {
"width": 2500,
"height": 2500,
"scrollTop": -849.8927,
"scrollLeft": -1027.0305,
"zoomLevel": 0.4,
"show": 511,
@syntaxTerr0r
syntaxTerr0r / shell.md
Last active February 10, 2025 13:52
hunt for memory leak

ENABLE_MEMORY_DUMPS=true DUMP_PID1=87 DUMP_PID2=75 ATTEMPT=1

ps -eo pid,ppid,comm,rss,vsz --sort -rss | grep ruby

bundle exec rbtrace --pid=${DUMP_PID1} --eval="Thread.new{require 'objspace';ObjectSpace.trace_object_allocations_start}.join" bundle exec rbtrace --pid=${DUMP_PID2} --eval="Thread.new{require 'objspace';ObjectSpace.trace_object_allocations_start}.join"