هل جرب أحد AlloyDB على Google Cloud؟

[jimmy0017]

في لوحة تحكم المسؤول، يبلغ عدد المستخدمين المشاركين يوميًا حوالي 2.5 ألف.

لقد قمت بتشغيل هذا الاستعلام مع العد وحصلت على 28 ألفًا.

Data explorer query for all active users (Lurkers + Posters)

This should give you every user that have either read whilst logged in or posted over the last year. The data explorer will also print out how many they are. SELECT p.user_id FROM posts p LEFT JOIN topics t ON t.id = p.topic_id WHERE p.created_at::date > CURRENT_TIMESTAMP - INTERVAL '365 days' AND t.deleted_at IS NULL AND t.visible = TRUE AND t.closed = FALSE AND t.archived = FALSE AND t.archetype = 'regular' AND p.deleted_at IS NULL UNION SELECT u.user_id FROM user_visits u WHERE u.posts…