Discourse - slowest query - front page load logged in as myself - 2014/07/01 - 13:39

gistfile1.txt

Executing action: latest
T+398.3 ms
Reader
472.7 ms
app/models/topic_list.rb:24:in `topics'
app/serializers/topic_list_serializer.rb:16:in `include_more_topics_url?'
app/controllers/list_controller.rb:209:in `block (2 levels) in respond'
app/controllers/list_controller.rb:206:in `respond'
app/controllers/list_controller.rb:67:in `block (2 levels) in <class:ListController>'
lib/middleware/anonymous_cache.rb:119:in `call'
lib/middleware/unicorn_oobgc.rb:95:in `process_client'
SELECT  "topics"."id" AS t0_r0, "topics"."title" AS t0_r1, "topics"."last_posted_at" AS t0_r2, "topics"."created_at" AS t0_r3, "topics"."updated_at" AS t0_r4, "topics"."views" AS t0_r5, "topics"."posts_count" AS t0_r6, "topics"."user_id" AS t0_r7, "topics"."last_post_user_id" AS t0_r8, "topics"."reply_count" AS t0_r9, "topics"."featured_user1_id" AS t0_r10, "topics"."featured_user2_id" AS t0_r11, "topics"."featured_user3_id" AS t0_r12, "topics"."avg_time" AS t0_r13, "topics"."deleted_at" AS t0_r14, "topics"."highest_post_number" AS t0_r15, "topics"."image_url" AS t0_r16, "topics"."off_topic_count" AS t0_r17, "topics"."like_count" AS t0_r18, "topics"."incoming_link_count" AS t0_r19, "topics"."bookmark_count" AS t0_r20, "topics"."star_count" AS t0_r21, "topics"."category_id" AS t0_r22, "topics"."visible" AS t0_r23, "topics"."moderator_posts_count" AS t0_r24, "topics"."closed" AS t0_r25, "topics"."archived" AS t0_r26, "topics"."bumped_at" AS t0_r27, "topics"."has_summary" AS t0_r28, "topics"."vote_count" AS t0_r29, "topics"."archetype" AS t0_r30, "topics"."featured_user4_id" AS t0_r31, "topics"."notify_moderators_count" AS t0_r32, "topics"."spam_count" AS t0_r33, "topics"."illegal_count" AS t0_r34, "topics"."inappropriate_count" AS t0_r35, "topics"."pinned_at" AS t0_r36, "topics"."score" AS t0_r37, "topics"."percent_rank" AS t0_r38, "topics"."notify_user_count" AS t0_r39, "topics"."subtype" AS t0_r40, "topics"."slug" AS t0_r41, "topics"."auto_close_at" AS t0_r42, "topics"."auto_close_user_id" AS t0_r43, "topics"."auto_close_started_at" AS t0_r44, "topics"."deleted_by_id" AS t0_r45, "topics"."participant_count" AS t0_r46, "topics"."word_count" AS t0_r47, "topics"."excerpt" AS t0_r48, "topics"."pinned_globally" AS t0_r49, "categories"."id" AS t1_r0, "categories"."name" AS t1_r1, "categories"."color" AS t1_r2, "categories"."topic_id" AS t1_r3, "categories"."topic_count" AS t1_r4, "categories"."created_at" AS t1_r5, "categories"."updated_at" AS t1_r6, "categories"."user_id" AS t1_r7, "categories"."topics_year" AS t1_r8, "categories"."topics_month" AS t1_r9, "categories"."topics_week" AS t1_r10, "categories"."slug" AS t1_r11, "categories"."description" AS t1_r12, "categories"."text_color" AS t1_r13, "categories"."read_restricted" AS t1_r14, "categories"."auto_close_hours" AS t1_r15, "categories"."post_count" AS t1_r16, "categories"."latest_post_id" AS t1_r17, "categories"."latest_topic_id" AS t1_r18, "categories"."position" AS t1_r19, "categories"."parent_category_id" AS t1_r20, "categories"."posts_year" AS t1_r21, "categories"."posts_month" AS t1_r22, "categories"."posts_week" AS t1_r23, "categories"."email_in" AS t1_r24, "categories"."email_in_allow_strangers" AS t1_r25, "categories"."topics_day" AS t1_r26, "categories"."posts_day" AS t1_r27, "categories"."logo_url" AS t1_r28, "categories"."background_url" AS t1_r29, "topic_only_relative_urls_categories"."id" AS t2_r0, "topic_only_relative_urls_categories"."title" AS t2_r1, "topic_only_relative_urls_categories"."last_posted_at" AS t2_r2, "topic_only_relative_urls_categories"."created_at" AS t2_r3, "topic_only_relative_urls_categories"."updated_at" AS t2_r4, "topic_only_relative_urls_categories"."views" AS t2_r5, "topic_only_relative_urls_categories"."posts_count" AS t2_r6, "topic_only_relative_urls_categories"."user_id" AS t2_r7, "topic_only_relative_urls_categories"."last_post_user_id" AS t2_r8, "topic_only_relative_urls_categories"."reply_count" AS t2_r9, "topic_only_relative_urls_categories"."featured_user1_id" AS t2_r10, "topic_only_relative_urls_categories"."featured_user2_id" AS t2_r11, "topic_only_relative_urls_categories"."featured_user3_id" AS t2_r12, "topic_only_relative_urls_categories"."avg_time" AS t2_r13, "topic_only_relative_urls_categories"."deleted_at" AS t2_r14, "topic_only_relative_urls_categories"."highest_post_number" AS t2_r15, "topic_only_relative_urls_categories"."image_url" AS t2_r16, "topic_only_relative_urls_categories"."off_topic_count" AS t2_r17, "topic_only_relative_urls_categories"."like_count" AS t2_r18, "topic_only_relative_urls_categories"."incoming_link_count" AS t2_r19, "topic_only_relative_urls_categories"."bookmark_count" AS t2_r20, "topic_only_relative_urls_categories"."star_count" AS t2_r21, "topic_only_relative_urls_categories"."category_id" AS t2_r22, "topic_only_relative_urls_categories"."visible" AS t2_r23, "topic_only_relative_urls_categories"."moderator_posts_count" AS t2_r24, "topic_only_relative_urls_categories"."closed" AS t2_r25, "topic_only_relative_urls_categories"."archived" AS t2_r26, "topic_only_relative_urls_categories"."bumped_at" AS t2_r27, "topic_only_relative_urls_categories"."has_summary" AS t2_r28, "topic_only_relative_urls_categories"."vote_count" AS t2_r29, "topic_only_relative_urls_categories"."archetype" AS t2_r30, "topic_only_relative_urls_categories"."featured_user4_id" AS t2_r31, "topic_only_relative_urls_categories"."notify_moderators_count" AS t2_r32, "topic_only_relative_urls_categories"."spam_count" AS t2_r33, "topic_only_relative_urls_categories"."illegal_count" AS t2_r34, "topic_only_relative_urls_categories"."inappropriate_count" AS t2_r35, "topic_only_relative_urls_categories"."pinned_at" AS t2_r36, "topic_only_relative_urls_categories"."score" AS t2_r37, "topic_only_relative_urls_categories"."percent_rank" AS t2_r38, "topic_only_relative_urls_categories"."notify_user_count" AS t2_r39, "topic_only_relative_urls_categories"."subtype" AS t2_r40, "topic_only_relative_urls_categories"."slug" AS t2_r41, "topic_only_relative_urls_categories"."auto_close_at" AS t2_r42, "topic_only_relative_urls_categories"."auto_close_user_id" AS t2_r43, "topic_only_relative_urls_categories"."auto_close_started_at" AS t2_r44, "topic_only_relative_urls_categories"."deleted_by_id" AS t2_r45, "topic_only_relative_urls_categories"."participant_count" AS t2_r46, "topic_only_relative_urls_categories"."word_count" AS t2_r47, "topic_only_relative_urls_categories"."excerpt" AS t2_r48, "topic_only_relative_urls_categories"."pinned_globally" AS t2_r49 FROM "topics" LEFT OUTER JOIN "categories" ON "categories"."id" = "topics"."category_id" LEFT OUTER JOIN "topics" "topic_only_relative_urls_categories" ON "topic_only_relative_urls_categories"."id" = "categories"."topic_id" AND ("topics"."deleted_at" IS NULL) LEFT OUTER JOIN topic_users AS tu ON (topics.id = tu.topic_id AND tu.user_id = 1) WHERE ("topics"."deleted_at" IS NULL) AND (topics.archetype <> 'private_message') AND (COALESCE(categories.topic_id, 0) <> topics.id) AND (NOT EXISTS(
                         SELECT 1 FROM category_users cu
                         WHERE cu.user_id = 1 AND
                               cu.category_id = topics.category_id AND
                               cu.notification_level = 0 AND
                               cu.category_id <> -1
                         ))  ORDER BY CASE
        WHEN topics.pinned_globally and (COALESCE(topics.pinned_at, '2010-01-01') > COALESCE(tu.cleared_pinned_at, '2010-01-01'))
          THEN '3000-01-01'
        ELSE topics.bumped_at
       END DESC LIMIT 30