Sébastien syntaxTerr0r

## heroku.md

      
              1 file
            
          
              0 forks
            
          
              0 comments
            
          
              0 stars
            
          
                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

  
## pg_search_slow.psql
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
	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