Re: Performance issues while running select sql query

On Sun, Apr 29, 2018 at 10:33 AM, Kaushal Shriyan <kaushalshriyan(at)gmail(dot)com>
wrote:

>
>
> On Sun, Apr 29, 2018 at 10:10 AM, Justin Pryzby <pryzby(at)telsasoft(dot)com>
> wrote:
>
>> On Sun, Apr 29, 2018 at 10:05:23AM +0530, Kaushal Shriyan wrote:
>> > Hi,
>> >
>> > I am running postgresql db server 9.4.14 on AWS of C4.2xlarge instance
>> type
>> > with 500 GB volume of volume type io1 with 25000 IOPS and I am seeing
>> > performance issues. The sql query response takes around *127713.413 ms
>> *time
>> > *.* Is there a way to find out the bottleneck?
>>
>> Send the output of "explain(analyze,buffers)" for the query?
>>
>> Justin
>>
>
> Hi Justin,
>
> Do i need to run the below sql query? Please comment.
>
> explain(analyze,buffers) SELECT serorgid,appname,sum(message_count) AS
>> mtrc0,date_trunc('day', client_received_start_timestamp at time zone
>> '+5:30:0')::timestamp without time zone AS time_unit FROM
>> analytics."test.prod.fact" WHERE client_received_start_timestamp >=
>> '2018-3-28 18:30:0' AND client_received_start_timestamp < '2018-4-11
>> 18:30:0' AND ((apiproxy in ('test-service' ) ) and (exchangeinstance !=
>> '(not set)' ) and (devemail != 'test(at)example(dot)com' ) and (devemail != '
>> srk(at)example(dot)com' ) and (devemail != 'abc(at)example(dot)com' ) and (devemail
>> != 'xyz(at)example(dot)com' ) and (apistatus = 'Success' ) and (apiaction not
>> in ('LRN','finder','ManuallySelect' ) ) and (appname not in ('Mobile
>> Connect Developer Portal (Int(', 'MinskHBM', 'LondonHBM', 'SeoulHBM',
>> 'MumbaiHBM', 'NVirginiaHBM','SPauloHBM', 'Mobile Connect HeartBeat
>> Monitor', 'PDMAOpenSDKTest1', 'PDMAOpenSDKTest2', 'PDMASDKTest',
>> 'APIHealth', 'A1qaDemoApp','test', 'dublin o2o test tool', 'Test from John
>> do not provision' ) ) and (serorgid = 'aircel' )) GROUP BY
>> serorgid,appname,time_unit ORDER BY time_unit DESC LIMIT 14400 OFFSET 0;
>
>
> I look forward to hearing from you.
>
> Best Regards,
>
>
Hi Justin,

Please find the below details and let me know if you need any additional
information.

> QUERY PLAN
>
>
> ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
>
> ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
>
> ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
>
> ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
>
> -------------------------------------------------------------------------------------------------------
> Limit (cost=2568002.26..2568038.26 rows=14400 width=35) (actual
> time=127357.296..127357.543 rows=231 loops=1)
> Buffers: shared hit=28019 read=1954681
> -> Sort (cost=2568002.26..2568389.38 rows=154849 width=35) (actual
> time=127357.294..127357.383 rows=231 loops=1)
> Sort Key: ((date_trunc('day'::text, timezone('+5:30:0'::text,
> "test.prod.fact".client_received_start_timestamp)))::timestamp without time
> zone)
> Sort Method: quicksort Memory: 45kB
> Buffers: shared hit=28019 read=1954681
> -> HashAggregate (cost=2553822.90..2556532.76 rows=154849
> width=35) (actual time=127356.707..127357.103 rows=231 loops=1)
> Group Key: (date_trunc('day'::text,
> timezone('+5:30:0'::text,
> "test.prod.fact".client_received_start_timestamp)))::timestamp without time
> zone, "test.prod.fact".serorgid, "excha
> nge-p.prod.fact".appname
> Buffers: shared hit=28016 read=1954681
> -> Result (cost=0.43..2551252.21 rows=257069 width=35)
> (actual time=2.399..126960.471 rows=311015 loops=1)
> Buffers: shared hit=28016 read=1954681
> -> Append (cost=0.43..2549324.20 rows=257069
> width=35) (actual time=2.294..126163.689 rows=311015 loops=1)
> Buffers: shared hit=28016 read=1954681
> -> Index Scan using
> "exchange-pprodfactclrecsts" on "test.prod.fact" (cost=0.43..6644.45
> rows=64 width=33) (actual time=2.292..3.887 rows=2 loops=1)
> Index Cond:
> ((client_received_start_timestamp >= '2018-03-28 18:30:00'::timestamp
> without time zone) AND (client_received_start_timestamp < '2018-04-11
> 18:30:00'::timestam
> p without time zone))
> Filter: ((exchangeinstance <> '(not
> set)'::text) AND (devemail <> 'test(at)example(dot)com'::text) AND (devemail <> '
> srk(at)example(dot)com'::text) AND (devemail <> 'abc(at)example(dot)com'::
> text) AND (devemail <> 'xyz(at)example(dot)com'::text) AND (apiproxy =
> 'test-service'::text) AND (apistatus = 'Success'::text) AND (serorgid =
> 'aircel'::text) AND (apiaction <> ALL ('{LRN,Pathfinder
> ,ManuallySelect}'::text[])) AND (appname <> ALL ('{"Mobile Connect
> Developer Portal
> (Int(",MinskHBM,LondonHBM,SeoulHBM,MumbaiHBM,NVirginiaHBM,SPauloHBM,"Mobile
> Connect HeartBeat Monitor",PDMAOpenSDKTest1,
> PDMAOpenSDKTest2,PDMASDKTest,APIHealth,A1qaDemoApp,test,"india e2e test
> tool","Test from John do not provision"}'::text[])))
> Rows Removed by Filter: 61
> Buffers: shared hit=25 read=6
> -> Index Scan using
> "test.prod.fact_624_client_received_start_timestamp_idx" on
> "test.prod.fact_624" (cost=0.42..10948.27 rows=1002 width=34) (actual
> time=3.034..2
> 78.320 rows=1231 loops=1)
> Index Cond:
> ((client_received_start_timestamp >= '2018-03-28 18:30:00'::timestamp
> without time zone) AND (client_received_start_timestamp < '2018-04-11
> 18:30:00'::timestam
> p without time zone))
> Filter: ((exchangeinstance <> '(not
> set)'::text) AND (devemail <> 'test(at)example(dot)com'::text) AND (devemail <> '
> srk(at)example(dot)com'::text) AND (devemail <> 'abc(at)example(dot)com'::
> text) AND (devemail <> 'xyz(at)example(dot)com'::text) AND (apiproxy =
> 'test-service'::text) AND (apistatus = 'Success'::text) AND (serorgid =
> 'aircel'::text) AND (apiaction <> ALL ('{LRN,Pathfinder
> ,ManuallySelect}'::text[])) AND (appname <> ALL ('{"Mobile Connect
> Developer Portal
> (Int(",MinskHBM,LondonHBM,SeoulHBM,MumbaiHBM,NVirginiaHBM,SPauloHBM,"Mobile
> Connect HeartBeat Monitor",PDMAOpenSDKTest1,
> PDMAOpenSDKTest2,PDMASDKTest,APIHealth,A1qaDemoApp,test,"india e2e test
> tool","Test from John do not provision"}'::text[])))
> Rows Removed by Filter: 42629
> Buffers: shared hit=27966 read=498
> -> Seq Scan on "test.prod.fact_631"
> (cost=0.00..171447.63 rows=16464 width=34) (actual time=0.070..7565.812
> rows=20609 loops=1)
> Filter: ((client_received_start_timestamp
> >= '2018-03-28 18:30:00'::timestamp without time zone) AND
> (client_received_start_timestamp < '2018-04-11 18:30:00'::timestamp wi
> thout time zone) AND (exchangeinstance <> '(not set)'::text) AND (devemail
> <> 'test(at)example(dot)com'::text) AND (devemail <> 'srk(at)example(dot)com'::text)
> AND (devemail <> 'abc(at)example(dot)com'::text) AND (devemail <
> > 'xyz(at)example(dot)com'::text) AND (apiproxy = 'test-service'::text) AND
> (apistatus = 'Success'::text) AND (serorgid = 'aircel'::text) AND
> (apiaction <> ALL ('{LRN,Pathfinder,ManuallySelect}'::te
> xt[])) AND (appname <> ALL ('{"Mobile Connect Developer Portal
> (Int(",MinskHBM,LondonHBM,SeoulHBM,MumbaiHBM,NVirginiaHBM,SPauloHBM,"Mobile
> Connect HeartBeat Monitor",PDMAOpenSDKTest1,PDMAOpenSDKTest2,PDMA
> SDKTest,APIHealth,A1qaDemoApp,test,"india e2e test tool","Test from John
> do not provision"}'::text[])))
> Rows Removed by Filter: 645406
> Buffers: shared hit=2 read=132279
> -> Seq Scan on "test.prod.fact_640"
> (cost=0.00..147539.09 rows=16739 width=34) (actual time=2.976..7356.452
> rows=20407 loops=1)
> Filter: ((client_received_start_timestamp
> >= '2018-03-28 18:30:00'::timestamp without time zone) AND
> (client_received_start_timestamp < '2018-04-11 18:30:00'::timestamp wi
> thout time zone) AND (exchangeinstance <> '(not set)'::text) AND (devemail
> <> 'test(at)example(dot)com'::text) AND (devemail <> 'srk(at)example(dot)com'::text)
> AND (devemail <> 'abc(at)example(dot)com'::text) AND (devemail <
> > 'xyz(at)example(dot)com'::text) AND (apiproxy = 'test-service'::text) AND
> (apistatus = 'Success'::text) AND (serorgid = 'aircel'::text) AND
> (apiaction <> ALL ('{LRN,Pathfinder,ManuallySelect}'::te
> xt[])) AND (appname <> ALL ('{"Mobile Connect Developer Portal
> (Int(",MinskHBM,LondonHBM,SeoulHBM,MumbaiHBM,NVirginiaHBM,SPauloHBM,"Mobile
> Connect HeartBeat Monitor",PDMAOpenSDKTest1,PDMAOpenSDKTest2,PDMA
> SDKTest,APIHealth,A1qaDemoApp,test,"india e2e test tool","Test from John
> do not provision"}'::text[])))
> Rows Removed by Filter: 553930
> Buffers: shared hit=2 read=113768
> -> Seq Scan on "test.prod.fact_647"
> (cost=0.00..148973.30 rows=16365 width=34) (actual time=2.274..7433.607
> rows=19296 loops=1)
> Filter: ((client_received_start_timestamp
> >= '2018-03-28 18:30:00'::timestamp without time zone) AND
> (client_received_start_timestamp < '2018-04-11 18:30:00'::timestamp wi
> thout time zone) AND (exchangeinstance <> '(not set)'::text) AND (devemail
> <> 'test(at)example(dot)com'::text) AND (devemail <> 'srk(at)example(dot)com'::text)
> AND (devemail <> 'abc(at)example(dot)com'::text) AND (devemail <
> > 'xyz(at)example(dot)com'::text) AND (apiproxy = 'test-service'::text) AND
> (apistatus = 'Success'::text) AND (serorgid = 'aircel'::text) AND
> (apiaction <> ALL ('{LRN,Pathfinder,ManuallySelect}'::te
> xt[])) AND (appname <> ALL ('{"Mobile Connect Developer Portal
> (Int(",MinskHBM,LondonHBM,SeoulHBM,MumbaiHBM,NVirginiaHBM,SPauloHBM,"Mobile
> Connect HeartBeat Monitor",PDMAOpenSDKTest1,PDMAOpenSDKTest2,PDMA
> SDKTest,APIHealth,A1qaDemoApp,test,"india e2e test tool","Test from John
> do not provision"}'::text[])))
> Rows Removed by Filter: 560618
> Buffers: shared hit=2 read=114852
> -> Seq Scan on "test.prod.fact_652"
> (cost=0.00..148086.43 rows=14102 width=34) (actual time=2.165..7423.880
> rows=16735 loops=1)
> Filter: ((client_received_start_timestamp
> >= '2018-03-28 18:30:00'::timestamp without time zone) AND
> (client_received_start_timestamp < '2018-04-11 18:30:00'::timestamp wi
> thout time zone) AND (exchangeinstance <> '(not set)'::text) AND (devemail
> <> 'test(at)example(dot)com'::text) AND (devemail <> 'srk(at)example(dot)com'::text)
> AND (devemail <> 'abc(at)example(dot)com'::text) AND (devemail <
> > 'xyz(at)example(dot)com'::text) AND (apiproxy = 'test-service'::text) AND
> (apistatus = 'Success'::text) AND (serorgid = 'aircel'::text) AND
> (apiaction <> ALL ('{LRN,Pathfinder,ManuallySelect}'::te
> xt[])) AND (appname <> ALL ('{"Mobile Connect Developer Portal
> (Int(",MinskHBM,LondonHBM,SeoulHBM,MumbaiHBM,NVirginiaHBM,SPauloHBM,"Mobile
> Connect HeartBeat Monitor",PDMAOpenSDKTest1,PDMAOpenSDKTest2,PDMA
> SDKTest,APIHealth,A1qaDemoApp,test,"india e2e test tool","Test from John
> do not provision"}'::text[])))
> Rows Removed by Filter: 557229
> Buffers: shared hit=1 read=114353
> -> Seq Scan on "test.prod.fact_661"
> (cost=0.00..172116.37 rows=15973 width=35) (actual time=0.091..8616.119
> rows=17820 loops=1)
> Filter: ((client_received_start_timestamp
> >= '2018-03-28 18:30:00'::timestamp without time zone) AND
> (client_received_start_timestamp < '2018-04-11 18:30:00'::timestamp wi
> thout time zone) AND (exchangeinstance <> '(not set)'::text) AND (devemail
> <> 'test(at)example(dot)com'::text) AND (devemail <> 'srk(at)example(dot)com'::text)
> AND (devemail <> 'abc(at)example(dot)com'::text) AND (devemail <
> > 'xyz(at)example(dot)com'::text) AND (apiproxy = 'test-service'::text) AND
> (apistatus = 'Success'::text) AND (serorgid = 'aircel'::text) AND
> (apiaction <> ALL ('{LRN,Pathfinder,ManuallySelect}'::te
> xt[])) AND (appname <> ALL ('{"Mobile Connect Developer Portal
> (Int(",MinskHBM,LondonHBM,SeoulHBM,MumbaiHBM,NVirginiaHBM,SPauloHBM,"Mobile
> Connect HeartBeat Monitor",PDMAOpenSDKTest1,PDMAOpenSDKTest2,PDMA
> SDKTest,APIHealth,A1qaDemoApp,test,"india e2e test tool","Test from John
> do not provision"}'::text[])))
> Rows Removed by Filter: 649730
> Buffers: shared hit=2 read=132886
> -> Seq Scan on "test.prod.fact_668"
> (cost=0.00..174813.25 rows=15675 width=35) (actual time=1.537..8751.908
> rows=16881 loops=1)
> Filter: ((client_received_start_timestamp
> >= '2018-03-28 18:30:00'::timestamp without time zone) AND
> (client_received_start_timestamp < '2018-04-11 18:30:00'::timestamp wi
> thout time zone) AND (exchangeinstance <> '(not set)'::text) AND (devemail
> <> 'test(at)example(dot)com'::text) AND (devemail <> 'srk(at)example(dot)com'::text)
> AND (devemail <> 'abc(at)example(dot)com'::text) AND (devemail <
> > 'xyz(at)example(dot)com'::text) AND (apiproxy = 'test-service'::text) AND
> (apistatus = 'Success'::text) AND (serorgid = 'aircel'::text) AND
> (apiaction <> ALL ('{LRN,Pathfinder,ManuallySelect}'::te
> xt[])) AND (appname <> ALL ('{"Mobile Connect Developer Portal
> (Int(",MinskHBM,LondonHBM,SeoulHBM,MumbaiHBM,NVirginiaHBM,SPauloHBM,"Mobile
> Connect HeartBeat Monitor",PDMAOpenSDKTest1,PDMAOpenSDKTest2,PDMA
> SDKTest,APIHealth,A1qaDemoApp,test,"india e2e test tool","Test from John
> do not provision"}'::text[])))
> Rows Removed by Filter: 661068
> Buffers: shared hit=2 read=134969
> -> Seq Scan on "test.prod.fact_674"
> (cost=0.00..199633.65 rows=22840 width=34) (actual time=0.017..9936.557
> rows=30245 loops=1)
> Filter: ((client_received_start_timestamp
> >= '2018-03-28 18:30:00'::timestamp without time zone) AND
> (client_received_start_timestamp < '2018-04-11 18:30:00'::timestamp wi
> thout time zone) AND (exchangeinstance <> '(not set)'::text) AND (devemail
> <> 'test(at)example(dot)com'::text) AND (devemail <> 'srk(at)example(dot)com'::text)
> AND (devemail <> 'abc(at)example(dot)com'::text) AND (devemail <
> > 'xyz(at)example(dot)com'::text) AND (apiproxy = 'test-service'::text) AND
> (apistatus = 'Success'::text) AND (serorgid = 'aircel'::text) AND
> (apiaction <> ALL ('{LRN,Pathfinder,ManuallySelect}'::te
> xt[])) AND (appname <> ALL ('{"Mobile Connect Developer Portal
> (Int(",MinskHBM,LondonHBM,SeoulHBM,MumbaiHBM,NVirginiaHBM,SPauloHBM,"Mobile
> Connect HeartBeat Monitor",PDMAOpenSDKTest1,PDMAOpenSDKTest2,PDMA
> SDKTest,APIHealth,A1qaDemoApp,test,"india e2e test tool","Test from John
> do not provision"}'::text[])))
> Rows Removed by Filter: 745118
> Buffers: shared hit=2 read=154045
> -> Seq Scan on "test.prod.fact_682"
> (cost=0.00..253714.68 rows=26677 width=35) (actual time=0.693..12670.194
> rows=33679 loops=1)
> Filter: ((client_received_start_timestamp
> >= '2018-03-28 18:30:00'::timestamp without time zone) AND
> (client_received_start_timestamp < '2018-04-11 18:30:00'::timestamp wi
> thout time zone) AND (exchangeinstance <> '(not set)'::text) AND (devemail
> <> 'test(at)example(dot)com'::text) AND (devemail <> 'srk(at)example(dot)com'::text)
> AND (devemail <> 'abc(at)example(dot)com'::text) AND (devemail <
> > 'xyz(at)example(dot)com'::text) AND (apiproxy = 'test-service'::text) AND
> (apistatus = 'Success'::text) AND (serorgid = 'aircel'::text) AND
> (apiaction <> ALL ('{LRN,Pathfinder,ManuallySelect}'::te
> xt[])) AND (appname <> ALL ('{"Mobile Connect Developer Portal
> (Int(",MinskHBM,LondonHBM,SeoulHBM,MumbaiHBM,NVirginiaHBM,SPauloHBM,"Mobile
> Connect HeartBeat Monitor",PDMAOpenSDKTest1,PDMAOpenSDKTest2,PDMA
> SDKTest,APIHealth,A1qaDemoApp,test,"india e2e test tool","Test from John
> do not provision"}'::text[])))
> Rows Removed by Filter: 950037
> Buffers: shared hit=2 read=195927
> -> Seq Scan on "test.prod.fact_688"
> (cost=0.00..239629.23 rows=26485 width=33) (actual time=0.627..11931.789
> rows=36929 loops=1)
> Filter: ((client_received_start_timestamp
> >= '2018-03-28 18:30:00'::timestamp without time zone) AND
> (client_received_start_timestamp < '2018-04-11 18:30:00'::timestamp wi
> thout time zone) AND (exchangeinstance <> '(not set)'::text) AND (devemail
> <> 'test(at)example(dot)com'::text) AND (devemail <> 'srk(at)example(dot)com'::text)
> AND (devemail <> 'abc(at)example(dot)com'::text) AND (devemail <
> > 'xyz(at)example(dot)com'::text) AND (apiproxy = 'test-service'::text) AND
> (apistatus = 'Success'::text) AND (serorgid = 'aircel'::text) AND
> (apiaction <> ALL ('{LRN,Pathfinder,ManuallySelect}'::te
> xt[])) AND (appname <> ALL ('{"Mobile Connect Developer Portal
> (Int(",MinskHBM,LondonHBM,SeoulHBM,MumbaiHBM,NVirginiaHBM,SPauloHBM,"Mobile
> Connect HeartBeat Monitor",PDMAOpenSDKTest1,PDMAOpenSDKTest2,PDMA
> SDKTest,APIHealth,A1qaDemoApp,test,"india e2e test tool","Test from John
> do not provision"}'::text[])))
> Rows Removed by Filter: 893363
> Buffers: shared hit=2 read=184963
> -> Seq Scan on "test.prod.fact_696"
> (cost=0.00..233816.76 rows=25627 width=34) (actual time=0.809..11647.744
> rows=36409 loops=1)
> Filter: ((client_received_start_timestamp
> >= '2018-03-28 18:30:00'::timestamp without time zone) AND
> (client_received_start_timestamp < '2018-04-11 18:30:00'::timestamp wi
> thout time zone) AND (exchangeinstance <> '(not set)'::text) AND (devemail
> <> 'test(at)example(dot)com'::text) AND (devemail <> 'srk(at)example(dot)com'::text)
> AND (devemail <> 'abc(at)example(dot)com'::text) AND (devemail <
> > 'xyz(at)example(dot)com'::text) AND (apiproxy = 'test-service'::text) AND
> (apistatus = 'Success'::text) AND (serorgid = 'aircel'::text) AND
> (apiaction <> ALL ('{LRN,Pathfinder,ManuallySelect}'::te
> xt[])) AND (appname <> ALL ('{"Mobile Connect Developer Portal
> (Int(",MinskHBM,LondonHBM,SeoulHBM,MumbaiHBM,NVirginiaHBM,SPauloHBM,"Mobile
> Connect HeartBeat Monitor",PDMAOpenSDKTest1,PDMAOpenSDKTest2,PDMA
> SDKTest,APIHealth,A1qaDemoApp,test,"india e2e test tool","Test from John
> do not provision"}'::text[])))
> Rows Removed by Filter: 871346
> Buffers: shared hit=2 read=180422
> -> Seq Scan on "test.prod.fact_701"
> (cost=0.00..177624.27 rows=15959 width=36) (actual time=1.174..8911.760
> rows=16227 loops=1)
> Filter: ((client_received_start_timestamp
> >= '2018-03-28 18:30:00'::timestamp without time zone) AND
> (client_received_start_timestamp < '2018-04-11 18:30:00'::timestamp wi
> thout time zone) AND (exchangeinstance <> '(not set)'::text) AND (devemail
> <> 'test(at)example(dot)com'::text) AND (devemail <> 'srk(at)example(dot)com'::text)
> AND (devemail <> 'abc(at)example(dot)com'::text) AND (devemail <
> > 'xyz(at)example(dot)com'::text) AND (apiproxy = 'test-service'::text) AND
> (apistatus = 'Success'::text) AND (serorgid = 'aircel'::text) AND
> (apiaction <> ALL ('{LRN,Pathfinder,ManuallySelect}'::te
> xt[])) AND (appname <> ALL ('{"Mobile Connect Developer Portal
> (Int(",MinskHBM,LondonHBM,SeoulHBM,MumbaiHBM,NVirginiaHBM,SPauloHBM,"Mobile
> Connect HeartBeat Monitor",PDMAOpenSDKTest1,PDMAOpenSDKTest2,PDMA
> SDKTest,APIHealth,A1qaDemoApp,test,"india e2e test tool","Test from John
> do not provision"}'::text[])))
> Rows Removed by Filter: 671146
> Buffers: shared hit=2 read=137231
> -> Seq Scan on "test.prod.fact_709"
> (cost=0.00..181100.86 rows=14987 width=36) (actual time=2.614..9080.548
> rows=15270 loops=1)
> Filter: ((client_received_start_timestamp
> >= '2018-03-28 18:30:00'::timestamp without time zone) AND
> (client_received_start_timestamp < '2018-04-11 18:30:00'::timestamp wi
> thout time zone) AND (exchangeinstance <> '(not set)'::text) AND (devemail
> <> 'test(at)example(dot)com'::text) AND (devemail <> 'srk(at)example(dot)com'::text)
> AND (devemail <> 'abc(at)example(dot)com'::text) AND (devemail <
> > 'xyz(at)example(dot)com'::text) AND (apiproxy = 'test-service'::text) AND
> (apistatus = 'Success'::text) AND (serorgid = 'aircel'::text) AND
> (apiaction <> ALL ('{LRN,Pathfinder,ManuallySelect}'::te
> xt[])) AND (appname <> ALL ('{"Mobile Connect Developer Portal
> (Int(",MinskHBM,LondonHBM,SeoulHBM,MumbaiHBM,NVirginiaHBM,SPauloHBM,"Mobile
> Connect HeartBeat Monitor",PDMAOpenSDKTest1,PDMAOpenSDKTest2,PDMA
> SDKTest,APIHealth,A1qaDemoApp,test,"india e2e test tool","Test from John
> do not provision"}'::text[])))
> Rows Removed by Filter: 686447
> Buffers: shared hit=2 read=139861
> -> Seq Scan on "test.prod.fact_716"
> (cost=0.00..155888.30 rows=13752 width=36) (actual time=2.874..7810.737
> rows=14500 loops=1)
> Filter: ((client_received_start_timestamp
> >= '2018-03-28 18:30:00'::timestamp without time zone) AND
> (client_received_start_timestamp < '2018-04-11 18:30:00'::timestamp wi
> thout time zone) AND (exchangeinstance <> '(not set)'::text) AND (devemail
> <> 'test(at)example(dot)com'::text) AND (devemail <> 'srk(at)example(dot)com'::text)
> AND (devemail <> 'abc(at)example(dot)com'::text) AND (devemail <
> > 'xyz(at)example(dot)com'::text) AND (apiproxy = 'test-service'::text) AND
> (apistatus = 'Success'::text) AND (serorgid = 'aircel'::text) AND
> (apiaction <> ALL ('{LRN,Pathfinder,ManuallySelect}'::te
> xt[])) AND (appname <> ALL ('{"Mobile Connect Developer Portal
> (Int(",MinskHBM,LondonHBM,SeoulHBM,MumbaiHBM,NVirginiaHBM,SPauloHBM,"Mobile
> Connect HeartBeat Monitor",PDMAOpenSDKTest1,PDMAOpenSDKTest2,PDMA
> SDKTest,APIHealth,A1qaDemoApp,test,"india e2e test tool","Test from John
> do not provision"}'::text[])))
> Rows Removed by Filter: 589910
> Buffers: shared hit=1 read=120362
> -> Seq Scan on "test.prod.fact_723"
> (cost=0.00..127347.65 rows=14358 width=36) (actual time=2.279..6364.821
> rows=14775 loops=1)
> Filter: ((client_received_start_timestamp
> >= '2018-03-28 18:30:00'::timestamp without time zone) AND
> (client_received_start_timestamp < '2018-04-11 18:30:00'::timestamp wi
> thout time zone) AND (exchangeinstance <> '(not set)'::text) AND (devemail
> <> 'test(at)example(dot)com'::text) AND (devemail <> 'srk(at)example(dot)com'::text)
> AND (devemail <> 'abc(at)example(dot)com'::text) AND (devemail <
> > 'xyz(at)example(dot)com'::text) AND (apiproxy = 'test-service'::text) AND
> (apistatus = 'Success'::text) AND (serorgid = 'aircel'::text) AND
> (apiaction <> ALL ('{LRN,Pathfinder,ManuallySelect}'::te
> xt[])) AND (appname <> ALL ('{"Mobile Connect Developer Portal
> (Int(",MinskHBM,LondonHBM,SeoulHBM,MumbaiHBM,NVirginiaHBM,SPauloHBM,"Mobile
> Connect HeartBeat Monitor",PDMAOpenSDKTest1,PDMAOpenSDKTest2,PDMA
> SDKTest,APIHealth,A1qaDemoApp,test,"india e2e test tool","Test from John
> do not provision"}'::text[])))
> Rows Removed by Filter: 480327
> Buffers: shared hit=1 read=98259
> Planning time: 395.624 ms
> Execution time: 127362.763 ms
> (81 rows)

Thanks in Advance. I look forward to hearing from you.

Best Regards,