Result for 7B596521DD6759B06D25BC0DF4E1DD18A1E4132E

Query result

Key Value
FileSize99608
MD5B7E3D3871E3AA94EDA9854CE64A115E1
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-17B596521DD6759B06D25BC0DF4E1DD18A1E4132E
SHA-256003FD80F6D4A5E091CD5494340E156D7225A5A2A4E75BF2F4BC282B9B37B6D47
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_common.bc
FileSize15320
MD5085EBB790D35DE6584F51F03C332FD7C
SHA-189EBE931D68BA1B51B53BF8B8137A5C0D4F34DDE
SHA-2561C82458A3CCEA08252189D43F9A783DEEAD4E1D94A1844A75D1E2CDE32ED2532
SSDEEP192:kEcn3r38YfrvhPnPgCipCOUJKtTFRHCxYhsjDM1V7KGSRY/DPxxcYGdicz356yK:kEc3r35FIPlZCxYhiMTqMDUYiiCQd
TLSHT15062F82EB6918BC5D884563E597F02CA83B6F509DF12A3433698773C3D71209E9B293C
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
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/13/lib/bitcode/ogr_fdw/ogr_fdw_deparse.bc
FileSize23976
MD577C7CFED9086939EC458D079BECD2F78
SHA-1E2678112E00C4E7BE6C53A5D9A4A0F33288944EB
SHA-256D5AC889B50ECDEB0D624A123BFCA883D7A43B4ABAF3C7C0D35365141FDB66C33
SSDEEP384:k54tMWHOyOXwAlNcZ7r3U4Nz/WEc6rVe7v3K7sB5Qp:kheOAAlNE7NDjW7vaoBGp
TLSHT1F3B28D28F1A55193C988123D8C7F03DB47E7F458FF0492936199672CAEB1684CEB29BD
Key Value
FileName./usr/lib/postgresql/13/lib/bitcode/ogr_fdw/stringbuffer_pg.bc
FileSize10356
MD5FCE0D265867D76DA8D3E7C71F1916E20
SHA-1FE55690BF95E342B19AF273BA1DFAAE47ADA1150
SHA-25614021FADED8A0490DB323682B7545D17603C4F0674C338B4C29A3778BBCEE2DA
SSDEEP192:knYoUtr3m1Yb7Qrtr3Nl4n5KtT8aGkihquOwNzxTgOOVfTWNJMLm:knYogr3vQhr3n4YGkFuOwNzxThOtWV
TLSHT12D224D3FF1184B91C18853381CFB028FA7AED844DF64726BE7B69E7CBDA11279860901
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/lib/bitcode/ogr_fdw.index.bc
FileSize10212
MD5E7DEA4289A773EA42F502108DF3A6C9F
SHA-13517AA6364EFB8D62F6239A4B3A3E93A5230A5D5
SHA-2563E2485BC416ADCC24CF391990EA67CE416AAE4A5B7EF3BBF3214C2B40CF70A12
SSDEEP192:98U27Sbr+LJBRJmv4SV3aQ00rWkuVzsVFLH1gJHus/7acqzef4hoW773iqXwIu9F:9727Sbqlpmvd5g0rFuVzsTVgJOs/7ac/
TLSHT1E5227CDAEBE5C1629293C5BA9CCF1DFC92F2481F521B32DBAD543C033089369648943A
Key Value
FileName./usr/share/doc/postgresql-13-ogr-fdw/changelog.Debian.mips64el.gz
FileSize224
MD55B41E905A5E016CC2DFAEED8A884D537
SHA-1827E901BC428013A42548C4F469BD9CE8D23457C
SHA-256D980E20E67CA4C4CD8129B026E72FF0FF8BDD837D49FD6A5F355DF637A88C9DA
SSDEEP6:XtkVpSCJUtLcvy+q/LswMLViGUcepFbsRsW5jJyLFqdGdI1E:XODSFc6+ECGm+hqdi1
TLSHT11DD0231210745DEB81A597B355B55530030CB0C010DDEE7D15749BF95DCD75D80BF1A5
Key Value
FileName./usr/lib/postgresql/13/lib/bitcode/ogr_fdw/ogr_fdw_func.bc
FileSize6020
MD5BB63A5E5DE857EEE4146D324B5B4E912
SHA-14BA86209FD39AD88C32C0AD9D8E0DCB013A52065
SHA-2566F21E5E9B99F883BF88D7B07215F82CD3C0569B16BCD9DDD78ADB58224433CBC
SSDEEP96:k59cXSFkqeJ7WSYJ7WS89HTn3eIKjH695Q1fKtZDy+uYym1FFanoYqXWQoYmwgbY:krcqe7Y78tr3IjaY1fKtTUCi+gs
TLSHT189C1196972A81291D2290B3C9CAD0289673DDD089FD9BB877355763CBF7022EBD00872
Key Value
FileName./usr/lib/postgresql/13/lib/bitcode/ogr_fdw/ogr_fdw.bc
FileSize65004
MD52479F094FB2F2ADA9E7587DC59353FC0
SHA-1F73F647E8C399DF03E87769F6FB69408E394C249
SHA-2561E4DC5A53DAC6FB83C0583733924CE47E942E6F1416948F8ECFFEEFA8137311B
SSDEEP1536:VTBwa05/WCq6+uzdvx/Hr1NUrLufijZepcDF8nJy:VTBwa0xWCqyBpAfufQen8
TLSHT15E537B19B064C6D0D588163E4CBF12DD0BA6B408CE499B537399B72C7D70288FAB367D
Key Value
FileName./usr/lib/postgresql/13/lib/ogr_fdw.so
FileSize67600
MD53E014FB2373DD08A8AEF7E6CC176FB35
SHA-1B9A58C6320981B66BCE7BEB979EFF2E59451975E
SHA-256AA31583CE2A3DFCBCBB1B29854557E0FC179C407A7171F1F78B3226BDC17BF77
SSDEEP768:RzBQR/egi9kOKVmgZ8f//aooYMsg8Z0wSEEj5pXzMR6Kb/NA:RzOR/M9kOKMKr0MZ8qnzGVA
TLSHT18E63E843FB042F12D0D58E35887EE271267C6D177740C792EA5C9999AE2B9CF09C3A4A
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/13/bin/ogr_fdw_info
FileSize33528
MD591A70EFEC9C83EB0E4A2517D735B5E51
SHA-16D046F798270E2AF6CBD6F53A8CCDFEAA9003B25
SHA-256308B66F98676C81226C56AA39803F902961134A8B4E6D34D05A55CB9599B767D
SSDEEP384:qZWiCDe6A+w8nXUnK6EqsLlJHl0cYCPRIKtb/7o/+pZ:qZWpe6A+znkKqWlJOWPRbtbMc
TLSHT160E2C593FF142F16D4C6AE35841EA27A06793E46FF11C353DA4C26A52E366CA4EC4C4D
Key Value
FileName./usr/share/doc/postgresql-13-ogr-fdw/copyright
FileSize1620
MD5499B3FB5D2AAB1E6C06D1CCFBC800180
SHA-17F3316DC5C6DD7A5E955520CA0887D2C6ACC47C2
SHA-256A44FF01B48025CB7EB1CA15965214E09653E902221EE69DF88BD5380112C5D1E
SSDEEP24:gttzRRSoRhmKWgKrKUxrwNJHZH0yf3gtk1Hc1hMK9QH0sUv4kOk4/+/U3oq4sFig:s3qfxyJxl/El5QH0s5ANU3oWFig
TLSHT1B631C84FF64403632DE233E29854B8E9A7337489B0AB16C5F44EE2047B2A0ADC1FA464