explain.depesz.com

PostgreSQL's explain analyze made readable

Result: Ixsi

Settings
# exclusive inclusive rows x rows loops node
1. 0.013 3,853.972 ↓ 0.0 100 1

Limit (cost=0.00..0.00 rows=0 width=0) (actual time=3,853.955..3,853.972 rows=100 loops=1)

2. 1.631 3,853.959 ↓ 0.0 100 1

Sort (cost=0.00..0.00 rows=0 width=0) (actual time=3,853.954..3,853.959 rows=100 loops=1)

  • Sort Key: remote_scan.gl_journal_id, remote_scan.gl_business_unit_code, remote_scan.gl_account_number
  • Sort Method: top-N heapsort Memory: 50kB
3. 2,686.744 3,852.328 ↓ 0.0 3,200 1

Custom Scan (Citus Adaptive) (cost=0.00..0.00 rows=0 width=0) (actual time=3,852.136..3,852.328 rows=3,200 loops=1)

  • Task Count: 32
  • Tasks Shown: One of 32
  • -> Task
  • Node: host=10.0.0.34 port=5,432 dbname=citus
4. 0.000 1,165.584 ↑ 1.0 100 1

Limit (cost=47,816.02..47,827.68 rows=100 width=76) (actual time=1,165.521..1,165.584 rows=100 loops=1)

5. 105.215 1,265.964 ↑ 3.6 100 1

Gather Merge (cost=47,816.02..47,858.49 rows=364 width=76) (actual time=1,165.520..1,265.964 rows=100 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
6. 2.248 1,160.749 ↑ 2.0 90 3 / 3

Sort (cost=46,815.99..46,816.45 rows=182 width=76) (actual time=1,160.745..1,160.749 rows=90 loops=3)

  • Sort Key: gl.gl_journal_id, gl.gl_business_unit_code, gl.gl_account_number
  • Sort Method: top-N heapsort Memory: 40kB
  • Worker 0: Sort Method: top-N heapsort Memory: 44kB
  • Worker 1: Sort Method: top-N heapsort Memory: 45kB
7. 83.240 1,158.501 ↓ 21.7 3,945 3 / 3

Hash Join (cost=8,109.74..46,809.16 rows=182 width=76) (actual time=1,005.508..1,158.501 rows=3,945 loops=3)

  • Hash Cond: (gl.gl_business_unit_and_journal_id_computed = gl_1.gl_business_unit_and_journal_id_computed)
8. 69.937 69.937 ↑ 1.2 614,173 3 / 3

Parallel Seq Scan on datasheet_aggr_106638 gl (cost=0.00..36,684.16 rows=767,716 width=100) (actual time=0.022..69.937 rows=614,173 loops=3)

9. 0.632 1,005.324 ↓ 28.6 3,637 3 / 3

Hash (cost=8,108.15..8,108.15 rows=127 width=24) (actual time=1,005.324..1,005.324 rows=3,637 loops=3)

  • Buckets: 4,096 (originally 1024) Batches: 1 (originally 1) Memory Usage: 235kB
10. 1.147 1,004.692 ↓ 28.6 3,637 3 / 3

Unique (cost=8,106.24..8,106.88 rows=127 width=24) (actual time=1,003.054..1,004.692 rows=3,637 loops=3)

11. 25.508 1,003.545 ↓ 64.6 8,203 3 / 3

Sort (cost=8,106.24..8,106.56 rows=127 width=24) (actual time=1,003.053..1,003.545 rows=8,203 loops=3)

  • Sort Key: gl_1.gl_business_unit_and_journal_id_computed
  • Sort Method: quicksort Memory: 1,025kB
  • Worker 0: Sort Method: quicksort Memory: 1,025kB
  • Worker 1: Sort Method: quicksort Memory: 1,025kB
12. 610.207 978.037 ↓ 64.6 8,203 3 / 3

Bitmap Heap Scan on mega_gl_106189 gl_1 (cost=7,911.99..8,101.81 rows=127 width=24) (actual time=384.888..978.037 rows=8,203 loops=3)

  • Recheck Cond: (gl_journal_id ~~ '%01_1%'::text)
  • Rows Removed by Index Recheck: 1,266,021
  • Heap Blocks: exact=99,452
13. 367.830 367.830 ↓ 10,033.3 1,274,224 3 / 3

Bitmap Index Scan on trgm_idx_mega_gl_jrn_id_106189 (cost=0.00..7,911.96 rows=127 width=0) (actual time=367.830..367.830 rows=1,274,224 loops=3)

  • Index Cond: (gl_journal_id ~~ '%01_1%'::text)
Planning time : 4.764 ms
Execution time : 3,854.080 ms