Skip to content

Instantly share code, notes, and snippets.

@nlienard
Created April 6, 2017 20:44
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save nlienard/f39b749b9413553dce2fd6d093638700 to your computer and use it in GitHub Desktop.
Save nlienard/f39b749b9413553dce2fd6d093638700 to your computer and use it in GitHub Desktop.
adding Gargron@mastodon.social
Apr 6 22:43:35 inxovh-soc001 bundle[14843]: [f43b2b93-d37e-49c3-9817-c298945a802f] #033[1m#033[36mUser Load (0.9ms)#033[0m #033[1m#033[34mSELECT "users".* FROM "users" WHERE "users"."id" = $1 ORDER BY "users"."id" ASC LIMIT $2#033[0m [["id", 1], ["LIMIT", 1]]
Apr 6 22:43:35 inxovh-soc001 bundle[14843]: [f43b2b93-d37e-49c3-9817-c298945a802f] #033[1m#033[36mAccount Load (0.5ms)#033[0m #033[1m#033[34mSELECT "accounts".* FROM "accounts" WHERE "accounts"."id" = $1 LIMIT $2#033[0m [["id", 1], ["LIMIT", 1]]
Apr 6 22:43:35 inxovh-soc001 bundle[14843]: [f43b2b93-d37e-49c3-9817-c298945a802f] #033[1m#033[36mAccount Load (1.0ms)#033[0m #033[1m#033[34mSELECT "accounts".* FROM "accounts" WHERE (lower(accounts.username) = 'gargron') AND (lower(accounts.domain) = 'mastodon.social') LIMIT $1#033[0m [["LIMIT", 1]]
Apr 6 22:43:35 inxovh-soc001 bundle[14843]: [f43b2b93-d37e-49c3-9817-c298945a802f] #033[1m#033[36mAccount Load (2.8ms)#033[0m #033[1m#033[34m SELECT
Apr 6 22:43:35 inxovh-soc001 bundle[14843]: accounts.*,
Apr 6 22:43:35 inxovh-soc001 bundle[14843]: (count(f.id) + 1) * ts_rank_cd((setweight(to_tsvector('simple', accounts.display_name), 'A') || setweight(to_tsvector('simple', accounts.username), 'B') || setweight(to_tsvector('simple', coalesce(accounts.domain, '')), 'C')), to_tsquery('simple', ''' ' || 'Gargron mastodon.social' || ' ''' || ':*'), 32) AS rank
Apr 6 22:43:35 inxovh-soc001 bundle[14843]: FROM accounts
Apr 6 22:43:35 inxovh-soc001 bundle[14843]: LEFT OUTER JOIN follows AS f ON (accounts.id = f.account_id AND f.target_account_id = 1) OR (accounts.id = f.target_account_id AND f.account_id = 1)
Apr 6 22:43:35 inxovh-soc001 bundle[14843]: WHERE to_tsquery('simple', ''' ' || 'Gargron mastodon.social' || ' ''' || ':*') @@ (setweight(to_tsvector('simple', accounts.display_name), 'A') || setweight(to_tsvector('simple', accounts.username), 'B') || setweight(to_tsvector('simple', coalesce(accounts.domain, '')), 'C'))
Apr 6 22:43:35 inxovh-soc001 bundle[14843]: GROUP BY accounts.id
Apr 6 22:43:35 inxovh-soc001 bundle[14843]: ORDER BY rank DESC
Apr 6 22:43:35 inxovh-soc001 bundle[14843]: LIMIT 5
Apr 6 22:43:35 inxovh-soc001 bundle[14843]: #033[0m
Apr 6 22:43:35 inxovh-soc001 bundle[14843]: [f43b2b93-d37e-49c3-9817-c298945a802f] #033[1m#033[36mCACHE (0.0ms)#033[0m #033[1m#033[34mSELECT "accounts".* FROM "accounts" WHERE (lower(accounts.username) = 'gargron') AND (lower(accounts.domain) = 'mastodon.social') LIMIT $1#033[0m [["LIMIT", 1]]
some seconds to wait then :
Apr 6 22:43:55 inxovh-soc001 bundle[14843]: [f43b2b93-d37e-49c3-9817-c298945a802f] #033[0;33;49m[httplog] GET http://mastodon.social/.well-known/host-meta completed with status code 301 in 0.013283377513289452 seconds#033[0m
Apr 6 22:44:15 inxovh-soc001 bundle[14843]: [f43b2b93-d37e-49c3-9817-c298945a802f] method=GET path=/api/v1/search format=html controller=Api::V1::SearchController action=index status=422 duration=40088.67 view=0.49 db=5.11
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment