Skip to content

Instantly share code, notes, and snippets.

@lukeasrodgers

lukeasrodgers/timings.md

Last active February 24, 2024 01:19
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save lukeasrodgers/8c2751c81df499219057333566cc8e14 to your computer and use it in GitHub Desktop.
Save lukeasrodgers/8c2751c81df499219057333566cc8e14 to your computer and use it in GitHub Desktop.
Download ZIP
time do do things
Raw
timings.md

databases

pg

  • dropping not null constraint on table with 800k rows, approx 35 columns: 32ms (8 core / 16 G RAM mbp)
  • counting table with 5.1M records: 42s (on heroku)
  • adding index on column, all values NULL: 42s (on heroku)
  • adding index concurrently on updated_at column, about 17M rows, aptible postgres ~800 IOPS: 455.8086s
  • adding index concurrently on 3 cols, item_type, event_type, updated_at, ~70M rows: 1.5hours
  • removing index concurrently, one index, table about 20M rows: 80s
  • adding index concurrently on 2 cols, banking_system_id (string, non-fk), platform (string), ~30M rows, about 3k IOPS: ~35 mins
  • adding index (employee_id, date, amount) non-concurrently on 60M row table, rds db.t3.large: about 1.5 mins
  • select count(*) on 60M row table db.t3.large: about 1.5 mins
  • concurrently add 3 column index on table with about 60M rows: 831.47s
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment