\set ECHO 0 planned_at | node_id | parent_id | node_type | total_runtime | strategy | operation | startup_cost | total_cost | plan_rows | plan_width | actual_startup_time | actual_total_time | actual_rows | actual_loops | parent_relationship | sort_key | sort_method | sort_space_used | sort_space_type | join_type | join_filter | hash_cond | relation_name | alias | scan_direction | index_name | index_cond | recheck_cond | tid_cond | merge_cond | subplan_name | function_name | function_call | filter | one_time_filter | command | shared_hit_blocks | shared_read_blocks | shared_written_blocks | local_hit_blocks | local_read_blocks | local_written_blocks | temp_read_blocks | temp_written_blocks | output | hash_buckets | hash_batches | original_hash_batches | peak_memory_usage | schema | cte_name | triggers -------------------------------+----------------------------------+-----------+-----------+---------------+----------+-----------+--------------+------------+-----------+------------+---------------------+-------------------+-------------+--------------+---------------------+----------+-------------+-----------------+-----------------+-----------+-------------+-----------+---------------+-------+----------------+------------+------------+--------------+----------+------------+--------------+---------------+---------------+--------+-----------------+---------+-------------------+--------------------+-----------------------+------------------+-------------------+----------------------+------------------+---------------------+--------+--------------+--------------+-----------------------+-------------------+--------+----------+---------- 2010-11-08 19:21:19.817375+00 | 6e9d7e0628d306480fece89e8483fe6e | | Seq Scan | | | | 0 | 34 | 2400 | 4 | | | | | | {} | {} | | | | | | foo | foo | | | | | | | | | | | | | | | | | | | | | {} | | | | | | | {} (1 row) have_planned_at | node_id | parent_id | node_type | have_total_runtime | strategy | operation | startup_cost | total_cost | plan_rows | plan_width | have_actual_startup_time | have_actual_total_time | actual_rows | actual_loops | parent_relationship | sort_key | sort_method | sort_space_used | sort_space_type | join_type | join_filter | hash_cond | relation_name | alias | scan_direction | index_name | index_cond | recheck_cond | tid_cond | merge_cond | subplan_name | function_name | function_call | filter | one_time_filter | command | shared_hit_blocks | shared_read_blocks | shared_written_blocks | local_hit_blocks | local_read_blocks | local_written_blocks | temp_read_blocks | temp_written_blocks | output | hash_buckets | hash_batches | original_hash_batches | peak_memory_usage | schema | cte_name -----------------+----------------------------------+-----------+-----------+--------------------+----------+-----------+--------------+------------+-----------+------------+--------------------------+------------------------+-------------+--------------+---------------------+----------+-------------+-----------------+-----------------+-----------+-------------+-----------+---------------+-------+----------------+------------+------------+--------------+----------+------------+--------------+---------------+---------------+--------+-----------------+---------+-------------------+--------------------+-----------------------+------------------+-------------------+----------------------+------------------+---------------------+--------+--------------+--------------+-----------------------+-------------------+--------+---------- t | b012abc1673778343cb1b89aae1e9b94 | | Seq Scan | t | | | 0 | 34 | 2400 | 4 | t | t | 0 | 1 | | {} | {} | | | | | | foo | foo | | | | | | | | | | | | | | | | | | | | | {} | | | | | | (1 row) node_id | parent_id | node_type | total_runtime | strategy | operation | startup_cost | total_cost | plan_rows | plan_width | actual_startup_time | actual_total_time | actual_rows | actual_loops | parent_relationship | sort_key | sort_method | sort_space_used | sort_space_type | join_type | join_filter | hash_cond | relation_name | alias | scan_direction | index_name | index_cond | recheck_cond | tid_cond | merge_cond | subplan_name | function_name | function_call | filter | one_time_filter | command | shared_hit_blocks | shared_read_blocks | shared_written_blocks | local_hit_blocks | local_read_blocks | local_written_blocks | temp_read_blocks | temp_written_blocks | output | hash_buckets | hash_batches | original_hash_batches | peak_memory_usage | schema | cte_name | triggers ----------------------------------+-----------+---------------+---------------+----------+-----------+--------------+------------+-----------+------------+---------------------+-------------------+-------------+--------------+---------------------+-------------------------------------------------------------------------------+-------------+-----------------+-----------------+-----------+----------------------------------------------+----------------------------+-------------------------+-------+----------------+------------------------+----------------------------+--------------+----------+------------+--------------+---------------+---------------+-----------------+-----------------+---------+-------------------+--------------------+-----------------------+------------------+-------------------+----------------------+------------------+---------------------+--------+--------------+--------------+-----------------------+-------------------+--------+----------+---------- 029dde3a3c872f0c960f03d2ecfaf5ee | | Aggregate | | Sorted | | 258.13 | 262.31 | 4 | 324 | 00:00:00.000121 | 00:00:00.000121 | 0 | 1 | | {} | {} | | | | | | | | | | | | | | | | | | | | | | | | | | | | {} | | | | | | | 3e4c4968cee7653037613c234a953be1 | | Sort | | | | 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 | | | | 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 | | | | 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 | | | | 0 | 15.1 | 510 | 128 | 00:00:00.000008 | 00:00:00.000008 | 0 | 1 | Outer | {} | {} | | | | | | distribution_extensions | de | | | | | | | | | | | | | | | | | | | | | {} | | | | | | | 709b2febd8e560dd8830f4c7277c3758 | | Hash | | | | 13 | 13 | 300 | 228 | 00:00:00 | 00:00:00 | 0 | 0 | Inner | {} | {} | | | | | | | | | | | | | | | | | | | | | | | | | | | | {} | | | | | | | 9dd89be09ea07a1000a21cbfc09121c7 | | Seq Scan | | | | 0 | 13 | 300 | 228 | 00:00:00 | 00:00:00 | 0 | 0 | Outer | {} | {} | | | | | | distributions | d | | | | | | | | | | | | | | | | | | | | | {} | | | | | | | 8dc3d35ab978f6c6e46f7927e7b86d21 | | Index Scan | | | | 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 | | | | 0 | 1 | 100 | 32 | 00:00:00 | 00:00:00 | 0 | 0 | SubPlan | {} | {} | | | | | | | g | | | | | | | SubPlan 1 | unnest | | (x IS NOT NULL) | | | | | | | | | | | {} | | | | | | | (9 rows) trigger_name | constraint_name | relation | time | calls --------------+-----------------+----------+-----------------+------- Harry | Melissa | users | 00:00:00.000234 | 14 Josh | Jeff | wankers | 00:00:00.000345 | 2 (2 rows) ROLLBACK