pg:blocking misses several classes of locks

[msakrejda]

The pg:blocking query seems to come from this wiki, but a note there highlights that it does not find all types of locks (something pg:blocking itself fails to make clear). I think it's possible to fix the query by finding the actual lock dependencies, but looking at the pg_locks documentation, it's not quite clear how to do that.