In this recipe, let's compare the index and sequential scan behaviors using the
inotifywait utility command, which will print a message when the mentioned event occurs on the given files.
inotify tools is a module that we can download using either the
yum command in the corresponding Linux distribution. This contrib module is developed based on the
inotify kernel API, which provides some kind of audit mechanism over the filesystem. To compare the index and sequential scan behavior, let's audit the relation and index physical file while executing the SQL queries.
Let's get the locations of index and relation physical files location using the