DEV Community


Discussion on: 【PostgreSQL】【EntityFramework Core】Debugging SQL 1

masanori_msl profile image
Masui Masanori Author

Thank you for reading my post.

Is log output and explain, analyze query output same mean?
I meant "log output" was outputting Entity Framework Core generated SQL as log, and "explain, analyze query output" was result of executing "EXPLAIN ANALYZE SELECT ~".

I want to analyze SQL and avoid writing slow queries. But I haven't understand "EXPLAIN" and "ANALYZE" result yet. So I just wrote execution times.