Result for 413C99944C5DB2B15B7E194DA635DC460B94C3BD

Query result

Key Value
FileSize102044
MD567CD1BB547ADCA497474A4ECAE709963
PackageDescriptionPostgreSQL foreign data wrapper for OGR OGR is the vector half of the GDAL spatial data access library. It allows access to a large number of GIS data formats using a simple C API for data reading and writing. Since OGR exposes a simple table structure and PostgreSQL foreign data wrappers allow access to table structures, the fit seems pretty perfect. . This implementation currently has the following limitations: * Only non-spatial query restrictions are pushed down to the OGR driver. PostgreSQL foreign data wrappers support delegating portions of the SQL query to the underlying data source, in this case OGR. This implementation currently pushes down only non-spatial query restrictions, and only for the small subset of comparison operators (>, <, <=, >=, =) supported by OGR. * Spatial restrictions are not pushed down. OGR can handle basic bounding box restrictions and even (for some drivers) more explicit intersection restrictions, but those are not passed to the OGR driver yet. * OGR connections every time Rather than pooling OGR connections, each query makes (and disposes of) two new ones, which seems to be the largest performance drag at the moment for restricted (small) queries. * All columns are retrieved every time. PostgreSQL foreign data wrappers don't require all columns all the time, and some efficiencies can be gained by only requesting the columns needed to fulfill a query. This would be a minimal efficiency improvement, but can be removed given some development time, since the OGR API supports returning a subset of columns.
PackageMaintainerDebian GIS Project <pkg-grass-devel@lists.alioth.debian.org>
PackageNamepostgresql-14-ogr-fdw
PackageSectiondatabase
PackageVersion1.1.1-2
SHA-1413C99944C5DB2B15B7E194DA635DC460B94C3BD
SHA-256AF504733E7886E9FC61FC2B99AD8B1CECFAD08CBA133850517A05580FA4C9E8A
hashlookup:children-total14
hashlookup:trust50

Network graph view

Children (Total: 14)

The searched file hash includes 14 children files known and seen by metalookup. A sample is included below:

Key Value
FileName./usr/share/doc/postgresql-14-ogr-fdw/changelog.Debian.gz
FileSize1631
MD520B13F809F60AC775A9B1E0A7318F312
SHA-1637298717C2311BABE75C971487902FFCAC419CB
SHA-256E8AADA811337EA2082B94BC74A0FAF87D54EFF11345E9C7A802EE6A72307FEB1
SSDEEP48:XkNTxssNxJ209jzGkJ70uFGIzJRByL7IKi07RvJ2wy:25N7n5J70ozJRB6Xp7y
TLSHT14131EAA6D717D0D3B960E70621DEEE7F153ADD99B15B8C033088B7A014221A0A24915D
Key Value
FileNameogr_fdw--1.0--1.1.sql
FileSize299
MD51EF554C616399D0FB6F06EA3F98F8207
RDS:package_id285120
SHA-130C012FEA931EA588C3F6A149ED4824C112DE8AB
SHA-256AA6E1255A8A15EA871B2BA23E9A48A4C44F694AEDC97C360A09146030F14DD93
SSDEEP6:ecUhTaUxCii752Jr6AgFeBzUhTCxCijw52JZzAgFeB5:ecURxZoFFeBzU0/l7zFFeB5
TLSHT12EE0CD0BAD675523D292BF349402C9BF4F13038F446BE95050BB741C8E5380C8B25EEB
insert-timestamp1662198435.8497121
sourcedelta.db
Key Value
FileName./usr/lib/postgresql/14/lib/bitcode/ogr_fdw.index.bc
FileSize10252
MD5BF36A6962786C001C32EC705DE291C6F
SHA-19C3C4B9A03ECC0374DD1F40AB267D23729A0EF3F
SHA-256DF89A898FEBC5A4B95BFD6FF27150745592E8EB12BF8A57483E6CD471DFD9E45
SSDEEP192:Kl639DnUrOfYKEuBBjCCALx0C2Wcy6S6yFj5Lr/yfahOzCMTHPAGXH8Ri:06ZUKAKEujpALxX2Wcy67yl5LWSszCMz
TLSHT1E2227DC2E7852631A247A6710DCF8CF8D1D6152B12A625C3C88C3D8E36E970E7AEC474
Key Value
FileName./usr/lib/postgresql/14/lib/bitcode/ogr_fdw/ogr_fdw_func.bc
FileSize5996
MD514BDE1F2EB3FBA42DE8DA5ECF4375BE8
SHA-11192C9CA1469048418006D2161B1AE3F8ACEC1C6
SHA-256F5DAFAF66D72CB4DEB914BA866FCD27F4DAAB5BB856F04819AE75D8E9DCCB6AD
SSDEEP96:kr9RXS1ePUKkHIk/EhkeweaU+LLfKtZDy+KkXrBD1oHHoYqXWdEWoYmwgb6:kZ9Zzhk7eIKtTFHgjgu
TLSHT14FC14A2E73540E55C2860B3D9CBF01DAA376BB428F57E7531696772CBEB022E6C20571
Key Value
FileName./usr/lib/postgresql/14/lib/bitcode/ogr_fdw/ogr_fdw_common.bc
FileSize15832
MD5F83727BCA3A998B393B808CAE8C98F54
SHA-1A4AD94B846029CC416E2E92CDA5F0D243FC7AEF2
SHA-2561A6485D82D87F3DCD1D8C574A4F4B9830132A832A5BB0B72C4A5C78B6DD17E95
SSDEEP192:ksMhkEYkcYYyIvvhkbL1xsvCbYzKtTwKEJEip6xu54JVUXLXGSRY/oACycYGdicK:ksMIc4AL1+REi64CzAMo7LYiiCed
TLSHT15562D52BF9A14B96D088073E197F02CF93B6F208CF1596532698772D39B0115E9B193E
Key Value
FileNameogr_fdw.control
FileSize152
MD5408F173AC888FA17C052E673078E59A0
RDS:package_id285118
SHA-1ABDA8467690571C922AFF0388ABD42855D6818F7
SHA-256163D3B61CC6DC3415543E755617DDC9579E6E42149687D2AA0A0A0C5A43773A0
SSDEEP3:SJFAYT8XqgSZVQisnqBCv2DB4AGNRKmVVERNwoCEHBYjQCvcTpdFR1n:SJFzT8XqgSZVgD2GNRKm/ErwoXHBYcPv
TLSHT158C08C2113AA84A20814BF28D9000020DEA43AB82212242712C8888C3BA0789B241B09
insert-timestamp1662198435.5457163
sourcedelta.db
Key Value
FileNamesnap-hashlookup-import/usr/share/lintian/overrides/libhdf4-0-alt
FileSize63
MD572EE11F9626FF424B93B5AF1F353BCBA
RDS:package_id293681
SHA-18B1072FD9A6A5C0ACC44BD875330A469DF2C4A09
SHA-256571DA562A54CEA577DAF5A18A413B8A1D02E78769BCB1E7254E9153B260D8C58
SHA-512B914B2C5B4B7400CB7BA0AD16C21E7F68BF2D612FC7E71D07E92D8D03BE24BB17C5F0BD8CBF70377651AF16C5E5BDE3EE10050BC446709E95947716C501BF79F
SSDEEP3:SLfELcAGAI+GAWZGOrtRogPvvn:SALccI+G1Zrnv
TLSHT169A002544D11155A575277107F311705627B617196A442406128154A7406FB422D262E
insert-timestamp1728263316.5318696
mimetypetext/plain
sourcesnap:2ZmiMNpbuanFwhJ4sSt9y1DaYHITLCyb_103
Key Value
FileName./usr/lib/postgresql/14/bin/ogr_fdw_info
FileSize31704
MD57ECA1A6AEFCE44EC7D057A7E9B90021D
SHA-13277BDE18E9F33D9B837D7432ADE787C53D57F7D
SHA-256A7EDD85C371C1E193E6F5BFB2EC06FB589E78C54A80AF57A9A69DDF5EF69B70B
SSDEEP384:JdyCVmWmaG8KYH40N7sKiExWBUITS9JzVz7gy:Jdf8Wm58K2RsKicATOJzd7x
TLSHT16CE2E937B592873CC0B4557444DF167361F1B841E722A96FA3057A381E60BA8EB0BEA7
Key Value
FileName./usr/lib/postgresql/14/lib/bitcode/ogr_fdw/ogr_fdw_deparse.bc
FileSize24812
MD5F397C3F191BF844BDF3EE9E91848D439
SHA-1C5A1B0FD2FC610CB99BE9063C573C760B12FEA1C
SHA-256F93BD039443F141E790B6CE74C42A4EBCDC52B3DB89D983866B9A8E3184AA947
SSDEEP384:kyd0odI+Lh75Cv2S6r3zhi6/FglzAlFG8WMA9MRQ6ERgP6j9tunp5QZ:nuyLLh75TzMwglWpW59MRQBr9t4pGZ
TLSHT1FAB28E1EF1E10515C9489B3EDCBF428753B2E68CDE10428B7A9A672E7D70240DFB167A
Key Value
FileName./usr/lib/postgresql/14/lib/bitcode/ogr_fdw/ogr_fdw.bc
FileSize65544
MD5AE6AED4D755381FD1560F5996B98F7D0
SHA-1E71CEDBBA7C95D79AF165D6A8BD6E1086718C07A
SHA-2569F2705BF4AA6F8EEB1B24EAD363933DEE42410D18C9CD690FC0DE4DD13DA189D
SSDEEP768:4MKZi036dwKgYtTGjCXy/S4sceXDehCe7r7hWDIxHMJnCNq3lYC5FAee68+FeJG:N8UGjCi/XsrDe8e7kkxHMJ733AeF8XJG
TLSHT189537C2DB551C390C849273E8CBF1ACE0BB67505DF09966327A9771C3C71254EA72ABC
Key Value
FileName./usr/lib/postgresql/14/lib/ogr_fdw.so
FileSize63840
MD55B53227D990B6D1228C27F9B20DA99F3
SHA-17EEFCA931E179B29C778167C4BDC6BC92598D7F7
SHA-256B2CE55C45C0BC90E3B5533807E4B6F6FB2B771721C71C0F5D4CB7C42FDB80828
SSDEEP1536:7xBXVoWqdSJtw88Ymox11DqBpY3rzYO/zOOX:dBXV+Kw1BUHYO
TLSHT162531A1FB2A08274C14991304ADB82724670BC66FA7166FF3248B37F2D55E98E50AF77
Key Value
FileNameogr_fdw--1.1.sql
FileSize767
MD5117BF214A9335C66AB3A7A7CD81D993B
RDS:package_id285120
SHA-13A2503FBEACD0C4038357414816667E81AF7B531
SHA-2567ED528C0611FFD669276F6E38F047C9CFE9E0CDC2E348245C1D49D241A955780
SSDEEP12:UtjGFoUEeBNFY/9UOeSxdcSewsncDS/WuAMVsEURxZoFFeBzU0/l7zFFeB5:qyto7ezSeDGS/WFb9p8eBIyl3eB5
TLSHT14A014C0F596DE1238391BE78A406887FDB12434E4817AAC0909B651C5EC6A094725FFA
insert-timestamp1662198435.6775877
sourcedelta.db
Key Value
FileName./usr/share/doc/postgresql-13-ogr-fdw/copyright
FileSize1620
MD5499B3FB5D2AAB1E6C06D1CCFBC800180
SHA-17F3316DC5C6DD7A5E955520CA0887D2C6ACC47C2
SHA-256A44FF01B48025CB7EB1CA15965214E09653E902221EE69DF88BD5380112C5D1E
SSDEEP24:gttzRRSoRhmKWgKrKUxrwNJHZH0yf3gtk1Hc1hMK9QH0sUv4kOk4/+/U3oq4sFig:s3qfxyJxl/El5QH0s5ANU3oWFig
TLSHT1B631C84FF64403632DE233E29854B8E9A7337489B0AB16C5F44EE2047B2A0ADC1FA464
Key Value
FileName./usr/lib/postgresql/14/lib/bitcode/ogr_fdw/stringbuffer_pg.bc
FileSize10364
MD538AFFF79355D328D956D7FD815A3AB6E
SHA-106780472AFA433F75136820FAC75FFBA6D051887
SHA-256D8BB8E0EA441D3D93306F41142631ED99026CC7DD01F0782AD73A0957F4013F8
SSDEEP192:kNRhkoYGr3rxuvhkBOKtTlAbR4F6mOC7hP6guvEx3TWugJMLg:kNRpr3ghNu6mOC7hiBvmjW5
TLSHT108225B0B77A55A94C1894B3E9CEA839E82BCF080CF64777367956D3C7DE11376890072