operations=# select id, part, position, field, value from header_fields where message = 2231708; id | part | position | field | value ----------+---------+----------+-------+------------------------------------------------------------------------------------------------------------------------------------ 47053407 | | 2 | 29 | from 91.216.35.72 (HELO mx4.lrau.net) by imap.lrau.net\\r + | | | | (Archiveopteryx 3.2.0) with lmtps id 1461428332-15877-15876/4/2 for\\r + | | | | Axel.Rau@Chaos1.DE; Sat, 23 Apr 2016 16:18:52 +0000 47053408 | | 3 | 29 | from lists4.lrau.net ([2a02:d40:2:2::92])\\r + | | | | by mx4.lrau.net with esmtps (TLSv1.2:ECDHE-RSA-AES256-GCM-SHA384:256)\\r + | | | | (Exim 4.86_2 (FreeBSD))\\r + | | | | (envelope-from )\\r + | | | | id 1au0Gh-00049R-9Q\\r + | | | | for Axel.Rau@chaos1.de; Sat, 23 Apr 2016 16:18:51 +0000 47053409 | | 4 | 29 | from lists4.lrau.net ([2a02:d40:2:2::92])\\r + | | | | by lists4.lrau.net with esmtp (Exim 4.86_2 (FreeBSD))\\r + | | | | (envelope-from )\\r + | | | | id 1au0Gh-00049D-P6\\r + | | | | for Axel.Rau@chaos1.de; Sat, 23 Apr 2016 16:18:51 +0000 47053410 | | 5 | 29 | from mailout4.lrau.net ([2a02:d40:2:2::73])\\r + | | | | by lists4.lrau.net with esmtps (TLSv1.2:ECDHE-RSA-AES256-GCM-SHA384:256)\\r + | | | | (Exim 4.86_2 (FreeBSD)) (envelope-from )\\r + | | | | id 1au0Gg-000496-9x\\r + | | | | for mailman@lists.framail.de; Sat, 23 Apr 2016 16:18:50 +0000 47053411 | | 6 | 325 | v=1; a=rsa-sha256; q=dns/txt; c=relaxed/relaxed; d=chaos1.de; \\r + | | | | s=email1;\\r + | | | | h=Mime-Version:To:Message-Id:Date:Subject:Content-Type:From; \\r + | | | | bh=Kv5MHgGYLTSZrIhbbQ7QxHixEvwc2zxn7zLqkpsdxZ8=; b=c4p0Qgm8UKOqWFVSkib6F9Fu1u\\r + | | | | kxL9xxOHZJSKXZoX5vuYFMjR+OG/4GLpmtyZyQJs4DoOiF6LVB5lcGq9U6zp6kK45ePbqc3AxV577\\r + | | | | XIwgMihjAR++xpHdyAfWFmifPsRnhyISRF8Ha/CHJx1Gg3RtcJOySfGhBnETZD6fZE/DBhHoDAI3P\\r + | | | | 2Ou2nvC0oqyNOAaZK2RyHYsjI/UA7HvLoC7H7XREkmqR9M1VI0XFWrjA+laRMoY+R6GnF/9uLf+z+\\r + | | | | q2Nip3Jxp0sdHwTmPFQYEJNNV98PV73k4vjDAUA9QB7f8wMo0w3EzjwEj8sclI1vsiPLXY6lTf9nK\\r + | | | | 5BYZLpWw==; 47053412 | | 7 | 29 | from [91.216.35.74] (helo=imap.lrau.net)\\r + | | | | by mailout4.lrau.net with esmtp (Exim 4.86_2 (FreeBSD))\\r + | | | | (envelope-from ) id 1au0Gg-000492-DK\\r + | | | | for mailman@lists.framail.de; Sat, 23 Apr 2016 16:18:50 +0000 47053413 | | 8 | 29 | from Axel.Rau@Chaos1.DE by imap.lrau.net (Archiveopteryx\\r + | | | | 3.2.0) with esmtpsa id 1461428328-15877-15876/6/2; Sat, 23 Apr 2016\\r + | | | | 16:18:48 +0000 47053414 | | 10 | 327 | GPGMail 2.6b2 47053415 | | 11 | 17 | Sat, 23 Apr 2016 18:18:40 +0200 47053416 | | 12 | 13 | <42533150-5146-4225-BA69-761558C22E16@Chaos1.DE> 47053417 | | 14 | 28 | 1.0 47053418 | | 15 | 317 | Apple Mail (2.3124) 47053419 | | 16 | 20 | [Mailman] PT 141 47053420 | | 17 | 309 | mailman@lists.framail.de 47053421 | | 18 | 310 | 2.1.21 47053422 | | 19 | 294 | list 47053423 | | 20 | 306 | 47053424 | | 21 | 290 | ,\\r + | | | | 47053425 | | 22 | 293 | 47053426 | | 23 | 291 | 47053427 | | 24 | 289 | 47053428 | | 25 | 307 | ,\\r + | | | | 47053429 | | 26 | 23 | multipart/mixed; boundary="===============8181654318731767555==" 47053430 | | 28 | 5288 | RVHL/true/1, RDNS/true/0.1, RKMR/false/0, RRAT/0.01/-0.02/-2, LLST(R:8:4)/4, RGRL/state_gl_opened/-1, TOT/5.08/-0.99/A/{2894464/3} 47053431 | 1 | 1 | 23 | multipart/signed; protocol="application/pgp-signature";\\r + | | | | boundary="Apple-Mail=_4F70631D-86BD-486D-A403-8AF4786BF90E";\\r + | | | | micalg=pgp-sha256 47053432 | 1.1 | 1 | 23 | multipart/alternative;\\r + | | | | boundary="Apple-Mail=_B9467D95-AAC0-4713-A17C-4E612A690E3D" 47053433 | 1.1.1 | 1 | 24 | quoted-printable 47053434 | 1.1.1 | 2 | 23 | text/plain; charset=utf-8 47053435 | 1.1.2 | 1 | 23 | multipart/mixed;\\r + | | | | boundary="Apple-Mail=_BD84052A-33E0-4E1D-862B-E3D483C21E17" 47053436 | 1.1.2.1 | 1 | 24 | quoted-printable 47053437 | 1.1.2.1 | 2 | 23 | text/html; charset=utf-8 47053438 | 1.1.2.2 | 1 | 25 | attachment; filename=start-with-git-txt 47053439 | 1.1.2.2 | 2 | 23 | application/octet-stream; name=start-with-git-txt 47053440 | 1.1.2.2 | 3 | 24 | base64 47053441 | 1.1.2.3 | 1 | 24 | quoted-printable 47053442 | 1.1.2.3 | 2 | 23 | text/html; charset=utf-8 47053443 | 1.2 | 1 | 24 | base64 47053444 | 1.2 | 2 | 25 | attachment; filename=signature.asc 47053445 | 1.2 | 3 | 23 | application/pgp-signature; name=signature.asc 47053446 | 1.2 | 4 | 26 | Message signed with OpenPGP using GPGMail 47053447 | 2 | 1 | 23 | text/plain; charset=iso-8859-1 47053448 | 2 | 4 | 25 | inline (42 rows) Time: 3,888 ms operations=# select pn.part, bp.hash, bp.bytes from part_numbers pn, bodyparts bp where pn.message = 2231708 and pn.bodypart = bp.id; part | hash | bytes ----------------+----------------------------------+------- 1 | 1687a3f2fe9ee2d76698f8d08b95c0e9 | 2844 1.1.1 | 0580822d54fbd5e253be44bccb64ea8a | 90 1.1.2.1 | 4e7bd7a83bf94162dfbc32904ff98734 | 307 1.1.2.2 | f48bbce4bd87eb9028364ccb866bf953 | 66 1.1.2.3 | c747ce800f87fc173e11b286a311c88c | 353 1.2 | 5cf6667c788fb83b1270d4c4669c4dfb | 538 2 | b72b4aa3a82049a42664c6a95e0a4148 | 139 raw-pgp-signed | 33c40eb81059a45a9f650b4de7fd8be9 | 3416