{"action":"created","issue":{"url":"https://api.github.com/repos/dbcli/pgcli/issues/238","labels_url":"https://api.github.com/repos/dbcli/pgcli/issues/238/labels{/name}","comments_url":"https://api.github.com/repos/dbcli/pgcli/issues/238/comments","events_url":"https://api.github.com/repos/dbcli/pgcli/issues/238/events","html_url":"https://github.com/dbcli/pgcli/issues/238","id":77999346,"number":238,"title":"Pasting queries can be slow","user":{"login":"NotSqrt","id":1997005,"avatar_url":"https://avatars.githubusercontent.com/u/1997005?v=3","gravatar_id":"","url":"https://api.github.com/users/NotSqrt","html_url":"https://github.com/NotSqrt","followers_url":"https://api.github.com/users/NotSqrt/followers","following_url":"https://api.github.com/users/NotSqrt/following{/other_user}","gists_url":"https://api.github.com/users/NotSqrt/gists{/gist_id}","starred_url":"https://api.github.com/users/NotSqrt/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/NotSqrt/subscriptions","organizations_url":"https://api.github.com/users/NotSqrt/orgs","repos_url":"https://api.github.com/users/NotSqrt/repos","events_url":"https://api.github.com/users/NotSqrt/events{/privacy}","received_events_url":"https://api.github.com/users/NotSqrt/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"milestone":null,"comments":4,"created_at":"2015-05-19T08:52:56Z","updated_at":"2015-05-21T04:51:50Z","closed_at":null,"body":"Hi,\r\n\r\nI want to paste a query like \r\n```sql\r\nexplain SELECT \"sentry_message\".\"id\", \"sentry_message\".\"group_id\", \"sentry_message\".\"message_id\", \"sentry_message\".\"project_id\", \"sentry_message\".\"logger\", \"sentry_message\".\"level\", \"sentry_message\".\"message\", \"sentry_message\".\"view\", \"sentry_message\".\"checksum\", \"sentry_message\".\"num_comments\", \"sentry_message\".\"platform\", \"sentry_message\".\"datetime\", \"sentry_message\".\"time_spent\", \"sentry_message\".\"server_name\", \"sentry_message\".\"site\", \"sentry_message\".\"data\" FROM \"sentry_message\" WHERE (\"sentry_message\".\"group_id\" = 6530  AND NOT (\"sentry_message\".\"id\" = 5710758 ) AND \"sentry_message\".\"datetime\" <= '2015-05-18 16:23:24+00:00' ) ORDER BY \"sentry_message\".\"datetime\" DESC LIMIT 1;\r\n```\r\n\r\nBut just pasting it and seeing it appear at the prompt can take 15 seconds, while using the history is instantaneous.\r\nDoes it try to run completion on every character ?"},"comment":{"url":"https://api.github.com/repos/dbcli/pgcli/issues/comments/104135555","html_url":"https://github.com/dbcli/pgcli/issues/238#issuecomment-104135555","issue_url":"https://api.github.com/repos/dbcli/pgcli/issues/238","id":104135555,"user":{"login":"amjith","id":49260,"avatar_url":"https://avatars.githubusercontent.com/u/49260?v=3","gravatar_id":"","url":"https://api.github.com/users/amjith","html_url":"https://github.com/amjith","followers_url":"https://api.github.com/users/amjith/followers","following_url":"https://api.github.com/users/amjith/following{/other_user}","gists_url":"https://api.github.com/users/amjith/gists{/gist_id}","starred_url":"https://api.github.com/users/amjith/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/amjith/subscriptions","organizations_url":"https://api.github.com/users/amjith/orgs","repos_url":"https://api.github.com/users/amjith/repos","events_url":"https://api.github.com/users/amjith/events{/privacy}","received_events_url":"https://api.github.com/users/amjith/received_events","type":"User","site_admin":false},"created_at":"2015-05-21T04:51:50Z","updated_at":"2015-05-21T04:51:50Z","body":"I'll upgrade prompt_toolkit dependency as soon as it is released to pypi. \r\n\r\nThanks a lot for the quick turn around Jonathan. :)"}}