explain.depesz.com

PostgreSQL's explain analyze made readable

Result: UW9z

Settings
# exclusive inclusive rows x rows loops node
1. 0.043 67,942.669 ↓ 0.0 0 1

Sort (cost=27,820,366.20..27,958,900.68 rows=55,413,793 width=51) (actual time=67,942.669..67,942.669 rows=0 loops=1)

  • Sort Key: index, id
  • Sort Method: quicksort Memory: 25kB
2. 67,942.626 67,942.626 ↓ 0.0 0 1

Seq Scan on search_passengerfareproductsectionmodel (cost=0.00..15,011,030.19 rows=55,413,793 width=51) (actual time=67,942.626..67,942.626 rows=0 loops=1)

  • Filter: (passenger_fare_product_segment_id = ANY ('{1117983744,1117983745,1117983746,1117983747,1117983748,1117983749,1117983750,1117983751,1117983752,1117983753,1117983754,1117983755,1117983756,1117983757,1117983758,1117983759,1117983760,1117983761,1117983762,1117983763,1117983764,1117983765,1117983766,1117983767,1117983768,1117983769,1117983770,1117983771,1117983772,1117983773,1117983774,1117983775,1117983776,1117983777,1117983778,1117983779,1117983780,1117983781,1117983782,1117983783,1117983784,1117983785,1117983786,1117983787,1117983788,1117983789,1117983790,1117983791,1117983792,1117983793,1117983794,1117983795,1117983796,1117983797,1117983798,1117983799,1117983800,1117983801,1117983802,1117983803,1117983804,1117983805,1117983806,1117983807,1117983808,1117983809,1117983810,1117983811,1117983812,1117983813,1117983814,1117983815,1117983816,1117983817,1117983818,1117983819,1117983820,1117983821,1117983822,1117983823,1117983824,1117983825,1117983826,1117983827,1117983828,1117983829,1117983830,1117983831,1117983832,1117983833,1117983834,1117983835,1117983836,1117983837,1117983838,1117983839,1117983840,1117983841,1117983842,1117983843,1117983844,1117983845,1117983846,1117983847,1117983652,1117983653,1117983654,1117983655,1117983656,1117983657,1117983658,1117983659,1117983660,1117983661,1117983662,1117983663,1117983664,1117983665,1117983666,1117983667,1117983668,1117983669,1117983670,1117983671,1117983672,1117983673,1117983674,1117983675,1117983676,1117983677,1117983678,1117983679,1117983680,1117983681,1117983682,1117983683,1117983684,1117983685,1117983686,1117983687,1117983688,1117983689,1117983690,1117983691,1117983692,1117983693,1117983694,1117983695,1117983696,1117983697,1117983698,1117983699,1117983700,1117983701,1117983702,1117983703,1117983704,1117983705,1117983706,1117983707,1117983708,1117983709,1117983710,1117983711,1117983712,1117983713,1117983714,1117983715,1117983716,1117983717,1117983718,1117983719,1117983720,1117983721,1117983722,1117983723,1117983724,1117983725,1117983726,1117983727,1117983728,1117983729,1117983730,1117983731,1117983732,1117983733,1117983734,1117983735,1117983736,1117983737,1117983738,1117983739,1117983740,1117983741,1117983742,1117983743}'::bigint[]))
  • Rows Removed by Filter: 56124616