Saziley National Park

Saziley National Park is a national park in Mayotte, a French island territory in the Comoro archipelago of the western Indian Ocean. It was established in 1991.

View looking east from the park
The park is an important site for Mayotte sunbirds

Description

The 4180 ha park comprises the south-easternmost headland of the island. it is 4 km long with a sharp ridge rising to 233 m and is vegetated with dry shrubland and thicket containing baobabs. It overlaps with the 1600 ha Mlima Choungui and Sazilé Important Bird Area (IBA), identified as such by BirdLife International because it supports populations of Comoro olive-pigeons, Comoro blue-pigeons, Mayotte white-eyes, Mayotte sunbirds and red-headed fodies. It is also home to Robert Mertens's day geckos, island day geckos and Pasteur's day geckos. Its beaches are a nesting site for green, and probably hawksbill, sea turtles.[1]

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.
gollark: So it works in about 30ms - perfectly okay - *without* the ts_headline, but takes about 30 seconds *with* it.

References
  1. "Mlima Choungui and Sazilé". Important Bird Areas factsheet. BirdLife International. 2013. Retrieved 2013-09-04.


This article is issued from Wikipedia. The text is licensed under Creative Commons - Attribution - Sharealike. Additional terms may apply for the media files.