`pragma mmap_size` will tell you the current mmap_size. If the result is 0 then it is not being used. If there is no result then it cannot be used. <https://sqlite.org/pragma.html#pragma_mmap_size> When in WAL mode the WAL Index always uses mmap, unless it doesn't.