test/best_index_test.rb in pghero-1.7.0 vs test/best_index_test.rb in pghero-2.0.0
- old
+ new
@@ -9,12 +9,12 @@
index = PgHero.best_index("SELECT * FROM users WHERE login_attempts = 1 ORDER BY created_at")
expected = {
found: true,
structure: {table: "users", where: [{column: "login_attempts", op: "="}], sort: [{column: "created_at", direction: "asc"}]},
index: {table: "users", columns: ["login_attempts", "created_at"]},
- rows: 10000,
- row_estimates: {"login_attempts (=)" => 333, "created_at (sort)" => 1},
- row_progression: [10000, 333, 0]
+ rows: 5000,
+ row_estimates: {"login_attempts (=)" => 167, "created_at (sort)" => 1},
+ row_progression: [5000, 167, 0]
}
assert_equal expected, index
end
def test_where_multiple_columns