Result for D2AE57F0F70C739BD52CAED8482A24C86AC9BF73

Query result

Key Value
FileSize102132
MD50AC65A1A746BE7D8A84A82341D31BF9E
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-13-ogr-fdw
PackageSectiondatabase
PackageVersion1.1.1-1+b1
SHA-1D2AE57F0F70C739BD52CAED8482A24C86AC9BF73
SHA-256F0625DB994F260C7ABDAFB67E1963108A770D090D6E7EFBC64A2D14857281D81
hashlookup:children-total15
hashlookup:trust50

Network graph view

Children (Total: 15)

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

Key Value
FileName./usr/lib/postgresql/13/lib/bitcode/ogr_fdw/ogr_fdw_deparse.bc
FileSize23948
MD5ABA75C55630233559140FD4944D92821
SHA-15C162B6DCF995DFF9B0506E5CBEA9E0EF3FEA29E
SHA-256572827FFF5B69D1509214A3C6C3C73D2B7076128C70031B3E0F0AA46AE16077D
SSDEEP384:k14tMWHOyOXwAlNcZj6r3liYVWeWZXFgEuKDqpfrNB5QC:oheOAAlNllDVfWZqEHwRBGC
TLSHT1E0B27D29F1E11142C488563E48BF43AB43E7F548EF1082933A9A573DBE716809F7267A
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
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/share/doc/postgresql-13-ogr-fdw/changelog.Debian.amd64.gz
FileSize233
MD5DEC49505F209F6ABEF86866220307664
SHA-1C2008016D703F82410D0BD5F6AA82DB1B8A7D0BD
SHA-256B433F49B3DFB1B544BDAE48F5BA22F687041E8EEBDD8B3305292E68F481E58A7
SSDEEP6:Xte2ajtoNQaYp9PMqv+eQcaGdu5u6YeZsV5Xmo26G:XRajt2Y9T5aGCu+ZsSdp
TLSHT104D09721B14B0FB1DD10C1B39C4E3C4B896F0BA208182E022F728244501A1A0A662A10
Key Value
FileName./usr/lib/postgresql/13/lib/bitcode/ogr_fdw/ogr_fdw_common.bc
FileSize15832
MD5819F178E62174D68253E82115ADE9E55
SHA-1863909DA53B0C694C8D39AA0230D93A730FD7B1A
SHA-2561BD97EC8811A8330DB28F714171F6DA1E9514F47CAD6D51C0A82BAA3196057F2
SSDEEP192:knMhkEYkcYYyIvvhkHL1xsvCbYzKtTqKEJEip6xu54JVUXLMGSRY/oACycYGdicd:knMIc4YL1MREi64CzBMo7LYiiCrd
TLSHT1C662D52BF9A14B96D488073E197F02CF93B6F208CF1592532798772D3970115E9B193E
Key Value
FileName./usr/share/doc/postgresql-13-ogr-fdw/changelog.Debian.gz
FileSize1585
MD583C3310E2A14F704F922D940954E2AF2
SHA-12D7DA18BF5A42B2CE51EE8F9A31D961F94A85307
SHA-256F45A09F7287DAEA7BE98FDA0D1D7F8CC58594145B6321D3283309006210E29C5
SSDEEP48:XJy/LznL9R1sC9GUBih1TfrKmyJg7hZdms1xT0x:efxHvGUBihVFGSt0x
TLSHT187310A2C3F7A52D76ABA1CECAFF6053E9712435843606059E452A9B55338B0981CFFA4
Key Value
FileName./usr/lib/postgresql/13/bin/ogr_fdw_info
FileSize31528
MD5F9DE91A22836706CE7B0FA458F7E9D3E
SHA-11C820346B811C1D169AF1A787D114E3841C9AE52
SHA-2560028D631E0B63E258588B689F078F932AD97D53EAECB2BA4A93D4DB7B6F9F931
SSDEEP384:4mdyCVmWmaG8KYH40N7sKiExWBUITS9JzVz7:Hdf8Wm58K2RsKicATOJzd7
TLSHT1FDE2E937B992873CC0B4557448DF167361F1BC41E722A96FA3057A381D60BA8EB0BDA7
Key Value
FileName./usr/lib/postgresql/13/lib/ogr_fdw.so
FileSize63664
MD5A16E81B77D4B7B8F9CC2B647B2CE955C
SHA-1BC22F0F69A313B04CF5E67F5FCE1828DCBB060F0
SHA-256DC209C696DFADBC11E563BA0867BC06B62E5CB7978608B5B615E5C07C213E6F9
SSDEEP1536:b7rAbNwV4D2ly7d04BIXagqBFe31KEHzIATX:b7rozx04OXeEvT
TLSHT152533A1FB2909678C18981304ADB82314A70FC65F96266BF3649B37E2C15ED8E50BF77
Key Value
FileName./usr/lib/postgresql/13/lib/bitcode/ogr_fdw/ogr_fdw_func.bc
FileSize5996
MD5E378A06855026AF27B80F57FAE6D984B
SHA-1F058C32BDB2078244429AEB35B5102194E9AA854
SHA-256484B7761335CD2E3DC3FDE713E661211EE857E0F832FD2AC9D6BE1100613A6FB
SSDEEP96:k69cXSFkqvkHIk/EhkeweaUqLrKtZDy+KiXrBD1oHXoYqXWdEWoYmwgbF:k+cqvzhk7eEKtTPHgzgR
TLSHT1CAC14B1E73540950C085073DADFF01DAA7B6EB428F92E39716D6B62CBBB032E6C20671
Key Value
FileName./usr/lib/postgresql/13/lib/bitcode/ogr_fdw/ogr_fdw.bc
FileSize64620
MD55878C327D66E650DAB92322F72E0B33C
SHA-16AF471EF995E5BD2B54D38772D0CC3C23250B7DF
SHA-25604CF5A64E021BBC9AB558A19583FAC421B2254619BB3BF79606470777ECE48FF
SSDEEP1536:aTBdc9L3FF8F9AjkJ9653y0MZE1YF8YJy:aTBC9L34FDvSnMeY8
TLSHT175536C1E7620C291E448237E4CBF16CE0BB6BA44DF05A65373A5771D3C71284EAB26BD
Key Value
FileName./usr/lib/postgresql/13/lib/bitcode/ogr_fdw.index.bc
FileSize10232
MD53C36CD0F078CB4E630C7BA3C89E61ABC
SHA-118631784054EA281D1B113F051D700F0E1255BD6
SHA-256CFB6322E4B8A57620088CE4D67BFE3741731A640F99EC62CDA8FBED0C75E2A8F
SSDEEP192:pSDpdeNc/hWNxvEDaU4jkgh1Z72LagBh6kkWEXo7l:oDpgNWhhl4jkk/72+i6kE4p
TLSHT1C6228DE1F3DC43C1F882E5B09CEF9DF962E0003341664ADBA964B941794538E92CC47D
Key Value
FileName./usr/lib/postgresql/13/lib/bitcode/ogr_fdw/stringbuffer_pg.bc
FileSize10364
MD5AFDC49F8A428BA9A00A43CA74F5D87B6
SHA-1E8B4C660403E89BB5DE404A52EE278E1770D11F9
SHA-25686FE581F65902541F76586B78ECD14BE898064D159DAED60D2EE45CAD1BE2FE2
SSDEEP192:kKRhkoYGr3rxuvhkBPKtTTAbR4F6mOC7hP6guvExOpTWugJML/:kKRpr3gcNu6mOC7hiBvmO9WK
TLSHT1A1224B0B77A55A95C1895B3D9CFA838E82B8F080CF64777367956D3C7DE1237A890072
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