Have any one experienced that, or any suggestion on researching/debugging?
Capture the contents of pg_catalog.pg_stat_activity whenever your cron job notices high lock counts. That'll give you some more information to work with.
Thanks, but the cron job query has already joined pg_stat_activity table