explain.depesz.com

PostgreSQL's explain analyze made readable

Result: QNIq

Settings
# exclusive inclusive rows x rows loops node
1. 0.014 191,893.023 ↑ 716.2 4 1

GroupAggregate (cost=19,534,251.63..19,534,301.76 rows=2,865 width=12) (actual time=191,893.014..191,893.023 rows=4 loops=1)

  • Group Key: applications.hiring_plan_id
  • Buffers: shared hit=432411 read=6295361
2. 0.030 191,893.009 ↑ 119.4 24 1

Sort (cost=19,534,251.63..19,534,258.79 rows=2,865 width=4) (actual time=191,893.004..191,893.009 rows=24 loops=1)

  • Sort Key: applications.hiring_plan_id
  • Sort Method: quicksort Memory: 26kB
  • Buffers: shared hit=432411 read=6295361
3. 180.392 191,892.979 ↑ 119.4 24 1

Hash Join (cost=18,884,540.82..19,534,087.11 rows=2,865 width=4) (actual time=183,395.264..191,892.979 rows=24 loops=1)

  • Hash Cond: (applications.id = application_stages.application_id)
  • Buffers: shared hit=432411 read=6295361
4. 29,436.993 29,436.993 ↑ 2.6 295,743 1

Index Scan using index_applications_on_hiring_plan_id on applications (cost=0.57..647,476.49 rows=776,571 width=8) (actual time=0.537..29,436.993 rows=295,743 loops=1)

  • Index Cond: (hiring_plan_id = ANY ('{1057260,1131449,1125505,1101767,1006658,996592,1046465,1100542,1074249,1069338,1036872,800447,871468,967011,1137120,1112635,919299,990775,990741,1131305,1098436,1125524,1079148,1136299,1086125,1139285,1133969,1050957,1139349,1121457,1127154,1051891,1051896,1134644,1120457,1112950,1115465,1136322,1090558,1120481,1085084,1130930,1130961,1114079,1095061,1136568,1130980,1115559,1136236,1131316,1024176,1077818,1121340,1106744,1106471,1125550,1095949,1120093,1136265,1134030,1134021,1130509,1093389,1130397,1130392,1127181,1088199,1130691,1137441,1139358,1053379,1099518,1052027,1125383,1106496,1130236,1124402,1126305,1057246,1080235,1083861,1026926,1092653,1050887,1099436,1093358,1110278,1062088,1115429,1125135,1085380,1021834,1115009,1137364,1137389,1099452,1130950,1114885,1093418,1110945,1042620,1089272,1096067,1100615,1008073,923020,883018,1134629,1086009,1084972,1047171,1132523,1130031,1127483,500390,1093571,629133,921506,991482,47616,967284,1137204,1139864,1121407,1117386,1125541,1090515,1092691,1058779,1113214,1057050,1107328,1140140,1083537,1106152,1119271,1137423,1070355,1025541,1137203,1088120,1033526,958204,1050765,1122031,1111772,1124028,964565,1109762,1049689,1140420,987003,1081616,1070372,1134744,1111739,1077483,985591,998608,1059718,1139277,1123936,1105352,1136336,942527,1089397,1136284,1080368,1072812,1084827,1084823,976294,1106256,1115506,1124318,1137197,1115510,1137080,1137083,1081951,1115725,1128986,1139516,1139542,1139534,1139550,1117067,1113038,1091879,1137555,1108803,1105106,1106269,1105080,1105107,1129022,1129333,1126569,889020,888963,888971,996625,1125326,1026742,1093671,838836,980416,1123689,1135984,1101689,1115467,888893,827810,938198,1091806,1091820,1091786,1088282,1114208,1082510,913710,1139541,1114388,1128869,899487,1133176,889098,910419,1047217,462148,914728,911324,764713,764735,914700,912443,910382,955290,952710,985566,756738,127438,309931,901259,1090605,1117723,1127472,845049,1115629,706921,867875,695752,1047222,920204,901278,901263,1099382,1110667,921124,1111623,931865,1138394,1127535,1138362,1138334,1114236,1129976,1128922,959738,1123781,1115509,991432,1086067,611484,991449,1052214,884111,732359,1120376,991421,507873,729593,850532,1059693,618773,755338,1024421,1082766,1069238,1029873,1120190,1070412,164459,1092689,1104197,933520,1107436,1139308,1107716,1097120,1115600,1096243,1023114,844044,1125134,1101676,1078006,55847,955320,586807,579343,453598,546253,453413,1119038,47808,1128961,1044046,1020692,927694,524703,1086970,991403,1061992,584583,1132480,1062207,1140434,1123882,1091857,1131420,1056192,1015852,1135962,921163,1108846,1118116,1101740,1099659,1032621,1102834,1082467,1129989,1122723,1126491,1101770,1115477,1017010,820908,1096111,1049938,1049645,1103817,1110706,1140370,1127651,1119279,1100578,1030954,1090488,1140214,1063333,1091653,1107555,904788,1137819,1118875,1124237,1106402,1100549,991474,47611,958007,1108951,1137431,1113258,947535,1128736,222534,1013794,1107858,996544,1093955,1071862,1063400,990631,1090802,1054828,1137251,1011049,1132522,997793,962351,1111349,1111376,1122891,1032565,1133667,1036158,1116700,1135104,1102852,1137225,1136285,1096939,1026136,1069613,1124222,1135162,1132592,1038760,1140401,1094800,1041318,1116781,1069306,1069365,1125523,1115072,1061993,1091133,966073,1109337,1078218,1004176,1113455,1137138,962355,1008147,1049617,1089434,82956,1132478,972178,1133763,779605,1105017,976467,1091657,1023186,1132669,1132683,1120999,1014579,1077630,824767,460711,1077554,1106324,959622,1131407,1108793,1084982,1121631,1091662,1066925,1115519,1112470,1113386,1065251,1124667,1124706,1131218,1122881,1113259,1126652,1100579,938165,966935,1134939,1133860,715688,1108521,1120089,1120982,1140443,1046799,453006,1043514,1004335,1108904,1004165,1082550,1043568,1046811,1133586,1097210,1094858,1117836,1086201,541456,1114399,1114393,1127555,960790,1027025,507915,1018487,931349,640098,1122743,1087917,1026975,1121357,1114530,1068342,1031185,1001435,1070448,1102929,1108601,815465,1039140,1036224,960721,923042,1115460,1067983,1135042,1128740,1049937,1083847,1079184,1082837,1097516,1133460,1115498,1090471,1117401,1095945,1114237,1103852,1094990,1058624,1107548,1086840,887938,1083787,1100429,1090404,57099,829105,835958,1134838,1109739,1125144,1077846,1113437,868011,1130105,1128969,1082671,1091865,1136307,1110692,1115571,1095973,1065690,1121408,1111955,823162,1136115,1137614,1119763,1139325,1062518,1112274,1083879,960842,1138232,1031591,1137103,1108707,1135931,1119379,1014681,921477,1131841,1086281,1102827,1083741,1091730,995237,1085932,1028363,992589,1099584,1065596,1083688,981826,696515,1002910,1017025,542547,892339,268263,906929,719187,532780,506235,530621,603435,490016,1109234,976355,47065,859679,855859,1128688,1122656,1134699,984385,1071813,1000250,1138220,1097097,1095032,1108526,1134853,1112158,1110154,1135059,1131562,1126409,1097011,1093797,1090464,815544,785340,1108708,982377,1112084,781778,996692,735354,866717,1075398,1064504,1140200,345814,1091687,1089674,1135179,1064571,162799,1132474,1110779,291216,1066418,791021,802670,291705,1129987,1009546,1121355,1069596,1106391,1107556,1120372,1065915,1090544,1135958,433868,1108584,1080542,1095978,1109458,1133635,1130180,1139294,947439,1128695,1106930,1138456,903698,1106419,1086275,1071534,938226,1106233,1017036,1049752,938085,864439,1031162,1123907,1096244,982980,250299,1014571,1109355,1072792,47342,991415,1110199,1066913,1128912,1099439,1129988,1125131,1125311,1065693,1131311}'::integer[]))
  • Filter: (stage_status_id = ANY ('{2,1,6}'::integer[]))
  • Buffers: shared hit=203003 read=83884
5. 544.150 162,275.594 ↓ 3.2 1,457,292 1

Hash (cost=18,878,907.48..18,878,907.48 rows=450,622 width=4) (actual time=162,275.594..162,275.594 rows=1,457,292 loops=1)

  • Buckets: 2097152 (originally 524288) Batches: 1 (originally 1) Memory Usage: 67617kB
  • Buffers: shared hit=229408 read=6211477
6. 1,693.318 161,731.444 ↓ 3.2 1,457,292 1

HashAggregate (cost=18,874,401.26..18,878,907.48 rows=450,622 width=4) (actual time=161,147.385..161,731.444 rows=1,457,292 loops=1)

  • Group Key: application_stages.application_id
  • Buffers: shared hit=229408 read=6211477
7. 24,143.505 160,038.126 ↓ 3.2 1,458,231 1

Hash Join (cost=206,525.58..18,873,274.71 rows=450,622 width=4) (actual time=2,107.910..160,038.126 rows=1,458,231 loops=1)

  • Hash Cond: (application_stages.hiring_plan_interview_stage_id = hiring_plan_interview_stages.id)
  • Buffers: shared hit=229408 read=6211477
8. 133,787.960 133,787.960 ↓ 5.7 74,022,927 1

Seq Scan on application_stages (cost=0.00..18,632,471.48 rows=13,058,146 width=8) (actual time=0.685..133,787.960 rows=74,022,927 loops=1)

  • Filter: ((entered_date IS NOT NULL) AND (entered_date >= '2017-12-31 23:00:00'::timestamp without time zone) AND (entered_date <= '2019-12-31 22:59:59'::timestamp without time zone))
  • Rows Removed by Filter: 745679385
  • Buffers: shared hit=208288 read=6133868
9. 118.126 2,106.661 ↑ 1.0 283,613 1

Hash (cost=202,929.73..202,929.73 rows=287,668 width=4) (actual time=2,106.661..2,106.661 rows=283,613 loops=1)

  • Buckets: 524288 Batches: 1 Memory Usage: 14067kB
  • Buffers: shared hit=21120 read=77609
10. 1,988.535 1,988.535 ↑ 1.0 283,613 1

Seq Scan on hiring_plan_interview_stages (cost=0.00..202,929.73 rows=287,668 width=4) (actual time=0.379..1,988.535 rows=283,613 loops=1)

  • Filter: (active AND (name = 'Preliminary Phone Screen'::text))
  • Rows Removed by Filter: 8057291
  • Buffers: shared hit=21120 read=77609
Planning time : 1.894 ms
Execution time : 191,905.837 ms