Being the most frequently used feature in WordPress sites, you need thorough understanding of the database usage. First, you need to go to Posts | Add New section and clear the existing query logs. Then, you can add the data and publish a post to track the database usage. The Post creation screen offers wide range of features and hence database usage may vary based on the amount of options you use. Let's track the queries by using the most common options in post creation:
INSERT INTO `wp_posts` (`post_author`, `post_date`...........) VALUES (1, '2018-07-13 08:43:22'.....)UPDATE `wp_posts` SET `post_author` = 1, `post_date` = '2018-07-13 08:43:30' ..... WHERE `ID` = 48INSERT INTO `wp_postmeta` (`post_id`, `meta_key`, `meta_value`) ...
