File: explain.sql

package info (click to toggle)
prefix 1.2.3-3
  • links: PTS, VCS
  • area: main
  • in suites: jessie, jessie-kfreebsd
  • size: 688 kB
  • ctags: 150
  • sloc: ansic: 1,313; sql: 756; makefile: 36; sh: 2
file content (8 lines) | stat: -rw-r--r-- 508 bytes parent folder | download | duplicates (7) 
1
2
3
4
5
6
7
8
 
explain (costs off) select * from ranges where prefix @> '0146640123';
explain (costs off) select * from ranges where prefix @> '0146640123' order by length(prefix) desc limit 1;
explain (costs off) select * from ranges where prefix @> '0100091234';
explain (costs off) select * from ranges where prefix @> '0100091234' order by length(prefix) desc limit 1;

explain (costs off) select * from numbers n join ranges r on r.prefix @> n.number;

explain (costs off) select count(*) from tst where pref <@ '55';