explain.depesz.com

PostgreSQL's explain analyze made readable

Result: oWHe

Settings
# exclusive inclusive rows x rows loops node
1. 84.576 349.762 ↓ 145.1 24,518 1

Bitmap Heap Scan on public.vulnerability_occurrences (cost=17,637.81..96,163.84 rows=169 width=51) (actual time=277.416..349.762 rows=24,518 loops=1)

  • Filter: (length(vulnerability_occurrences.location_fingerprint) = 40)
  • Rows Removed by Filter: 24,621
  • Buffers: shared hit=44,993
2. 14.910 265.186 ↓ 0.0 0 1

BitmapAnd (cost=17,637.81..17,637.81 rows=33,774 width=0) (actual time=265.186..265.186 rows=0 loops=1)

  • Buffers: shared hit=9,807
3. 131.574 131.574 ↓ 1.2 429,414 1

Bitmap Index Scan using idx_container_scanning_findings (cost=0.00..7,480.38 rows=359,045 width=0) (actual time=131.574..131.574 rows=429,414 loops=1)

  • Index Cond: ((vulnerability_occurrences.id >= 231,411) AND (vulnerability_occurrences.id <= 2,312,411))
  • Buffers: shared hit=3,288
4. 118.702 118.702 ↓ 1.1 446,612 1

Bitmap Index Scan using index_vulnerability_occurrences_on_unique_keys (cost=0.00..10,157.10 rows=421,330 width=0) (actual time=118.702..118.702 rows=446,612 loops=1)

  • Index Cond: (vulnerability_occurrences.project_id = ANY ('{2274018,3601513,3870115,4046696,4456656,5715024,5868249,6102100,6130122,6457868,6535935,6871339,7071551,7277861,7431213,7508482,7688358,7902245,7924221,8036028,8488826,8527777,8551697,8585075,8610329,8868593,8886640,9358979,9450192,9450195,9450197,9614193,9651559,9739033,9762266,9792253,10004723,10300671,10309187,10649622,10796396,10960429,11027085,11099514,11099521,11099524,11099539,11159498,11278726,11396738,11432834,11801229,11924841,12058473,12157034,12258016,12390221,12465475,12511246,12775029,12822119,12829984,12922853,13028657,13036657,13109960,13123287,13192485,13234622,13241824,13278778,13357162,13455976,13487474,13586946,13640563,13722782,13894353,13933781,13974213,13991164,14048317,14145814,14218494,14219659,14240500,14260724,14260748,14260749,14260754,14263452,14481239,14490310,14500273,14574472,14597475,14611203,14648219,14669775,14707669,14785263,14817843,14841940,14860336,14895370,14910589,14951449,15003116,15093443,15111527,15128509,15166220,15166224,15184411,15213733,15228132,15229548,15305525,15310444,15312352,15371142,15372463,15375150,15414698,15518695,15532238,15580167,15633349,15815639,15912216,15915125,15961025,15965072,15968232,16335055,16411230,16428811,16458767,16489106,16489328,16489530,16505542,16591642,16602774,16609234,16631860,16673880,16676423,16769504,16775571,16874356,16893933,16921126,16971900,16978875,17119656,17129648,17275553,17306445,17335051,17371743,17403098,17570533,17592433,17693758,17921195,17927056,18006606,18125267,18129703,18149499,18151032,18159196,18160395,18237288,18237292,18259236,18299346,18359633,18391388,18396790,18448582,18449857,18464659,18466096,18540007,18574986,18669457,18720941,18754736,18796106,18889330,18891040,18978351,18978714,19120295,19142110,19369633,19387712,19399705,19466852,19498114,19559683,19581535,19597023,19698897,19708855,19759749,19767311,19797474,19811514,19840105,19906394,19973386,19977032,20022887,20074447,20099473,20110131,20161308,20218645,20241253,20283063,20283103,20283303,20317580,20327880,20371459,20384556,20409362,20503186,20544594,20580006,20581867,20601386,20640706,20715843,20723724,20730673,20770289}'::integer[]))
  • Buffers: shared hit=6,519