explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 1XXV

Settings
# exclusive inclusive rows x rows loops node
1. 4,703.769 11,902.723 ↑ 1.0 8,977,976 1

Gather Merge (cost=687,271.66..1,772,956.40 rows=8,978,180 width=161) (actual time=7,166.536..11,902.723 rows=8,977,976 loops=1)

  • Workers Planned: 5
  • Workers Launched: 5
  • Buffers: shared hit=292 read=259,776
2. 1,739.644 7,198.954 ↑ 1.2 1,496,329 6 / 6

Sort (cost=686,271.59..690,760.68 rows=1,795,636 width=161) (actual time=7,042.184..7,198.954 rows=1,496,329 loops=6)

  • Sort Key: tm.system_time
  • Sort Method: quicksort Memory: 242,314kB
  • Worker 0: Sort Method: quicksort Memory: 258,147kB
  • Worker 1: Sort Method: quicksort Memory: 264,302kB
  • Worker 2: Sort Method: quicksort Memory: 260,257kB
  • Worker 3: Sort Method: quicksort Memory: 245,021kB
  • Worker 4: Sort Method: quicksort Memory: 249,633kB
  • Buffers: shared hit=292 read=259,776
3. 492.795 5,459.310 ↑ 1.2 1,496,329 6 / 6

Hash Left Join (cost=125,166.71..413,464.05 rows=1,795,636 width=161) (actual time=1,484.395..5,459.310 rows=1,496,329 loops=6)

  • Hash Cond: (qm.id_passive_side = sq.id)
  • Buffers: shared hit=157 read=259,776
4. 960.175 4,966.502 ↑ 1.2 1,496,329 6 / 6

Parallel Hash Left Join (cost=125,165.64..402,090.62 rows=1,795,636 width=102) (actual time=1,484.337..4,966.502 rows=1,496,329 loops=6)

  • Hash Cond: ((tm.id_day = qm.id_day) AND (tm.id_journal_record_msg = qm.id_journal_record_msg))
  • Buffers: shared hit=151 read=259,776
5. 347.837 3,109.207 ↑ 1.2 1,496,329 6 / 6

Hash Left Join (cost=49,811.07..317,308.97 rows=1,795,636 width=90) (actual time=573.331..3,109.207 rows=1,496,329 loops=6)

  • Hash Cond: (trm.id_aggressor_side = str.id)
  • Buffers: shared hit=13 read=222,376
6. 905.555 2,761.341 ↑ 1.2 1,496,329 6 / 6

Parallel Hash Left Join (cost=49,810.01..305,935.54 rows=1,795,636 width=89) (actual time=573.272..2,761.341 rows=1,496,329 loops=6)

  • Hash Cond: ((tm.id_day = trm.id_day) AND (tm.id_journal_record_msg = trm.id_journal_record_msg))
  • Buffers: shared hit=7 read=222,376
7. 558.860 1,290.540 ↑ 1.2 1,496,329 6 / 6

Hash Join (cost=1.16..246,699.61 rows=1,795,636 width=65) (actual time=0.158..1,290.540 rows=1,496,329 loops=6)

  • Hash Cond: (tm.inst_id = iim.inst_info_msg_id)
  • Buffers: shared hit=7 read=199,562
8. 731.646 731.646 ↑ 1.2 1,496,329 6 / 6

Parallel Seq Scan on tick_msg tm (cost=0.00..222,008.46 rows=1,795,636 width=64) (actual time=0.055..731.646 rows=1,496,329 loops=6)

  • Filter: (id_day = 1)
  • Buffers: shared hit=2 read=199,561
9. 0.009 0.034 ↑ 1.0 7 6 / 6

Hash (cost=1.07..1.07 rows=7 width=9) (actual time=0.034..0.034 rows=7 loops=6)

  • Buckets: 1,024 Batches: 1 Memory Usage: 9kB
  • Buffers: shared hit=5 read=1
10. 0.025 0.025 ↑ 1.0 7 6 / 6

Seq Scan on inst_info_msg iim (cost=0.00..1.07 rows=7 width=9) (actual time=0.024..0.025 rows=7 loops=6)

  • Buffers: shared hit=5 read=1
11. 387.576 565.246 ↑ 1.9 507,176 6 / 6

Parallel Hash (cost=35,084.38..35,084.38 rows=981,631 width=28) (actual time=565.246..565.246 rows=507,176 loops=6)

  • Buckets: 4,194,304 Batches: 1 Memory Usage: 226,432kB
  • Buffers: shared read=22,814
12. 177.670 177.670 ↑ 1.9 507,176 6 / 6

Parallel Seq Scan on trade_msg trm (cost=0.00..35,084.38 rows=981,631 width=28) (actual time=0.051..177.670 rows=507,176 loops=6)

  • Filter: (id_day = 1)
  • Buffers: shared read=22,814
13. 0.013 0.029 ↑ 1.0 3 6 / 6

Hash (cost=1.03..1.03 rows=3 width=9) (actual time=0.027..0.029 rows=3 loops=6)

  • Buckets: 1,024 Batches: 1 Memory Usage: 9kB
  • Buffers: shared hit=6
14. 0.016 0.016 ↑ 1.0 3 6 / 6

Seq Scan on side str (cost=0.00..1.03 rows=3 width=9) (actual time=0.016..0.016 rows=3 loops=6)

  • Buffers: shared hit=6
15. 590.642 897.120 ↑ 1.5 920,111 6 / 6

Parallel Hash (cost=54,652.07..54,652.07 rows=1,380,166 width=24) (actual time=897.118..897.120 rows=920,111 loops=6)

  • Buckets: 8,388,608 Batches: 1 Memory Usage: 385,056kB
  • Buffers: shared read=37,400
16. 306.478 306.478 ↑ 1.5 920,111 6 / 6

Parallel Seq Scan on quote_msg qm (cost=0.00..54,652.07 rows=1,380,166 width=24) (actual time=0.050..306.478 rows=920,111 loops=6)

  • Filter: (id_day = 1)
  • Buffers: shared read=37,400
17. 0.009 0.013 ↑ 1.0 3 6 / 6

Hash (cost=1.03..1.03 rows=3 width=9) (actual time=0.013..0.013 rows=3 loops=6)

  • Buckets: 1,024 Batches: 1 Memory Usage: 9kB
  • Buffers: shared hit=6
18. 0.004 0.004 ↑ 1.0 3 6 / 6

Seq Scan on side sq (cost=0.00..1.03 rows=3 width=9) (actual time=0.004..0.004 rows=3 loops=6)

  • Buffers: shared hit=6
Planning time : 4.395 ms
Execution time : 12,595.783 ms