DB: Separate Postgres Dashboard: Standalone Open Dashboard →

API Complex

Multiple JOINs, GROUP BY, aggregations, and data transformations — slower response. Add .json to the URL for the raw JSON response.

Response Data

{
  "user_statistics": [
    {
      "id": 1,
      "name": "Alice Johnson",
      "posts": 2,
      "comments": 2
    },
    {
      "id": 2,
      "name": "Bob Smith",
      "posts": 1,
      "comments": 2
    },
    {
      "id": 3,
      "name": "Charlie Brown",
      "posts": 1,
      "comments": 2
    },
    {
      "id": 4,
      "name": "Diana Prince",
      "posts": 1,
      "comments": 2
    }
  ],
  "popular_posts": [
    {
      "id": 4,
      "title": "Rails Performance Tips",
      "comments": 2
    },
    {
      "id": 2,
      "title": "Understanding ActiveRecord",
      "comments": 2
    },
    {
      "id": 3,
      "title": "Building APIs with Rails",
      "comments": 2
    },
    {
      "id": 5,
      "title": "Testing in Rails",
      "comments": 2
    },
    {
      "id": 1,
      "title": "Getting Started with Rails",
      "comments": 2
    }
  ],
  "recent_activity": [
    {
      "user": "Bob Smith",
      "post": "Testing in Rails",
      "content": "This is comment 2 on 'Testing in Rails'."
    },
    {
      "user": "Alice Johnson",
      "post": "Testing in Rails",
      "content": "This is comment 1 on 'Testing in Rails'."
    },
    {
      "user": "Alice Johnson",
      "post": "Rails Performance Tips",
      "content": "This is comment 2 on 'Rails Performance Tips'."
    },
    {
      "user": "Edward Norton",
      "post": "Rails Performance Tips",
      "content": "This is comment 1 on 'Rails Performance Tips'."
    },
    {
      "user": "Edward Norton",
      "post": "Building APIs with Rails",
      "content": "This is comment 2 on 'Building APIs with Rails'."
    },
    {
      "user": "Diana Prince",
      "post": "Building APIs with Rails",
      "content": "This is comment 1 on 'Building APIs with Rails'."
    },
    {
      "user": "Diana Prince",
      "post": "Understanding ActiveRecord",
      "content": "This is comment 2 on 'Understanding ActiveRecord'."
    },
    {
      "user": "Charlie Brown",
      "post": "Understanding ActiveRecord",
      "content": "This is comment 1 on 'Understanding ActiveRecord'."
    },
    {
      "user": "Charlie Brown",
      "post": "Getting Started with Rails",
      "content": "This is comment 2 on 'Getting Started with Rails'."
    },
    {
      "user": "Bob Smith",
      "post": "Getting Started with Rails",
      "content": "This is comment 1 on 'Getting Started with Rails'."
    }
  ],
  "generated_at": "2026-04-27 11:11:32 UTC"
}

Details

  • Format: JSON
  • Complexity: High
  • Operations: JOINs, GROUP BY, aggregations
  • Expected performance: Slower

Data Included

  • User statistics with post/comment counts
  • Popular posts ranked by comments
  • Recent activity timeline
  • Generation timestamp

JSON response