select * from key_value where name = "block.deleted"; code example

Example: select * from key_value where name = "block.deleted";

select * from key_value where name = "field.field.deleted" or name = "field.storage.deleted"