> [!BtreeVacuum] > <table><tr><td rowspan="4" width="25%"><img src="assets/wl_lw_btreevacuum.png"></td><td><b>Wait Category</b></td><td>LWLock</td></tr><tr><td><b>Mechanism</b></td><td><code>BtreeVacuumLock</code></td></tr><tr><td><b>Operations</b></td><td><a href="Operations/Table/SeqScan">SeqScan</a>, <a href="Operations/Index/IndexScan">IndexScan</a></td></tr><tr><td><b>Resources</b></td><td><a href="Resources/CPU">CPU</a>, <a href="Resources/RAM">Memory</a></td></tr><tr><td colspan="3">Contention on <b>Index Maintenance</b>. When <code>autovacuum</code> cleans up a table, it must also clean up the associated B-tree indexes to remove pointers to dead tuples.</td></tr></table>