explain.depesz.com

PostgreSQL's explain analyze made readable

Result: rNJG

Settings
# exclusive inclusive rows x rows loops node
1. 20.319 667.772 ↑ 58.1 321 1

HashAggregate (cost=57,429,033.70..57,738,853.60 rows=18,647 width=28) (actual time=667.687..667.772 rows=321 loops=1)

  • Output: ((SubPlan 1)), exstep0.lobj_id, exstep0.wflinst_id, wflinst1.wflinst_id, ((SubPlan 2))
  • Group Key: (SubPlan 1), exstep0.lobj_id, exstep0.wflinst_id, wflinst1.wflinst_id, (SubPlan 2)
  • Buffers: shared hit=561842 read=3165
  • I/O Timings: read=266.289
2. 102.225 647.453 ↓ 2.1 38,841 1

Nested Loop (cost=1.13..57,428,800.61 rows=18,647 width=28) (actual time=4.450..647.453 rows=38,841 loops=1)

  • Output: (SubPlan 1), exstep0.lobj_id, exstep0.wflinst_id, wflinst1.wflinst_id, (SubPlan 2)
  • Buffers: shared hit=561842 read=3165
  • I/O Timings: read=266.289
3. 310.898 310.898 ↑ 95.3 39,162 1

Index Scan using ix_exestep_lobj_step on dalimes.exestep exstep0 (cost=0.57..9,842,273.91 rows=3,730,607 width=16) (actual time=3.560..310.898 rows=39,162 loops=1)

  • Output: exstep0.exestep_id, exstep0.wflinst_id, exstep0.lobj_id, exstep0.step_id, exstep0.task_id, exstep0.resultref_id, exstep0.status, exstep0.virtualstatus, exstep0.ts_deletion, exstep0.queueentryid, exstep0.deviceid, exstep0.exestep_info, exstep0.vstatusaction, exstep0.ts_stepbegun, exstep0.ts_stepended, exstep0.ts_submit, exstep0.jdfdoc_id, exstep0.step_bypass
  • Index Cond: (exstep0.lobj_id = ANY ('{24588160,24588442,24588729,24589712,24588733,24589748,24589170,24588122,24589530,24589039,24589790,24587282,24589630,24588149,24588083,24588164,24588241,24588876,24589435,24589744,24588424,24589540,24587773,24588688,24587595,24588935,24588746,24589075,24588849,24589580,24589824,24587928,24588381,24589497,24589384,24589254,24589487,24588149,24589178,24589305,24588475,24589790,24588733,24589744,24589630,24588746,24588782,24589039,24588729,24588241,24589435,24588164,24588083,24589530,24587282,24589540,24588561,24588876,24588663,24588115,24589082,24589325,24589178,24588182,24589580,24587608,24588746,24588381,24589777,24588782,24588565,24587693,24588649,24588108,24588479,24589325,24589431,24589640,24589136,24588029,24589195,24588561,24588260,24588773,24588811,24589748,24589082,24588479,24588621,24588253,24588504,24588108,24588942,24587608,24588626,24589103,24589777,24588115,24588605,24588182,24588182,24588182,24587693,24589136,24587869,24589195,24588663,24589325,24589011,24588586,24588586,24588586,24589431,24588260,24588565,24589529,24589748,24588649,24587407,24588811,24588479,24588253,24588464,24588773,24588050,24588904,24589305,24589622,24588579,24588942,24588395,24589529,24588260,24589103,24589136,24589039,24587596,24588522,24588504,24588504,24588504,24589185,24589011,24588196,24588196,24588196,24588688,24587728,24588289,24588464,24589358,24588395,24587832,24589622,24589333,24589059,24587596,24588579,24589007,24588626,24589480,24588522,24589185,24589107,24588050,24588688,24588985,24588845,24588621,24588679,24589597,24589358,24587728,24589449,24589086,24587865,24587832,24588547,24588289,24588098,24587282,24589865,24589059,24588000,24588292,24589799,24589431,24588985,24588934,24588679,24588414,24589505,24589358,24589185,24588674,24587608,24588626,24589007,24588729,24589487,24589086,24588547,24588919,24589107,24589043,24588174,24588621,24588454,24589865,24589814,24587728,24589480,24589286,24587996,24588845,24589258,24588934,24589505,24588605,24588174,24588522,24588729,24587865,24588122,24588122,24588122,24587596,24589562,24588454,24589498,24589043,24588679,24588985,24588674,24588893,24588357,24589431,24587728,24588442,24589596,24587773,24587773,24587773,24588414,24589086,24588919,24587996,24588149,24588149,24588149,24589601,24588729,24588904,24588547,24589307,24589384,24588663,24588292,24588292,24588292,24587596,24589000,24589099,24589813,24588424,24588424,24588424,24588357,24589498,24588605,24588934,24588880,24588996,24588454,24589043,24587992,24589185,24588893,24589566,24589562,24588368,24589099,24589596,24589000,24588278,24589384,24589398,24588083,24588083,24588083,24588442,24588442,24588442,24589813,24588904,24588880,24589307,24588098,24588504,24588663,24588663,24588663,24589299,24588357,24589737,24589498,24589699,24589000,24589202,24589626,24588599,24589838,24588504,24588880,24587798,24588381,24588381,24588381,24588098,24589346,24588223,24588278,24589622,24589737,24588800,24589358,24589791,24589269,24589838,24589402,24589258,24589699,24589202,24589022,24588000,24588064,24589806,24589824,24589838,24587987,24589278,24588956,24588036,24587736,24589082,24589626,24589790,24587798,24589254,24588223,24589346,24588250,24589601,24588245,24589512,24589325,24588599,24588599,24588599,24588000,24588395,24588395,24588395,24589622,24589022,24589791,24588292,24588996,24588160,24589806,24587736,24588250,24587987,24588064,24588245,24588178,24588094,24589726,24589254,24587865,24589202,24587996,24589082,24588856,24588292,24589007,24589136,24589317,24589512,24588036,24588434,24588126,24589383,24589369,24589216,24588996,24588621,24589274,24588178,24588663,24589806,24589270,24588094,24589726,24588356,24588160,24588296,24589630,24589254,24589744,24588985,24589126,24588649,24588856,24588800,24589007,24588126,24588663,24589216,24588406,24589383,24588464,24589369,24588434,24589333,24589554,24588695,24589630,24588729,24589126,24589580,24589597,24588985,24588075,24587818,24588296,24589321,24588586,24588391,24589497,24588695,24588800,24588957,24588037,24589126,24589286,24588849,24588075,24588905,24589333,24588328,24588268,24589529,24589554,24588729,24589467,24588406,24588406,24588406,24588514,24588037,24589748,24588875,24589813,24589777,24587600,24588464,24588391,24589169,24588174,24588174,24588174,24588626,24588905,24589333,24589467,24587818,24588674,24587890,24588522,24588849,24588268,24588328,24588995,24589777,24589365,24588381,24588313,24587600,24589317,24589654,24589813,24589554,24587780,24588434,24588702,24589865,24588688,24588822,24588593,24588551,24587890,24589365,24589195,24589103,24589317,24588313,24588905,24588004,24588626,24589654,24588324,24588688,24589505,24587669,24587938,24588522,24588522,24588522,24589321,24588702,24588547,24588160,24588691,24588561,24589365,24588551,24589195,24588822,24588313,24588004,24588575,24587780,24589317,24587656,24589814,24588098,24588923,24589075,24588324,24587669,24588434,24588434,24588434,24589321,24588547,24589103,24588691,24588561,24588688,24588551,24587938,24588593,24588923,24588946,24588786,24588702,24588695,24588278,24588278,24588278,24589286,24589195,24588733,24589107,24588268,24588575,24587656,24588547,24588561,24589075,24587682,24588098,24588750,24589018,24588368,24588695,24588414,24588923,24589029,24589011,24589107,24588526,24589115,24589286,24588841,24587818,24588250,24588250,24588250,24589442,24588414,24589831,24588368,24588909,24588068,24588268,24589099,24589449,24588750,24588875,24588182,24588957,24588774,24589580,24588733,24589170,24588841,24589725,24589011,24588909,24588636,24588904,24588368,24588601,24588722,24588182,24588320,24588454,24588000,24588414,24588875,24588800,24588774,24589146,24588957,24589626,24589831,24589369,24587928,24589550,24587780,24588593,24588636,24588800,24588876,24589244,24589640,24588909,24589699,24588841,24589115,24589626,24588050,24589597,24589299,24588626,24588722,24587600,24589725,24588601,24588601,24588601,24589369,24589487,24588098,24588526,24589146,24588636,24588774,24589550,24588500,24588320,24588320,24588320,24589332,24588313,24589390,24587869,24589712,24589640,24588935,24588626,24589286,24589230,24588000,24588800,24589480,24589216,24589597,24588260,24589115,24588605,24589278,24588075,24588075,24588075,24588526,24588575,24588593,24588593,24588593,24588919,24589153,24588029,24588946,24588757,24588786,24589487,24588500,24588605,24588050,24588050,24588050,24587600,24589011,24588876,24588876,24588876,24587682,24588897,24589390,24588313,24588037,24588037,24588037,24588605,24589692,24588153,24588829,24587275,24588098,24588098,24588098,24588935,24589597,24588626,24589170,24589216,24589480,24589230,24587869,24589107,24589244,24589278,24589516,24589449,24587682,24589726,24588946,24588454,24589373,24588757,24589011,24588260,24589487,24588605,24588029,24589170,24588786,24589153,24589497,24588897,24588904,24589107,24589373,24588212,24587928,24587275,24589449,24589692,24588822,24587682,24588153,24588615,24589383,24588688,24587585,24587773,24589029,24588450,24589244,24588829,24588122,24588008,24588454,24588449,24588212,24588395,24589107,24588656,24589011,24589730,24588260,24589771,24588822,24587729,24588450,24588904,24589029,24588454,24588919,24587643,24588663,24589059,24589730,24588230,24587585,24588008,24589824,24588782,24589771,24588816,24589169,24588840,24588579,24589357,24589630,24588601,24588974,24589813,24588449,24588449,24588449,24588656,24587831,24588226,24588845,24589467,24588663,24588816,24588434,24589427,24588579,24588957,24588800,24588919,24588230,24588782,24589630,24587643,24589357,24588750,24588192,24588840,24588974,24589059,24589039,24589654,24587961,24589169,24589220,24588601,24589813,24588504,24587831,24589075,24588442,24588479,24588434,24589185,24588126,24589688,24589427,24588782,24588996,24589419,24588226,24588241,24588816,24587988,24588356,24588192,24589258,24588579,24589332,24589357,24589384,24588487,24588504,24587961,24588479,24588442,24588695,24588695,24588695,24589039,24588810,24588845,24587831,24587275,24588974,24588126,24588750,24588996,24588781,24588328,24588615,24589185,24588241,24589282,24589075,24589419,24588407,24588514,24588688,24587988,24589086,24589806,24588356,24587928,24588487,24588722,24589777,24588621,24589332,24589505,24588781,24587831,24588328,24588615,24588479,24589122,24588599,24588996,24588514,24589831,24588810,24588688,24587832,24589050,24589687,24588722,24587928,24588621,24589402,24588241,24589799,24587992,24588942,24588599,24589000,24588407,24589831,24588346,24589122,24588849,24589174,24589687,24588781,24589050,24589402,24589018,24589099,24587992,24589000,24588905,24588260,24588679,24588942,24588722,24588015,24587845,24588346,24587832,24589274,24589174,24589050,24588981,24588691,24589554,24588253,24589018,24588923,24588833,24588905,24587701,24589744,24588875,24589402,24588849,24589670,24588679,24588956,24587845,24588601,24588942,24589626,24588289,24589011,24589000,24589814,24588346,24589055,24588981,24589274,24588733,24589321,24588526,24589670,24588260,24589554,24588601,24588679,24588268,24588875,24587845,24587869,24588833,24588905,24588691,24589011,24588253,24588561,24588312,24588718,24589530,24589550,24588486,24589615,24588956,24588981,24589670,24588450,24588450,24588450,24587585,24588212,24588212,24588212,24588985,24588381,24588424,24588816,24588289,24588289,24588289,24589601,24589369,24587869,24588875,24588015,24588750,24589011,24589480,24588312,24588486,24588615,24588223,24588985,24587585,24589234,24589498,24589530,24588561,24587773,24588435,24587784,24589654,24588036,24589169,24589558,24588381,24588196,24588750,24588342,24588733,24588923,24589103,24589332,24588223,24588015,24589647,24588811,24589423,24588064,24588615,24589018,24588663,24588663,24588663,24587773,24589259,24588626,24588923,24589601,24589169,24589435,24588811,24588718,24588064,24588342,24589562,24589103,24588750,24588036,24587784,24589234,24588985,24589390,24588234,24589512,24589865,24588547,24589558,24588522,24588626,24587596,24589018,24588182,24589647,24588733,24588923,24588192,24588192,24588192,24588504,24588504,24588504,24589333,24588149,24588064,24589055,24587740,24589435,24588522,24589103,24588479,24588253,24589512,24589373,24588561,24588126,24588718,24588182,24589505,24588435,24588361,24588811,24588471,24589771,24589562,24588729,24588626,24587596,24588234,24589838,24588547,24588268,24589814,24589055,24589470,24588615,24588328,24588328,24588328,24588479,24588605,24587890,24588292,24588253,24589202,24588253,24589505,24589730,24588935,24588471,24588674,24589449,24588530,24589640,24588414,24588268,24589321,24588615,24588435,24589814,24588292,24588649,24588126,24589677,24588561,24588561,24588561,24589576,24588036,24589505,24588729,24588729,24588729,24588357,24589202,24588935,24587890,24589540,24588253,24589043,24588268,24588605,24588098,24588615,24587992,24589431,24588414,24588471,24589813,24588036,24587656,24589118,24588649,24588649,24588649,24587845,24588995,24589670,24589540,24588098,24588454,24587669,24588335,24589195,24588690,24589431,24588357,24589712,24588241,24589630,24589383,24587992,24589687,24588690,24588840,24588144,24589712,24588995,24588667,24589022,24587669,24589654,24589427,24588335,24588964,24588934,24589195,24589099,24588475,24589562,24589799,24588368,24588691,24588674,24588601,24588601,24588601,24589601,24588454,24589442,24588486,24588486,24588486,24588144,24588667,24589529,24588178,24587728,24588530,24589562,24588691,24588822,24589712,24588313,24588690,24588565,24589654,24589799,24589195,24588518,24589442,24588893,24589282,24588674,24589842,24588475,24588475,24588475,24588080,24588691,24588144,24588178,24588368,24589576,24588530,24589799,24588880,24589566,24589050,24588361,24588212,24587728,24589118,24588126,24588487,24587784,24588313,24588313,24588313,24589790,24588893,24588974,24589419,24589282,24587907,24588586,24589442,24588565,24588565,24588565,24589601,24588342,24588342,24588342,24588479,24589022,24588518,24589842,24589566,24588442,24588487,24589487,24588816,24589118,24588361,24588663,24588974,24589050,24588586,24589831,24587907,24588746,24589601,24588442,24588615,24589007,24588833,24588324,24589099,24589022,24588278,24589234,24589806,24588479,24589566,24588115,24588956,24588674,24588182,24588182,24588182,24589530,24588000,24587832,24588746,24588133,24589406,24588974,24589384,24589007,24588324,24589059,24587669,24588880,24588934,24589234,24588615,24589806,24588674,24588226,24588250,24589791,24588000,24589099,24588223,24588357,24588833,24588833,24588833,24588464,24589435,24588746,24589497,24588691,24588934,24589007,24589498,24589373,24588133,24589406,24588880,24588757,24589365,24588995,24589791,24588108,24587784,24588292,24588292,24588292,24588000,24589286,24588174,24588981,24588702,24588691,24587596,24589498,24588663,24589039,24588223,24588226,24588226,24588226,24588357,24588357,24588357,24588757,24588464,24588464,24588464,24589580,24588995,24588108,24588981,24587728,24588605,24588000,24588346,24588702,24589358,24588599,24589286,24589730,24588691,24589688,24588781,24587596,24589307,24588087,24588750,24588663,24588757,24589039,24589512,24588981,24588115,24588702,24589178,24589777,24587458,24588522,24588856,24589358,24587832,24587798,24588346,24588599,24589423,24587907,24588964,24587682,24589497,24589011,24588746,24589580,24589530,24589307,24589018,24588816,24588605,24588605,24588605,24588856,24588593,24588087,24589317,24588475,24589126,24588335,24588335,24588335,24588522,24588115,24588471,24587832,24589195,24587458,24589115,24587798,24588964,24589497,24589580,24589423,24588435,24588722,24589018,24588593,24588816,24588475,24589576,24588856,24587832,24588115,24589000,24587938,24587682,24589195,24589269,24588845,24588667,24588518,24587798,24589688,24588083,24588746,24588164,24589022,24589777,24588108,24589018,24588450,24589640,24589269,24589576,24588068,24587992,24587798,24588312,24588004,24588391,24589122,24589688,24588108,24589107,24588381,24589540,24589270,24589022,24588514,24588551,24589777,24589317,24588773,24589011,24588487,24588487,24588487,24588164,24588164,24588164,24589029,24588530,24588395,24588098,24588004,24588956,24588841,24589103,24588518,24588518,24588518,24589640,24588312,24588223,24589269,24588075,24588856,24588068,24589270,24588391,24589654,24589122,24588108,24589398,24589011,24588381,24588530,24588098,24588514,24589384,24589435,24588551,24589278,24589814,24588442,24588442,24588442,24588773,24588395,24589824,24589317,24589398,24589029,24589626,24588856,24589562,24589195,24589647,24589039,24589431,24588324,24588324,24588324,24588245,24589550,24589278,24589050,24589286,24589824,24588530,24588526,24589075,24589427,24587682,24588782,24589647,24589398,24589055,24589254,24587938,24588356,24589000,24589813,24589384,24589107,24588245,24589195,24589540,24589332,24589050,24589099,24589103,24589055,24589824,24589622,24588486,24588663,24588526,24589122,24589748,24589530,24589286,24589075,24589000,24588434,24587992,24589305,24589677,24588904,24589615,24589480,24588368,24589580,24588395,24588094,24589107,24588649,24589622,24589332,24588356,24588434,24588800,24588956,24589055,24589103,24589530,24589677,24588904,24588781,24587656,24589122,24587987,24589305,24588663,24588649,24588674,24589325,24588599,24588599,24588599,24589688,24588781,24589487,24588320,24588406,24588122,24587656,24588690,24588115,24588368,24588368,24588368,24589677,24589039,24588956,24588395,24587987,24588094,24588904,24589813,24588196,24588849,24589791,24589730,24589305,24589530,24589325,24589596,24587656,24589230,24588522,24588522,24588522,24588289,24588674,24587987,24588320,24589487,24588391,24588406,24589259,24589195,24588800,24589039,24589725,24588122,24589449,24588849,24588196,24588115,24589687,24587988,24588245,24588289,24589596,24589230,24588674,24587987,24589670,24588942,24588841,24588178,24588690,24589777,24588234,24589725,24588593,24589259,24589169,24589103,24588781,24588946,24587988,24587693,24589449,24588674,24588575,24588722,24589398,24588296,24588593,24589670,24589654,24588178,24588995,24588064,24588981,24588774,24589640,24588946,24588442,24588435,24589103,24588690,24588335,24588904,24589813,24588471,24588841,24589737,24587988,24588234,24588234,24588234,24589597,24588722,24588153,24589018,24587869,24588781,24589216,24589402,24587693,24588985,24589383,24589540,24588178,24589730,24588296,24588575,24588312,24588312,24588312,24588004,24588004,24588004,24588435,24589737,24588942,24589022,24589842,24589640,24589103,24588471,24588196,24589813,24588015,24589018,24588782,24588946,24588153,24587988,24589730,24588981,24589307,24589540,24587938,24587736,24588904,24588098,24588098,24588098,24589777,24589216,24587585,24589126,24588178,24588985,24588985,24588985,24587869,24589082,24588196,24588782,24589346,24588551,24588268,24589018,24588292,24588905,24588942,24589712,24588015,24589842,24588995,24587736,24587938,24588391,24588037,24589777,24589126,24587585,24588626,24587784,24589321,24589082,24588361,24589216,24588414,24589576,24589178,24589346,24588909,24588601,24588956,24588212,24588268,24588829,24588407,24588486,24588995,24588905,24589055,24587784,24588626,24588816,24588182,24588115,24588551,24588551,24588551,24588909,24588164,24589022,24588450,24588875,24589692,24589178,24588810,24589321,24587992,24588880,24589601,24589529,24588050,24589687,24589082,24588605,24588361,24588956,24588414,24588414,24588414,24588486,24588626,24588212,24589692,24588781,24588164,24588875}'::bigint[]))
  • Filter: (exstep0.ts_deletion = 0)
  • Buffers: shared hit=15262 read=3160
  • I/O Timings: read=265.002
4. 117.486 156.648 ↑ 1.0 1 39,162

Index Scan using ixu_wflinstance_id on dalimes.wflinstance wflinst1 (cost=0.56..12.66 rows=1 width=12) (actual time=0.004..0.004 rows=1 loops=39,162)

  • Output: wflinst1.wflinst_id, wflinst1.wfl_id, wflinst1.wflinst_obj, wflinst1.wflinst_tpl, wflinst1.priority, wflinst1.wflinst_starttime, wflinst1.wflinst_orgobj, wflinst1.status, wflinst1.virtualstatus, wflinst1.vstatusaction, wflinst1.execounter, wflinst1.ts_deletion
  • Index Cond: ((wflinst1.ts_deletion = 0) AND (wflinst1.wflinst_id = exstep0.wflinst_id))
  • Filter: (((SubPlan 3))::text = 'false'::text)
  • Rows Removed by Filter: 0
  • Buffers: shared hit=313534 read=5
  • I/O Timings: read=1.287
5.          

SubPlan (forIndex Scan)

6. 39.162 39.162 ↑ 1.0 1 39,162

Index Scan using ix_wfl_idname on dalimes.wfl wfl_2 (cost=0.28..8.30 rows=1 width=5) (actual time=0.001..0.001 rows=1 loops=39,162)

  • Output: wfl_2.wfl_issystem
  • Index Cond: ((wfl_2.wfl_id = wflinst1.wfl_id) AND (wfl_2.ts_deletion = 0))
  • Buffers: shared hit=117486
7.          

SubPlan (forNested Loop)

8. 38.841 38.841 ↑ 1.0 1 38,841

Index Only Scan using ix_wfl_idname on dalimes.wfl (cost=0.28..8.30 rows=1 width=36) (actual time=0.001..0.001 rows=1 loops=38,841)

  • Output: wfl.wfl_name
  • Index Cond: ((wfl.wfl_id = wflinst1.wfl_id) AND (wfl.ts_deletion = 0))
  • Heap Fetches: 38841
  • Buffers: shared hit=116523
9. 38.841 38.841 ↑ 1.0 1 38,841

Index Scan using ix_wfl_idname on dalimes.wfl wfl_1 (cost=0.28..8.30 rows=1 width=5) (actual time=0.001..0.001 rows=1 loops=38,841)

  • Output: wfl_1.wfl_issystem
  • Index Cond: ((wfl_1.wfl_id = wflinst1.wfl_id) AND (wfl_1.ts_deletion = 0))
  • Buffers: shared hit=116523
Planning time : 19.410 ms
Execution time : 668.337 ms