holy crap

 1
 2
 3
 4
 5
 6
 7
 8
 9
10
11
12
13
14
15
16
17
qqq=> EXPLAIN SELECT * FROM "artist" WHERE ("artist"."name" ILIKE '%%') ORDER BY "artist"."name" ASC, "artist"."id" ASC;
QUERY PLAN
----------------------------------------------------------------
Sort (cost=4.37..4.40 rows=12 width=1491)
Sort Key: name, id
-> Seq Scan on artist (cost=0.00..4.15 rows=12 width=1491)
Filter: ((name)::text ~~* '%%'::text)
(4 rows)
qqq=> EXPLAIN SELECT * FROM "artist" WHERE ("artist"."name" ILIKE '%K%') ORDER BY "artist"."name" ASC, "artist"."id" ASC;
QUERY PLAN
----------------------------------------------------------------
Sort (cost=4.37..4.40 rows=12 width=1491)
Sort Key: name, id
-> Seq Scan on artist (cost=0.00..4.15 rows=12 width=1491)
Filter: ((name)::text ~~* '%K%'::text)
(4 rows)