Badanahatti
Badanahatti is a village in the southern state of Karnataka, India.[1][2] It is located in the Kurugodu taluk of Ballari district in Karnataka.
Badanahatti Badanahatti | |
|---|---|
village | |
  Badanahatti Location in Karnataka, India  Badanahatti Badanahatti (India) | |
| Coordinates: 15.15°N 76.92°E | |
| Country |  |
| State | Karnataka |
| District | Bellary |
| Talukas | Kurugodu |
| Government | |
| • Body | Gram panchayat |
| Population (2001) | |
| • Total | 6,977 |
| Languages | |
| • Official | Kannada |
| Time zone | UTC+5:30 (IST) |
| ISO 3166 code | IN-KA |
| Vehicle registration | KA |
| Website | karnataka |
Demographics
As of 2001 India census, Badanahatti had a population of 6977 with 3583 males and 3394 females.[1]
gollark: Oops, it turns out I'm accidentally sorting by it instead of the rank, but it's equally slow after fixing that.
gollark: ```nonlocality=# EXPLAIN ANALYZE SELECT url, ts_rank(fts, query), ts_headline(fts::text, query, 'MaxWords=60') AS rank FROM pages, websearch_to_tsquery('bee') query WHERE fts @@ query ORDER BY rank LIMIT 1; QUERY PLAN ------------------------------------------------------------------------------------------------------------------------------------------------- Limit (cost=860.92..860.92 rows=1 width=96) (actual time=8506.425..8506.427 rows=1 loops=1) -> Sort (cost=860.92..861.05 rows=52 width=96) (actual time=8506.423..8506.425 rows=1 loops=1) Sort Key: (ts_headline((pages.fts)::text, query.query, 'MaxWords=60'::text)) Sort Method: top-N heapsort Memory: 25kB -> Nested Loop (cost=688.65..860.66 rows=52 width=96) (actual time=1.362..8505.403 rows=348 loops=1) -> Function Scan on websearch_to_tsquery query (cost=0.25..0.26 rows=1 width=32) (actual time=0.023..0.025 rows=1 loops=1) -> Bitmap Heap Scan on pages (cost=688.40..846.49 rows=52 width=142) (actual time=0.353..1.502 rows=348 loops=1) Recheck Cond: (fts @@ query.query) Heap Blocks: exact=231 -> Bitmap Index Scan on page_search_index (cost=0.00..688.39 rows=52 width=0) (actual time=0.320..0.320 rows=387 loops=1) Index Cond: (fts @@ query.query) Planning Time: 0.190 ms Execution Time: 8506.463 ms(13 rows)```
gollark: It's not a condition, it's an extra row on the output, and I can see exactly what it does via `EXPLAIN ANALYZE`.
gollark: Maybe I need a better full text search backend?!
gollark: This is apioform.
See also
- Ballari
- Districts of Karnataka
References
- Village code= 913500 "Census of India : Villages with population 5000 & above". Registrar General & Census Commissioner, India. Archived from the original on 8 December 2008. Retrieved 18 December 2008.
- "Yahoomaps India :". Archived from the original on 18 December 2008. Retrieved 18 December 2008. Badanahatti, Bellary, Karnataka
This article is issued from Wikipedia. The text is licensed under Creative Commons - Attribution - Sharealike. Additional terms may apply for the media files.