Created
April 20, 2020 14:29
-
-
Save cs2018ncsa/c2fad0d0bd56102fc820d9baef7b67a2 to your computer and use it in GitHub Desktop.
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
Bitmap Heap Scan on "DiaSource" (cost=541.17..33856.16 rows=7831 width=848) (actual time=1.329..5.238 rows=8524 loops=1) | |
Recheck Cond: ((("pixelId" >= '10729436479488'::bigint) AND ("pixelId" <= '10729440673791'::bigint)) OR (("pixelId" >= '10729449062400'::bigint) AND ("pixelId" <= '10729499394047'::bigint)) OR (("pixelId" >= '10729532948480'::bi | |
gint) AND ("pixelId" <= '10729537142783'::bigint)) OR (("pixelId" >= '10729542385664'::bigint) AND ("pixelId" <= '10729542451199'::bigint)) OR (("pixelId" >= '10729542516736'::bigint) AND ("pixelId" <= '10729542647807'::bigint)) OR | |
(("pixelId" >= '10729546579968'::bigint) AND ("pixelId" <= '10729546711039'::bigint)) OR (("pixelId" >= '10729546776576'::bigint) AND ("pixelId" <= '10729546842111'::bigint)) OR (("pixelId" >= '10729566502912'::bigint) AND ("pixel | |
Id" <= '10729570697215'::bigint)) OR (("pixelId" >= '10729570959360'::bigint) AND ("pixelId" <= '10729571090431'::bigint)) OR (("pixelId" >= '10729571155968'::bigint) AND ("pixelId" <= '10729571221503'::bigint)) OR (("pixelId" >= ' | |
10729571745792'::bigint) AND ("pixelId" <= '10729573056511'::bigint)) OR (("pixelId" >= '10729573122048'::bigint) AND ("pixelId" <= '10729574105087'::bigint)) OR (("pixelId" >= '10729574170624'::bigint) AND ("pixelId" <= '107295832 | |
80127'::bigint)) OR (("pixelId" >= '10729601105920'::bigint) AND ("pixelId" <= '10729601171455'::bigint)) OR (("pixelId" >= '10729604251648'::bigint) AND ("pixelId" <= '10729608445951'::bigint)) OR (("pixelId" >= '10729613164544':: | |
bigint) AND ("pixelId" <= '10729613295615'::bigint)) OR (("pixelId" >= '10729613361152'::bigint) AND ("pixelId" <= '10729613426687'::bigint)) OR (("pixelId" >= '10729614737408'::bigint) AND ("pixelId" <= '10729614868479'::bigint)) | |
OR (("pixelId" >= '10729614934016'::bigint) AND ("pixelId" <= '10729615065087'::bigint)) OR (("pixelId" >= '10729615130624'::bigint) AND ("pixelId" <= '10729615261695'::bigint)) OR (("pixelId" >= '10729615654912'::bigint) AND ("pix | |
elId" <= '10729615720447'::bigint)) OR (("pixelId" >= '10729616048128'::bigint) AND ("pixelId" <= '10729616113663'::bigint)) OR (("pixelId" >= '10729621028864'::bigint) AND ("pixelId" <= '10729625223167'::bigint)) OR (("pixelId" >= | |
'10729625747456'::bigint) AND ("pixelId" <= '10729625812991'::bigint)) OR (("pixelId" >= '10729625878528'::bigint) AND ("pixelId" <= '10729626009599'::bigint)) OR (("pixelId" >= '10729626337280'::bigint) AND ("pixelId" <= '1072962 | |
6796031'::bigint)) OR (("pixelId" >= '10729626861568'::bigint) AND ("pixelId" <= '10729628893183'::bigint)) OR (("pixelId" >= '10729628958720'::bigint) AND ("pixelId" <= '10729630466047'::bigint)) OR (("pixelId" >= '10729630597120' | |
::bigint) AND ("pixelId" <= '10729630662655'::bigint)) OR (("pixelId" >= '10729630793728'::bigint) AND ("pixelId" <= '10729630859263'::bigint)) OR (("pixelId" >= '10729630990336'::bigint) AND ("pixelId" <= '10729631383551'::bigint) | |
) OR (("pixelId" >= '10729631449088'::bigint) AND ("pixelId" <= '10729633611775'::bigint)) OR (("pixelId" >= '10729650388992'::bigint) AND ("pixelId" <= '10729650651135'::bigint)) OR (("pixelId" >= '10729650716672'::bigint) AND ("p | |
ixelId" <= '10729651437567'::bigint)) OR (("pixelId" >= '10729652748288'::bigint) AND ("pixelId" <= '10729653010431'::bigint)) OR (("pixelId" >= '10729653141504'::bigint) AND ("pixelId" <= '10729653207039'::bigint)) OR (("pixelId" | |
>= '10729653272576'::bigint) AND ("pixelId" <= '10729653338111'::bigint)) OR (("pixelId" >= '10729653600256'::bigint) AND ("pixelId" <= '10729653665791'::bigint)) OR (("pixelId" >= '10729653796864'::bigint) AND ("pixelId" <= '10729 | |
654059007'::bigint)) OR (("pixelId" >= '10729654190080'::bigint) AND ("pixelId" <= '10729654255615'::bigint)) OR (("pixelId" >= '10729654321152'::bigint) AND ("pixelId" <= '10729654386687'::bigint)) OR (("pixelId" >= '1072965445222 | |
4'::bigint) AND ("pixelId" <= '10729654583295'::bigint)) OR (("pixelId" >= '10729734275072'::bigint) AND ("pixelId" <= '10729734799359'::bigint)) OR (("pixelId" >= '10729735061504'::bigint) AND ("pixelId" <= '10729735585791'::bigin | |
t)) OR (("pixelId" >= '10729735847936'::bigint) AND ("pixelId" <= '10729736372223'::bigint)) OR (("pixelId" >= '10729737945088'::bigint) AND ("pixelId" <= '10729738207231'::bigint)) OR (("pixelId" >= '10729738993664'::bigint) AND ( | |
"pixelId" <= '10729739124735'::bigint)) OR (("pixelId" >= '10729739190272'::bigint) AND ("pixelId" <= '10729739255807'::bigint)) OR (("pixelId" >= '10729740566528'::bigint) AND ("pixelId" <= '10729740697599'::bigint)) OR (("pixelId | |
" >= '10729740763136'::bigint) AND ("pixelId" <= '10729740894207'::bigint)) OR (("pixelId" >= '10729740959744'::bigint) AND ("pixelId" <= '10729741090815'::bigint)) OR (("pixelId" >= '10729741484032'::bigint) AND ("pixelId" <= '107 | |
29741549567'::bigint)) OR (("pixelId" >= '10729741877248'::bigint) AND ("pixelId" <= '10729741942783'::bigint)) OR (("pixelId" >= '10729748955136'::bigint) AND ("pixelId" <= '10729749020671'::bigint)) OR (("pixelId" >= '10729868492 | |
800'::bigint) AND ("pixelId" <= '10729868754943'::bigint)) OR (("pixelId" >= '10729869082624'::bigint) AND ("pixelId" <= '10729869148159'::bigint)) OR (("pixelId" >= '10729869344768'::bigint) AND ("pixelId" <= '10729869410303'::big | |
int)) OR (("pixelId" >= '10776494538752'::bigint) AND ("pixelId" <= '10776494604287'::bigint))) | |
Heap Blocks: exact=2377 | |
-> BitmapOr (cost=541.17..541.17 rows=7831 width=0) (actual time=1.049..1.049 rows=0 loops=1) | |
-> Bitmap Index Scan on "IDX_DiaSource_htmId20" (cost=0.00..11.92 rows=335 width=0) (actual time=0.073..0.073 rows=406 loops=1) | |
Index Cond: (("pixelId" >= '10729436479488'::bigint) AND ("pixelId" <= '10729440673791'::bigint)) | |
-> Bitmap Index Scan on "IDX_DiaSource_htmId20" (cost=0.00..100.33 rows=3976 width=0) (actual time=0.581..0.581 rows=4886 loops=1) | |
Index Cond: (("pixelId" >= '10729449062400'::bigint) AND ("pixelId" <= '10729499394047'::bigint)) | |
-> Bitmap Index Scan on "IDX_DiaSource_htmId20" (cost=0.00..11.92 rows=335 width=0) (actual time=0.031..0.031 rows=333 loops=1) | |
Index Cond: (("pixelId" >= '10729532948480'::bigint) AND ("pixelId" <= '10729537142783'::bigint)) | |
-> Bitmap Index Scan on "IDX_DiaSource_htmId20" (cost=0.00..4.67 rows=10 width=0) (actual time=0.004..0.004 rows=1 loops=1) | |
Index Cond: (("pixelId" >= '10729542385664'::bigint) AND ("pixelId" <= '10729542451199'::bigint)) | |
-> Bitmap Index Scan on "IDX_DiaSource_htmId20" (cost=0.00..4.72 rows=15 width=0) (actual time=0.003..0.003 rows=16 loops=1) | |
Index Cond: (("pixelId" >= '10729542516736'::bigint) AND ("pixelId" <= '10729542647807'::bigint)) | |
-> Bitmap Index Scan on "IDX_DiaSource_htmId20" (cost=0.00..4.72 rows=15 width=0) (actual time=0.004..0.004 rows=5 loops=1) | |
Index Cond: (("pixelId" >= '10729546579968'::bigint) AND ("pixelId" <= '10729546711039'::bigint)) | |
-> Bitmap Index Scan on "IDX_DiaSource_htmId20" (cost=0.00..4.67 rows=10 width=0) (actual time=0.003..0.003 rows=8 loops=1) | |
Index Cond: (("pixelId" >= '10729546776576'::bigint) AND ("pixelId" <= '10729546842111'::bigint)) | |
-> Bitmap Index Scan on "IDX_DiaSource_htmId20" (cost=0.00..11.92 rows=335 width=0) (actual time=0.029..0.029 rows=318 loops=1) | |
Index Cond: (("pixelId" >= '10729566502912'::bigint) AND ("pixelId" <= '10729570697215'::bigint)) | |
-> Bitmap Index Scan on "IDX_DiaSource_htmId20" (cost=0.00..4.72 rows=15 width=0) (actual time=0.003..0.003 rows=0 loops=1) | |
Index Cond: (("pixelId" >= '10729570959360'::bigint) AND ("pixelId" <= '10729571090431'::bigint)) | |
-> Bitmap Index Scan on "IDX_DiaSource_htmId20" (cost=0.00..4.67 rows=10 width=0) (actual time=0.002..0.002 rows=8 loops=1) | |
Index Cond: (("pixelId" >= '10729571155968'::bigint) AND ("pixelId" <= '10729571221503'::bigint)) | |
-> Bitmap Index Scan on "IDX_DiaSource_htmId20" (cost=0.00..5.65 rows=108 width=0) (actual time=0.011..0.012 rows=108 loops=1) | |
Index Cond: (("pixelId" >= '10729571745792'::bigint) AND ("pixelId" <= '10729573056511'::bigint)) | |
-> Bitmap Index Scan on "IDX_DiaSource_htmId20" (cost=0.00..5.39 rows=82 width=0) (actual time=0.009..0.009 rows=105 loops=1) | |
Index Cond: (("pixelId" >= '10729573122048'::bigint) AND ("pixelId" <= '10729574105087'::bigint)) | |
-> Bitmap Index Scan on "IDX_DiaSource_htmId20" (cost=0.00..19.80 rows=723 width=0) (actual time=0.049..0.049 rows=674 loops=1) | |
Index Cond: (("pixelId" >= '10729574170624'::bigint) AND ("pixelId" <= '10729583280127'::bigint)) | |
-> Bitmap Index Scan on "IDX_DiaSource_htmId20" (cost=0.00..4.67 rows=10 width=0) (actual time=0.003..0.003 rows=1 loops=1) | |
Index Cond: (("pixelId" >= '10729601105920'::bigint) AND ("pixelId" <= '10729601171455'::bigint)) | |
-> Bitmap Index Scan on "IDX_DiaSource_htmId20" (cost=0.00..11.92 rows=335 width=0) (actual time=0.029..0.029 rows=343 loops=1) | |
Index Cond: (("pixelId" >= '10729604251648'::bigint) AND ("pixelId" <= '10729608445951'::bigint)) | |
-> Bitmap Index Scan on "IDX_DiaSource_htmId20" (cost=0.00..4.72 rows=15 width=0) (actual time=0.010..0.010 rows=16 loops=1) | |
Index Cond: (("pixelId" >= '10729613164544'::bigint) AND ("pixelId" <= '10729613295615'::bigint)) | |
-> Bitmap Index Scan on "IDX_DiaSource_htmId20" (cost=0.00..4.67 rows=10 width=0) (actual time=0.003..0.003 rows=2 loops=1) | |
Index Cond: (("pixelId" >= '10729613361152'::bigint) AND ("pixelId" <= '10729613426687'::bigint)) | |
-> Bitmap Index Scan on "IDX_DiaSource_htmId20" (cost=0.00..4.72 rows=15 width=0) (actual time=0.004..0.004 rows=2 loops=1) | |
Index Cond: (("pixelId" >= '10729614737408'::bigint) AND ("pixelId" <= '10729614868479'::bigint)) | |
-> Bitmap Index Scan on "IDX_DiaSource_htmId20" (cost=0.00..4.72 rows=15 width=0) (actual time=0.003..0.003 rows=12 loops=1) | |
Index Cond: (("pixelId" >= '10729614934016'::bigint) AND ("pixelId" <= '10729615065087'::bigint)) | |
-> Bitmap Index Scan on "IDX_DiaSource_htmId20" (cost=0.00..4.72 rows=15 width=0) (actual time=0.003..0.003 rows=11 loops=1) | |
Index Cond: (("pixelId" >= '10729615130624'::bigint) AND ("pixelId" <= '10729615261695'::bigint)) | |
-> Bitmap Index Scan on "IDX_DiaSource_htmId20" (cost=0.00..4.67 rows=10 width=0) (actual time=0.003..0.003 rows=10 loops=1) | |
Index Cond: (("pixelId" >= '10729615654912'::bigint) AND ("pixelId" <= '10729615720447'::bigint)) | |
-> Bitmap Index Scan on "IDX_DiaSource_htmId20" (cost=0.00..4.67 rows=10 width=0) (actual time=0.002..0.002 rows=2 loops=1) | |
Index Cond: (("pixelId" >= '10729616048128'::bigint) AND ("pixelId" <= '10729616113663'::bigint)) | |
-> Bitmap Index Scan on "IDX_DiaSource_htmId20" (cost=0.00..11.92 rows=335 width=0) (actual time=0.022..0.023 rows=254 loops=1) | |
Index Cond: (("pixelId" >= '10729621028864'::bigint) AND ("pixelId" <= '10729625223167'::bigint)) | |
-> Bitmap Index Scan on "IDX_DiaSource_htmId20" (cost=0.00..4.67 rows=10 width=0) (actual time=0.004..0.004 rows=15 loops=1) | |
Index Cond: (("pixelId" >= '10729625747456'::bigint) AND ("pixelId" <= '10729625812991'::bigint)) | |
-> Bitmap Index Scan on "IDX_DiaSource_htmId20" (cost=0.00..4.72 rows=15 width=0) (actual time=0.004..0.004 rows=17 loops=1) | |
Index Cond: (("pixelId" >= '10729625878528'::bigint) AND ("pixelId" <= '10729626009599'::bigint)) | |
-> Bitmap Index Scan on "IDX_DiaSource_htmId20" (cost=0.00..4.98 rows=41 width=0) (actual time=0.004..0.004 rows=32 loops=1) | |
Index Cond: (("pixelId" >= '10729626337280'::bigint) AND ("pixelId" <= '10729626796031'::bigint)) | |
-> Bitmap Index Scan on "IDX_DiaSource_htmId20" (cost=0.00..6.22 rows=165 width=0) (actual time=0.013..0.013 rows=144 loops=1) | |
Index Cond: (("pixelId" >= '10729626861568'::bigint) AND ("pixelId" <= '10729628893183'::bigint)) | |
-> Bitmap Index Scan on "IDX_DiaSource_htmId20" (cost=0.00..5.80 rows=123 width=0) (actual time=0.009..0.009 rows=100 loops=1) | |
Index Cond: (("pixelId" >= '10729628958720'::bigint) AND ("pixelId" <= '10729630466047'::bigint)) | |
-> Bitmap Index Scan on "IDX_DiaSource_htmId20" (cost=0.00..4.67 rows=10 width=0) (actual time=0.003..0.003 rows=4 loops=1) | |
Index Cond: (("pixelId" >= '10729630597120'::bigint) AND ("pixelId" <= '10729630662655'::bigint)) | |
-> Bitmap Index Scan on "IDX_DiaSource_htmId20" (cost=0.00..4.67 rows=10 width=0) (actual time=0.002..0.002 rows=2 loops=1) | |
Index Cond: (("pixelId" >= '10729630793728'::bigint) AND ("pixelId" <= '10729630859263'::bigint)) | |
-> Bitmap Index Scan on "IDX_DiaSource_htmId20" (cost=0.00..4.92 rows=35 width=0) (actual time=0.003..0.003 rows=22 loops=1) | |
Index Cond: (("pixelId" >= '10729630990336'::bigint) AND ("pixelId" <= '10729631383551'::bigint)) | |
-> Bitmap Index Scan on "IDX_DiaSource_htmId20" (cost=0.00..6.32 rows=175 width=0) (actual time=0.014..0.014 rows=155 loops=1) | |
Index Cond: (("pixelId" >= '10729631449088'::bigint) AND ("pixelId" <= '10729633611775'::bigint)) | |
-> Bitmap Index Scan on "IDX_DiaSource_htmId20" (cost=0.00..4.82 rows=25 width=0) (actual time=0.009..0.009 rows=58 loops=1) | |
Index Cond: (("pixelId" >= '10729650388992'::bigint) AND ("pixelId" <= '10729650651135'::bigint)) | |
-> Bitmap Index Scan on "IDX_DiaSource_htmId20" (cost=0.00..5.18 rows=61 width=0) (actual time=0.007..0.007 rows=63 loops=1) | |
Index Cond: (("pixelId" >= '10729650716672'::bigint) AND ("pixelId" <= '10729651437567'::bigint)) | |
-> Bitmap Index Scan on "IDX_DiaSource_htmId20" (cost=0.00..4.82 rows=25 width=0) (actual time=0.006..0.006 rows=30 loops=1) | |
Index Cond: (("pixelId" >= '10729652748288'::bigint) AND ("pixelId" <= '10729653010431'::bigint)) | |
-> Bitmap Index Scan on "IDX_DiaSource_htmId20" (cost=0.00..4.67 rows=10 width=0) (actual time=0.003..0.003 rows=10 loops=1) | |
Index Cond: (("pixelId" >= '10729653141504'::bigint) AND ("pixelId" <= '10729653207039'::bigint)) | |
-> Bitmap Index Scan on "IDX_DiaSource_htmId20" (cost=0.00..4.67 rows=10 width=0) (actual time=0.002..0.002 rows=1 loops=1) | |
Index Cond: (("pixelId" >= '10729653272576'::bigint) AND ("pixelId" <= '10729653338111'::bigint)) | |
-> Bitmap Index Scan on "IDX_DiaSource_htmId20" (cost=0.00..4.67 rows=10 width=0) (actual time=0.002..0.002 rows=0 loops=1) | |
Index Cond: (("pixelId" >= '10729653600256'::bigint) AND ("pixelId" <= '10729653665791'::bigint)) | |
-> Bitmap Index Scan on "IDX_DiaSource_htmId20" (cost=0.00..4.82 rows=25 width=0) (actual time=0.003..0.003 rows=20 loops=1) | |
Index Cond: (("pixelId" >= '10729653796864'::bigint) AND ("pixelId" <= '10729654059007'::bigint)) | |
-> Bitmap Index Scan on "IDX_DiaSource_htmId20" (cost=0.00..4.67 rows=10 width=0) (actual time=0.002..0.002 rows=1 loops=1) | |
Index Cond: (("pixelId" >= '10729654190080'::bigint) AND ("pixelId" <= '10729654255615'::bigint)) | |
-> Bitmap Index Scan on "IDX_DiaSource_htmId20" (cost=0.00..4.67 rows=10 width=0) (actual time=0.002..0.002 rows=2 loops=1) | |
Index Cond: (("pixelId" >= '10729654321152'::bigint) AND ("pixelId" <= '10729654386687'::bigint)) | |
-> Bitmap Index Scan on "IDX_DiaSource_htmId20" (cost=0.00..4.72 rows=15 width=0) (actual time=0.002..0.002 rows=2 loops=1) | |
Index Cond: (("pixelId" >= '10729654452224'::bigint) AND ("pixelId" <= '10729654583295'::bigint)) | |
-> Bitmap Index Scan on "IDX_DiaSource_htmId20" (cost=0.00..5.03 rows=46 width=0) (actual time=0.007..0.007 rows=47 loops=1) | |
Index Cond: (("pixelId" >= '10729734275072'::bigint) AND ("pixelId" <= '10729734799359'::bigint)) | |
-> Bitmap Index Scan on "IDX_DiaSource_htmId20" (cost=0.00..5.03 rows=46 width=0) (actual time=0.006..0.006 rows=45 loops=1) | |
Index Cond: (("pixelId" >= '10729735061504'::bigint) AND ("pixelId" <= '10729735585791'::bigint)) | |
-> Bitmap Index Scan on "IDX_DiaSource_htmId20" (cost=0.00..5.03 rows=46 width=0) (actual time=0.007..0.007 rows=54 loops=1) | |
Index Cond: (("pixelId" >= '10729735847936'::bigint) AND ("pixelId" <= '10729736372223'::bigint)) | |
-> Bitmap Index Scan on "IDX_DiaSource_htmId20" (cost=0.00..4.82 rows=25 width=0) (actual time=0.007..0.007 rows=42 loops=1) | |
Index Cond: (("pixelId" >= '10729737945088'::bigint) AND ("pixelId" <= '10729738207231'::bigint)) | |
-> Bitmap Index Scan on "IDX_DiaSource_htmId20" (cost=0.00..4.72 rows=15 width=0) (actual time=0.003..0.003 rows=8 loops=1) | |
Index Cond: (("pixelId" >= '10729738993664'::bigint) AND ("pixelId" <= '10729739124735'::bigint)) | |
-> Bitmap Index Scan on "IDX_DiaSource_htmId20" (cost=0.00..4.67 rows=10 width=0) (actual time=0.003..0.003 rows=20 loops=1) | |
Index Cond: (("pixelId" >= '10729739190272'::bigint) AND ("pixelId" <= '10729739255807'::bigint)) | |
-> Bitmap Index Scan on "IDX_DiaSource_htmId20" (cost=0.00..4.72 rows=15 width=0) (actual time=0.002..0.002 rows=4 loops=1) | |
Index Cond: (("pixelId" >= '10729740566528'::bigint) AND ("pixelId" <= '10729740697599'::bigint)) | |
-> Bitmap Index Scan on "IDX_DiaSource_htmId20" (cost=0.00..4.72 rows=15 width=0) (actual time=0.003..0.003 rows=16 loops=1) | |
Index Cond: (("pixelId" >= '10729740763136'::bigint) AND ("pixelId" <= '10729740894207'::bigint)) | |
-> Bitmap Index Scan on "IDX_DiaSource_htmId20" (cost=0.00..4.72 rows=15 width=0) (actual time=0.003..0.003 rows=13 loops=1) | |
Index Cond: (("pixelId" >= '10729740959744'::bigint) AND ("pixelId" <= '10729741090815'::bigint)) | |
-> Bitmap Index Scan on "IDX_DiaSource_htmId20" (cost=0.00..4.67 rows=10 width=0) (actual time=0.006..0.006 rows=23 loops=1) | |
Index Cond: (("pixelId" >= '10729741484032'::bigint) AND ("pixelId" <= '10729741549567'::bigint)) | |
-> Bitmap Index Scan on "IDX_DiaSource_htmId20" (cost=0.00..4.67 rows=10 width=0) (actual time=0.002..0.002 rows=3 loops=1) | |
Index Cond: (("pixelId" >= '10729741877248'::bigint) AND ("pixelId" <= '10729741942783'::bigint)) | |
-> Bitmap Index Scan on "IDX_DiaSource_htmId20" (cost=0.00..4.67 rows=10 width=0) (actual time=0.004..0.004 rows=11 loops=1) | |
Index Cond: (("pixelId" >= '10729748955136'::bigint) AND ("pixelId" <= '10729749020671'::bigint)) | |
-> Bitmap Index Scan on "IDX_DiaSource_htmId20" (cost=0.00..4.82 rows=25 width=0) (actual time=0.005..0.005 rows=15 loops=1) | |
Index Cond: (("pixelId" >= '10729868492800'::bigint) AND ("pixelId" <= '10729868754943'::bigint)) | |
-> Bitmap Index Scan on "IDX_DiaSource_htmId20" (cost=0.00..4.67 rows=10 width=0) (actual time=0.003..0.003 rows=11 loops=1) | |
Index Cond: (("pixelId" >= '10729869082624'::bigint) AND ("pixelId" <= '10729869148159'::bigint)) | |
-> Bitmap Index Scan on "IDX_DiaSource_htmId20" (cost=0.00..4.67 rows=10 width=0) (actual time=0.002..0.002 rows=1 loops=1) | |
Index Cond: (("pixelId" >= '10729869344768'::bigint) AND ("pixelId" <= '10729869410303'::bigint)) | |
-> Bitmap Index Scan on "IDX_DiaSource_htmId20" (cost=0.00..4.67 rows=10 width=0) (actual time=0.006..0.006 rows=12 loops=1) | |
Index Cond: (("pixelId" >= '10776494538752'::bigint) AND ("pixelId" <= '10776494604287'::bigint)) | |
Planning Time: 0.697 ms | |
Execution Time: 5.755 ms | |
(122 rows) |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment