add batch remove batch split batch show hidden batches hide batch
db<>fiddle
feedback about
By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
CREATE TABLE
INSERT 0 10001
SET
VACUUM
lc_collate
en_GB.UTF-8
SHOW
CREATE INDEX
name
BaomSxwZEgnW
BasxPBKsFdxYw
BaT[nroveIM`s
Dr]KAM
DrlFQzKrX
DrOop\HvBPUKm
Drqlapuse\VmKD
DrWxMgp
SELECT 8
QUERY PLAN
Sort (cost=207.02..207.03 rows=2 width=10) (actual time=1.746..1.747 rows=8 loops=1)
  Sort Key: name
  Sort Method: quicksort Memory: 25kB
  -> Seq Scan on spelers (cost=0.00..207.01 rows=2 width=10) (actual time=0.134..1.734 rows=8 loops=1)
        Filter: ((name ~~ 'Ba%'::text) OR (name ~~ 'Dr%'::text))
        Rows Removed by Filter: 9993
Planning Time: 0.069 ms
Execution Time: 1.766 ms
EXPLAIN
name
BaomSxwZEgnW
BasxPBKsFdxYw
BaT[nroveIM`s
Dr]KAM
DrlFQzKrX
DrOop\HvBPUKm
Drqlapuse\VmKD
DrWxMgp
SELECT 8
QUERY PLAN
Sort (cost=182.02..182.03 rows=2 width=10) (actual time=1.672..1.673 rows=8 loops=1)
  Sort Key: name
  Sort Method: quicksort Memory: 25kB
  -> Seq Scan on spelers (cost=0.00..182.01 rows=2 width=10) (actual time=0.130..1.661 rows=8 loops=1)
        Filter: (name ~~ ANY ('{Ba%,Dr%}'::text[]))
        Rows Removed by Filter: 9993
Planning Time: 0.062 ms
Execution Time: 1.686 ms
EXPLAIN
name
BaomSxwZEgnW
BasxPBKsFdxYw
BaT[nroveIM`s
Dr]KAM
DrlFQzKrX
DrOop\HvBPUKm
Drqlapuse\VmKD
DrWxMgp
SELECT 8
QUERY PLAN
Sort (cost=207.02..207.03 rows=2 width=10) (actual time=3.681..3.683 rows=8 loops=1)
  Sort Key: name
  Sort Method: quicksort Memory: 25kB
  -> Seq Scan on spelers (cost=0.00..207.01 rows=2 width=10) (actual time=0.275..3.667 rows=8 loops=1)
        Filter: ((name ^@ 'Ba'::text) OR (name ^@ 'Dr'::text))
        Rows Removed by Filter: 9993
Planning Time: 0.107 ms
Execution Time: 3.700 ms
EXPLAIN
name
BaomSxwZEgnW
BasxPBKsFdxYw
BaT[nroveIM`s
Dr]KAM
DrlFQzKrX
DrOop\HvBPUKm
Drqlapuse\VmKD
DrWxMgp
SELECT 8
QUERY PLAN
Sort (cost=182.02..182.03 rows=2 width=10) (actual time=3.678..3.679 rows=8 loops=1)
  Sort Key: name
  Sort Method: quicksort Memory: 25kB
  -> Seq Scan on spelers (cost=0.00..182.01 rows=2 width=10) (actual time=0.296..3.666 rows=8 loops=1)
        Filter: (name ^@ ANY ('{Ba,Dr}'::text[]))
        Rows Removed by Filter: 9993
Planning Time: 0.080 ms
Execution Time: 3.693 ms
EXPLAIN
name
BaomSxwZEgnW
BasxPBKsFdxYw
BaT[nroveIM`s
Dr]KAM
DrlFQzKrX
DrOop\HvBPUKm
Drqlapuse\VmKD
DrWxMgp
SELECT 8
QUERY PLAN
Sort (cost=182.02..182.03 rows=1 width=10) (actual time=3.756..3.757 rows=8 loops=1)
  Sort Key: name
  Sort Method: quicksort Memory: 25kB
  -> Seq Scan on spelers (cost=0.00..182.01 rows=1 width=10) (actual time=0.299..3.742 rows=8 loops=1)
        Filter: (name ~ '^(Ba|Dr).*'::text)
        Rows Removed by Filter: 9993
Planning Time: 0.100 ms
Execution Time: 3.773 ms
EXPLAIN
name
BaomSxwZEgnW
BAsV\RniCMgBGZi
BasxPBKsFdxYw
BAtmgcbz
BaT[nroveIM`s
BbCyfoVrJZY_Ys_
BbK[KoENSQ
BBkXXpJx
B[BlRAe
BBnfiLAj\
B`bobeugWKVL]usYoA
BBqPjYo]O
BbSIhvNQQE_PqAKma
BbZ\WDxVPzooGNi
BCciDLYRutZ_
BcCtcHFuHoZ
BCfJYO
BcJLx\p]hGDn
BCVao[AFIJvFQ
Bd
BdcWS[CJY
BdGSYN^cG_z
B_dtKwXtAxKu_OP
BdxYdwiNbvJ
BDzQetDLVLg
BebgOiOf
BEFEmvFQCRL
BeFMnJ
BElfFF
B[e_NDdQ
BENHycvsu
BeUKwLp
BfbTgUrwhQZpF
BFJDfCPa
BghxxW
BgktFYFCz\Eks
B_GPyvt
B^GsHgW
BgTgMUYCa
BgXzBN
BHbJ^mCKC
BhcoWEBCLS
BHECHPNgX\Y
Bh]miPB]
BHQXNlalMsy
BHskHJLF
BicLQf
BipwPFGAPt]YGEei
BIYF_wjCd
BJae_tU\
BJRXOxyNWci
Bjs\NvX`Kh
B\JUeC\kGqy
B[[Ka\qYBIBi
BkcRhDV
BkdrAsNoenHvtbv
BkFk\o
Bk[Hfm\mmYt
BKiT_sEGzVgF
B[k]U_
BLeGuaZnrv
BljoXfv
BLokL_BKCywuZF
BmfztUJhDCkO
BMGnuFi
BMJtt]
BmqMafdkewI
BMQsyeRqHcNtzn[zLr
BMsbxs]F
BN
BNetME`
BnMgi[Sn
BnvXZIsC
BNYZAk
BNZNIJxSgg`PF
BOadx[K
BOfxN
BOOnliplBp
BOQPMjYvj
BoT[vjrdmK
BOwjjH]jX
BoZ[RQgS
BpAPylI
Bp`AxHaf
BPdEK
BPdKVHDfYnHAI
BpExGFzqMoG
B\pgJVfkfRDv
Bpg^LYX_BzFiqWQn
BP^H]Ku
Bpj]fmYcn
BpkiJld
B_PMBKTKDKbNZwUxP
BPNBPLav\SbJQ
BPNoad^M
BppwIzSisNHhy
BpWgTC`fXkOz
BPW`gT`pcv
BQGmDjH
Bqi]hUMq[
BQYgWboPg`
BQzvZXav
BRDqL`OepyHwB
BRerINckS[Hd
BRiIa
BRjHvwo
BrNRpt_HuAC
BrOcDm
BRuvyCqMH`
BsH^zsFogx
BSkpPu[uEDCdg
BSMjF[YxS]HCWOIEf
BsVCW_
BsWKrZE\
Bsxqlk_oBnnx
BTcnxdxK^
BTFVEY[_a
Bt_gRjMaeld
BtguBmo
BTHXnscJG\M
BTM`OswFL
BtNmDa]
BT`Rbw`HPri
BTsKHFlCxuEC
BtsocAlDxn`Krm]
BtXDK]
BUEOGwIzG
B`uKklqbZQc`v
BUmbMI]Z
BurfRxYJXm
BuVhjd
B[u[xB_
BVaFyjuf
BVIuNHoRF
BVkoKac
BvmVLrfUhg
BVnBmgJa^
BvS`OPczMW`MB
BVtUIID`Lp\e
BV]VrPLhxpX^WrZ
BvWeQebv
BvYkxs]AP^Cd
BWC]ABEmi
B`[WfSjd
BwGIzHsnei
BwIquXK_
BW]jHYcNKPGAd
BxHjpXV`z
B_xjlUVDeJ
BxOmCUUHAME_
B[XoUytQyh
BxQQqI[ArV
Bx`[QRGz
Bx[zELKjD^
BxzrAle_exeJc
ByBdx
Byk[A`r
BYkFcPyR
B[YrVrEjKvG
ByvbWS
ByXMZep
BZATXTWC
BZfjrPL[jy_ZI
BZKjay[mKFTrlG
BzLGgYlt]EE
BzNXxtqUji`SOS
BZPRL]dckBsb
DAbFffhxzUE
DAemMGCnM[[Sh
DairpfSMSj
DamoVRkcv
D^AnibYwCXNPM
DaOu[VhvktUZ
D\aQPvPO
DAsA_goDdp
DaSmtzKGH
DA^VmnFA
DAzs_AQPhpOw
Db[cIz]ze]W
DbFSBM]koN
DBKY
DBrzQljViwlQxX
DbsNDnj\JY
Dc[hNlnx
DcPvd
DCRU]iCINoA
DCzHrbhhURmhuWT
DdbWw
Ddlnf
DdOvDh
DdtHlyn\Wpe
DDYAnHbwm`RlSm
DEExfzInZQTX
De^iTea
DeSBAobhS`wy^As
DEseETSXt
DfGm
DfgOkJRRHBKa
DFl`HKFzV
D]fOdgnP
D[\fOp_N\UW
D^fucRSsGvZ
DF_vF`FbNe^
Df[XaIfCraB
DFXdTJtqsuncVM
DGdCFAjW_QOaBi
DGfRxjhGoVRc
DhapYpD_Yu
DhaQvTGWCu[
DhbB
DHbkGzxlfqdQq
DHdVmZF
DhiixRvr
D`HJenVtR
DHjUk_LiWX
DHJz\axCps\Mp
DHNgSYynzZ_AaRp
DhQVzIBh]
D[ICHL`Db
DiFH^jGupKLo
DIMiirJLF
DImRvdh
DIUloB]hMTkKJzkU
DJa`WgukvP
DjboYk\lGL
DJisBflvqC
DjQonW
DjqSw\m
DJtNLR^S
DJxzm
DJ]]ZuF[Ko
D`kpy
DKuebv^lfF
DKzAlscG`
DkZMxyUe]
DlEqwFs\LVr
D`l\hX
D_LktRPAV
DlOpCdXAqG
DLtBYsQa
DLTyEBb
DMcsGBqgP
DmGlCbe`ZCjEo
DmkWN[Gv
DM]olwm
DMpGASPVoTz
D[mpMvD
DNgs\
DNjZjyKUVpiw
Dn_NIfoSyZEwgdSI\D
DoBoAmp`[a
D`O_[efEckRJan[Dw
DoitnlKxUCo
DoiYIiy
DORNCw`fBKa
DO^tJXjE
DoWWVcmVD
DOy[vHohQ
DPc
D]PGsmo`
DpkundnN
DPMJ]cfVMxe
DPUHBNeUwk\VtG
DPVM[SWVSQFZ
D\PvyCEalO
DQbmEK
DqFPRt
DQiW^hy
DQoG
D`qtcYqQd
DQZDBvOW
D^rAPZdfes[nF
DRCPGlAPW]
Dr]KAM
DrlFQzKrX
DrOop\HvBPUKm
Drqlapuse\VmKD
DrWxMgp
DsF^wnH
D^SgEHtj
DSJ\dHCrVk
DsJoOwj][h
DsjUiJujWZ
DSOVt`F
D_sylAjZm_Ri
DTAekjNIyBy
DTC\b`K
DtfnDszVKkJtP
DTJOtdDE
DtMxCVAXYU
Dtn_DbSr\
DtPhx^t\kQ^\Jc
DTqawVkKqA
DtZzQFHf
DUedHYxx`
DuemYFaij[
DUigCxZC
DuJr_QVFEZ
DuMLyTqFW
DuQKBDeD
DuxfM\
Dv[EQL^]grikBFNuqewXT
DVLkWmuJA[ko
DV``WC`_htVc
DVw^JhvadkSmLNfL
D]VWV
DV`xWi_D^\XZMJ
D\w
DwapfMOSGrekm
D]wCnjUISCkCv
DW_F[B^l
Dw_GGWpe
Dw]IqefUHj`
DwmtyrG
DwMYYRQV
DWnbxZ
DwnjYIeD\diVc
DWNpOhmfj`c
DWQvmLOFU
DwspiN`A`G
D_WVHlIi
Dwvjl
DWxD]Czp
DwxnUt
DwyM^
DxI_]\h
DXjdr[SAwDrkvLY
DxSMx_ZNwp
DY[bFv`ePnw
DybxeTZijuX
DYEn_MB[jxmlOsH
DYgnxxdX_q^ODDGWE
DY`RhRlFWtsUf
DZBKTr
DZHAD\MPGOT
DzI\ZoddJfDJG
DZkbaOQPsQ
Dz\vi
Dz[_x\V_NB
DzYNotu]mP
SELECT 340
QUERY PLAN
Sort (cost=199.50..200.51 rows=404 width=10) (actual time=4.087..4.108 rows=340 loops=1)
  Sort Key: name
  Sort Method: quicksort Memory: 43kB
  -> Seq Scan on spelers (cost=0.00..182.01 rows=404 width=10) (actual time=0.015..3.669 rows=340 loops=1)
        Filter: (name ~ '^[BD].*'::text)
        Rows Removed by Filter: 9661
Planning Time: 0.117 ms
Execution Time: 4.140 ms
EXPLAIN
name
BaomSxwZEgnW
BasxPBKsFdxYw
BaT[nroveIM`s
Dr]KAM
DrlFQzKrX
DrOop\HvBPUKm
Drqlapuse\VmKD
DrWxMgp
SELECT 8
QUERY PLAN
Sort (cost=257.03..257.03 rows=1 width=10) (actual time=1.946..1.947 rows=8 loops=1)
  Sort Key: name
  Sort Method: quicksort Memory: 25kB
  -> Seq Scan on spelers (cost=0.00..257.02 rows=1 width=10) (actual time=0.151..1.934 rows=8 loops=1)
        Filter: (((name ~>=~ 'Ba'::text) AND (name ~<~ 'Bb'::text)) OR ((name ~>=~ 'Dr'::text) AND (name ~<~ 'Ds'::text)))
        Rows Removed by Filter: 9993
Planning Time: 0.078 ms
Execution Time: 1.964 ms
EXPLAIN
DROP INDEX
CREATE INDEX
QUERY PLAN
Sort (cost=3.92..3.92 rows=2 width=10) (actual time=0.140..0.142 rows=8 loops=1)
  Sort Key: name
  Sort Method: quicksort Memory: 25kB
  -> Bitmap Heap Scan on spelers (cost=2.79..3.91 rows=2 width=10) (actual time=0.108..0.122 rows=8 loops=1)
        Recheck Cond: ((name ~~ 'Ba%'::text) OR (name ~~ 'Dr%'::text))
        Filter: ((name ~~ 'Ba%'::text) OR (name ~~ 'Dr%'::text))
        Heap Blocks: exact=8
        -> BitmapOr (cost=2.79..2.79 rows=1 width=0) (actual time=0.092..0.093 rows=0 loops=1)
              -> Bitmap Index Scan on spelers_name_c_idx (cost=0.00..1.40 rows=1 width=0) (actual time=0.063..0.063 rows=3 loops=1)
                    Index Cond: ((name >= 'Ba'::text) AND (name < 'Bb'::text))
              -> Bitmap Index Scan on spelers_name_c_idx (cost=0.00..1.40 rows=1 width=0) (actual time=0.025..0.025 rows=5 loops=1)
                    Index Cond: ((name >= 'Dr'::text) AND (name < 'Ds'::text))
Planning Time: 0.541 ms
Execution Time: 0.193 ms
EXPLAIN
QUERY PLAN
Sort (cost=182.02..182.03 rows=2 width=10) (actual time=1.725..1.726 rows=8 loops=1)
  Sort Key: name
  Sort Method: quicksort Memory: 25kB
  -> Seq Scan on spelers (cost=0.00..182.01 rows=2 width=10) (actual time=0.139..1.712 rows=8 loops=1)
        Filter: (name ~~ ANY ('{Ba%,Dr%}'::text[]))
        Rows Removed by Filter: 9993
Planning Time: 0.078 ms
Execution Time: 1.768 ms
EXPLAIN
QUERY PLAN
Sort (cost=3.92..3.92 rows=2 width=10) (actual time=0.043..0.045 rows=8 loops=1)
  Sort Key: name
  Sort Method: quicksort Memory: 25kB
  -> Bitmap Heap Scan on spelers (cost=2.79..3.91 rows=2 width=10) (actual time=0.023..0.033 rows=8 loops=1)
        Recheck Cond: ((name ^@ 'Ba'::text) OR (name ^@ 'Dr'::text))
        Filter: ((name ^@ 'Ba'::text) OR (name ^@ 'Dr'::text))
        Heap Blocks: exact=8
        -> BitmapOr (cost=2.79..2.79 rows=1 width=0) (actual time=0.015..0.016 rows=0 loops=1)
              -> Bitmap Index Scan on spelers_name_c_idx (cost=0.00..1.40 rows=1 width=0) (actual time=0.011..0.012 rows=3 loops=1)
                    Index Cond: ((name >= 'Ba'::text) AND (name < 'Bb'::text))
              -> Bitmap Index Scan on spelers_name_c_idx (cost=0.00..1.40 rows=1 width=0) (actual time=0.003..0.003 rows=5 loops=1)
                    Index Cond: ((name >= 'Dr'::text) AND (name < 'Ds'::text))
Planning Time: 0.137 ms
Execution Time: 0.071 ms
EXPLAIN
QUERY PLAN
Sort (cost=182.02..182.03 rows=2 width=10) (actual time=3.659..3.660 rows=8 loops=1)
  Sort Key: name
  Sort Method: quicksort Memory: 25kB
  -> Seq Scan on spelers (cost=0.00..182.01 rows=2 width=10) (actual time=0.305..3.645 rows=8 loops=1)
        Filter: (name ^@ ANY ('{Ba,Dr}'::text[]))
        Rows Removed by Filter: 9993
Planning Time: 0.081 ms
Execution Time: 3.675 ms
EXPLAIN
QUERY PLAN
Sort (cost=182.02..182.03 rows=1 width=10) (actual time=3.966..3.967 rows=8 loops=1)
  Sort Key: name
  Sort Method: quicksort Memory: 25kB
  -> Seq Scan on spelers (cost=0.00..182.01 rows=1 width=10) (actual time=0.313..3.946 rows=8 loops=1)
        Filter: (name ~ '^(Ba|Dr).*'::text)
        Rows Removed by Filter: 9993
Planning Time: 0.152 ms
Execution Time: 3.989 ms
EXPLAIN
QUERY PLAN
Sort (cost=199.50..200.51 rows=404 width=10) (actual time=4.039..4.060 rows=340 loops=1)
  Sort Key: name
  Sort Method: quicksort Memory: 43kB
  -> Seq Scan on spelers (cost=0.00..182.01 rows=404 width=10) (actual time=0.013..3.622 rows=340 loops=1)
        Filter: (name ~ '^[BD].*'::text)
        Rows Removed by Filter: 9661
Planning Time: 0.091 ms
Execution Time: 4.088 ms
EXPLAIN
QUERY PLAN
Sort (cost=257.03..257.03 rows=1 width=10) (actual time=2.036..2.037 rows=8 loops=1)
  Sort Key: name
  Sort Method: quicksort Memory: 25kB
  -> Seq Scan on spelers (cost=0.00..257.02 rows=1 width=10) (actual time=0.165..2.017 rows=8 loops=1)
        Filter: (((name ~>=~ 'Ba'::text) AND (name ~<~ 'Bb'::text)) OR ((name ~>=~ 'Dr'::text) AND (name ~<~ 'Ds'::text)))
        Rows Removed by Filter: 9993
Planning Time: 0.137 ms
Execution Time: 2.061 ms
EXPLAIN
DROP INDEX
CREATE INDEX
QUERY PLAN
Sort (cost=4.72..4.72 rows=2 width=10) (actual time=0.242..0.244 rows=8 loops=1)
  Sort Key: name
  Sort Method: quicksort Memory: 25kB
  -> Bitmap Heap Scan on spelers (cost=2.52..4.71 rows=2 width=10) (actual time=0.211..0.224 rows=8 loops=1)
        Recheck Cond: ((name ~~ 'Ba%'::text) OR (name ~~ 'Dr%'::text))
        Filter: ((name ~~ 'Ba%'::text) OR (name ~~ 'Dr%'::text))
        Heap Blocks: exact=8
        -> BitmapOr (cost=2.52..2.52 rows=2 width=0) (actual time=0.200..0.201 rows=0 loops=1)
              -> Bitmap Index Scan on spelers_name_spgist_idx (cost=0.00..1.26 rows=1 width=0) (actual time=0.192..0.192 rows=3 loops=1)
                    Index Cond: (name ^@ 'Ba'::text)
              -> Bitmap Index Scan on spelers_name_spgist_idx (cost=0.00..1.26 rows=1 width=0) (actual time=0.007..0.007 rows=5 loops=1)
                    Index Cond: (name ^@ 'Dr'::text)
Planning Time: 0.338 ms
Execution Time: 0.484 ms
EXPLAIN
QUERY PLAN
Sort (cost=182.02..182.03 rows=2 width=10) (actual time=1.740..1.741 rows=8 loops=1)
  Sort Key: name
  Sort Method: quicksort Memory: 25kB
  -> Seq Scan on spelers (cost=0.00..182.01 rows=2 width=10) (actual time=0.140..1.727 rows=8 loops=1)
        Filter: (name ~~ ANY ('{Ba%,Dr%}'::text[]))
        Rows Removed by Filter: 9993
Planning Time: 0.092 ms
Execution Time: 1.756 ms
EXPLAIN
QUERY PLAN
Sort (cost=4.72..4.72 rows=2 width=10) (actual time=0.040..0.041 rows=8 loops=1)
  Sort Key: name
  Sort Method: quicksort Memory: 25kB
  -> Bitmap Heap Scan on spelers (cost=2.52..4.71 rows=2 width=10) (actual time=0.022..0.030 rows=8 loops=1)
        Recheck Cond: ((name ^@ 'Ba'::text) OR (name ^@ 'Dr'::text))
        Heap Blocks: exact=8
        -> BitmapOr (cost=2.52..2.52 rows=2 width=0) (actual time=0.016..0.017 rows=0 loops=1)
              -> Bitmap Index Scan on spelers_name_spgist_idx (cost=0.00..1.26 rows=1 width=0) (actual time=0.011..0.011 rows=3 loops=1)
                    Index Cond: (name ^@ 'Ba'::text)
              -> Bitmap Index Scan on spelers_name_spgist_idx (cost=0.00..1.26 rows=1 width=0) (actual time=0.005..0.005 rows=5 loops=1)
                    Index Cond: (name ^@ 'Dr'::text)
Planning Time: 0.110 ms
Execution Time: 0.072 ms
EXPLAIN
QUERY PLAN
Sort (cost=4.71..4.72 rows=2 width=10) (actual time=0.039..0.040 rows=8 loops=1)
  Sort Key: name
  Sort Method: quicksort Memory: 25kB
  -> Bitmap Heap Scan on spelers (cost=2.52..4.70 rows=2 width=10) (actual time=0.022..0.029 rows=8 loops=1)
        Recheck Cond: (name ^@ ANY ('{Ba,Dr}'::text[]))
        Heap Blocks: exact=8
        -> Bitmap Index Scan on spelers_name_spgist_idx (cost=0.00..2.52 rows=2 width=0) (actual time=0.016..0.017 rows=8 loops=1)
              Index Cond: (name ^@ ANY ('{Ba,Dr}'::text[]))
Planning Time: 0.087 ms
Execution Time: 0.066 ms
EXPLAIN
QUERY PLAN
Sort (cost=182.02..182.03 rows=1 width=10) (actual time=3.975..3.976 rows=8 loops=1)
  Sort Key: name
  Sort Method: quicksort Memory: 25kB
  -> Seq Scan on spelers (cost=0.00..182.01 rows=1 width=10) (actual time=0.301..3.959 rows=8 loops=1)
        Filter: (name ~ '^(Ba|Dr).*'::text)
        Rows Removed by Filter: 9993
Planning Time: 0.114 ms
Execution Time: 3.991 ms
EXPLAIN
QUERY PLAN
Sort (cost=199.50..200.51 rows=404 width=10) (actual time=4.324..4.347 rows=340 loops=1)
  Sort Key: name
  Sort Method: quicksort Memory: 43kB
  -> Seq Scan on spelers (cost=0.00..182.01 rows=404 width=10) (actual time=0.019..3.875 rows=340 loops=1)
        Filter: (name ~ '^[BD].*'::text)
        Rows Removed by Filter: 9661
Planning Time: 0.141 ms
Execution Time: 4.387 ms
EXPLAIN
QUERY PLAN
Sort (cost=3.65..3.66 rows=1 width=10) (actual time=0.080..0.082 rows=8 loops=1)
  Sort Key: name
  Sort Method: quicksort Memory: 25kB
  -> Bitmap Heap Scan on spelers (cost=2.52..3.64 rows=1 width=10) (actual time=0.038..0.062 rows=8 loops=1)
        Recheck Cond: (((name ~>=~ 'Ba'::text) AND (name ~<~ 'Bb'::text)) OR ((name ~>=~ 'Dr'::text) AND (name ~<~ 'Ds'::text)))
        Heap Blocks: exact=8
        -> BitmapOr (cost=2.52..2.52 rows=1 width=0) (actual time=0.030..0.030 rows=0 loops=1)
              -> Bitmap Index Scan on spelers_name_spgist_idx (cost=0.00..1.26 rows=1 width=0) (actual time=0.019..0.020 rows=3 loops=1)
                    Index Cond: ((name ~>=~ 'Ba'::text) AND (name ~<~ 'Bb'::text))
              -> Bitmap Index Scan on spelers_name_spgist_idx (cost=0.00..1.26 rows=1 width=0) (actual time=0.009..0.009 rows=5 loops=1)
                    Index Cond: ((name ~>=~ 'Dr'::text) AND (name ~<~ 'Ds'::text))
Planning Time: 0.185 ms
Execution Time: 0.121 ms
EXPLAIN
QUERY PLAN
Bitmap Heap Scan on spelers (cost=2.52..4.71 rows=2 width=10) (actual time=0.024..0.040 rows=8 loops=1)
  Recheck Cond: ((name ~ '^(?:Ba.*)$'::text) OR (name ~ '^(?:Dr.*)$'::text))
  Filter: ((name ~ '^(?:Ba.*)$'::text) OR (name ~ '^(?:Dr.*)$'::text))
  Heap Blocks: exact=8
  -> BitmapOr (cost=2.52..2.52 rows=2 width=0) (actual time=0.015..0.016 rows=0 loops=1)
        -> Bitmap Index Scan on spelers_name_spgist_idx (cost=0.00..1.26 rows=1 width=0) (actual time=0.010..0.010 rows=3 loops=1)
              Index Cond: (name ^@ 'Ba'::text)
        -> Bitmap Index Scan on spelers_name_spgist_idx (cost=0.00..1.26 rows=1 width=0) (actual time=0.005..0.005 rows=5 loops=1)
              Index Cond: (name ^@ 'Dr'::text)
Planning Time: 0.212 ms
Execution Time: 0.067 ms
EXPLAIN