[Question] Query Log only shows SELECT statements, not INSERT or UPDATE

[kt81]

Hello,

I have a question about the query logging functionality.

I have configured the settings to display the query log. However, only SELECT statements are being logged, while INSERT and UPDATE statements are not appearing in the log.

Is this the intended behavior or a specification of the driver? If there is a way to configure it to correctly log INSERT and UPDATE statements as well, please let me know.

Thank you.

// Settings
        services.AddDbContext<UserDbContext>((sp, options) =>
        {
            options.UseLazyLoadingProxies();
            options.UseSpanner(connectionStringBuilder.ConnectionString);
            options.UseMutations(MutationUsage.Never);
            
            var loggerFactory = sp.GetRequiredService<ILoggerFactory>();
            options.UseLoggerFactory(loggerFactory);
//...
        }

[olavloite]

Hi @kt81,

Thanks for reaching out. This is an unintended effect of the fact that the Spanner Entity Framework provider internally takes more control over the execution of inserts and updates than most other providers do. The reason for this is that it allows us to use BatchDML and Mutations more efficiently when that is possible. The drawback is that it bypasses some of the standard features in Entity Framework. And in this case that also includes the logging.

More in detail:

1. Entity Framework normally executes these statements through the standard RelationalCommand class, which logs the statements here.
2. The Spanner Entity Framework implementation overrides the use of RelationalCommand for inserts/updates/deletes, and instead executes them here.

The Spanner Entity Framework provider does use the standard RelationalCommand class for executing queries, which is why those are being logged.

I'll keep this issue open, as it is something that we should look into whether it would be possible to enable logging for these statements as well.

[kt81]

Hi @olavloite,

Thank you for the quick reply and detailed explanation.

I now understand why INSERT and UPDATE statements are not being logged due to the current execution path.

I appreciate you keeping this issue open to investigate enabling logging for these statements.