2
93%
master: 93%

Ran 18 Nov 2017 05:48AM UTC

Files 36

Run time 2s

Badge

Embed ▾

Committed 18 Nov 2017 05:45AM UTC coverage: 92.125%. Remained the same

Job # 2.2.4, ADAPTER=active_record, gemfiles/activerecord_3.gemfile

Build Type

push

travis-ci

Committed by

EppO

Commit Message

remove a separate index for the name column for PG (#467)

remove a separate index for the name column if running on Postgresql

*Note:* I tested with Postgres only. Run an `EXPLAIN` query:  
```
> Role.where(name: 'Admin').explain
  Role Load (0.5ms)  SELECT "roles".* FROM "roles" WHERE "roles"."name" = $1  [["name", "Admin"]]
 => EXPLAIN for: SELECT "roles".* FROM "roles" WHERE "roles"."name" = $1 [["name", "Admin"]]
                                                     QUERY PLAN
--------------------------------------------------------------------------------------------------------------------
 Bitmap Heap Scan on roles  (cost=4.17..11.28 rows=3 width=96)
   Recheck Cond: ((name)::text = 'Admin'::text)
   ->  Bitmap Index Scan on index_roles_on_name_and_resource_type_and_resource_id  (cost=0.00..4.17 rows=3 width=0)
         Index Cond: ((name)::text = 'Admin'::text)
(4 rows)
```

https://github.com/ankane/pghero adds this index to the Duplicate Indexes section.

On roles  
`index_roles_on_name (name)`  
is covered by  
`index_roles_on_name_and_resource_type_and_resource_id (name, resource_type, resource_id)`

* add the name index only when necessary

Run Details

1591 of 1727 relevant lines covered (92.13%)

69.06 hits per line

RolifyCommunity / rolify / 617 / 2
93%
master: 93%

README BADGES
x

Markdown

Textile

RDoc

HTML

Rst

Source Files on job 617.2 (2.2.4, ADAPTER=active_record, gemfiles/activerecord_3.gemfile)

RolifyCommunity / rolify / 617 / 2 93% master: 93%

README BADGES x

Markdown

Textile

RDoc

HTML

Rst

Source Files on job 617.2 (2.2.4, ADAPTER=active_record, gemfiles/activerecord_3.gemfile)

RolifyCommunity / rolify / 617 / 2
93%
master: 93%

README BADGES
x