[Feedback] Page: /api/latest/hypertable/show_chunks/ Show Chunks not working

[hexxone]

Is it easy to find the information you need?

No

Are the instructions clear?

No

How could we improve the TigerData documentation site?

No matter how I try to use the show_chunks() function like it says in the docs, it does not work:

https://docs.tigerdata.com/api/latest/hypertable/show_chunks/

I tried different forms of escaping and passing the table-space name (public) without success.

SELECT show_chunks("public"."VirtualMeasurementSeries", older_than => INTERVAL '1 second');
ERROR:  missing FROM-clause entry for table "public"
LINE 1: SELECT show_chunks("public"."VirtualMeasurementSeries", olde...
                           ^
SELECT *  show_chunks("public"."VirtualMeasurementSeries", older_than => INTERVAL '1 second') i;
ERROR:  syntax error at or near "show_chunks"
LINE 1: SELECT *  show_chunks("public"."VirtualMeasurementSeries", o...
                  ^
SELECT * FROM show_chunks("public"."VirtualMeasurementSeries", older_than => INTERVAL '1 second') i;
ERROR:  missing FROM-clause entry for table "public"
LINE 1: SELECT * FROM show_chunks("public"."VirtualMeasurementSeries...
                                  ^
SELECT * FROM show_chunks("VirtualMeasurementSeries", older_than => INTERVAL '1 second') i;
ERROR:  column "VirtualMeasurementSeries" does not exist
LINE 1: SELECT * FROM show_chunks("VirtualMeasurementSeries", older_...
                                  ^
SELECT show_chunks('VirtualMeasurementSeries');
ERROR:  relation "virtualmeasurementseries" does not exist
LINE 1: SELECT show_chunks('VirtualMeasurementSeries')
                           ^
SELECT show_chunks('virtualmeasurementseries');
ERROR:  relation "virtualmeasurementseries" does not exist
LINE 1: SELECT show_chunks('virtualmeasurementseries')

Its ALWAYS either column does not exist or relation does not exist which doesnt make sense.

The only thing that works for me is querying it manually?

select * from timescaledb_information.chunks where hypertable_name = 'VirtualMeasurementSeries';
 hypertable_schema |     hypertable_name      |     chunk_schema      |      chunk_name       | primary_dimension |  primary_dimension_type  |      range_start       |       range_end        | range_start_integer | range_end_integer | is_compressed | chunk_tablespace |      chunk_creation_time      
-------------------+--------------------------+-----------------------+-----------------------+-------------------+--------------------------+------------------------+------------------------+---------------------+-------------------+---------------+------------------+-------------------------------
 public            | VirtualMeasurementSeries | _timescaledb_internal | _hyper_17_27560_chunk | Timestamp         | timestamp with time zone | 2025-08-28 00:00:00+00 | 2025-09-11 00:00:00+00 |                     |                   | f             |                  | 2025-09-03 17:05:53.631927+00
 public            | VirtualMeasurementSeries | _timescaledb_internal | _hyper_17_27568_chunk | Timestamp         | timestamp with time zone | 2025-09-11 00:00:00+00 | 2025-09-25 00:00:00+00 |                     |                   | f             |                  | 2025-09-11 00:02:51.996039+00
 public            | VirtualMeasurementSeries | _timescaledb_internal | _hyper_17_27583_chunk | Timestamp         | timestamp with time zone | 2025-09-25 00:00:00+00 | 2025-10-09 00:00:00+00 |                     |                   | f             |                  | 2025-09-25 00:01:39.715179+00
(3 rows)

Can you please clarify how exactly the function should and can be used in the docs?

Unfortunately because show_chunks doesnt work, the docs for "decompressing" and everything that relies on this function is currently not working for me and needs manual tweaking of the query...

Thanks in advance!

[github-actions]

Thank you for the report. We welcome documentation contributions!

• For information about how to propose a change, see the contributing guide in our GitHub repository.

[billy-the-fish]

@svenklemm, could you give guidance please.

[hexxone]

Oh, while I was searching for something else, I just noticed the solution is to actually double-quote the Table name ....

This is what works for me: SELECT show_chunks('"public"."VirtualMeasurementSeries"');

So probably the docs should be hinting at this instead of just suggesting 'VirtualMeasurementSeries'