explain.depesz.com

PostgreSQL's explain analyze made readable

Result: WeHd

Settings
# exclusive inclusive rows x rows loops node
1. 195.068 532,836.613 ↑ 531.7 6 1

GroupAggregate (cost=16,802,247.53..16,813,927.17 rows=3,190 width=32) (actual time=532,569.778..532,836.613 rows=6 loops=1)

  • Group Key: hiring_plan_interview_stages.name
  • Buffers: shared hit=1,334,431 read=6,586,485 dirtied=143,948 written=12,448, temp read=29,544 written=29,538
2. 517.657 532,641.545 ↑ 1.9 301,616 1

Sort (cost=16,802,247.53..16,803,702.50 rows=581,988 width=32) (actual time=532,560.069..532,641.545 rows=301,616 loops=1)

  • Sort Key: hiring_plan_interview_stages.name
  • Sort Method: quicksort Memory: 35,540kB
  • Buffers: shared hit=1,334,431 read=6,586,485 dirtied=143,948 written=12,448, temp read=29,544 written=29,538
3. 676.910 532,123.888 ↑ 1.9 301,616 1

Nested Loop (cost=865,838.07..16,746,520.35 rows=581,988 width=32) (actual time=18,102.117..532,123.888 rows=301,616 loops=1)

  • Buffers: shared hit=1,334,428 read=6,586,485 dirtied=143,948 written=12,448, temp read=29,544 written=29,538
4. 2,503.977 312,473.762 ↑ 2.3 301,616 1

Hash Join (cost=865,837.50..15,360,108.81 rows=679,575 width=36) (actual time=18,100.832..312,473.762 rows=301,616 loops=1)

  • Hash Cond: (application_stages.hiring_plan_interview_stage_id = hiring_plan_interview_stages.id)
  • Buffers: shared hit=141,263 read=6,271,397 dirtied=134,942 written=12,448, temp read=29,544 written=29,538
5. 66,507.631 301,335.790 ↑ 2.5 301,687 1

Hash Join (cost=553,025.14..14,993,510.16 rows=761,258 width=24) (actual time=9,442.540..301,335.790 rows=301,687 loops=1)

  • Hash Cond: (application_stages.application_id = applications.id)
  • Buffers: shared hit=107,761 read=6,208,348 dirtied=134,795 written=12,448
6. 225,396.622 225,396.622 ↓ 1.0 137,753,049 1

Seq Scan on application_stages (cost=0.00..14,079,008.72 rows=137,705,250 width=24) (actual time=1.825..225,396.622 rows=137,753,049 loops=1)

  • Filter: (entered_date IS NOT NULL)
  • Rows Removed by Filter: 655,880,178
  • Buffers: shared hit=40,005 read=6,105,149 dirtied=133,565 written=12,448
7. 173.152 9,431.537 ↑ 2.8 235,403 1

Hash (cost=544,761.14..544,761.14 rows=661,120 width=8) (actual time=9,431.536..9,431.537 rows=235,403 loops=1)

  • Buckets: 1,048,576 Batches: 1 Memory Usage: 17,388kB
  • Buffers: shared hit=67,756 read=103,199 dirtied=1,230
8. 9,258.385 9,258.385 ↑ 2.8 235,403 1

Index Scan using index_applications_on_hiring_plan_id on applications (cost=0.57..544,761.14 rows=661,120 width=8) (actual time=0.157..9,258.385 rows=235,403 loops=1)

  • Index Cond: (hiring_plan_id = ANY ('{1287555,1287545,1119791,433716,1280127,1277836,534660,1288571,1287045,19102,1286553,1287515,193021,1286448,1023983,1083884,1285087,1283161,842416,1285356,1285340,179564,1243823,597881,518363,1108022,1284944,1279708,179562,1283429,1281551,1282563,1284093,1282774,1181411,1283360,1283467,1097627,963732,1280989,1282082,1227225,52828,1281423,1280938,1280940,1184099,1276210,958175,435576,1279837,1277194,1276474,1187615,985854,1276890,1276869,1276569,1136266,1276088,1275736,1085082,971177,1274923,1269978,1274517,1274513,1058536,439622,1001925,1274493,1170206,1274487,375703,1273614,1269500,979204,1272590,1272538,1265086,38424,964643,973954,1269635,1270312,1270310,1270309,1270307,1270306,1270303,1270301,1270298,1270297,1270296,1270293,1270292,1270291,1270287,1270285,574245,1268284,999616,1269202,1120920,1269094,1269090,1269091,1250240,181794,1265450,1266509,1266101,1190629,1265808,1265798,1080820,1265309,693833,1265173,1262982,749408,872478,1264542,48035,179561,1086210,401919,401926,1260547,1239697,1255229,1083926,200665,369321,14204,91036,1253130,652180,1247317,1247323,1135830,1247090,912122,1246574,1061122,36384,1237769,1130540,1082863,601659,1241081,1240530,1239797,1234382,1238529,1238357,1088880,28682,649720,1166667,1235525,1235541,1235524,1112844,1234327,59337,1233492,1233484,1233464,16697,1230688,1230677,31015,1230737,749374,10014,1100501,1227235,669572,1136552,1010701,38494,1179496,1184074,568478,1224263,1224824,1290803,1290797,1290787,1290775,1290755,1288761,1287549,1287542,1287538,1287534,1289202,1287528,1289367,40852,777520,1287101,1251236,694525,1222045,170484,823469,1221865,1204013,1219814,1220796,1126183,1218666,377927,527661,1216731,1217512,1217335,1216717,1180128,1207978,1195357,1215135,1214352,729012,1213432,1212292,1195918,1114200,941048,784707,1096420,1205060,549258,1089035,1205877,38497,1092380,1048167,1204459,1204452,553117,1202447,1201283,1196903,1198017,1198696,1199742,966988,458146,1196795,1196786,1196778,736248,1183111,293547,1094097,1194386,890249,1184093,1188427,1105774,1186880,978200,1185565,1105742,825479,298544,1182937,1180928,1176228,1176719,1176174,1172163,1166124,1170657,1170634,1168556,1136451,1164457,1164465,1164472,1160106,1165345,1165541,1163800,573957,970350,735909,742590,1105762,1024663,317043,1159981,1160055,426509,54747,1153840,287238,1106723,1152848,641000,1142393,1142431,1131423,298533,54976,326810,652755,1148810,1011912,1112598,764318,815858,844606,1138917,1138909,891879,1135880,856666,38306,965156,585286,377931,33374,639365,451863,13885,1045925,99514,170116,201391,858061,1125636,935900,1123690,1121614,1071606,369257,1120508,519441,732095,1089231,1089197,844618,369306,1116411,1041621,1105797,1112626,735738,1112620,320312,736540,1027507,750038,736269,736261,736231,12966,1105745,1105746,1105768,736256,745220,1105753,1105776,1105777,1027791,1104091,698017,1103957,1103647,1098764,1096411,1092845,1089188,532479,41419,977807,510958,1084831,1006565,1089229,1089199,1089196,1089193,1089232,1088788,193031,678121,407265,1086233,1086224,694508,663073,966990,269560,10013,634525,66312,193033,1069711,133475,1015555,566428,477360,1084149,309519,377930,91029,858467,669695,747843,736473,736451,666321,1078201,1078246,1076702,128353,616707,1036604,998427,958838,1047903,934357,694503,603322,603415,1141606,1141569,742585,1138014,916538,1136572,1137172,1132251,193032,598197,555368,1045899,926446,668867,977817,738837,86719,934375,678358,1061621,878759,1059852,921275,63930,898034,1046060,1046031,684736,10015,874540,215127,1031471,1031512,701653,1025638,1032343,669613,98192,328214,1027521,753019,1015554,596952,502801,597587,760594,669636,1023525,369277,621507,670582,48805,1015557,1015556,967785,1012763,756590,527670,735902,903232,736257,789756,736244,39560,800555,10090,67122,928785,978450,978444,584596,971671,534573,514007,965941,597428,962683,962054,957974,953550,921279,877940,972817,950571,834333,935754,933765,893629,36387,843269,919471,918021,902873,909618,121159,121195,864086,882986,179567,85717,286953,853526,994164,651272,810886,655293,201320,814135,736458,745228,806414,806415,789031,70306,787474,10016,903140,748751,747319,736448,736251,736245,736239,729195,369318,725514,699676,698552,91031,534600,644946,625969,591974,400542,566431,369271,172969,301870,93547,10008}'::integer[]))
  • Buffers: shared hit=67,756 read=103,199 dirtied=1,230
9. 4,083.023 8,633.995 ↓ 1.0 7,336,870 1

Hash (cost=178,499.13..178,499.13 rows=7,315,778 width=20) (actual time=8,633.994..8,633.995 rows=7,336,870 loops=1)

  • Buckets: 4,194,304 Batches: 4 Memory Usage: 129,814kB
  • Buffers: shared hit=33,499 read=63,049 dirtied=147, temp written=28,306
10. 4,550.972 4,550.972 ↓ 1.0 7,336,870 1

Seq Scan on hiring_plan_interview_stages (cost=0.00..178,499.13 rows=7,315,778 width=20) (actual time=0.018..4,550.972 rows=7,336,870 loops=1)

  • Filter: active
  • Rows Removed by Filter: 864,145
  • Buffers: shared hit=33,499 read=63,049 dirtied=147
11. 218,973.216 218,973.216 ↑ 1.0 1 301,616

Index Scan using people_pkey on people (cost=0.57..2.04 rows=1 width=4) (actual time=0.726..0.726 rows=1 loops=301,616)

  • Index Cond: (id = applications.person_id)
  • Filter: (import_hash IS NULL)
  • Buffers: shared hit=1,193,165 read=315,088 dirtied=9,006
Planning time : 4.898 ms
Execution time : 532,839.665 ms