explain.depesz.com

PostgreSQL's explain analyze made readable

Result: sF2KZ

Settings
# exclusive inclusive rows x rows loops node
1. 7,516.593 14,711.139 ↓ 1.0 8,977,976 1

Gather Merge (cost=708,482.46..1,794,137.57 rows=8,977,935 width=137) (actual time=6,085.818..14,711.139 rows=8,977,976 loops=1)

  • Workers Planned: 5
  • Workers Launched: 5
2. 2,595.376 7,194.546 ↑ 1.2 1,496,329 6 / 6

Sort (cost=707,482.39..711,971.35 rows=1,795,587 width=137) (actual time=6,039.997..7,194.546 rows=1,496,329 loops=6)

  • Sort Key: tm.system_time
  • Sort Method: external merge Disk: 152,072kB
  • Worker 0: Sort Method: external merge Disk: 151,472kB
  • Worker 1: Sort Method: external merge Disk: 156,424kB
  • Worker 2: Sort Method: external merge Disk: 156,000kB
  • Worker 3: Sort Method: external merge Disk: 157,144kB
  • Worker 4: Sort Method: external merge Disk: 155,520kB
3. 1,021.647 4,599.170 ↑ 1.2 1,496,329 6 / 6

Parallel Hash Left Join (cost=133,251.57..445,467.39 rows=1,795,587 width=137) (actual time=2,164.819..4,599.170 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))
4. 368.163 3,125.675 ↑ 1.2 1,496,329 6 / 6

Hash Join (cost=83,442.72..386,231.71 rows=1,795,587 width=85) (actual time=1,706.982..3,125.675 rows=1,496,329 loops=6)

  • Hash Cond: (tm.inst_id = iim.inst_info_msg_id)
5. 1,730.037 2,757.481 ↑ 1.2 1,496,329 6 / 6

Parallel Hash Left Join (cost=83,441.57..361,541.23 rows=1,795,587 width=84) (actual time=1,706.926..2,757.481 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))
6. 558.220 558.220 ↑ 1.2 1,496,329 6 / 6

Parallel Seq Scan on tick_msg tm (cost=0.00..222,007.84 rows=1,795,587 width=64) (actual time=0.024..558.220 rows=1,496,329 loops=6)

  • Filter: (id_day = 1)
7. 258.052 469.224 ↑ 1.5 920,111 6 / 6

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

  • Buckets: 1,048,576 Batches: 16 Memory Usage: 28,320kB
8. 211.172 211.172 ↑ 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.019..211.172 rows=920,111 loops=6)

  • Filter: (id_day = 1)
9. 0.005 0.031 ↑ 1.0 7 6 / 6

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

  • Buckets: 1,024 Batches: 1 Memory Usage: 9kB
10. 0.026 0.026 ↑ 1.0 7 6 / 6

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

11. 321.581 451.848 ↑ 1.9 507,176 6 / 6

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

  • Buckets: 4,194,304 Batches: 1 Memory Usage: 226,464kB
12. 130.267 130.267 ↑ 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.045..130.267 rows=507,176 loops=6)

  • Filter: (id_day = 1)
Planning time : 1.061 ms
Execution time : 15,399.726 ms