617
93%

Ran 18 Nov 2017 05:47AM UTC

Jobs 22

Files 39

Run time 13min

Badge

Embed ▾

pending completion

Build # 617

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

1751 of 1881 relevant lines covered (93.09%)

1117.14 hits per line

Jobs

ID	Job ID	Ran	Coverage
1	617.1 (2.3.0, ADAPTER=active_record, gemfiles/activerecord_3.gemfile)	18 Nov 2017 05:47AM UTC	92.13	Travis Job 617.1
2	617.2 (2.2.4, ADAPTER=active_record, gemfiles/activerecord_3.gemfile)	18 Nov 2017 05:48AM UTC	92.13	Travis Job 617.2
3	617.3 (2.1.8, ADAPTER=active_record, gemfiles/activerecord_3.gemfile)	18 Nov 2017 05:47AM UTC	92.13	Travis Job 617.3
4	617.4 (2.0.0, ADAPTER=active_record, gemfiles/activerecord_3.gemfile)	18 Nov 2017 05:48AM UTC	92.13	Travis Job 617.4
5	617.5 (2.3.0, ADAPTER=active_record, gemfiles/activerecord_4.gemfile)	18 Nov 2017 05:48AM UTC	92.13	Travis Job 617.5
6	617.6 (2.2.4, ADAPTER=active_record, gemfiles/activerecord_4.gemfile)	18 Nov 2017 05:49AM UTC	92.13	Travis Job 617.6
7	617.7 (2.1.8, ADAPTER=active_record, gemfiles/activerecord_4.gemfile)	18 Nov 2017 05:51AM UTC	92.13	Travis Job 617.7
8	617.8 (2.0.0, ADAPTER=active_record, gemfiles/activerecord_4.gemfile)	18 Nov 2017 05:52AM UTC	92.13	Travis Job 617.8
9	617.9 (2.3.0, ADAPTER=active_record, gemfiles/activerecord_5.gemfile)	18 Nov 2017 05:51AM UTC	92.13	Travis Job 617.9
10	617.10 (2.2.4, ADAPTER=active_record, gemfiles/activerecord_5.gemfile)	18 Nov 2017 05:50AM UTC	92.13	Travis Job 617.10
11	617.11 (2.3.0, ADAPTER=mongoid, gemfiles/mongoid_3.gemfile)	18 Nov 2017 05:52AM UTC	91.75	Travis Job 617.11
12	617.12 (2.2.4, ADAPTER=mongoid, gemfiles/mongoid_3.gemfile)	18 Nov 2017 05:52AM UTC	91.75	Travis Job 617.12
13	617.13 (2.1.8, ADAPTER=mongoid, gemfiles/mongoid_3.gemfile)	18 Nov 2017 05:54AM UTC	91.75	Travis Job 617.13
14	617.14 (2.0.0, ADAPTER=mongoid, gemfiles/mongoid_3.gemfile)	18 Nov 2017 05:54AM UTC	91.75	Travis Job 617.14
15	617.15 (2.3.0, ADAPTER=mongoid, gemfiles/mongoid_4.gemfile)	18 Nov 2017 05:57AM UTC	91.75	Travis Job 617.15
16	617.16 (2.2.4, ADAPTER=mongoid, gemfiles/mongoid_4.gemfile)	18 Nov 2017 05:55AM UTC	91.75	Travis Job 617.16
17	617.17 (2.1.8, ADAPTER=mongoid, gemfiles/mongoid_4.gemfile)	18 Nov 2017 05:56AM UTC	91.75	Travis Job 617.17
18	617.18 (2.0.0, ADAPTER=mongoid, gemfiles/mongoid_4.gemfile)	18 Nov 2017 05:57AM UTC	91.75	Travis Job 617.18
19	617.19 (2.3.0, ADAPTER=mongoid, gemfiles/mongoid_5.gemfile)	18 Nov 2017 05:57AM UTC	91.75	Travis Job 617.19
20	617.20 (2.2.4, ADAPTER=mongoid, gemfiles/mongoid_5.gemfile)	18 Nov 2017 05:58AM UTC	91.75	Travis Job 617.20
21	617.21 (2.1.8, ADAPTER=mongoid, gemfiles/mongoid_5.gemfile)	18 Nov 2017 05:59AM UTC	91.75	Travis Job 617.21
22	617.22 (2.0.0, ADAPTER=mongoid, gemfiles/mongoid_5.gemfile)	18 Nov 2017 06:00AM UTC	91.75	Travis Job 617.22

Source Files on build 617

Detailed source file information is not available for this build.

RolifyCommunity / rolify / 617
93%

README BADGES
x

Markdown

Textile

RDoc

HTML

Rst

Jobs

Source Files on build 617

RolifyCommunity / rolify / 617 93%

README BADGES x

Markdown

Textile

RDoc

HTML

Rst

Jobs

Source Files on build 617

RolifyCommunity / rolify / 617
93%

README BADGES
x