medium10 pts · first answer countsquery-tuningpostgresql

Sort Method: external merge

EXPLAIN ANALYZE of a report shows the line below. What does it tell you?

Sort Method: external merge  Disk: 812345kB

A.The sort did not fit in work_mem and spilled to temporary files on diskB.The table is stored on an external diskC.The query used an index to avoid sortingD.The sort was done by a parallel worker on a replica

← Adding an index on a live table Bad plan right after a bulk load →