0

My program in C# using Entity Framework Core I can point to a PostgreSQL or SQLite database. When pointed to PostgreSQL the Database tool of Performance Analyzer does not work. There only appear native code calls in the CPU Usage tab and no queries in the queries tab. I tried both debug and release mode, as well as switching off all options except CPU usage, and then queries to isolate them.

When I switch to SQLite I see all function calls in the CPU Usage tab and all queries in the queries tab. Nothing changes in the code besides in DbContext switching from optionsBUilder.UseNpgsql(connectionString); to optionsBuilder.UseSqlite(connectionString); and one entity for how PostgreSQL and SQLite deal with DateTime.

Improve this question
2
  • It is not comment for you, it was a comment for currently deleted message. Anyway look at Npgsql OpenTelementry, I have no time to make experiments, but from this blog, I see that can be root why SqLite works. Commented Feb 12 at 13:58
  • Could you please offer some pictures about the CPU Usage tab? Better post two pictures which record the difference when you point to SQLite and psql. Commented Feb 13 at 5:53
Related questions
259
Optimise PostgreSQL for fast testing
1
How to switch between sqlserver and postgresql using entity framework by parameters
5
Inserting multiple records at once in Entity Framework Core 6
Load 5 more related questions Show fewer related questions

0

Reset to default

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.