I have a prometheus metric as shown below

query_duration{query = “SELECT * FROM TABLE_NAME”}

I’m trying to extract only TABLE_NAME from the label query. I’m trying to use regex to extract TABLE_NAME.

Can anyone please help me out in extracting table name from the query label in promql ?