\set ECHO 0
 029dde3a3c872f0c960f03d2ecfaf5ee |           | Aggregate     | 00:00:00.01435 | Sorted   |           |       258.13 |     262.31 |         4 |        324 | 00:00:00.000121     | 00:00:00.000121   |           0 |            1 |                     | {}                                                                            | {}          |                 |                 |           |                                              |                            |                         |       |                |                        |                            |              |          |            |              |               |               |                 |                 |         |                   |                    |                       |                  |                   |                      |                  |                     | {}     |              |              |                       |                   |        |          | {"(Harry,Melissa,users,00:00:00.000234,14)"}
 3e4c4968cee7653037613c234a953be1 |           | Sort          | 00:00:00.01435 |          |           |       258.13 |     258.14 |         4 |        324 | 00:00:00.000117     | 00:00:00.000117   |           0 |            1 | Outer               | {d.name,d.version,d.abstract,d.description,d.relstatus,d.owner,d.sha1,d.meta} | {}          |              25 | Memory          |           |                                              |                            |                         |       |                |                        |                            |              |          |            |              |               |               |                 |                 |         |                   |                    |                       |                  |                   |                      |                  |                     | {}     |              |              |                       |                   |        |          | 
 dd3d1b1fb6c70be827075e01b306250c |           | Nested Loop   | 00:00:00.01435 |          |           |        16.75 |     258.09 |         4 |        324 | 00:00:00.000009     | 00:00:00.000009   |           0 |            1 | Outer               | {}                                                                            | {}          |                 |                 | Left      | (semver_cmp(d.version, dt.version) = 0)      |                            |                         |       |                |                        |                            |              |          |            |              |               |               |                 |                 |         |                   |                    |                       |                  |                   |                      |                  |                     | {}     |              |              |                       |                   |        |          | 
 037a8fe70739ed1be6a3006d0ab80c82 |           | Hash Join     | 00:00:00.01435 |          |           |        16.75 |     253.06 |         4 |        292 | 00:00:00.000009     | 00:00:00.000009   |           0 |            1 | Outer               | {}                                                                            | {}          |                 |                 | Inner     | (semver_cmp(d.version, de.dist_version) = 0) | (de.distribution = d.name) |                         |       |                |                        |                            |              |          |            |              |               |               |                 |                 |         |                   |                    |                       |                  |                   |                      |                  |                     | {}     |              |              |                       |                   |        |          | 
 2c4e922dc19ce9f01a3bf08fbd76b041 |           | Seq Scan      | 00:00:00.01435 |          |           |            0 |       15.1 |       510 |        128 | 00:00:00.000008     | 00:00:00.000008   |           0 |            1 | Outer               | {}                                                                            | {}          |                 |                 |           |                                              |                            | distribution_extensions | de    |                |                        |                            |              |          |            |              |               |               |                 |                 |         |                   |                    |                       |                  |                   |                      |                  |                     | {}     |              |              |                       |                   |        |          | 
 709b2febd8e560dd8830f4c7277c3758 |           | Hash          | 00:00:00.01435 |          |           |           13 |         13 |       300 |        228 | 00:00:00            | 00:00:00          |           0 |            0 | Inner               | {}                                                                            | {}          |                 |                 |           |                                              |                            |                         |       |                |                        |                            |              |          |            |              |               |               |                 |                 |         |                   |                    |                       |                  |                   |                      |                  |                     | {}     |              |              |                       |                   |        |          | 
 9dd89be09ea07a1000a21cbfc09121c7 |           | Seq Scan      | 00:00:00.01435 |          |           |            0 |         13 |       300 |        228 | 00:00:00            | 00:00:00          |           0 |            0 | Outer               | {}                                                                            | {}          |                 |                 |           |                                              |                            | distributions           | d     |                |                        |                            |              |          |            |              |               |               |                 |                 |         |                   |                    |                       |                  |                   |                      |                  |                     | {}     |              |              |                       |                   |        |          | 
 8dc3d35ab978f6c6e46f7927e7b86d21 |           | Index Scan    | 00:00:00.01435 |          |           |            0 |       0.46 |         3 |         96 | 00:00:00            | 00:00:00          |           0 |            0 | Inner               | {}                                                                            | {}          |                 |                 |           |                                              |                            | distribution_tags       | dt    | NoMovement     | distribution_tags_pkey | (d.name = dt.distribution) |              |          |            |              |               |               |                 |                 |         |                   |                    |                       |                  |                   |                      |                  |                     | {}     |              |              |                       |                   |        |          | 
 3d7c72f13ae7571da70f434b5bc9e0af |           | Function Scan | 00:00:00.01435 |          |           |            0 |          1 |       100 |         32 | 00:00:00            | 00:00:00          |           0 |            0 | SubPlan             | {}                                                                            | {}          |                 |                 |           |                                              |                            |                         | g     |                |                        |                            |              |          |            | SubPlan 1    | unnest        |               | (x IS NOT NULL) |                 |         |                   |                    |                       |                  |                   |                      |                  |                     | {}     |              |              |                       |                   |        |          |