In PilotFish, transaction logs are specific to individual transactions and are stored in a database, providing a detailed view of each transaction. Show logs, on the other hand, consist of written EIP log files that are saved on disk, offering a general overview of operations.