explain.depesz.com

PostgreSQL's explain analyze made readable

Result: ArlZ

Settings
# exclusive inclusive rows x rows loops node
1. 6,652.922 13,713.245 ↑ 1.0 8,977,976 1

Gather Merge (cost=697,793.75..1,783,467.60 rows=8,978,090 width=125) (actual time=6,111.525..13,713.245 rows=8,977,976 loops=1)

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

Sort (cost=696,793.67..701,282.71 rows=1,795,618 width=125) (actual time=6,051.580..7,060.323 rows=1,496,329 loops=6)

  • Sort Key: tm.me_in_time
  • Sort Method: external merge Disk: 132,816kB
  • Worker 0: Sort Method: external merge Disk: 142,776kB
  • Worker 1: Sort Method: external merge Disk: 134,072kB
  • Worker 2: Sort Method: external merge Disk: 132,848kB
  • Worker 3: Sort Method: external merge Disk: 139,136kB
  • Worker 4: Sort Method: external merge Disk: 132,832kB
3. 1,010.155 4,716.929 ↑ 1.2 1,496,329 6 / 6

Parallel Hash Left Join (cost=133,251.57..441,962.53 rows=1,795,618 width=125) (actual time=2,621.817..4,716.929 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. 1,796.062 3,206.649 ↑ 1.2 1,496,329 6 / 6

Parallel Hash Left Join (cost=83,442.72..382,726.69 rows=1,795,618 width=73) (actual time=2,114.826..3,206.649 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))
5. 505.030 929.885 ↑ 1.2 1,496,329 6 / 6

Hash Join (cost=1.16..246,699.13 rows=1,795,618 width=53) (actual time=0.072..929.885 rows=1,496,329 loops=6)

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

Parallel Seq Scan on tick_msg tm (cost=0.00..222,008.22 rows=1,795,618 width=52) (actual time=0.021..424.822 rows=1,496,329 loops=6)

  • Filter: (id_day = 1)
7. 0.004 0.033 ↑ 1.0 7 6 / 6

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

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

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

9. 263.384 480.702 ↑ 1.5 920,111 6 / 6

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

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

  • Filter: (id_day = 1)
11. 348.607 500.125 ↑ 1.9 507,176 6 / 6

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

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

  • Filter: (id_day = 1)
Planning time : 0.500 ms
Execution time : 14,137.879 ms