Open
Description
New Issue Checklist
- I am not disclosing a vulnerability.I am not just asking a question.I have searched through existing issues.I can reproduce the issue with the latest versions of Parse Server and Parse Dashboard.
Issue Description
Dashboard doesn't count object in most of the classes
Steps to reproduce
Since the first installation I always had this issue...
Actual Outcome
Only showing '2' in the _Session
class, the other classes show '0'
Expected Outcome
To show the total of objects in each class
Environment
Parse dashboard hosted on AWS Ubuntu EC2
Dashboard
- Parse Dashboard
version: 4.1.1
- Browser:
Safari, Safari Technology Preview Release, Firefox, Chrome
- Browser version:
Safari 15.5, Safari Technology Preview Release 146, Firefox 100.0.2, Chrome 102.0.5005.61.
Server
- Parse Server version:
5.2.1
- Operating system:
macOS Monterrey
- Local or remote host (AWS, Azure, Google Cloud, Heroku, Digital Ocean, etc):
AWS Ubuntu EC2
Database
- System (MongoDB or Postgres):
Postgres
- Database version:
14.2
- Local or remote host (MongoDB Atlas, mLab, AWS, Azure, Google Cloud, etc):
AWS
Activity
parse-github-assistant commentedon Jun 4, 2022
Thanks for opening this issue!
mtrezza commentedon Jun 4, 2022
Probably related: parse-community/parse-dashboard#1637
The issue above was reported to only happen on Postgres, not on MongoDB; same as this new issue. May be DB specific, and therefore possibly a Parse Server issue.
patelmilanun commentedon Apr 5, 2023
it indeed is parse server issue as the count is coming from parse server only.
patelmilanun commentedon Apr 5, 2023
i found the solution should i raise MR
it can be done using
qs = `SELECT n_live_tup AS approximate_row_count FROM pg_stat_all_tables WHERE relname = $1;
instead of
qs = 'SELECT reltuples AS approximate_row_count FROM pg_class WHERE relname = $1';
when doing count insideparse-server\src\Adapters\Storage\Postgres\PostgresStorageAdapter.js
mtrezza commentedon Apr 9, 2023
Would this be a Parse Server or Parse Dashboard PR?
patelmilanun commentedon Apr 10, 2023
Parse server it is
parse-github-assistant commentedon Apr 10, 2023
parse-github-assistant commentedon Apr 10, 2023
mtrezza commentedon Apr 10, 2023
Moving the issue to Parse Server.
parseplatformorg commentedon May 28, 2023
🎉 This change has been released in version 6.1.0-alpha.15
24 remaining items