Result for 21F94D177270A370A9D33982AD0870309E2BA1D2

Query result

Key Value
FileSize99488
MD55042B2C86342CBE7EB329B4E6F837A6C
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-121F94D177270A370A9D33982AD0870309E2BA1D2
SHA-25641A8CE6B890A31004E52D11D3B1C4ADD43B0E7A9F1ACC201FC756BB4A3C2EF4E
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
FileSize23692
MD57FC4389DE30E4CECA3A4AB111A441A5C
SHA-1900EE419BF6B4EE18711B88E68A1F96F7D59E38B
SHA-256A3CF085F2801C2F2CF60D48CEBA010890D58862ED366A5A43561C22C268FF5BC
SSDEEP384:kK4tMWHOyOXwAlNcZYr3hzkOWRYK6N4slXE+t2Srj+PB5QG:TheOAAlNphNWVsFPrqPBGG
TLSHT11EB27D09F596625BC488463E4EBF02DB4BA6F588EF0483433559672C7E71384DF7217A
Key Value
FileName./usr/lib/postgresql/13/lib/bitcode/ogr_fdw/ogr_fdw_func.bc
FileSize5860
MD5E03D6DA4ECB8CDF3412E7656FD458D58
SHA-10C653CBB1E618487B1433278B8D23FA0AD920709
SHA-25660A1809B0762567BEFD771CFE581AE6D4DECA3AD1A14B14F5B7CC93A1E81E9E0
SSDEEP96:kM59cXSFkq6JVRWE8SEh7q/mHTn3ZHGmQ6YKtZDy+KacJ1ouoYqXWf7oYmwgbB/:kMrcq6nmh7q/0r3gkYKtT+hgV
TLSHT15DC12B2933641A91C05E073DEDAF42C75739EA089FC6B7577785B72CB9F021E69108B2
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/13/lib/bitcode/ogr_fdw/stringbuffer_pg.bc
FileSize10488
MD50762B24C283C571D739E9BE298EC081E
SHA-1BE2A62C1C9749F737937914E7DC3FA07FFE56169
SHA-2563998B20CBC26DDA514AA81896563BCE57B446E72EACC6DA2AF35B7489A48873E
SSDEEP192:kps23h7EZ5Yl71NVp0r38G425KtTyFKfg6DGo++AfIeFPA3guJlHETMJMLG:kpJWSnVar3hjFegaG7+Af7FPA3BJ9Ii
TLSHT1CC223A2FB75866D1C08857381CEB42CE96E9A4408FB07677ABB36A3C7EB217758B0550
Key Value
FileName./usr/lib/postgresql/13/lib/bitcode/ogr_fdw/ogr_fdw.bc
FileSize63732
MD53FC31778A2B36A8DC42833DFBB1AA0A1
SHA-11438C60FDC606AE7739F7E1FB0B03AC20518AB2E
SHA-256C4E088D5D29B41E3704943167122D7EFB2A6C344F1133828F45F515CB97564AC
SSDEEP1536:ZTBsTyIf3GclUNIQLxBlQ/cqZK0JaF8gJ:ZTBsTyIfWcaeQLxFxeg
TLSHT11C536B2E7260D2D2D44C537D4CBF02CE07B5BA04AF15926737A8672C7CB1288EA7297D
Key Value
FileName./usr/lib/postgresql/13/bin/ogr_fdw_info
FileSize27352
MD5E7FD979B7E739135895D9C47E267FD1F
SHA-107A53C9DC97007B1137D776DAEEB58BB907890BC
SHA-256857B3042784C8F6CEEF55898B6450EB87D85D4E9495243E1339F0805DC980483
SSDEEP384:MmrmohhnkdoQG/INpTIlsMOelJb/hhXEF:prmoSW/InTqrOEJbp
TLSHT1B0C2B76EF958D96BC88AD3745D9F8372B3235108E336C3F27148065DAE8B7FA4D60990
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
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/13/lib/ogr_fdw.so
FileSize63576
MD5EBCAFE8450D29D0D377810EA69982BEC
SHA-1B074F5450C1DB03DAF70404DCBE949C2A6F5D1E5
SHA-256968F3801E159ECF21C85E1E03CB2BAFB8E7F1AD417E81A25404C1D5910C98F18
SSDEEP768:q6WQTPSh9oaE1R9g/PYsGEzBWWEjEbRIPTV9u1zMR6Tbbzcl:qmTPl1R9QYJEzIAQJ9UzbX
TLSHT183532B1EF40D95E3C746F33509CA5761F733201CF15E4AD233285B696E4B28EAEB2998
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/share/doc/postgresql-13-ogr-fdw/changelog.Debian.arm64.gz
FileSize220
MD5CDB0DAAEF553EE12171A2D04B89470FB
SHA-12859B417D7CC82D33E9DCA5689368FAD595452D0
SHA-256527CF871182C807F97B6DD103B016B672B9E8C55C020602E7F3C3196E7255EC7
SSDEEP3:FttNLPrKT1HmJwnKKlYhpXtxRMNEq0rnNGJECa8kVzcLEdm8fWxvycI9wR1X0sUc:XtNYyQYhBsEqra8kZkO2XrvNwAl
TLSHT17AD0A784174E15065151AB27477E99101391070219744B95E0079957224FEA99C6A6C4
Key Value
FileName./usr/lib/postgresql/13/lib/bitcode/ogr_fdw.index.bc
FileSize10228
MD57517CAE886F16765EF8B0C8CFAADAF36
SHA-13BFB78E6D4FB127B38B601B85D79F6BE8B4D7096
SHA-25601098264FA9302122E2BC6C22BB65490575FC862AEB738ABE6D814707E164B6C
SSDEEP192:y2bWD6SIzswJQ5cp0s59yhrCMVPFWjkurEoTEY/t+yqxYF4g4iDm2Yi5QSug/:hS8/JQOpn9qQPEov/5wjgxt5dx
TLSHT1A1228DC7F38D926615DAEA95C8FF2CFA41E0547A019328C3D16A3C0336A93AE05DE079
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/lib/bitcode/ogr_fdw/ogr_fdw_common.bc
FileSize15536
MD51F38EDB91AE48DB9EFAAD555BB3B9438
SHA-13C92A40563A31CF2630CC80A61A6C799E99CB4A2
SHA-256C5717B61B36A13086B2C9F94EE78ED1EA202D327942EA3C139E5D82DE163781B
SSDEEP192:k8LL3h7Jr3tYwnXKO5fx07HYPsvCbYzKtTcwG7pw7La/5zLPGSRY/FZLLcYGdicU:k8/Hr3wwxDPdGtKLa/rMgYiiC3dW
TLSHT18962E72AB6944792D188433D197F02CB93BAF10CCF0A9743269C773D6975245E9B1E3E
Key Value
FileName./usr/share/doc/postgresql-13-ogr-fdw/copyright
FileSize1620
MD5499B3FB5D2AAB1E6C06D1CCFBC800180
SHA-17F3316DC5C6DD7A5E955520CA0887D2C6ACC47C2
SHA-256A44FF01B48025CB7EB1CA15965214E09653E902221EE69DF88BD5380112C5D1E
SSDEEP24:gttzRRSoRhmKWgKrKUxrwNJHZH0yf3gtk1Hc1hMK9QH0sUv4kOk4/+/U3oq4sFig:s3qfxyJxl/El5QH0s5ANU3oWFig
TLSHT1B631C84FF64403632DE233E29854B8E9A7337489B0AB16C5F44EE2047B2A0ADC1FA464