Guest User

Untitled

a guest
Jun 20th, 2018
77
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.18 KB | None | 0 0
  1. my_db=> explain select value from my_table;
  2. Seq Scan on my_table (cost=0.00..94431870.58 rows=5441724758 width=4)
  3.  
  4. my_db=> explain select max(value) from my_table;
  5. Finalize Aggregate (cost=48518318.76..48518318.77 rows=1 width=4)
  6. -> Gather (cost=48518317.93..48518318.74 rows=8 width=4)
  7. Workers Planned: 8
  8. -> Partial Aggregate (cost=48517317.93..48517317.94 rows=1 width=4)
  9. -> Parallel Seq Scan on my_table (cost=0.00..46816778.95 rows=680215595 width=4)
  10.  
  11. my_db=> d my_table
  12. id | bigint | not null default nextval('my_table_id_seq'::regclass)
  13. datetime | timestamp(0) without time zone | not null
  14. value | real | not null
  15. my_id | smallint | not null
  16. my_flag | boolean | not null
  17.  
  18. my_db=> d my_table_id_seq
  19. sequence_name | name | my_table_id_seq
  20. last_value | bigint | 4971842011
  21. start_value | bigint | 1
  22. increment_by | bigint | 1
  23. max_value | bigint | 9223372036854775807
  24. min_value | bigint | 1
  25. cache_value | bigint | 1
  26. log_cnt | bigint | 22
  27. is_cycled | boolean | f
  28. is_called | boolean | t
Add Comment
Please, Sign In to add comment