explain.depesz.com

PostgreSQL's explain analyze made readable

Result: dQAK

Settings
# exclusive inclusive rows x rows loops node
1. 4,568.739 10,972.235 ↑ 1.0 8,977,976 1

Gather Merge (cost=687,273.10..1,772,963.28 rows=8,978,225 width=161) (actual time=6,546.342..10,972.235 rows=8,977,976 loops=1)

  • Workers Planned: 5
  • Workers Launched: 5
  • Buffers: shared hit=260,065
2. 1,752.465 6,403.496 ↑ 1.2 1,496,329 6 / 6

Sort (cost=686,273.02..690,762.14 rows=1,795,645 width=161) (actual time=6,230.066..6,403.496 rows=1,496,329 loops=6)

  • Sort Key: tm.system_time
  • Sort Method: quicksort Memory: 264,119kB
  • Worker 0: Sort Method: quicksort Memory: 258,241kB
  • Worker 1: Sort Method: quicksort Memory: 246,155kB
  • Worker 2: Sort Method: quicksort Memory: 239,251kB
  • Worker 3: Sort Method: quicksort Memory: 257,331kB
  • Worker 4: Sort Method: quicksort Memory: 254,578kB
  • Buffers: shared hit=260,065
3. 493.791 4,651.031 ↑ 1.2 1,496,329 6 / 6

Hash Left Join (cost=125,166.71..413,464.49 rows=1,795,645 width=161) (actual time=1,172.920..4,651.031 rows=1,496,329 loops=6)

  • Hash Cond: (qm.id_passive_side = sq.id)
  • Buffers: shared hit=259,930
4. 896.470 4,157.234 ↑ 1.2 1,496,329 6 / 6

Parallel Hash Left Join (cost=125,165.64..402,091.00 rows=1,795,645 width=102) (actual time=1,172.897..4,157.234 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=259,924
5. 351.752 2,555.916 ↑ 1.2 1,496,329 6 / 6

Hash Left Join (cost=49,811.07..317,309.30 rows=1,795,645 width=90) (actual time=457.416..2,555.916 rows=1,496,329 loops=6)

  • Hash Cond: (trm.id_aggressor_side = str.id)
  • Buffers: shared hit=222,389
6. 831.421 2,204.149 ↑ 1.2 1,496,329 6 / 6

Parallel Hash Left Join (cost=49,810.01..305,935.82 rows=1,795,645 width=89) (actual time=457.386..2,204.149 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=222,383
7. 545.794 922.802 ↑ 1.2 1,496,329 6 / 6

Hash Join (cost=1.16..246,699.84 rows=1,795,645 width=65) (actual time=0.063..922.802 rows=1,496,329 loops=6)

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

Parallel Seq Scan on tick_msg tm (cost=0.00..222,008.56 rows=1,795,645 width=64) (actual time=0.010..376.982 rows=1,496,329 loops=6)

  • Filter: (id_day = 1)
  • Buffers: shared hit=199,563
9. 0.006 0.026 ↑ 1.0 7 6 / 6

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

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

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

  • Buffers: shared hit=6
11. 334.878 449.926 ↑ 1.9 507,176 6 / 6

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

  • Buckets: 4,194,304 Batches: 1 Memory Usage: 226,464kB
  • Buffers: shared hit=22,814
12. 115.048 115.048 ↑ 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.018..115.048 rows=507,176 loops=6)

  • Filter: (id_day = 1)
  • Buffers: shared hit=22,814
13. 0.008 0.015 ↑ 1.0 3 6 / 6

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

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

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

  • Buffers: shared hit=6
15. 508.959 704.848 ↑ 1.5 920,111 6 / 6

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

  • Buckets: 8,388,608 Batches: 1 Memory Usage: 385,088kB
  • Buffers: shared hit=37,400
16. 195.889 195.889 ↑ 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.022..195.889 rows=920,111 loops=6)

  • Filter: (id_day = 1)
  • Buffers: shared hit=37,400
17. 0.003 0.006 ↑ 1.0 3 6 / 6

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

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

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

  • Buffers: shared hit=6
Planning time : 0.875 ms
Execution time : 11,593.165 ms