The N+1 anti-pattern happens when a query is executed for every result of a previous query. If left unchecked N+1 queries result in a gradual slowdown in the performance of an application.
Detecting N+1 queries is tricky, because they are not revealed by any mainstream testing strategy.
To detect the N+1 query problems we need to look at the number of SQL queries that are performed in a realistic situation, such as an integration test, and compare this number with a “reasonable” expectation.
You can find full usage instructions, and all these links, on the AppMap page in the VSCode marketplace.
Thanks for watching!