{"action":"closed","issue":{"url":"https://api.github.com/repos/jakob/Postico/issues/184","repository_url":"https://api.github.com/repos/jakob/Postico","labels_url":"https://api.github.com/repos/jakob/Postico/issues/184/labels{/name}","comments_url":"https://api.github.com/repos/jakob/Postico/issues/184/comments","events_url":"https://api.github.com/repos/jakob/Postico/issues/184/events","html_url":"https://github.com/jakob/Postico/issues/184","id":133740252,"number":184,"title":"Cast to TEXT applied to UUID columns in the UI filter","user":{"login":"vlad-at-yteq","id":5677295,"avatar_url":"https://avatars.githubusercontent.com/u/5677295?v=3","gravatar_id":"","url":"https://api.github.com/users/vlad-at-yteq","html_url":"https://github.com/vlad-at-yteq","followers_url":"https://api.github.com/users/vlad-at-yteq/followers","following_url":"https://api.github.com/users/vlad-at-yteq/following{/other_user}","gists_url":"https://api.github.com/users/vlad-at-yteq/gists{/gist_id}","starred_url":"https://api.github.com/users/vlad-at-yteq/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/vlad-at-yteq/subscriptions","organizations_url":"https://api.github.com/users/vlad-at-yteq/orgs","repos_url":"https://api.github.com/users/vlad-at-yteq/repos","events_url":"https://api.github.com/users/vlad-at-yteq/events{/privacy}","received_events_url":"https://api.github.com/users/vlad-at-yteq/received_events","type":"User","site_admin":false},"labels":[{"url":"https://api.github.com/repos/jakob/Postico/labels/started","name":"started","color":"009800"}],"state":"closed","locked":false,"assignee":null,"milestone":null,"comments":1,"created_at":"2016-02-15T15:26:25Z","updated_at":"2016-03-04T10:37:04Z","closed_at":"2016-03-04T10:37:04Z","body":"Hi Jakob,\r\n\r\nFirst of all congrats, Postico is a great tool!\r\n\r\nThere is an issue in the UI filter on UUID columns which make querying very slow on sizeable amount of data. t the moment it's done this way:\r\n\r\nuuid_col::text = '<uuid literal as string>'\r\n\r\nThe ::text cast causes UUID index to be skipped. So it should rather do the following:\r\n\r\nuuid_col = '<uuid literal as string>'\r\n\r\nPostgres will apply implicit cast to '<uuid literal as string>' as '<uuid literal as string>'::uuid.\r\n\r\nI would appreciate if this could be fix (I imagine a fix would be fairly trivial)."}}