Guest User

Untitled

a guest
Feb 20th, 2018
84
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 3.48 KB | None | 0 0
  1. ----- Update statistics by running the ANALYZE command on these tables -----
  2. ----- Tables missing statistics: campaigns78000295_v2 -----
  3. XN Limit (cost=2999999999999999659174894884133939956615861204479803088453030456896447381288632370463183954715344896.00..2999999999999999659174894884133939956615861204479803088453030456896447381288632370463183954715344896.00 rows=1 width=52)
  4. -> XN Merge (cost=2999999999999999659174894884133939956615861204479803088453030456896447381288632370463183954715344896.00..2999999999999999659174894884133939956615861204479803088453030456896447381288632370463183954715344896.00 rows=1 width=52)
  5. -> XN Network (cost=2999999999999999659174894884133939956615861204479803088453030456896447381288632370463183954715344896.00..2999999999999999659174894884133939956615861204479803088453030456896447381288632370463183954715344896.00 rows=1 width=52)
  6. -> XN Sort (cost=2999999999999999659174894884133939956615861204479803088453030456896447381288632370463183954715344896.00..2999999999999999659174894884133939956615861204479803088453030456896447381288632370463183954715344896.00 rows=1 width=52)
  7. -> XN HashAggregate (cost=2999999999999999659174894884133939956615861204479803088453030456896447381288632370463183954715344896.00..2999999999999999659174894884133939956615861204479803088453030456896447381288632370463183954715344896.00 rows=1 width=52)
  8. -> XN Hash Left Join DS_DIST_BOTH (cost=2891.40..2999999999999999659174894884133939956615861204479803088453030456896447381288632370463183954715344896.00 rows=1 width=52)
  9. -> XN Hash Left Join DS_DIST_OUTER (cost=2571.28..1999999999999999934672337608233382547699066371613110945835923558942591691843455725217479736910938112.00 rows=1 width=52)
  10. -> XN Hash (cost=319.62..319.62 rows=200 width=4)
  11. -> XN Hash Left Join DS_DIST_OUTER (cost=1680.67..999999999999999967336168804116691273849533185806555472917961779471295845921727862608739868455469056.00 rows=1 width=52)
  12. -> XN Hash (cost=890.10..890.10 rows=200 width=4)
  13. -> XN Seq Scan on es_search_dump_accesses a (cost=0.00..1.50 rows=1 width=52)
  14. -> XN Hash (cost=1680.17..1680.17 rows=200 width=4)
  15. -> XN Subquery Scan c (cost=1678.17..1680.17 rows=200 width=4)
  16. -> XN HashAggregate (cost=1678.17..1678.17 rows=200 width=4)
  17. -> XN Seq Scan on "lr$f6me2cnolx6aybfay1l2f_hasoffers_clicks_payout" (cost=0.00..1342.54 rows=134254 width=4)
  18. -> XN Subquery Scan cpa (cost=888.10..890.10 rows=200 width=4)
  19. -> XN HashAggregate (cost=888.10..888.10 rows=200 width=4)
  20. -> XN Seq Scan on "lr$f6hb1o3p5j3w6swm406kb_hasoffers_conversions_payout" (cost=0.00..710.48 rows=71048 width=4)
  21. -> XN Subquery Scan g (cost=317.12..319.62 rows=200 width=4)
  22. -> XN HashAggregate (cost=317.12..317.62 rows=200 width=8)
  23. -> XN Seq Scan on campaigns78000295_v2 d (cost=0.00..253.70 rows=25370 width=8)
Add Comment
Please, Sign In to add comment