\set ECHO 0
\set QUIET 1
BEGIN;
\t
\pset format unaligned
SET IntervalStyle = 'postgres';
\i sql/explanation.sql
SELECT node_type FROM parse_node('Aggregate');
SELECT strategy FROM parse_node('Sorted');
SELECT operation FROM parse_node('foo');
SELECT startup_cost FROM parse_node('258.13');
SELECT total_cost FROM parse_node('259.13');
SELECT plan_rows FROM parse_node('1000');
SELECT plan_width FROM parse_node('33');
SELECT actual_startup_time FROM parse_node('0.121');
SELECT actual_total_time FROM parse_node('0.134');
SELECT actual_rows FROM parse_node('2000');
SELECT actual_loops FROM parse_node('20');
SELECT parent_relationship FROM parse_node('Outer');
SELECT sort_key FROM parse_node('- d.id
- d.name
');
SELECT sort_method FROM parse_node('- this
- that
');
SELECT sort_space_type FROM parse_node('whatever');
SELECT sort_space_used FROM parse_node('32434');
SELECT join_type FROM parse_node('nested');
SELECT join_filter FROM parse_node('pandering');
SELECT hash_cond FROM parse_node('(de.distribution = d.name)');
SELECT relation_name FROM parse_node('users');
SELECT alias FROM parse_node('u');
SELECT scan_direction FROM parse_node('forward');
SELECT index_name FROM parse_node('idx_users');
SELECT index_cond FROM parse_node('(u.name = mumble)');
SELECT recheck_cond FROM parse_node('(u.id = fumble)');
SELECT tid_cond FROM parse_node('(t.id = tid)');
SELECT merge_cond FROM parse_node('(m.id = mid)');
SELECT subplan_name FROM parse_node('my-subplan');
SELECT function_name FROM parse_node('parse_node()');
SELECT function_call FROM parse_node('parse_node(this, that)');
SELECT filter FROM parse_node('x = y');
SELECT one_time_filter FROM parse_node('one = two');
SELECT command FROM parse_node('go!');
SELECT shared_hit_blocks FROM parse_node('2000');
SELECT shared_read_blocks FROM parse_node('20');
SELECT shared_written_blocks FROM parse_node('0');
SELECT local_hit_blocks FROM parse_node('3453');
SELECT local_read_blocks FROM parse_node('234');
SELECT local_written_blocks FROM parse_node('12');
SELECT temp_read_blocks FROM parse_node('349394934934934');
SELECT temp_written_blocks FROM parse_node('2323');
SELECT output FROM parse_node('');
SELECT hash_buckets FROM parse_node('42');
SELECT hash_batches FROM parse_node('96');
SELECT original_hash_batches FROM parse_node('2');
SELECT peak_memory_usage FROM parse_node('34234823482348');
SELECT schema FROM parse_node('public');
SELECT cte_name FROM parse_node('ralph');
ROLLBACK;