Result for A610C0F9B5CC8B4F14A1C64F7149C17A67174787

Query result

Key Value
FileSize99124
MD59021F72D4E041C8E5A4BD9C42D26D733
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-1A610C0F9B5CC8B4F14A1C64F7149C17A67174787
SHA-256E58BA902C1D0EF3614EA862AD03540A4248DC3B10909391145557334A40864EB
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
FileName./usr/lib/postgresql/14/lib/ogr_fdw.so
FileSize62164
MD590E57AF8A5BF0424F71427A71F80DB16
SHA-1DB01901638887469BB083611EF7BB652544B799F
SHA-256919A65AA54BEAFABBA2722225723CCE0A2689CF47C1E97B90C034AAF09C30D43
SSDEEP1536:1frKpiewm7YKqr46cYOMdtZqLZUjowe+5ST7OpxhjZ2lo5qrTYJ4sJueLghTkRkk:1frKpietYKqr46cYOMdtZMZUjowe+5SS
TLSHT17353C817FF04AF56C4C7CC30082EC71296FE9C5E6168B6A7B82CCA497E4269A5CE75C4
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
FileSize10240
MD57155D7268E34625F1930384336CFBD8F
SHA-19FC6E3A45B1B2D6A1E8BA40DFD6C896A8DC5EDEF
SHA-256FC5048C187A66B1BC42388C4066566723DBC51B97EDF674E58EB69D35FF18EEA
SSDEEP192:JpDKeiPhredh8FAD0BlgD4GBxWtGLeotwCO2vh3fi1hBATnPbENM/nyCQVR:HxilOQAYng34GLe/KP0BA7PbENM/yCQ3
TLSHT1C0226CC3E74822B11946E6EAC9DF6EFD13C80023010965CBE5B4BE67B59835C16EE178
Key Value
FileName./usr/lib/postgresql/14/lib/bitcode/ogr_fdw/stringbuffer_pg.bc
FileSize10344
MD53EE7A17E9FA1052819E6E119F905CA33
SHA-1874E265A6AA533EA73F6F0A57AC5B3B9C93B5CCC
SHA-2566CFB7170B58DC6D5CBC757B5FDEA649956BBF07470F6365B6F414C1D616F69B9
SSDEEP192:kjHvrcIDtr32YvFz7KtTq0Cte1qCxTW6JML8:kjwI5r3PBX+1qClW6
TLSHT1B8221B3FF19C5B50C40D033D4CDB459DE2AA95808F35E76BFBE2AA3CBEA113998A0111
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
FileName./usr/lib/postgresql/14/lib/bitcode/ogr_fdw/ogr_fdw_func.bc
FileSize6028
MD5D0184E1E1141C0710D0C43EC91E1D825
SHA-1AC1C0BFF0591A3F7A988AB60995D31B8B617AFD8
SHA-256825094A1ED5F1E69CA12CDB7A883101B43D288E753ED67BF7DF2D1D1E291CDA4
SSDEEP96:khS9XJxy8jtWHUVRNJ7WmzJ7Wmr9HTn3y3ffL3FTJKtZDy+KSzTc8yoYqXWjhoYN:kh2BVRNvzvrtr3eTFVKtTpTUVg
TLSHT194C10B1672582DA2C159173D9C6D43C96329DB08DF66FB43B25ABB2CFEF021FB550062
Key Value
FileName./usr/share/lintian/overrides/ruby-narray-miss
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/lib/bitcode/ogr_fdw/ogr_fdw_common.bc
FileSize15936
MD58394E24130AB487D363156EBCEF9FD41
SHA-13F473F8430A6DB5D91D1B1E2649F5225518EC916
SHA-256E0000F798CFFF7FBCC71747B4001712AB63579E62819B9C858835753CF805CF6
SSDEEP192:kHEGr3xKhO5fx07SbkGvCbYzKtThQCQqIFCa6/3lyYATLLeGSRY/VgecYGdici3b:kH9r3MMxyDQzI3iCMWYii/+i
TLSHT13A62293A7AA48BA1C588023F087F41DE565AF908DF3BD29376E9733D6D70104EAB0975
Key Value
FileName./usr/lib/postgresql/14/lib/bitcode/ogr_fdw/ogr_fdw.bc
FileSize65268
MD54EA7432BE910C3F38205F55B40F23DD7
SHA-1C9027D9A7F10489EC9462A91A5A74D7E6454516B
SHA-256CFA93477A2298FEF912FF3BB6ED25FF560520F1E99D88D1F435C75E8BB42BF07
SSDEEP1536:GHfuKoPdQBWFTTB6oetARsjGrx0QF8l1L:GHf8PdQ8TpetAR7rhef
TLSHT120538D2976A1C791D49D133F8CBF02CD06B9A604AF62A55333946B1C2DB134CE972AFD
Key Value
FileName./usr/lib/postgresql/14/bin/ogr_fdw_info
FileSize24000
MD52C3EE544C4C896CF9EE557E277829ECB
SHA-122D723A550C17EF9DA1B1CB87C64EBE045CB0617
SHA-2565E761A76D265106272FC34439A624275487A86FBDF8AD802C1666ED288FF2642
SSDEEP384:dzFro6A+ZBnqhhw/HyKdfUmB768tO/QD356JLqaRqZ+jVAQMEcyet0byg7W97If5:dBo6A+fqhhw/HyKdf1l68tO/QD356J+4
TLSHT17AB2831BAF405FD2C4C2CC314C5FE36353BFA99E50A0A373E65CD9842D62A8A5DE7885
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/lib/postgresql/14/lib/bitcode/ogr_fdw/ogr_fdw_deparse.bc
FileSize24744
MD556A17B7145DC1544927CAEF910510A4E
SHA-138724418D4E3F151975B54657506882DF670EF48
SHA-256F3EA03B34D356A52F8A31A9B248766995CBA1876E3E9B1A7FD7F5B439CB1FECB
SSDEEP768:m44c6rNC8FBnXeBDpWGZClrKKQnTbIdyP51xvGpvpGC1f:7k/HnXqDVZClrKKQnTbIdyP57GN1f
TLSHT161B29E25F5B98593CD951A3E8C3F02CA416AFA0CEF55C2832669672C3E71704CFA05FA
Key Value
FileName./usr/share/doc/postgresql-13-ogr-fdw/copyright
FileSize1620
MD5499B3FB5D2AAB1E6C06D1CCFBC800180
SHA-17F3316DC5C6DD7A5E955520CA0887D2C6ACC47C2
SHA-256A44FF01B48025CB7EB1CA15965214E09653E902221EE69DF88BD5380112C5D1E
SSDEEP24:gttzRRSoRhmKWgKrKUxrwNJHZH0yf3gtk1Hc1hMK9QH0sUv4kOk4/+/U3oq4sFig:s3qfxyJxl/El5QH0s5ANU3oWFig
TLSHT1B631C84FF64403632DE233E29854B8E9A7337489B0AB16C5F44EE2047B2A0ADC1FA464