explain.depesz.com

PostgreSQL's explain analyze made readable

Result: mEAV

Settings
# exclusive inclusive rows x rows loops node
1. 0.000 0.228 ↓ 0.0 0 1

Update on boi_rel (cost=2,973.37..1,856,086.07 rows=94,737 width=105) (actual time=0.228..0.228 rows=0 loops=1)

2. 0.002 0.228 ↓ 0.0 0 1

Bitmap Heap Scan on boi_rel (cost=2,973.37..1,856,086.07 rows=94,737 width=105) (actual time=0.228..0.228 rows=0 loops=1)

  • Recheck Cond: ((from_bo_instance_id = ANY ('{8610022,8610021,8610020,8610019,8610018,8610017,8610016,8610015,8610014,8610013,8610012,8610011,8610010,8610009,8610008,8610007,8610006,8610005,8610004,8610003,8610002,8610001,8610000,8609999,8609998,8609997,8609996,8609995,8609994,8609993,8609992,8609991,8609990,8609989,8609988,8609987,8609986,8609985,8609984,8609983,8609982,8609981,8609980,8609979,8609978,8609977,8609976,8609975,8609974,8609973,8609972,8609971,8609970,8609969,8609968,8609967,8609966,8609965,8609964,8609963,8609962,8609961,8609960,8609959,8609958,8609957,8609956,8609955,8609954,8609953,8609952,8609951,8609950,8609949,8609948,8609947,8609946,8609945,8609944,8609943,8609942,8609941,8609940,8609939,8609938,8609937,8609936,8609935,8609934,8609933,8609932,8609931,8609930,8609929,8609928,8609927,8609926,8609925,8609924,8609923,8609922,8609921,8609920,8609919,8609918,8609917,8609916,8609915,8609914,8609913,8609912,8609911,8609910,8609909,8609908,8609907,8609906,8609905,8609904,8609903,8609902,8609901,8609900,8609899,8609898,8609897,8609896,8609895,8609894,8609893}'::bigint[])) OR (to_bo_instance_id = ANY ('{8610022,8610021,8610020,8610019,8610018,8610017,8610016,8610015,8610014,8610013,8610012,8610011,8610010,8610009,8610008,8610007,8610006,8610005,8610004,8610003,8610002,8610001,8610000,8609999,8609998,8609997,8609996,8609995,8609994,8609993,8609992,8609991,8609990,8609989,8609988,8609987,8609986,8609985,8609984,8609983,8609982,8609981,8609980,8609979,8609978,8609977,8609976,8609975,8609974,8609973,8609972,8609971,8609970,8609969,8609968,8609967,8609966,8609965,8609964,8609963,8609962,8609961,8609960,8609959,8609958,8609957,8609956,8609955,8609954,8609953,8609952,8609951,8609950,8609949,8609948,8609947,8609946,8609945,8609944,8609943,8609942,8609941,8609940,8609939,8609938,8609937,8609936,8609935,8609934,8609933,8609932,8609931,8609930,8609929,8609928,8609927,8609926,8609925,8609924,8609923,8609922,8609921,8609920,8609919,8609918,8609917,8609916,8609915,8609914,8609913,8609912,8609911,8609910,8609909,8609908,8609907,8609906,8609905,8609904,8609903,8609902,8609901,8609900,8609899,8609898,8609897,8609896,8609895,8609894,8609893}'::bigint[])))
  • Filter: (NOT is_deleted)
3. 0.000 0.226 ↓ 0.0 0 1

BitmapOr (cost=2,973.37..2,973.37 rows=99,246 width=0) (actual time=0.226..0.226 rows=0 loops=1)

4. 0.116 0.116 ↓ 0.0 0 1

Bitmap Index Scan on boi_rel_from_bo_instance_id_idx1 (cost=0.00..2,339.70 rows=98,009 width=0) (actual time=0.116..0.116 rows=0 loops=1)

  • Index Cond: (from_bo_instance_id = ANY ('{8610022,8610021,8610020,8610019,8610018,8610017,8610016,8610015,8610014,8610013,8610012,8610011,8610010,8610009,8610008,8610007,8610006,8610005,8610004,8610003,8610002,8610001,8610000,8609999,8609998,8609997,8609996,8609995,8609994,8609993,8609992,8609991,8609990,8609989,8609988,8609987,8609986,8609985,8609984,8609983,8609982,8609981,8609980,8609979,8609978,8609977,8609976,8609975,8609974,8609973,8609972,8609971,8609970,8609969,8609968,8609967,8609966,8609965,8609964,8609963,8609962,8609961,8609960,8609959,8609958,8609957,8609956,8609955,8609954,8609953,8609952,8609951,8609950,8609949,8609948,8609947,8609946,8609945,8609944,8609943,8609942,8609941,8609940,8609939,8609938,8609937,8609936,8609935,8609934,8609933,8609932,8609931,8609930,8609929,8609928,8609927,8609926,8609925,8609924,8609923,8609922,8609921,8609920,8609919,8609918,8609917,8609916,8609915,8609914,8609913,8609912,8609911,8609910,8609909,8609908,8609907,8609906,8609905,8609904,8609903,8609902,8609901,8609900,8609899,8609898,8609897,8609896,8609895,8609894,8609893}'::bigint[]))
5. 0.110 0.110 ↓ 0.0 0 1

Bitmap Index Scan on boi_rel_to_bo_instance_id_idx1 (cost=0.00..586.30 rows=1,236 width=0) (actual time=0.110..0.110 rows=0 loops=1)

  • Index Cond: (to_bo_instance_id = ANY ('{8610022,8610021,8610020,8610019,8610018,8610017,8610016,8610015,8610014,8610013,8610012,8610011,8610010,8610009,8610008,8610007,8610006,8610005,8610004,8610003,8610002,8610001,8610000,8609999,8609998,8609997,8609996,8609995,8609994,8609993,8609992,8609991,8609990,8609989,8609988,8609987,8609986,8609985,8609984,8609983,8609982,8609981,8609980,8609979,8609978,8609977,8609976,8609975,8609974,8609973,8609972,8609971,8609970,8609969,8609968,8609967,8609966,8609965,8609964,8609963,8609962,8609961,8609960,8609959,8609958,8609957,8609956,8609955,8609954,8609953,8609952,8609951,8609950,8609949,8609948,8609947,8609946,8609945,8609944,8609943,8609942,8609941,8609940,8609939,8609938,8609937,8609936,8609935,8609934,8609933,8609932,8609931,8609930,8609929,8609928,8609927,8609926,8609925,8609924,8609923,8609922,8609921,8609920,8609919,8609918,8609917,8609916,8609915,8609914,8609913,8609912,8609911,8609910,8609909,8609908,8609907,8609906,8609905,8609904,8609903,8609902,8609901,8609900,8609899,8609898,8609897,8609896,8609895,8609894,8609893}'::bigint[]))
Planning time : 0.454 ms
Execution time : 0.303 ms