Created
February 7, 2018 14:30
-
-
Save adatta02/dcaf3d280c2f7672007b7b420f65d64d to your computer and use it in GitHub Desktop.
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| ----- Update statistics by running the ANALYZE command on these tables ----- | |
| ----- Tables missing statistics: campaigns78000295_v2 ----- | |
| XN Limit (cost=2999999999999999659174894884133939956615861204479803088453030456896447381288632370463183954715344896.00..2999999999999999659174894884133939956615861204479803088453030456896447381288632370463183954715344896.00 rows=1 width=52) | |
| -> XN Merge (cost=2999999999999999659174894884133939956615861204479803088453030456896447381288632370463183954715344896.00..2999999999999999659174894884133939956615861204479803088453030456896447381288632370463183954715344896.00 rows=1 width=52) | |
| -> XN Network (cost=2999999999999999659174894884133939956615861204479803088453030456896447381288632370463183954715344896.00..2999999999999999659174894884133939956615861204479803088453030456896447381288632370463183954715344896.00 rows=1 width=52) | |
| -> XN Sort (cost=2999999999999999659174894884133939956615861204479803088453030456896447381288632370463183954715344896.00..2999999999999999659174894884133939956615861204479803088453030456896447381288632370463183954715344896.00 rows=1 width=52) | |
| -> XN HashAggregate (cost=2999999999999999659174894884133939956615861204479803088453030456896447381288632370463183954715344896.00..2999999999999999659174894884133939956615861204479803088453030456896447381288632370463183954715344896.00 rows=1 width=52) | |
| -> XN Hash Left Join DS_DIST_BOTH (cost=2891.40..2999999999999999659174894884133939956615861204479803088453030456896447381288632370463183954715344896.00 rows=1 width=52) | |
| -> XN Hash Left Join DS_DIST_OUTER (cost=2571.28..1999999999999999934672337608233382547699066371613110945835923558942591691843455725217479736910938112.00 rows=1 width=52) | |
| -> XN Hash (cost=319.62..319.62 rows=200 width=4) | |
| -> XN Hash Left Join DS_DIST_OUTER (cost=1680.67..999999999999999967336168804116691273849533185806555472917961779471295845921727862608739868455469056.00 rows=1 width=52) | |
| -> XN Hash (cost=890.10..890.10 rows=200 width=4) | |
| -> XN Seq Scan on es_search_dump_accesses a (cost=0.00..1.50 rows=1 width=52) | |
| -> XN Hash (cost=1680.17..1680.17 rows=200 width=4) | |
| -> XN Subquery Scan c (cost=1678.17..1680.17 rows=200 width=4) | |
| -> XN HashAggregate (cost=1678.17..1678.17 rows=200 width=4) | |
| -> XN Seq Scan on "lr$f6me2cnolx6aybfay1l2f_hasoffers_clicks_payout" (cost=0.00..1342.54 rows=134254 width=4) | |
| -> XN Subquery Scan cpa (cost=888.10..890.10 rows=200 width=4) | |
| -> XN HashAggregate (cost=888.10..888.10 rows=200 width=4) | |
| -> XN Seq Scan on "lr$f6hb1o3p5j3w6swm406kb_hasoffers_conversions_payout" (cost=0.00..710.48 rows=71048 width=4) | |
| -> XN Subquery Scan g (cost=317.12..319.62 rows=200 width=4) | |
| -> XN HashAggregate (cost=317.12..317.62 rows=200 width=8) | |
| -> XN Seq Scan on campaigns78000295_v2 d (cost=0.00..253.70 rows=25370 width=8) |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment