Disable introspecting schema from running for every change?

Answered

Hello,

I am using Datagrip 2016.3 build #DB-163.7744.4 on Windows 7 Enterprise. I develop against an in house Postgres v9.6 database with about 2k tables and 10k functions/views/triggers and the database is 790 MB in size.

Every time I create/alter a function the introspecting schema process is kicked off in the background tasks taking at least a minute to complete. During that time Datagrip often becomes un-usable as it either slows down or completely freezes. Another developer on my team is having the same issue and neither of us recall having this issue prior to upgrading to 2016.3.

Is there a way to disable the introspecting schema process from kicking off every time I create/alter a function? I would prefer to manually kick this off when needed instead of having to deal w/ the slow down. It appears to refresh the entire schema which seems unnecessary when only a single function was changed. Is there a way to limit that?

10 comments
Comment actions Permalink

This is a symptom of another problem that remains in DG 2017.3: Introspection is not asynchronous and prevents work from being done.  This should be a priority as it reduces the value of the software.

11
Comment actions Permalink

I was looking around and I noticed there is an "Auto sync" checkbox on the data source properties page for this connection. I unchecked this box and the introspecting schema process appears to no longer automatically run when I create/alter a function.

5
Comment actions Permalink

Maybe you will already finish jerking off to trends and start fixing problems?
Nothing changed. As I lost time for introspection (> 1h) 4 years ago, I continue now. It was 2022... The question is why am I paying if you do not solve my problems?

1
Comment actions Permalink

Hi,

You're right. Don't forget to synchronise manually from time to time.

0
Comment actions Permalink

This is still a problem.

0
Comment actions Permalink

Yep, this is still a problem in 2021. Navicat doesn't do this at all and is MUCH faster. I really want to like DataGrip, but stuff like this keeps me away from it. 

0
Comment actions Permalink

Charles Thompson,

Could you e-mail Vasily.Chernov@jetbrains.com  me logs from `Prepare Introspector Diagnostics` action and SQL Logs?

0
Comment actions Permalink

Still actual. I don't want all tables of the scheme to be introspected at all. Only some and only on demand.

0
Comment actions Permalink

D Strelets A,

Could you describe your issue in details? RDBMS? Number of schemas / objects?

0

Please sign in to leave a comment.