search

Iridescent-CM / curiosity-machine

Curiosity machine application for Iridescent.
3 stars 0 forks source link

Staging database nearing row limit #2324

Closed stenington closed 5 years ago

stenington commented 5 years ago

We have a limit of 10,000 rows on our free-tier staging database, we're at 7,920 or so.

Here's an estimate of where those rows are being used: 

curiositystaging::DATABASE=> SELECT schemaname,relname,n_live_tup 
curiositystaging::DATABASE->   FROM pg_stat_user_tables 
curiositystaging::DATABASE->   ORDER BY n_live_tup DESC;
 schemaname |                relname                 | n_live_tup 
------------+----------------------------------------+------------
 public     | django_admin_log                       |       2366
 public     | images_image                           |        584
 public     | cmcomments_comment                     |        525
 public     | notifications_notification             |        396
 public     | challenges_question                    |        391
 public     | django_migrations                      |        284
 public     | auth_user                              |        281
 public     | profiles_userextra                     |        281
 public     | account_emailaddress                   |        258
 public     | django_session                         |        218
 public     | families_familymember                  |        189
 public     | auth_permission                        |        186
 public     | challenges_progress                    |        172
 public     | lessons_progress                       |        141
 public     | surveys_surveyresponse                 |        123
 public     | videos_video_thumbnails                |        116
 public     | lessons_comment                        |        113
 public     | students_studentprofile                |         92
 public     | families_familyprofile                 |         88
 public     | memberships_membership_challenges      |         83
 public     | memberships_member                     |         80
 public     | locations_location                     |         79
 public     | families_permissionslip                |         79
 public     | hellosign_signature                    |         76
 public     | lessons_quizresult                     |         75
 public     | django_content_type                    |         63
 public     | videos_encodedvideo                    |         58
 public     | quizzes_result                         |         56
 public     | challenges_challenge_reflect_questions |         46
 public     | educators_educatorprofile              |         44
 public     | challenges_example                     |         43
 public     | videos_video                           |         29
 public     | challenges_resourcefile                |         27
 public     | lessons_lesson                         |         25
 public     | challenges_challenge_themes            |         24
 public     | challenges_favorite                    |         24
 public     | challenges_filter_challenges           |         18
 public     | feedback_feedbackresult                |         17
 public     | memberships_membership                 |         16
 public     | challenges_challenge                   |         16
 public     | challenges_theme                       |         15
 public     | units_unitchallenge                    |         13
 public     | families_awardforceintegration         |         12
 public     | memberships_groupmember                |         11
 public     | units_resource                         |         11
 public     | educators_impactsurvey                 |         10
 public     | memberships_group                      |         10
 public     | lessons_quiz                           |          9
 public     | challenges_resource                    |          9
 public     | units_unit                             |          9
 public     | challenges_filter                      |          8
 public     | memberships_memberimport               |          7
 public     | quizzes_quiz                           |          5
 public     | documents_document                     |          5
 public     | memberships_membership_extra_units     |          3
 public     | feedback_feedbackquestion              |          1
 public     | django_site                            |          1
 public     | profiles_impactsurvey                  |          0
 public     | socialaccount_socialaccount            |          0
 public     | socialaccount_socialapp                |          0
 public     | django_flatpage_sites                  |          0
 public     | socialaccount_socialapp_sites          |          0
 public     | auth_group                             |          0
 public     | memberships_memberlimit                |          0
 public     | auth_group_permissions                 |          0
 public     | auth_user_groups                       |          0
 public     | django_summernote_attachment           |          0
 public     | django_flatpage                        |          0
 public     | account_emailconfirmation              |          0
 public     | socialaccount_socialtoken              |          0
 public     | units_resource_units                   |          0
 public     | auth_user_user_permissions             |          0
stenington commented 5 years ago

From the django shell:

from django.contrib.admin.models import LogEntry

LogEntry.objects.all().delete()

That drops the count by 2366, so we can see how long that lasts us. Should be a while.