explain.depesz.com

PostgreSQL's explain analyze made readable

Result: gCZW

Settings
# exclusive inclusive rows x rows loops node
1. 0.000 815,620.162 ↓ 1.1 21,162,707 1

Gather Merge (cost=64,714,320.69..66,939,230.73 rows=19,069,326 width=57) (actual time=805,401.651..815,620.162 rows=21,162,707 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
2. 23,380.224 2,424,303.159 ↑ 1.4 7,054,236 3

Sort (cost=64,713,320.67..64,737,157.33 rows=9,534,663 width=57) (actual time=805,360.502..808,101.053 rows=7,054,236 loops=3)

  • Sort Key: t.input_sequence
  • Sort Method: external merge Disk: 286600kB
  • Worker 0: Sort Method: external merge Disk: 258176kB
  • Worker 1: Sort Method: external merge Disk: 300312kB
3. 36,750.690 2,400,922.935 ↑ 1.4 7,054,236 3

Parallel Hash Left Join (cost=56,576,811.28..63,249,542.75 rows=9,534,663 width=57) (actual time=790,172.958..800,307.645 rows=7,054,236 loops=3)

  • Hash Cond: (t.input_sequence = snd_tro.reply_input_sequence)
4. 23,499.786 1,946,052.960 ↑ 1.1 7,054,236 3

Parallel Hash Left Join (cost=44,164,226.05..50,346,292.37 rows=7,917,300 width=49) (actual time=642,986.761..648,684.320 rows=7,054,236 loops=3)

  • Hash Cond: (r.input_sequence = rpl_snd_tro.reply_input_sequence)
5. 28,762.497 1,512,650.913 ↑ 1.1 7,054,236 3

Parallel Hash Left Join (cost=31,751,640.82..37,458,505.98 rows=7,917,300 width=41) (actual time=497,595.327..504,216.971 rows=7,054,236 loops=3)

  • Hash Cond: (r.input_sequence = rpl_rec_tro.input_sequence)
6. 39,764.031 1,099,322.445 ↑ 1.1 7,054,236 3

Hash Left Join (cost=19,339,055.59..24,588,160.71 rows=7,917,300 width=33) (actual time=316,567.948..366,440.815 rows=7,054,236 loops=3)

  • Hash Cond: (t.input_sequence = rec_tro.input_sequence)
7. 122,153.106 122,153.106 ↓ 1.0 6,582,146 3

Parallel Seq Scan on tbl_inputrequest t (cost=0.00..4,442,726.29 rows=6,574,290 width=17) (actual time=1,297.563..40,717.702 rows=6,582,146 loops=3)

  • Filter: ((receive_time < '2019-07-31 00:00:00'::timestamp without time zone) AND (input_sequence < '201908090079014702'::bigint) AND ((msg_status)::text = ANY ('{COMPLETED,REJECTED}'::text[])))
  • Rows Removed by Filter: 6705583
8. 32,760.732 937,405.308 ↑ 1.7 27,628,542 3

Hash (cost=18,457,951.29..18,457,951.29 rows=47,992,024 width=24) (actual time=312,468.436..312,468.436 rows=27,628,542 loops=3)

  • Buckets: 524288 Batches: 128 Memory Usage: 20474kB
9. 145,749.744 904,644.576 ↓ 1.1 55,182,153 3

Hash Right Join (cost=13,179,176.54..18,457,951.29 rows=47,992,024 width=24) (actual time=186,027.040..301,548.192 rows=55,182,153 loops=3)

  • Hash Cond: (r.related_output_sequence = rec_tro.output_sequence)
10. 200,940.060 200,940.060 ↓ 1.0 39,863,187 3

Seq Scan on tbl_inputrequest r (cost=0.00..4,550,656.48 rows=39,851,148 width=16) (actual time=0.181..66,980.020 rows=39,863,187 loops=3)

11. 66,414.447 557,954.772 ↓ 1.1 53,756,334 3

Hash (cost=12,344,939.24..12,344,939.24 rows=47,992,024 width=16) (actual time=185,984.922..185,984.924 rows=53,756,334 loops=3)

  • Buckets: 1048576 Batches: 128 Memory Usage: 26185kB
12. 491,540.325 491,540.325 ↓ 1.1 53,756,334 3

Seq Scan on tbl_outputrequest rec_tro (cost=0.00..12,344,939.24 rows=47,992,024 width=16) (actual time=0.030..163,846.775 rows=53,756,334 loops=3)

13. 18,932.634 384,565.971 ↑ 1.1 17,918,778 3

Parallel Hash (cost=12,064,985.77..12,064,985.77 rows=19,996,677 width=16) (actual time=128,188.656..128,188.657 rows=17,918,778 loops=3)

  • Buckets: 1048576 Batches: 128 Memory Usage: 17856kB
14. 365,633.337 365,633.337 ↑ 1.1 17,918,778 3

Parallel Seq Scan on tbl_outputrequest rpl_rec_tro (cost=0.00..12,064,985.77 rows=19,996,677 width=16) (actual time=0.055..121,877.779 rows=17,918,778 loops=3)

15. 20,177.442 409,902.261 ↑ 1.1 17,918,778 3

Parallel Hash (cost=12,064,985.77..12,064,985.77 rows=19,996,677 width=16) (actual time=136,634.085..136,634.087 rows=17,918,778 loops=3)

  • Buckets: 1048576 Batches: 128 Memory Usage: 18176kB
16. 389,724.819 389,724.819 ↑ 1.1 17,918,778 3

Parallel Seq Scan on tbl_outputrequest rpl_snd_tro (cost=0.00..12,064,985.77 rows=19,996,677 width=16) (actual time=0.051..129,908.273 rows=17,918,778 loops=3)

17. 20,530.977 418,119.285 ↑ 1.1 17,918,778 3

Parallel Hash (cost=12,064,985.77..12,064,985.77 rows=19,996,677 width=16) (actual time=139,373.094..139,373.095 rows=17,918,778 loops=3)

  • Buckets: 1048576 Batches: 128 Memory Usage: 18176kB
18. 397,588.308 397,588.308 ↑ 1.1 17,918,778 3

Parallel Seq Scan on tbl_outputrequest snd_tro (cost=0.00..12,064,985.77 rows=19,996,677 width=16) (actual time=4.599..132,529.436 rows=17,918,778 loops=3)

Planning time : 64.341 ms
Execution time : 816,675.179 ms