{"action":"created","issue":{"url":"https://api.github.com/repos/geoadmin/mf-geoadmin3/issues/2319","labels_url":"https://api.github.com/repos/geoadmin/mf-geoadmin3/issues/2319/labels{/name}","comments_url":"https://api.github.com/repos/geoadmin/mf-geoadmin3/issues/2319/comments","events_url":"https://api.github.com/repos/geoadmin/mf-geoadmin3/issues/2319/events","html_url":"https://github.com/geoadmin/mf-geoadmin3/issues/2319","id":71536727,"number":2319,"title":"[query tool] indication of total number of results when more than 200","user":{"login":"mariokeusen","id":4577749,"avatar_url":"https://avatars.githubusercontent.com/u/4577749?v=3","gravatar_id":"","url":"https://api.github.com/users/mariokeusen","html_url":"https://github.com/mariokeusen","followers_url":"https://api.github.com/users/mariokeusen/followers","following_url":"https://api.github.com/users/mariokeusen/following{/other_user}","gists_url":"https://api.github.com/users/mariokeusen/gists{/gist_id}","starred_url":"https://api.github.com/users/mariokeusen/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/mariokeusen/subscriptions","organizations_url":"https://api.github.com/users/mariokeusen/orgs","repos_url":"https://api.github.com/users/mariokeusen/repos","events_url":"https://api.github.com/users/mariokeusen/events{/privacy}","received_events_url":"https://api.github.com/users/mariokeusen/received_events","type":"User","site_admin":false},"labels":[{"url":"https://api.github.com/repos/geoadmin/mf-geoadmin3/labels/enhancement","name":"enhancement","color":"84b6eb"},{"url":"https://api.github.com/repos/geoadmin/mf-geoadmin3/labels/question","name":"question","color":"cc317c"}],"state":"open","locked":false,"assignee":{"login":"gjn","id":2572317,"avatar_url":"https://avatars.githubusercontent.com/u/2572317?v=3","gravatar_id":"","url":"https://api.github.com/users/gjn","html_url":"https://github.com/gjn","followers_url":"https://api.github.com/users/gjn/followers","following_url":"https://api.github.com/users/gjn/following{/other_user}","gists_url":"https://api.github.com/users/gjn/gists{/gist_id}","starred_url":"https://api.github.com/users/gjn/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/gjn/subscriptions","organizations_url":"https://api.github.com/users/gjn/orgs","repos_url":"https://api.github.com/users/gjn/repos","events_url":"https://api.github.com/users/gjn/events{/privacy}","received_events_url":"https://api.github.com/users/gjn/received_events","type":"User","site_admin":false},"milestone":null,"comments":4,"created_at":"2015-04-28T09:37:05Z","updated_at":"2015-06-02T12:51:23Z","closed_at":null,"body":"UC: open app, load a queryable layer, make a query with more than 200 results, look at the list.\r\nResult: in the headline there is \"Objects (+200)\". No obvious message, that there are more than 200 results to load. Users who are not common with the tool do not understand that.\r\nExpected: indicate the total number of results, e.g. \"Objects 200/1260\" in the headline. Is this querying the total number of results really a performance issue? Make a message text or a tooltipwindow appear, when more than 200 objects are available.\r\n\r\nTo discuss again. I had more customer feedbacks in this direction."},"comment":{"url":"https://api.github.com/repos/geoadmin/mf-geoadmin3/issues/comments/107943305","html_url":"https://github.com/geoadmin/mf-geoadmin3/issues/2319#issuecomment-107943305","issue_url":"https://api.github.com/repos/geoadmin/mf-geoadmin3/issues/2319","id":107943305,"user":{"login":"ltclm","id":5286659,"avatar_url":"https://avatars.githubusercontent.com/u/5286659?v=3","gravatar_id":"","url":"https://api.github.com/users/ltclm","html_url":"https://github.com/ltclm","followers_url":"https://api.github.com/users/ltclm/followers","following_url":"https://api.github.com/users/ltclm/following{/other_user}","gists_url":"https://api.github.com/users/ltclm/gists{/gist_id}","starred_url":"https://api.github.com/users/ltclm/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/ltclm/subscriptions","organizations_url":"https://api.github.com/users/ltclm/orgs","repos_url":"https://api.github.com/users/ltclm/repos","events_url":"https://api.github.com/users/ltclm/events{/privacy}","received_events_url":"https://api.github.com/users/ltclm/received_events","type":"User","site_admin":false},"created_at":"2015-06-02T12:51:23Z","updated_at":"2015-06-02T12:51:23Z","body":"retrieving the total number of results of a select by rectangle query is really slow:\r\n```bash\r\n$ time psql -c \"Select count(1) FROM (SELECT bfs.adr.egid_edid AS bfs_adr_egid_edid, bfs.adr.egid AS bfs_adr_egid, bfs.adr.strname1 AS bfs_adr_strname1, bfs.adr.deinr AS bfs_adr_deinr, bfs.adr.plz4 AS bfs_adr_plz4, bfs.adr.plzname AS bfs_adr_plzname, bfs.adr.gdename AS bfs_adr_gdename, bfs.adr.gdekt AS bfs_adr_gdekt, bfs.adr.dstrid AS bfs_adr_dstrid, bfs.adr.gkplaus AS bfs_adr_gkplaus, bfs.adr.gstat AS bfs_adr_gstat, bfs.adr.gdenr AS bfs_adr_gdenr, bfs.adr.ggbkr AS bfs_adr_ggbkr, bfs.adr.bgdi_created AS bfs_adr_bgdi_created, ST_AsEWKB(bfs.adr.the_geom) AS bfs_adr_the_geom\r\n         FROM bfs.adr\r\n         WHERE ST_DWITHIN(bfs.adr.the_geom, ST_GeomFromWKB('\\x010300000001000000050000000000000090ff204100000000701c04410000000090ff204100000000b0760f4100000000906a244100000000b0760f4100000000906a244100000000701c04410000000090ff204100000000701c0441'::bytea, 21781), 2500.0)\r\n          ) sub\" -d kogis_dev -h pg.bgdi.ch -U www-data\r\n count\r\n--------\r\n 671602\r\n(1 Zeile)\r\n\r\nreal    0m9.440s\r\nuser    0m0.028s\r\nsys     0m0.008s\r\n```\r\n\r\nSince there are already geometry indices, i dont think we can significantly improve this query performance."}}