explain.depesz.com

PostgreSQL's explain analyze made readable

Result: BjED

Settings
# exclusive inclusive rows x rows loops node
1. 0.004 12,778.524 ↓ 0.0 0 1

Update on boi_rel (cost=0.00..3,138,187.42 rows=97,686 width=105) (actual time=12,778.524..12,778.524 rows=0 loops=1)

2. 12,778.520 12,778.520 ↓ 0.0 0 1

Seq Scan on boi_rel (cost=0.00..3,138,187.42 rows=97,686 width=105) (actual time=12,778.520..12,778.520 rows=0 loops=1)

  • Filter: ((NOT is_deleted) AND ((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[]))))
  • Rows Removed by Filter: 8903006
Planning time : 0.674 ms
Execution time : 12,778.578 ms