Hi there, why cannot I query device_partitions without a WHERE clause? I wanted to list all parititions on centos7 if that matters.

I think you want

select * from block_devices

Actually, I wanted to list only the logical partitions and seems block_devices wouldn;t help