From my tests, I'm surprised because the rows_read / rows_written are not what I thought: 1) An INS
From my tests, I'm surprised because the rows_read / rows_written are not what I thought:
1) An INSERT is indeed 1 write, but also a read cost
2) More surprising, an « INSERT ... RETURNING * » is 2 writes + 2 reads
3) A DROP TABLE is 3 read and 0 write
4) A CREATE TABLE is 1 read + 2 writes
5) A SELECT from an empty table is 1 read
Do you known if it's the correct expected billing please ?
1) An INSERT is indeed 1 write, but also a read cost
2) More surprising, an « INSERT ... RETURNING * » is 2 writes + 2 reads
3) A DROP TABLE is 3 read and 0 write
4) A CREATE TABLE is 1 read + 2 writes
5) A SELECT from an empty table is 1 read
Do you known if it's the correct expected billing please ?
