Skip to content

Instantly share code, notes, and snippets.

@cs2018ncsa

cs2018ncsa/pg explain

Created April 20, 2020 14:29
Show Gist options
  • Save cs2018ncsa/c2fad0d0bd56102fc820d9baef7b67a2 to your computer and use it in GitHub Desktop.
Save cs2018ncsa/c2fad0d0bd56102fc820d9baef7b67a2 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
pg explain
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