Skip to content

Instantly share code, notes, and snippets.

View alekseyl's full-sized avatar
👨‍💻
Looking for a job

Aleksey Leshchuk alekseyl

👨‍💻
Looking for a job
12 followers · 1 following
View GitHub Profile
@alekseyl
alekseyl / rswag_quote.rb
Created November 8, 2017 13:46
rswag quote for API documenting note
# spec/integration/blogs_spec.rb
require 'swagger_helper'
describe 'Blogs API' do
path '/blogs' do
post 'Creates a blog' do
tags 'Blogs'
consumes 'application/json', 'application/xml'
@alekseyl
alekseyl / minitest-apidoc-quote.rb
Created November 8, 2017 13:52
minitest apidoc quote for API-comparision tech note
require_relative "../../spec_helper"
document Albums::Create do
meta :group, "Albums"
meta :request_method, "POST"
meta :request_path, "/albums"
meta :description, "Creates a new album with the given parameters."
param "name", "Name of the album", required: true
@alekseyl
alekseyl / apipie_example_quote.rb
Created November 8, 2017 14:31
apipie quote
class UsersController < ApplicationController
resource_description do
formats [:json]
api_versions 'public'
end
api :POST, '/users' 'Create user'
description 'Create user with specifed user params'
param :user, Hash, desc: 'User information' do
@alekseyl
alekseyl / swagger-docs-exmaple-quote.rb
Created November 8, 2017 15:22
swagger doc example for my note from sitepoint.com/do-the-right-thing-and-document-your-rails-api-with-swagger/
class Api::V1::UsersController < ApplicationController
.....
# POST /users
swagger_api :create do
summary "To create user"
notes "Implementation notes, such as required params, example queries for apis are written here."
param :form, "user[name]", :string, :required, "Name of user"
param :form, "user[age]", :integer, :optional, "Age of user"
param_list :form, "user[status]", :string, :required, "Status of user, can be active or inactive"
response :success
@alekseyl
alekseyl / derailed_index_example.sql
Last active November 23, 2017 12:14
derailed postgres index example on GIN without datatype convertion
EXPLAIN ANALYZE SELECT id, title FROM "cards"
WHERE (title_tsv @@ to_tsquery( 'english', '(o:*|o)')) AND collection_id = 624
LIMIT 10;
QUERY PLAN
-----------------------------------------------------------------------------------------------------------------------------------------------------------------
Limit (cost=408.55..447.93 rows=10 width=57) (actual time=273.000..273.103 rows=10 loops=1)
-> Bitmap Heap Scan on cards (cost=408.55..554.24 rows=37 width=57) (actual time=272.999..273.101 rows=10 loops=1)
Recheck Cond: ((collection_id = 624) AND (title_tsv @@ '''o'':* | ''o'''::tsquery) )
Heap Blocks: exact=10
-> BitmapAnd (cost=408.55..408.55 rows=37 width=0) (actual time=272.973..272.973 rows=0 loops=1)
@alekseyl
alekseyl / postgres_derailed_GIN_2.sql
Last active November 23, 2017 14:38
Fixed plan.
EXPLAIN ANALYZE SELECT id, title FROM "cards"
WHERE (title_tsv @@ to_tsquery( 'english', '(o:*|o)')) AND collection_id = 624::bigint
LIMIT 10;
QUERY PLAN
-------------------------------------------------------------------------------------------------------------------------------------------------
Limit (cost=64.38..103.76 rows=10 width=57) (actual time=70.233..70.250 rows=10 loops=1)
-> Bitmap Heap Scan on cards (cost=64.38..210.07 rows=37 width=57) (actual time=70.231..70.248 rows=10 loops=1)
Recheck Cond: ((title_tsv @@ '''o'':* | ''o'''::tsquery) AND (collection_id = '624'::bigint))
Heap Blocks: exact=10
-> Bitmap Index Scan on index_examples_fts_with_collection (cost=0.00..64.37 rows=37 width=0) (actual time=70.204..70.204 rows=131 loops=1)
@alekseyl
alekseyl / broken_like_example.sql
Last active November 24, 2017 11:12
EXPLAIN ANALYZE SELECT * FROM words WHERE word LIKE 't%' LIMIT 10;
QUERY PLAN
-------------------------------------------------------------------------------------------------------------------
Limit (cost=0.00..32.10 rows=10 width=440) (actual time=68.487..100.961 rows=10 loops=1)
-> Seq Scan on words (cost=0.00..40795.61 rows=12707 width=440) (actual time=68.485..100.959 rows=10 loops=1)
Filter: ((word)::text ~~ 't%'::text)
Rows Removed by Filter: 181269
Planning time: 7.296 ms
Execution time: 101.007 ms
@alekseyl
alekseyl / varchar_pattern_example2.sql
Created November 24, 2017 11:31
EXPLAIN ANALYZE SELECT * FROM words WHERE word = 'test';
QUERY PLAN
--------------------------------------------------------------------------------------------------------------------------
Index Scan using index_words_word on words (cost=0.42..8.44 rows=1 width=440) (actual time=1.628..1.631 rows=1 loops=1)
Index Cond: ((word)::text = 'test'::text)
Planning time: 0.269 ms
Execution time: 1.686 ms
@alekseyl
alekseyl / var_char_patter_ops3.sql
Created November 24, 2017 12:47
EXPLAIN ANALYZE SELECT * FROM words WHERE word LIKE 'o%' LIMIT 10;
QUERY PLAN
----------------------------------------------------------------------------------------------------------------------------------------
Limit (cost=0.42..36.23 rows=10 width=440) (actual time=1.343..1.473 rows=10 loops=1)
-> Index Scan using index_words_word on words (cost=0.42..30333.13 rows=8471 width=440) (actual time=1.341..1.468 rows=10 loops=1)
Index Cond: (((word)::text ~>=~ 'o'::text) AND ((word)::text ~<~ 'p'::text))
Filter: ((word)::text ~~ 'o%'::text)
Planning time: 0.207 ms
Execution time: 1.521 ms
@alekseyl
alekseyl / varchar_pattern_example4.sql
Created November 24, 2017 12:49
EXPLAIN ANALYZE SELECT * FROM words WHERE word LIKE 'o%' ORDER BY word LIMIT 10;
QUERY PLAN
------------------------------------------------------------------------------------------------------------------------------------------------
Limit (cost=20178.09..20178.12 rows=10 width=440) (actual time=123.264..123.267 rows=10 loops=1)
-> Sort (cost=20178.09..20199.27 rows=8471 width=440) (actual time=123.263..123.264 rows=10 loops=1)
Sort Key: word
Sort Method: top-N heapsort Memory: 29kB
-> Bitmap Heap Scan on words (cost=218.41..19995.04 rows=8471 width=440) (actual time=12.194..97.945 rows=11599 loops=1)
Filter: ((word)::text ~~ 'o%'::text)
Heap Blocks: exact=1192