LEGO Workbench

Popular Recent Workbench Posts

Recent Workbench Posts

DJDT

Time

Resource usage

Resource Value
User CPU time 24.966 msec
System CPU time 1.913 msec
Total CPU time 26.879 msec
Elapsed time 47.711 msec
Context switches 10 voluntary, 0 involuntary

Browser timing

Timing attribute Timeline Milliseconds since navigation start (+length)

SQL queries from 1 connection

  • default 20.77 ms (2 queries )
Query Timeline Time (ms) Action
SELECT up.id,
       coalesce(log(t.views+1::float) + 2*log(count(l.user_id+1::float)), 0) as score,
       t.views as num_views,
       count(l.user_id) as num_likes
  FROM accounts_userpost up
  JOIN accounts_userpoststatstotal t
    on up.id = t.post_id
  join accounts_userpostlike l
    on up.id = l.post_id
 WHERE up.is_active
   AND up.timestamp >= '2026-11-12 23:48:22.487692+00:00'
 GROUP BY up.id,
       t.views
 ORDER by 2 desc
 LIMIT 10 SELECT up.id, coalesce(log(t.views+1::float) + 2*log(count(l.user_id+1::float)), 0) as score, t.views as num_views, count(l.user_id) as num_likes FROM accounts_userpost up JOIN accounts_userpoststatstotal t on up.id = t.post_id join accounts_userpostlike l on up.id = l.post_id WHERE up.is_active AND up.timestamp >= '2026-11-12 23:48:22.487692+00:00' GROUP BY up.id, t.views ORDER by 2 desc LIMIT 10
20.62

Connection: default

Transaction status: Idle

/home/nathan/rb/site/./lego/views/mocs.py in workbench_posts(1145)
  for post in posts:
SELECT "countries_plus_country"."iso",
       "countries_plus_country"."iso3",
       "countries_plus_country"."iso_numeric",
       "countries_plus_country"."fips",
       "countries_plus_country"."name",
       "countries_plus_country"."capital",
       "countries_plus_country"."area",
       "countries_plus_country"."population",
       "countries_plus_country"."continent",
       "countries_plus_country"."tld",
       "countries_plus_country"."currency_code",
       "countries_plus_country"."currency_symbol",
       "countries_plus_country"."currency_name",
       "countries_plus_country"."phone",
       "countries_plus_country"."postal_code_format",
       "countries_plus_country"."postal_code_regex",
       "countries_plus_country"."languages",
       "countries_plus_country"."geonameid",
       "countries_plus_country"."neighbours",
       "countries_plus_country"."equivalent_fips_code"
  FROM "countries_plus_country"
 WHERE "countries_plus_country"."iso" = 'US'
 LIMIT 21SELECT ••• FROM "countries_plus_country" WHERE "countries_plus_country"."iso" = 'US' LIMIT 21
 0.14

Connection: default

Transaction status: Idle

/home/nathan/rb/site/./lego/views/mocs.py in workbench_posts(1176)
  return render(request, 'mocs/workbench_posts.html', {'search_form': search_form, 'popular_posts': popular_posts})

/home/nathan/rb/site/./rb/templatetags/rb_geo.py in geo_currency(20)
  geo_data = user.geo.get_user_currency()

/home/nathan/rb/site/./geo/geo.py in get_user_currency(253)
  country = Country.objects.get(iso=country_code)
74 </a>
75 </li>
76 <li>
77 {% geo_currency request.user %}
78 </li>
79 {% comment %}
80 <li class="hidden-xs hidden-sm">
81 <a href={% if request.user.is_authenticated %}"{% url 'user_profile_settings' request.user.get_username %}#personalisation"{% else %}"#" onclick="return false;"{% endif %} title="All date/times are being converted to this timezone">{% get_user_timezone request.user %}</a>

/home/nathan/rb/site/rb/templates/rb/includes/topbar.html

Log messages

No messages logged.