Can't disable scanning for filter values

Get Help
1

Hi all, I’m using Metabase version 0.50.36, I’ve already checked the option “Never, I'll do this manually if I need to“ for Scanning for Filter Values but I still seeing these queries are running interval 2 minutes in my Postgres database, what problem is happening ? Is there anything that I need to do to totally disable it ? My database has a timeout threshold is 2 minutes.

These are the running queries:
```
-- Metabase
SELECT ("logging"."auto_pooling_prod_logs"."trip"#>> array[$1, $2]::text)::text AS "trip → from_location → type" FROM "logging"."auto_pooling_prod_logs" GROUP BY "trip → from_location → type" ORDER BY "trip → from_location → type" ASC LIMIT 1000
``

```
-- Metabase
SELECT ("public"."order"."_extra_props"#>> array[$1]::text)::text AS "_extra_props → tpl_id" FROM "public"."order" GROUP BY "_extra_props → tpl_id" ORDER BY "_extra_props → tpl_id" ASC LIMIT 1000
```

I find out these queries aren’t Postgres syntax. Does Metabase run them to scan for filter values ?

2

Looks like it’s fingerprinting your embedded JSON values (the #>> operator extracts a JSON path provided as an array).

The Metabase log should be saying what it’s doing when these queries are run, assuming you haven’t overridden the log levels.

If the queries are timing out then you might need to turn off ‘Unfold JSON’ for the column in the Table Metadata tab in Admin.

3

I want to check which card or model are causing those queries. How could I do it ?

4

I don’t think there’s a report that lists what cards or models are using a given table. You can look at each one and see what tables it references, but that is a tedious method.

You can see what questions are using a given model by opening the model, clicking on the ‘i’ icon on the toolbar (on the right), and selecting the Relationships tab. (This doesn’t seem to list questions using Actions in the model, however.)

There may be more information available if you’re using a paid version of Metabase, where the Insights tab on questions is active.

Worst case you can hide the table in Admin and see what questions break, but that’s a disruptive method. If you do this, un-hide the table fairly quickly afterward or else Metabase might permanently disconnect it from the questions. Metabase can handle tables temporarily disappearing, but will give up waiting after a number of hours.

5

You mean if I hide the table, it won’t break the question immediately, it will break after a number of hours, right ? Do we have any workaround to break the question after I hide the table ? I want to find out who use that filter value ASAP ?

6

The question will return error if the table is hidden, just that Metabase won’t forget about the table in its internal tracking for a while.

I’d suggest looking in Admin → Troubleshooting → Log first, it should detail who’s hitting what and what queries it’s making in response.

7

I see. I’m following the logs to find out the detail of this situation. Thanks a lot folk !

8

Looks like something related to this was fixed in 56.4: