{"push_id":2109781730,"size":8,"distinct_size":1,"ref":"refs/heads/dev-stable","head":"c65ca57764ece8581450c8bc8044ae0396f72bbe","before":"70258c866a71837345d0ed39aa83e0fcaefccff0","commits":[{"sha":"c80bbe64baf9de2cb74083c1ac94791d9d80948f","author":{"name":"alburde1","email":"c8b052319a5e42bc2f27f0abb12d287437019187@bah.com"},"message":"Speeding up a33_2\n\n+ sf_133 is loaded by us and tas in appropriation is a derived field so\nneither is ever NULL","distinct":false,"url":"https://api.github.com/repos/fedspendingtransparency/data-act-broker-backend/commits/c80bbe64baf9de2cb74083c1ac94791d9d80948f"},{"sha":"bf2798a6dd6f9d27977d7a5db7de8232cba7b665","author":{"name":"alburde1","email":"c8b052319a5e42bc2f27f0abb12d287437019187@bah.com"},"message":"Speeding up a35","distinct":false,"url":"https://api.github.com/repos/fedspendingtransparency/data-act-broker-backend/commits/bf2798a6dd6f9d27977d7a5db7de8232cba7b665"},{"sha":"88372053954853e3887f7e95c56d123f261577f3","author":{"name":"alburde1","email":"c8b052319a5e42bc2f27f0abb12d287437019187@bah.com"},"message":"Speeding up c9_award_financial","distinct":false,"url":"https://api.github.com/repos/fedspendingtransparency/data-act-broker-backend/commits/88372053954853e3887f7e95c56d123f261577f3"},{"sha":"79d374702b0fe6d97b286df0399c065802248983","author":{"name":"alburde1","email":"c8b052319a5e42bc2f27f0abb12d287437019187@bah.com"},"message":"Speeding up b9_award_financial further\n\n+ program_activity is our table and program_activity_name and\nprogram_activity_code will never be null (ran a query in prod to make\nsure). Others can be so we have to coalesce if we want to remove IS NOT\nDISTINCT FROM","distinct":false,"url":"https://api.github.com/repos/fedspendingtransparency/data-act-broker-backend/commits/79d374702b0fe6d97b286df0399c065802248983"},{"sha":"dbd43b2f15c91abff488f53ef4ff9223ac9a9cd3","author":{"name":"alburde1","email":"c8b052319a5e42bc2f27f0abb12d287437019187@bah.com"},"message":"Speeding up c11_cross_file","distinct":false,"url":"https://api.github.com/repos/fedspendingtransparency/data-act-broker-backend/commits/dbd43b2f15c91abff488f53ef4ff9223ac9a9cd3"},{"sha":"847ca72b4cad6b5e2e0303b62c2a3f6cdeb083a8","author":{"name":"alburde1","email":"c8b052319a5e42bc2f27f0abb12d287437019187@bah.com"},"message":"Speeding up b20_object_class_program_activity","distinct":false,"url":"https://api.github.com/repos/fedspendingtransparency/data-act-broker-backend/commits/847ca72b4cad6b5e2e0303b62c2a3f6cdeb083a8"},{"sha":"1178c319a75058b0e41099a92625423b99b67a67","author":{"name":"alburde1","email":"c8b052319a5e42bc2f27f0abb12d287437019187@bah.com"},"message":"Speeding up b9_object_class_program_activity\n\nSame speedups as the other b9 rule for the same reasons","distinct":false,"url":"https://api.github.com/repos/fedspendingtransparency/data-act-broker-backend/commits/1178c319a75058b0e41099a92625423b99b67a67"},{"sha":"c65ca57764ece8581450c8bc8044ae0396f72bbe","author":{"name":"Michael Hess","email":"a5b7a83047a1829e80ea6134d4959dd40001174c@users.noreply.github.com"},"message":"Merge pull request #1028 from fedspendingtransparency/db-2300-dabs-sql-speedups\n\nDb 2300 dabs sql speedups","distinct":true,"url":"https://api.github.com/repos/fedspendingtransparency/data-act-broker-backend/commits/c65ca57764ece8581450c8bc8044ae0396f72bbe"}]}
{"actor":{"display_login":"michaeldhess"}}