explain.depesz.com

PostgreSQL's explain analyze made readable

Result: epxZ

Settings
# exclusive inclusive rows x rows loops node
1. 13.278 70.793 ↑ 1.1 1,786 1

Hash Join (cost=5,711.00..10,463.79 rows=1,998 width=36) (actual time=56.406..70.793 rows=1,786 loops=1)

  • Hash Cond: (fdt_pair_flights.flight_id = flight.id)
2. 1.388 1.388 ↑ 1.1 1,786 1

Index Scan using fdt_pair_flights_pair_id_769f2633 on fdt_pair_flights (cost=0.42..3,606.74 rows=1,998 width=8) (actual time=0.007..1.388 rows=1,786 loops=1)

  • Index Cond: (pair_id = ANY ('{198711,198716,198718,198719,198720,198722,198724,198725,198733,198737,198738,198739,198740,198744,198745,198751,198752,198753,198754,198755,198756,198757,198758,198759,198760,198761,198762,198763,198764,198765,198766,198767,198769,198770,198771,198772,198773,198774,198775,198776,198777,198778,198779,198781,198782,198783,198784,198785,198786,198787,198788,198789,198790,198791,198794,198795,198796,198797,198799,198800,198801,198802,198803,198804,198805,198806,198807,198808,198809,198810,198811,198812,198813,198814,198815,198816,198817,198818,198819,198820,198821,198822,198823,198824,198825,198826,198827,198828,198829,198830,198831,198832,198833,198834,198835,198836,198837,198839,198840,198841,198842,198843,198844,198845,198847,198848,198849,198850,198851,198852,198853,198854,198855,198856,198857,198858,198859,198860,198861,198862,198863,198864,198865,198866,198867,198868,198869,198870,198872,198873,198874,198876,198877,198878,198879,198880,198881,198882,198883,198884,198885,198886,198887,198888,198890,198891,198892,198893,198894,198895,198896,198897,198898,198899,198900,198901,198902,198903,198904,198905,198906,198907,198908,198909,198910,198911,198912,198913,198914,198915,198916,198917,198918,198919,198921,198922,198923,198924,198925,198926,198927,198928,198930,198932,198933,198934,198935,198936,198937,198938,198939,198940,198941,198942,198943,198944,198946,198947,198949,198950,198951,198952,198953,198956,198959,198961,198962,198963,198964,198965,198966,198967,198968,198969,198970,198971,198972,198974,198975,198976,198977,198978,198979,198980,198981,198982,198983,198984,198985,198986,198987,198988,198989,198990,198993,198994,198995,198996,198997,198998,198999,199000,199003,199004,199005,199006,199007,199009,199011,199013,199014,199015,199016,199017,199018,199019,199020,199021,199022,199023,199024,199025,199026,199027,199028,199029,199030,199031,199032,199033,199034,199035,199036,199037,199038,199039,199040,199041,199043,199044,199045,199047,199048,199049,199050,199051,199052,199053,199054,199055,199056,199057,199058,199059,199060,199061,199062,199063,199064,199066,199069,199070,199071,199072,199073,199074,199075,199077,199078,199079,199080,199081,199082,199083,199084,199085,199087,199088,199089,199090,199091,199092,199093,199094,199096,199097,199098,199099,199100,199101,199102,199103,199105,199106,199107,199109,199110,199111,199114,199115,199116,199117,199118,199119,199120,199121,199122,199123,199124,199125,199127,199128,199130,199131,199132,199133,199134,199135,199136,199138,199139,199140,199141,199142,199143,199144,199145,199146,199147,199148,199149,199151,199152,199153,199154,199155,199156,199158,199159,199161,199165,199166,199167,199168,199169,199170,199171,199172,199173,199174,199175,199176,199177,199178,199179,199180,199181,199182,199183,199184,199185,199187,199189,199191,199192,199193,199194,199195,199196,199197,199198,199199,199200,199201,199202,199203,199204,199205,199206,199207,199208,199209,199211,199212,199215,199217,199218,199219,199220,199223,199225,199226,199227,199228,199229,199231,199232,199233,199234,199235,199237,199238,199239,199240,199241,199242,199243,199244,199245,199246,199247,199248,199249,199252,199253,199254,199255,199256,199257,199258,199259,199260,199261,199262,199263,199264,199265,199266,199267,199268,199269,199270,199271,199272,199273,199274,199275,199276,199277,199278,199279,199280,199281,199282,199283,199284,199285,199286,199287,199288,199289,199290,199293,199294,199295,199296,199298,199299,199300,199301,199302,199303,199304,199306,199307,199308,199310,199311,199312,199313,199314,199315,199316,199317,199318,199319,199320,199321,199322,199323,199324,199325,199326,199327,199328,199329,199330,199331,199332,199333,199334,199335,199336,199337,199339,199340,199341,199342,199343,199344,199346,199347,199349,199350,199351,199352,199353,199354,199355,199356,199357,199358,199359,199360,199361,199362,199363,199364,199365,199366,199367,199368,199370,199371,199372,199373,199374,199375,199376,199377,199378,199380,199381,199382,199383,199384,199385,199386,199387,199388,199390,199391,199392,199394,199395,199396,199397,199398,199399,199400,199401,199402,199403,199404,199405,199406,199407,199408,199409,199411,199412,199413,199414,199415,199416,199417}'::integer[]))
3. 26.982 56.127 ↑ 1.0 94,070 1

Hash (cost=3,431.70..3,431.70 rows=94,070 width=72) (actual time=56.127..56.127 rows=94,070 loops=1)

  • Buckets: 65536 Batches: 4 Memory Usage: 2522kB
4. 29.145 29.145 ↑ 1.0 94,070 1

Seq Scan on flight (cost=0.00..3,431.70 rows=94,070 width=72) (actual time=0.027..29.145 rows=94,070 loops=1)

Planning time : 2.322 ms
Execution time : 70.954 ms