-- Read-only PostgreSQL inspection after installing the 250-profile fixture. -- Optional: -v ON_ERROR_STOP=1. No manual changes to the DB. \set ON_ERROR_STOP on WITH demo AS ( SELECT login, normalized_login FROM user_identity_current WHERE left(free_data_item_id,20)='SHINE_DEV_GRAPH_250_' ), counts AS ( SELECT (SELECT count(*) FROM demo) AS users, (SELECT count(*) FROM user_profile_state p JOIN demo d ON p.login=d.login) AS profiles, (SELECT count(*) FROM user_stats_state s JOIN demo d ON s.login=d.login) AS stats, (SELECT count(*) FROM users_params p JOIN demo d ON p.login=d.login WHERE p.param='about' AND p.value LIKE 'ДЕМО SHiNE.%') AS bios, (SELECT count(*) FROM user_profile_state p JOIN demo d ON p.login=d.login WHERE p.shine_status='shining') AS shining, (SELECT count(*) FROM user_profile_state p JOIN demo d ON p.login=d.login WHERE p.shine_status='unknown') AS unknown, (SELECT count(*) FROM user_profile_state p JOIN demo d ON p.login=d.login WHERE p.account_role='primary') AS official, (SELECT count(*) FROM user_profile_state p JOIN demo d ON p.login=d.login WHERE p.account_role='non_voting') AS unofficial ) SELECT * FROM counts; SELECT cs.rel_type, count(*) AS relations FROM connections_state cs JOIN user_identity_current owner ON owner.login=cs.login JOIN user_identity_current target ON target.login=cs.to_login WHERE left(owner.free_data_item_id,20)='SHINE_DEV_GRAPH_250_' AND left(target.free_data_item_id,20)='SHINE_DEV_GRAPH_250_' AND cs.to_block_number=0 GROUP BY cs.rel_type ORDER BY cs.rel_type; SELECT s.login, s.friends_count, s.close_friends_count, s.shine_confirmations_received_count, s.primary_confirmations_received_count FROM user_stats_state s WHERE s.login IN ('testuser001@free','testuser052@free','testuser112@free') ORDER BY s.login;