Pitcairnia alata
Pitcairnia alata is a species of plant in the family Bromeliaceae. It is endemic to Ecuador, where it is known from only two subpopulations in Zamora-Chinchipe Province.[1]
| Pitcairnia alata | |
|---|---|
Scientific classification  | |
| Kingdom: | Plantae |
| Clade: | Tracheophytes |
| Clade: | Angiosperms |
| Clade: | Monocots |
| Clade: | Commelinids |
| Order: | Poales |
| Family: | Bromeliaceae |
| Genus: | Pitcairnia |
| Species: | P. alata |
| Binomial name | |
| Pitcairnia alata | |
This epiphyte was initially discovered along the Río Valladolid between Quebrada Honda and Tambo Valladolid.[2] Its natural habitat is the forests of the high Andes. It is threatened by habitat destruction as forest is cleared for agriculture.[1]
Notes
- Manzanares, J.M. & Pitman, N. (2003). "Pitcairnia alata". The IUCN Red List of Threatened Species. IUCN. 2003: e.T43281A10786447. doi:10.2305/IUCN.UK.2003.RLTS.T43281A10786447.en. Retrieved 21 December 2017.
- Pitcairnia alata. FCBS Bromeliad Directory.
gollark: Slower, even.
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?!
References
- Valencia, R., Pitman, N., León-Yánez, S. and Jørgensen, P.M. (eds). 2000. Libro Rojo de las Plantas Endémicas del Ecuador 2000. Publicaciones del Herbario QCA, Ponticicia Universidad Católica del Ecuador, Quito.
This article is issued from Wikipedia. The text is licensed under Creative Commons - Attribution - Sharealike. Additional terms may apply for the media files.