daily pastebin goal
8%
SHARE
TWEET

Untitled

a guest Mar 16th, 2018 599 Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. ANALYZE subscribers;
  2. SELECT reltuples AS estimate FROM pg_class WHERE relname = 'subscribers'
  3. (and where status = 'active' / where status= 'inactive' or status='suspended')
  4.    
  5. estimate (active): 12
  6. estimate (inactive/suspended): 12
  7.    
  8. SELECT count(*) AS active
  9. FROM   subscribers
  10. WHERE  status = 'active';
  11.  
  12. SELECT count(*) AS inactive
  13. FROM   subscribers
  14. WHERE  status = 'inactive'
  15. OR     status = 'suspended';
  16.    
  17. CREATE EXTENSION IF NOT EXISTS "uuid-ossp";
  18. DROP TABLE IF EXISTS subscribers;
  19.  
  20. CREATE TABLE subscribers (
  21.   id VARCHAR(36) DEFAULT uuid_generate_v1mc(),
  22.   key SERIAL PRIMARY KEY,
  23.   status VARCHAR(20) DEFAULT 'inactive',
  24.   email VARCHAR,
  25.   subscriber VARCHAR NOT NULL,
  26.   password VARCHAR,
  27.   phone VARCHAR,
  28.   plan VARCHAR,
  29.   startDate TEXT DEFAULT TO_CHAR(NOW(), 'Mon DD, YYYY'),
  30.   endDate TEXT,
  31.   amount DECIMAL(12,2),
  32.   isGod BOOLEAN DEFAULT FALSE
  33. );
  34.  
  35. INSERT INTO subscribers (status, email, subscriber, password, phone, plan, endDate, amount)
  36.   VALUES
  37.   ('active', 'admin@admin.com', 'Admin', 'password', '(555) 555-5555', 'Carlotta Prime', null, 29.99),
  38.   ('active', 'squatters@gmail.com', 'Sherry Waters', 'password', '(555) 555-5555', 'Carlotta Prime', null, 29.99),
  39.   ('active', 'bob-eh@sap.com', 'Bob Aronssen', 'password', '(555) 555-5555', 'Carlotta Prime', null, 29.99),
  40.   ('active', 'shani.smith@hotmail.com', 'Shaniqua Smith', 'password', '(555) 555-5555', 'Carlotta Prime', null, 29.99),
  41.   ('active', 'tanyaballschin@gmail.com', 'Tanya Ballschin', 'password', '(555) 555-5555', 'Carlotta Prime', null, 29.99),
  42.   ('active', 'lukeskywalker@rebelforce.com', 'Siemen Walker', 'password', '(555) 555-5555', 'Carlotta Prime', null, 29.99),
  43.   ('active', 'jTank@aol.com', 'Jenny Tanks', 'password', '(555) 555-5555', 'Carlotta Prime', null, 29.99),
  44.   ('active', 'amberLamps@yahoo.com', 'Amber Lalampas', 'password', '(555) 555-5555', 'Carlotta Prime', null, 29.99),
  45.   ('active', 'kylebTeegue@gmail.com', 'Kyle Teegue', 'password', '(555) 555-5555', 'Carlotta Prime', null, 29.99),
  46.   ('active', 'snakePiliskin@gmail.com', 'Gary Pilkinson', 'password', '(555) 555-5555', 'Carlotta Prime', null, 29.99),
  47.   ('active', 'yasminRod@hotmail.com', 'Yasmin Rodrigues', 'password', '(555) 555-5555', 'Carlotta Prime', null, 29.99),
  48.   ('active', 'adaDamn@photonmail.com', 'Adam Johnson', 'password', '(555) 555-5555', 'Carlotta Prime', null, 29.99),
  49.   ('inactive', 'carlsagan42@yahoo.com', 'Carl Sagan', 'password', '(555) 555-555', 'Carlotta Prime', 'Jan 3, 2018', 29.99),
  50.   ('inactive', 'seamark@outlook.com', 'Mark Canelo', 'password', '(555) 555-555', 'Carlotta Prime', 'Jan 12, 2018', 29.99),
  51.   ('suspended', 'axxll@manjaro.com', 'Axle Root', 'password', '(555) 555-555', 'Carlotta Prime', 'Jan 16, 2018', 29.99),
  52.   ('inactive', 'vicksAdam@sap.com', 'Adamn Vicks', 'password', '(555) 555-555', 'Carlotta Prime', 'Jan 17, 2018', 29.99),
  53.   ('inactive', 'wallyworld@manjaro.com', 'Wes Walls', 'password', '(555) 555-555', 'Carlotta Prime', 'Jan 17, 2018', 29.99),
  54.   ('suspended', 'kellyUll@gmail.com', 'Kelly Ullman', 'password', '(555) 555-555', 'Carlotta Prime', 'Jan 17, 2018', 29.99),
  55.   ('inactive', 'oatesA@aol.com', 'Adam Oates', 'password', '(555) 555-555', 'Carlotta Prime', 'Jan 17, 2018', 29.99),
  56.   ('suspended', 'scottParker@jaro.com', 'Scott Parker', 'password', '(555) 555-555', 'Carlotta Prime', 'Jan 21, 2018', 29.99),
  57.   ('suspended', 'asmLossenger@mancusco.com', 'Emily Loz', 'password', '(555) 555-555', 'Carlotta Prime', 'Jan 22, 2018', 29.99),
  58.   ('inactive', 'pparks@akins.com', 'Parker Posey', 'password', '(555) 555-555', 'Carlotta Prime', 'Jan 29, 2018', 29.99),
  59.   ('suspended', 'aleashtrails@kilmas.com', 'Alisha Tallis', 'password', '(555) 555-555', 'Carlotta Prime', 'Jan 29, 2018', 29.99),
  60.   ('suspended', '88Damon@photonmail.com', 'Damien Smith', 'password', '(555) 555-5555', 'Carlotta Prime', 'Jan 29, 2018', 29.99);
RAW Paste Data
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy. OK, I Understand
 
Top