Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1X6Vt2-00052p-MI for pgsql-performance@arkaria.postgresql.org; Mon, 14 Jul 2014 02:21:04 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.80) (envelope-from ) id 1X6Vt2-0003TN-1G for pgsql-performance@arkaria.postgresql.org; Mon, 14 Jul 2014 02:21:04 +0000 Received: from makus.postgresql.org ([2001:4800:1501:1::229]) by malur.postgresql.org with esmtps (TLS1.2:DHE_RSA_AES_256_CBC_SHA256:256) (Exim 4.80) (envelope-from ) id 1X6Vt0-0003Pt-H5 for pgsql-performance@postgresql.org; Mon, 14 Jul 2014 02:21:02 +0000 Received: from atlmail3.turner.com ([157.166.168.181]) by makus.postgresql.org with esmtps (TLS1.0:DHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.80) (envelope-from ) id 1X6Vsw-0005Ko-44 for pgsql-performance@postgresql.org; Mon, 14 Jul 2014 02:20:59 +0000 Received: from pps.filterd (ppmprmsa [127.0.0.1]) by ppmprmsa.turner.com (8.14.4/8.14.4) with SMTP id s6E2KmcV014285; Sun, 13 Jul 2014 22:20:52 -0400 Received: from atltbshub01.turner.com (ATLTBSHUB01.turner.com [10.189.248.155]) by ppmprmsa.turner.com with ESMTP id 1n467w81d2-2 (version=TLSv1/SSLv3 cipher=AES128-SHA bits=128 verify=NOT); Sun, 13 Jul 2014 22:20:52 -0400 Received: from edge.turner.com (10.166.126.156) by ATLTBSHUB01.turner.com (10.189.248.155) with Microsoft SMTP Server (TLS) id 14.3.146.0; Sun, 13 Jul 2014 22:20:52 -0400 Received: from na01-by2-obe.outbound.protection.outlook.com (207.46.163.243) by edge.turner.com (10.166.126.156) with Microsoft SMTP Server (TLS) id 14.3.195.1; Sun, 13 Jul 2014 22:20:51 -0400 Received: from CO2PR07MB601.namprd07.prod.outlook.com (10.141.229.11) by CO2PR07MB601.namprd07.prod.outlook.com (10.141.229.11) with Microsoft SMTP Server (TLS) id 15.0.985.8; Mon, 14 Jul 2014 02:20:50 +0000 Received: from CO2PR07MB601.namprd07.prod.outlook.com ([10.141.229.11]) by CO2PR07MB601.namprd07.prod.outlook.com ([10.141.229.11]) with mapi id 15.00.0985.008; Mon, 14 Jul 2014 02:20:50 +0000 From: "Magers, James" To: Tomas Vondra , "pgsql-performance@postgresql.org" Subject: Re: Query Performance question Thread-Topic: [PERFORM] Query Performance question Thread-Index: AQHPnu0UGRZQXArbRUGg1JATMGQy4Juev4AAgAAWe5E= Date: Mon, 14 Jul 2014 02:20:49 +0000 Message-ID: <1405304448354.64039@turner.com> References: <1405292142269.59034@turner.com>,<53C32B20.8010100@fuzzy.cz> In-Reply-To: <53C32B20.8010100@fuzzy.cz> Accept-Language: en-US Content-Language: en-US X-MS-Has-Attach: X-MS-TNEF-Correlator: x-originating-ip: [2601:0:bc40:172:ace1:e85c:d229:695d] x-microsoft-antispam: BCL:0;PCL:0;RULEID: x-forefront-prvs: 02723F29C4 x-forefront-antispam-report: SFV:NSPM; SFS:(6009001)(189002)(199002)(19580395003)(86362001)(81342001)(99396002)(101416001)(77982001)(15975445006)(74662001)(79102001)(21056001)(107046002)(99286002)(31966008)(107886001)(74502001)(4396001)(85852003)(2656002)(105586002)(50986999)(87936001)(95666004)(76176999)(85306003)(92566001)(106116001)(106356001)(551934003)(80022001)(15202345003)(76482001)(92726001)(81542001)(64706001)(36756003)(46102001)(20776003)(54356999)(83322001)(83072002)(3826002); DIR:OUT; SFP:; SCL:1; SRVR:CO2PR07MB601; H:CO2PR07MB601.namprd07.prod.outlook.com; FPR:; MLV:sfv; PTR:InfoNoRecords; MX:1; LANG:en; Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable MIME-Version: 1.0 X-OriginatorOrg: turner.com X-Proofpoint-Virus-Version: vendor=fsecure engine=2.50.10432:5.12.52, 1.0.14, 0.0.0000 definitions=2014-07-13_03:2014-07-11,2014-07-13,1970-01-01 signatures=0 X-Pg-Spam-Score: -4.2 (----) List-Archive: List-Help: List-ID: List-Owner: List-Post: List-Subscribe: List-Unsubscribe: X-Mailing-List: pgsql-performance Precedence: bulk Sender: pgsql-performance-owner@postgresql.org Tomas, Thank you for your feedback. I am attaching the requested information. Wh= ile I do not think the query is necessarily inefficient, I believe a seque= nce scan would be more efficient.=20=20 \d member_subscription_d Table "public.member_subscription_d" Column | Type | = Modifiers -----------------------+--------------------------+------------------------= ----------------------------------------- subscription_key | bigint | not null default nextva= l('subscription_id_seq'::regclass) version | integer | not null date_from | timestamp with time zone | date_to | timestamp with time zone | newsletter_nme | character varying(50) | subscription_platform | character varying(50) | subscription_value | character varying(255) | subscription_status | character varying(100) | list_status | character varying(25) | current_status | boolean | unsubscribetoken | character varying(200) | transaction_date | timestamp with time zone | newsletter_sts | integer | Indexes: "member_subscription_key" PRIMARY KEY, btree (subscription_key) "idx_member_subscription_d_list_status" btree (list_status) "idx_member_subscription_d_newsletter_nme" btree (newsletter_nme) "idx_member_subscription_d_subscription_status" btree (subscription_sta= tus) "idx_member_subscription_d_subscription_value" btree (subscription_valu= e) "idx_member_subscription_d_tk" btree (subscription_key) Referenced by: TABLE "member_recipient_f" CONSTRAINT "member_subscription_d_recipient_= f_fk" FOREIGN KEY (subscription_key) REFERENCES member_subscription_d(subsc= ription_key) pgahq_datamart-# FROM pg_class WHERE relname =3D 'member_subscription_d= '; relname | relpages | reltuples -----------------------+----------+----------- member_subscription_d | 1383 | 63012 (1 row) Explain output: http://explain.depesz.com/s/OVK --=20 Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance