Skip to content

Instantly share code, notes, and snippets.

@chaintng
Created February 1, 2018 11:09
Show Gist options
  • Save chaintng/0d3d34b2e897ad0bed5df917a71ab473 to your computer and use it in GitHub Desktop.
Save chaintng/0d3d34b2e897ad0bed5df917a71ab473 to your computer and use it in GitHub Desktop.
QUERY PLAN
------------------------------------------------------------------------------------------------
Custom Scan (Citus Real-Time) (cost=0.00..0.00 rows=0 width=0)
Task Count: 32
Tasks Shown: All
-> Task
Node: host=10.140.0.4 port=5432 dbname=temp_db
-> Bitmap Heap Scan on record_102008 record (cost=10.74..31.37 rows=850 width=4)
Recheck Cond: (id < 3)
-> Bitmap Index Scan on record_pkey_102008 (cost=0.00..10.53 rows=850 width=0)
Index Cond: (id < 3)
-> Task
Node: host=10.140.0.5 port=5432 dbname=temp_db
-> Bitmap Heap Scan on record_102009 record (cost=10.74..31.37 rows=850 width=4)
Recheck Cond: (id < 3)
-> Bitmap Index Scan on record_pkey_102009 (cost=0.00..10.53 rows=850 width=0)
Index Cond: (id < 3)
-> Task
Node: host=10.140.0.4 port=5432 dbname=temp_db
-> Bitmap Heap Scan on record_102010 record (cost=10.74..31.37 rows=850 width=4)
Recheck Cond: (id < 3)
-> Bitmap Index Scan on record_pkey_102010 (cost=0.00..10.53 rows=850 width=0)
Index Cond: (id < 3)
-> Task
Node: host=10.140.0.5 port=5432 dbname=temp_db
-> Bitmap Heap Scan on record_102011 record (cost=10.74..31.37 rows=850 width=4)
Recheck Cond: (id < 3)
-> Bitmap Index Scan on record_pkey_102011 (cost=0.00..10.53 rows=850 width=0)
Index Cond: (id < 3)
-> Task
Node: host=10.140.0.4 port=5432 dbname=temp_db
-> Bitmap Heap Scan on record_102012 record (cost=10.74..31.37 rows=850 width=4)
Recheck Cond: (id < 3)
-> Bitmap Index Scan on record_pkey_102012 (cost=0.00..10.53 rows=850 width=0)
Index Cond: (id < 3)
-> Task
Node: host=10.140.0.5 port=5432 dbname=temp_db
-> Bitmap Heap Scan on record_102013 record (cost=10.74..31.37 rows=850 width=4)
Recheck Cond: (id < 3)
-> Bitmap Index Scan on record_pkey_102013 (cost=0.00..10.53 rows=850 width=0)
Index Cond: (id < 3)
-> Task
Node: host=10.140.0.4 port=5432 dbname=temp_db
-> Bitmap Heap Scan on record_102014 record (cost=10.74..31.37 rows=850 width=4)
Recheck Cond: (id < 3)
-> Bitmap Index Scan on record_pkey_102014 (cost=0.00..10.53 rows=850 width=0)
Index Cond: (id < 3)
-> Task
Node: host=10.140.0.5 port=5432 dbname=temp_db
-> Bitmap Heap Scan on record_102015 record (cost=10.74..31.37 rows=850 width=4)
Recheck Cond: (id < 3)
-> Bitmap Index Scan on record_pkey_102015 (cost=0.00..10.53 rows=850 width=0)
Index Cond: (id < 3)
-> Task
Node: host=10.140.0.4 port=5432 dbname=temp_db
-> Bitmap Heap Scan on record_102016 record (cost=10.74..31.37 rows=850 width=4)
Recheck Cond: (id < 3)
-> Bitmap Index Scan on record_pkey_102016 (cost=0.00..10.53 rows=850 width=0)
Index Cond: (id < 3)
-> Task
Node: host=10.140.0.5 port=5432 dbname=temp_db
-> Bitmap Heap Scan on record_102017 record (cost=10.74..31.37 rows=850 width=4)
Recheck Cond: (id < 3)
-> Bitmap Index Scan on record_pkey_102017 (cost=0.00..10.53 rows=850 width=0)
Index Cond: (id < 3)
-> Task
Node: host=10.140.0.4 port=5432 dbname=temp_db
-> Bitmap Heap Scan on record_102018 record (cost=10.74..31.37 rows=850 width=4)
Recheck Cond: (id < 3)
-> Bitmap Index Scan on record_pkey_102018 (cost=0.00..10.53 rows=850 width=0)
Index Cond: (id < 3)
-> Task
Node: host=10.140.0.5 port=5432 dbname=temp_db
-> Bitmap Heap Scan on record_102019 record (cost=10.74..31.37 rows=850 width=4)
Recheck Cond: (id < 3)
-> Bitmap Index Scan on record_pkey_102019 (cost=0.00..10.53 rows=850 width=0)
Index Cond: (id < 3)
-> Task
Node: host=10.140.0.4 port=5432 dbname=temp_db
-> Bitmap Heap Scan on record_102020 record (cost=10.74..31.37 rows=850 width=4)
Recheck Cond: (id < 3)
-> Bitmap Index Scan on record_pkey_102020 (cost=0.00..10.53 rows=850 width=0)
Index Cond: (id < 3)
-> Task
Node: host=10.140.0.5 port=5432 dbname=temp_db
-> Bitmap Heap Scan on record_102021 record (cost=10.74..31.37 rows=850 width=4)
Recheck Cond: (id < 3)
-> Bitmap Index Scan on record_pkey_102021 (cost=0.00..10.53 rows=850 width=0)
Index Cond: (id < 3)
-> Task
Node: host=10.140.0.4 port=5432 dbname=temp_db
-> Bitmap Heap Scan on record_102022 record (cost=10.74..31.37 rows=850 width=4)
Recheck Cond: (id < 3)
-> Bitmap Index Scan on record_pkey_102022 (cost=0.00..10.53 rows=850 width=0)
Index Cond: (id < 3)
-> Task
Node: host=10.140.0.5 port=5432 dbname=temp_db
-> Bitmap Heap Scan on record_102023 record (cost=10.74..31.37 rows=850 width=4)
Recheck Cond: (id < 3)
-> Bitmap Index Scan on record_pkey_102023 (cost=0.00..10.53 rows=850 width=0)
Index Cond: (id < 3)
-> Task
Node: host=10.140.0.4 port=5432 dbname=temp_db
-> Bitmap Heap Scan on record_102024 record (cost=10.74..31.37 rows=850 width=4)
Recheck Cond: (id < 3)
-> Bitmap Index Scan on record_pkey_102024 (cost=0.00..10.53 rows=850 width=0)
Index Cond: (id < 3)
-> Task
Node: host=10.140.0.5 port=5432 dbname=temp_db
-> Bitmap Heap Scan on record_102025 record (cost=10.74..31.37 rows=850 width=4)
Recheck Cond: (id < 3)
-> Bitmap Index Scan on record_pkey_102025 (cost=0.00..10.53 rows=850 width=0)
Index Cond: (id < 3)
-> Task
Node: host=10.140.0.4 port=5432 dbname=temp_db
-> Bitmap Heap Scan on record_102026 record (cost=10.74..31.37 rows=850 width=4)
Recheck Cond: (id < 3)
-> Bitmap Index Scan on record_pkey_102026 (cost=0.00..10.53 rows=850 width=0)
Index Cond: (id < 3)
-> Task
Node: host=10.140.0.5 port=5432 dbname=temp_db
-> Bitmap Heap Scan on record_102027 record (cost=10.74..31.37 rows=850 width=4)
Recheck Cond: (id < 3)
-> Bitmap Index Scan on record_pkey_102027 (cost=0.00..10.53 rows=850 width=0)
Index Cond: (id < 3)
-> Task
Node: host=10.140.0.4 port=5432 dbname=temp_db
-> Bitmap Heap Scan on record_102028 record (cost=10.74..31.37 rows=850 width=4)
Recheck Cond: (id < 3)
-> Bitmap Index Scan on record_pkey_102028 (cost=0.00..10.53 rows=850 width=0)
Index Cond: (id < 3)
-> Task
Node: host=10.140.0.5 port=5432 dbname=temp_db
-> Bitmap Heap Scan on record_102029 record (cost=10.74..31.37 rows=850 width=4)
Recheck Cond: (id < 3)
-> Bitmap Index Scan on record_pkey_102029 (cost=0.00..10.53 rows=850 width=0)
Index Cond: (id < 3)
-> Task
Node: host=10.140.0.4 port=5432 dbname=temp_db
-> Bitmap Heap Scan on record_102030 record (cost=10.74..31.37 rows=850 width=4)
Recheck Cond: (id < 3)
-> Bitmap Index Scan on record_pkey_102030 (cost=0.00..10.53 rows=850 width=0)
Index Cond: (id < 3)
-> Task
Node: host=10.140.0.5 port=5432 dbname=temp_db
-> Bitmap Heap Scan on record_102031 record (cost=10.74..31.37 rows=850 width=4)
Recheck Cond: (id < 3)
-> Bitmap Index Scan on record_pkey_102031 (cost=0.00..10.53 rows=850 width=0)
Index Cond: (id < 3)
-> Task
Node: host=10.140.0.4 port=5432 dbname=temp_db
-> Bitmap Heap Scan on record_102032 record (cost=10.74..31.37 rows=850 width=4)
Recheck Cond: (id < 3)
-> Bitmap Index Scan on record_pkey_102032 (cost=0.00..10.53 rows=850 width=0)
Index Cond: (id < 3)
-> Task
Node: host=10.140.0.5 port=5432 dbname=temp_db
-> Bitmap Heap Scan on record_102033 record (cost=10.74..31.37 rows=850 width=4)
Recheck Cond: (id < 3)
-> Bitmap Index Scan on record_pkey_102033 (cost=0.00..10.53 rows=850 width=0)
Index Cond: (id < 3)
-> Task
Node: host=10.140.0.4 port=5432 dbname=temp_db
-> Bitmap Heap Scan on record_102034 record (cost=10.74..31.37 rows=850 width=4)
Recheck Cond: (id < 3)
-> Bitmap Index Scan on record_pkey_102034 (cost=0.00..10.53 rows=850 width=0)
Index Cond: (id < 3)
-> Task
Node: host=10.140.0.5 port=5432 dbname=temp_db
-> Bitmap Heap Scan on record_102035 record (cost=10.74..31.37 rows=850 width=4)
Recheck Cond: (id < 3)
-> Bitmap Index Scan on record_pkey_102035 (cost=0.00..10.53 rows=850 width=0)
Index Cond: (id < 3)
-> Task
Node: host=10.140.0.4 port=5432 dbname=temp_db
-> Bitmap Heap Scan on record_102036 record (cost=10.74..31.37 rows=850 width=4)
Recheck Cond: (id < 3)
-> Bitmap Index Scan on record_pkey_102036 (cost=0.00..10.53 rows=850 width=0)
Index Cond: (id < 3)
-> Task
Node: host=10.140.0.5 port=5432 dbname=temp_db
-> Bitmap Heap Scan on record_102037 record (cost=10.74..31.37 rows=850 width=4)
Recheck Cond: (id < 3)
-> Bitmap Index Scan on record_pkey_102037 (cost=0.00..10.53 rows=850 width=0)
Index Cond: (id < 3)
-> Task
Node: host=10.140.0.4 port=5432 dbname=temp_db
-> Bitmap Heap Scan on record_102038 record (cost=10.74..31.37 rows=850 width=4)
Recheck Cond: (id < 3)
-> Bitmap Index Scan on record_pkey_102038 (cost=0.00..10.53 rows=850 width=0)
Index Cond: (id < 3)
-> Task
Node: host=10.140.0.5 port=5432 dbname=temp_db
-> Bitmap Heap Scan on record_102039 record (cost=10.74..31.37 rows=850 width=4)
Recheck Cond: (id < 3)
-> Bitmap Index Scan on record_pkey_102039 (cost=0.00..10.53 rows=850 width=0)
Index Cond: (id < 3)
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment