Loader query

gistfile1.txt

Guest Load Including Associations (1874.3ms)   SELECT "guests"."id" AS t0_r0, "guests"."event_id" AS t0_r1, "guests"."state" AS t0_r2, "guests"."additional_guests" AS t0_r3, "guests"."comment" AS t0_r4, "guests"."removed" AS t0_r5, "guests"."last_action_at" AS t0_r6, "guests"."created_at" AS t0_r7, "guests"."updated_at" AS t0_r8, "guests"."sent_at" AS t0_r9, "guests"."sent_from_host_email_address" AS t0_r10, "guests"."trash" AS t0_r11, "guests"."removed_from_postbox" AS t0_r12, "guests"."redelivered" AS t0_r13, "guests"."additional_guests_allowed" AS t0_r14, "guests"."archived" AS t0_r15, "guests"."personal_note" AS t0_r16, "guests"."name_id" AS t0_r17, "guests"."image_key" AS t0_r18, "guests"."publicly_registered" AS t0_r19, "guests"."redelivered_at" AS t0_r20, "guests"."coins" AS t0_r21, "guests"."stamps" AS t0_r22, "guests"."created_app_version" AS t0_r23, "guests"."last_app_version" AS t0_r24, "guests"."display_name" AS t0_r25, "guests"."email_address_id" AS t0_r26, "guests"."mailing_address_id" AS t0_r27, "guests"."account_id" AS t0_r28, "guests"."sent_app_download_id" AS t0_r29, "mailing_addresses"."id" AS t1_r0, "mailing_addresses"."name" AS t1_r1, "mailing_addresses"."line_1" AS t1_r2, "mailing_addresses"."line_2" AS t1_r3, "mailing_addresses"."city" AS t1_r4, "mailing_addresses"."state" AS t1_r5, "mailing_addresses"."zip_code" AS t1_r6, "mailing_addresses"."email_address_id" AS t1_r7, "mailing_addresses"."created_at" AS t1_r8, "mailing_addresses"."updated_at" AS t1_r9, "mailing_addresses"."account_id" AS t1_r10, "mailing_addresses"."primary" AS t1_r11, "mailing_addresses"."country" AS t1_r12, "mailing_addresses"."commercial" AS t1_r13, "mailing_addresses"."edited" AS t1_r14, "mailing_addresses"."company" AS t1_r15, "mailing_addresses"."contact_id" AS t1_r16, "mailing_addresses"."promo_campaign" AS t1_r17, "mailing_addresses"."removed" AS t1_r18, "mailing_addresses"."country_id" AS t1_r19, "email_addresses"."id" AS t2_r0, "email_addresses"."email_address" AS t2_r1, "email_addresses"."primary" AS t2_r2, "email_addresses"."confirmed" AS t2_r3, "email_addresses"."created_at" AS t2_r4, "email_addresses"."updated_at" AS t2_r5, "email_addresses"."verification_sent_at" AS t2_r6, "email_addresses"."follow_up_sent_at" AS t2_r7, "email_addresses"."account_id" AS t2_r8, "email_addresses"."last_mobile_email_user_agent" AS t2_r9, "accounts"."id" AS t3_r0, "accounts"."inactive" AS t3_r1, "accounts"."created_at" AS t3_r2, "accounts"."updated_at" AS t3_r3, "accounts"."coins" AS t3_r4, "accounts"."password_digest" AS t3_r5, "accounts"."salt_format" AS t3_r6, "accounts"."invite_slug" AS t3_r7, "accounts"."short_invite_url" AS t3_r8, "accounts"."facebook_like" AS t3_r9, "accounts"."display_name" AS t3_r10, "accounts"."one_currency" AS t3_r11, "accounts"."send_event_comment_notifications" AS t3_r12, "accounts"."birthday" AS t3_r13, "accounts"."remember_me_token" AS t3_r14, "accounts"."braintree_customer_id" AS t3_r15, "accounts"."public_key" AS t3_r16, "accounts"."shared_short_link" AS t3_r17, "accounts"."last_sent_at" AS t3_r18, "accounts"."last_received_at" AS t3_r19, "accounts"."last_created_event_at" AS t3_r20, "accounts"."registered" AS t3_r21, "accounts"."registered_at" AS t3_r22, "accounts"."reserved_coins" AS t3_r23, "accounts"."currency_id" AS t3_r24, "accounts"."country_id" AS t3_r25, "events"."id" AS t4_r0, "events"."user_id" AS t4_r1, "events"."name" AS t4_r2, "events"."host" AS t4_r3, "events"."time" AS t4_r4, "events"."time_zone" AS t4_r5, "events"."state" AS t4_r6, "events"."options" AS t4_r7, "events"."last_viewed_stats_at" AS t4_r8, "events"."created_at" AS t4_r9, "events"."updated_at" AS t4_r10, "events"."removed" AS t4_r11, "events"."trash" AS t4_r12, "events"."reminder_sent" AS t4_r13, "events"."type" AS t4_r14, "events"."time_all_day" AS t4_r15, "events"."archived" AS t4_r16, "events"."stationery_template_id" AS t4_r17, "events"."sent_at" AS t4_r18, "events"."subject" AS t4_r19, "events"."end_time" AS t4_r20, "events"."has_end_time" AS t4_r21, "events"."clone_of_id" AS t4_r22, "events"."account_id" AS t4_r23, "events"."email_route" AS t4_r24, "events"."postmark_id" AS t4_r25, "events"."is_xtreme" AS t4_r26, "events"."public_key" AS t4_r27, "events"."is_shared" AS t4_r28, "events"."shared_at" AS t4_r29, "events"."template" AS t4_r30, "events"."from_package_id" AS t4_r31, "events"."create_version" AS t4_r32, "events"."shared_short_link" AS t4_r33, "events"."last_user_agent" AS t4_r34, "events"."last_flash_version" AS t4_r35, "events"."unshared_at" AS t4_r36, "events"."uneditable_in_hybrid" AS t4_r37, "events"."details_saved" AS t4_r38, "events"."is_print" AS t4_r39, "events"."locked_for_order_id" AS t4_r40, "events"."print_request_id" AS t4_r41, "events"."mode" AS t4_r42, "events"."locked" AS t4_r43, "events"."completed_print_order" AS t4_r44, "events"."created_app_download_id" AS t4_r45, "events"."updated_app_download_id" AS t4_r46, "events"."scheduled_time" AS t4_r47, "events"."scheduled_time_zone" AS t4_r48, "events"."training_category" AS t4_r49, "events"."new_reply_page" AS t4_r50, "events"."has_viewed_tracking_page" AS t4_r51, "events"."pre_event_reminder_for_guests_sent" AS t4_r52, "events"."is_ham" AS t4_r53, "events"."is_spam" AS t4_r54, "events"."may_be_spam" AS t4_r55, "events"."spam_score" AS t4_r56, "cards"."id" AS t5_r0, "cards"."event_id" AS t5_r1, "cards"."category_id" AS t5_r2, "cards"."original_card_id" AS t5_r3, "cards"."created_at" AS t5_r4, "cards"."updated_at" AS t5_r5, "cards"."custom" AS t5_r6, "cards"."width" AS t5_r7, "cards"."height" AS t5_r8, "cards"."background_id" AS t5_r9, "cards"."r2" AS t5_r10, "card_sides"."id" AS t6_r0, "card_sides"."card_id" AS t6_r1, "card_sides"."side_type_id" AS t6_r2, "card_sides"."num" AS t6_r3, "card_sides"."created_at" AS t6_r4, "card_sides"."updated_at" AS t6_r5, "card_sides"."orientation_type_id" AS t6_r6, "card_sides"."bounds_x" AS t6_r7, "card_sides"."bounds_y" AS t6_r8, "card_sides"."bounds_width" AS t6_r9, "card_sides"."bounds_height" AS t6_r10, "card_sides"."position" AS t6_r11, "card_sides"."saved_version" AS t6_r12, "card_sides"."rendered_version" AS t6_r13, "card_sides"."width" AS t6_r14, "card_sides"."height" AS t6_r15, "card_sides"."custom" AS t6_r16, "card_sides"."custom_pdf" AS t6_r17, "card_sides"."total_spot_colors" AS t6_r18, "packages"."id" AS t7_r0, "packages"."event_id" AS t7_r1, "packages"."name" AS t7_r2, "packages"."envelope_settings" AS t7_r3, "packages"."featured_until" AS t7_r4, "packages"."active" AS t7_r5, "packages"."created_at" AS t7_r6, "packages"."updated_at" AS t7_r7, "packages"."primary_paper_id" AS t7_r8, "packages"."popularity_rank" AS t7_r9, "packages"."times_favorited" AS t7_r10, "packages"."partner_id" AS t7_r11, "packages"."updated_by_id" AS t7_r12, "packages"."created_by_id" AS t7_r13, "packages"."mobile" AS t7_r14, "packages"."show_in_carousel" AS t7_r15, "packages"."print_enabled" AS t7_r16, "packages"."wedding_related" AS t7_r17, "packages"."print_event_id" AS t7_r18, "packages"."crane_event_id" AS t7_r19, "packages"."crane_enabled" AS t7_r20, "packages"."occasion" AS t7_r21, "packages"."default_envelope_id" AS t7_r22, "packages"."default_secondary_id" AS t7_r23, "packages"."default_response_card_id" AS t7_r24, "packages"."default_response_envelope_id" AS t7_r25, "packages"."baby_related" AS t7_r26, "packages"."minimum_ipad_version" AS t7_r27, "packages"."default_variation" AS t7_r28, "partners"."id" AS t8_r0, "partners"."name" AS t8_r1, "partners"."slug" AS t8_r2, "partners"."url" AS t8_r3, "partners"."description" AS t8_r4, "partners"."image_key" AS t8_r5, "partners"."created_at" AS t8_r6, "partners"."updated_at" AS t8_r7, "partners"."always_active" AS t8_r8, "partners"."active_starts_at" AS t8_r9, "partners"."active_ends_at" AS t8_r10, "partners"."background_color" AS t8_r11, "partners"."tagline" AS t8_r12, "partners"."design_category_id" AS t8_r13, "partners"."promo_code_title" AS t8_r14, "partners"."promo_code_sub_title" AS t8_r15, "partners"."promo_url" AS t8_r16, "partners"."is_internal" AS t8_r17, "partners"."headline_color" AS t8_r18, "partners"."headline_shadow_color" AS t8_r19, "partners"."subtext_color" AS t8_r20, "partners"."link_color" AS t8_r21, "partners"."type" AS t8_r22, "partners"."show_designer" AS t8_r23, "partners"."show_bio" AS t8_r24, "partners"."private" AS t8_r25, "partners"."use_custom_landing_page" AS t8_r26, "partners"."branded_create_app" AS t8_r27, "partners"."reply_page_banner_link" AS t8_r28, "partners"."default_package_id" AS t8_r29, "partners"."create_app_background_color_hex" AS t8_r30, "partners"."facebook_template" AS t8_r31, "partners"."twitter_template" AS t8_r32, "partners"."cause" AS t8_r33, "partners"."design_card_url" AS t8_r34, "partners"."view_samples_url" AS t8_r35, "partners"."learn_more_url" AS t8_r36, "partners"."show_design_card_link" AS t8_r37, "partners"."show_view_samples_link" AS t8_r38, "partners"."show_learn_more_link" AS t8_r39, "partners"."paper_coins" AS t8_r40, "partners"."liner_coins" AS t8_r41, "partners"."flat_print_partner" AS t8_r42, "partners"."crane_print_partner" AS t8_r43, "partners"."nav_group_id" AS t8_r44, "partners"."mercury_default" AS t8_r45, "partners"."nav_node_id" AS t8_r46, "event_options_lists"."id" AS t9_r0, "event_options_lists"."event_id" AS t9_r1, "event_options_lists"."show_envelope" AS t9_r2, "event_options_lists"."friends" AS t9_r3, "event_options_lists"."public_guest_list" AS t9_r4, "event_options_lists"."show_attending_guests" AS t9_r5, "event_options_lists"."show_not_attending_guests" AS t9_r6, "event_options_lists"."show_not_replied_guests" AS t9_r7, "event_options_lists"."auto_follow_up" AS t9_r8, "event_options_lists"."personal_greeting_text" AS t9_r9, "event_options_lists"."redirect_to_url" AS t9_r10, "event_options_lists"."reminder_email_enabled" AS t9_r11, "event_options_lists"."reminder_email_from" AS t9_r12, "event_options_lists"."reminder_email_subject" AS t9_r13, "event_options_lists"."reminder_email_message" AS t9_r14, "event_options_lists"."reminder_email_states" AS t9_r15, "event_options_lists"."embed" AS t9_r16, "event_options_lists"."invitation_color" AS t9_r17, "event_options_lists"."updated_at" AS t9_r18, "event_options_lists"."show_map" AS t9_r19, "event_options_lists"."reminder_send_at" AS t9_r20, "event_options_lists"."reminder_set" AS t9_r21, "event_options_lists"."auto_follow_up_set" AS t9_r22, "event_options_lists"."custom_email_text" AS t9_r23, "event_options_lists"."show_all_invited_guests" AS t9_r24, "event_options_lists"."link_away_url" AS t9_r25, "event_options_lists"."link_away_text" AS t9_r26, "event_options_lists"."link_away_text_description" AS t9_r27, "event_options_lists"."is_capped" AS t9_r28, "event_options_lists"."max_cap" AS t9_r29, "event_options_lists"."link_away_show_time_and_location" AS t9_r30, "event_options_lists"."shareable_animation" AS t9_r31, "event_options_lists"."spent_stamp" AS t9_r32, "event_options_lists"."send_host_comment_notification" AS t9_r33, "event_options_lists"."last_viewed_guest_book_at" AS t9_r34, "event_options_lists"."extended_reply_question" AS t9_r35, "event_options_lists"."collect_guest_addresses" AS t9_r36, "event_options_lists"."registries_enabled" AS t9_r37, "event_options_lists"."eventbrite" AS t9_r38, "event_options_lists"."address_reply_card" AS t9_r39, "event_options_lists"."photo_album_enabled" AS t9_r40, "event_options_lists"."first_nav_type" AS t9_r41, "event_options_lists"."first_nav_type_id" AS t9_r42, "event_options_lists"."last_nav_type" AS t9_r43, "event_options_lists"."last_nav_type_id" AS t9_r44, "event_options_lists"."photo_emails_enabled_for_guests" AS t9_r45, "event_options_lists"."pinned_note" AS t9_r46, "event_options_lists"."photo_album_enabled_at" AS t9_r47, "event_options_lists"."photo_album_removed" AS t9_r48, "event_options_lists"."phone_number_id" AS t9_r49, "guest_side_permissions"."id" AS t10_r0, "guest_side_permissions"."event_id" AS t10_r1, "guest_side_permissions"."guest_list" AS t10_r2, "guest_side_permissions"."public_messages" AS t10_r3, "guest_side_permissions"."created_at" AS t10_r4, "guest_side_permissions"."updated_at" AS t10_r5, "locations"."id" AS t11_r0, "locations"."event_id" AS t11_r1, "locations"."address" AS t11_r2, "locations"."place" AS t11_r3, "locations"."city" AS t11_r4, "locations"."state" AS t11_r5, "locations"."time_zone" AS t11_r6, "locations"."created_at" AS t11_r7, "locations"."updated_at" AS t11_r8, "locations"."zip" AS t11_r9, "locations"."country" AS t11_r10, "locations"."lat" AS t11_r11, "locations"."lng" AS t11_r12, "social_event_connections"."id" AS t12_r0, "social_event_connections"."event_id" AS t12_r1, "social_event_connections"."social_account_connection_id" AS t12_r2, "social_event_connections"."social_event_id" AS t12_r3, "social_event_connections"."type" AS t12_r4, "social_event_connections"."removed" AS t12_r5, "social_event_connections"."created_in_background" AS t12_r6, "social_event_connections"."created_at" AS t12_r7, "social_event_connections"."updated_at" AS t12_r8 FROM "guests" LEFT OUTER JOIN "mailing_addresses" ON "mailing_addresses".id = "guests".mailing_address_id LEFT OUTER JOIN "email_addresses" ON "email_addresses".id = "guests".email_address_id LEFT OUTER JOIN "accounts" ON "accounts".id = "email_addresses".account_id LEFT OUTER JOIN "events" ON "events".id = "guests".event_id LEFT OUTER JOIN "cards" ON cards.event_id = events.id LEFT OUTER JOIN "card_sides" ON card_sides.card_id = cards.id LEFT OUTER JOIN "packages" ON "packages".id = "events".from_package_id LEFT OUTER JOIN "partners" ON "partners".id = "packages".partner_id LEFT OUTER JOIN "event_options_lists" ON event_options_lists.event_id = events.id LEFT OUTER JOIN "guest_side_permissions" ON guest_side_permissions.event_id = events.id LEFT OUTER JOIN "locations" ON locations.event_id = events.id LEFT OUTER JOIN "social_event_connections" ON social_event_connections.event_id = events.id WHERE ((((((guests.removed_from_postbox IS FALSE) AND (guests.archived IS FALSE)) AND (guests.trash IS FALSE)) AND (guests.removed IS FALSE)) AND (guests.state NOT IN ('created','scheduled','unsubscribed'))) AND ("accounts"."id" = 838721)) ORDER BY COALESCE(guests.sent_at, events.sent_at, events.shared_at, events.time, guests.updated_at, guests.last_action_at) DESC NULLS FIRST