explain.depesz.com

PostgreSQL's explain analyze made readable

Result: b2fh

Settings
# exclusive inclusive rows x rows loops node
1. 3.770 684.741 ↑ 13.1 192 1

Gather (cost=38,068.56..205,008.27 rows=2,515 width=86) (actual time=102.995..684.741 rows=192 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
2. 659.094 680.971 ↑ 16.4 64 3 / 3

Parallel Bitmap Heap Scan on "Payments" "Payment" (cost=37,068.56..203,756.77 rows=1,048 width=86) (actual time=100.518..680.971 rows=64 loops=3)

  • Filter: ((NOT "isDeleted") AND (category = 0) AND ("employerId" = ANY ('{126369,126370,43527,126382,126381,126393,126390,126375,126391,126394,43553,126406,126405,126379,126430,10159,126410,126418,126411,126424,126415,126425,126426,126421,126427,126455,126454,126453,126457,126460,126459,126452,126462,126461,126493,126473,126466,126468,126475,709404,126470,126494,126480,126486,126469,126510,126495,126499,126500,126496,126497,126503,126507,126501,126506,126505,126518,126555,126530,126569,1401428,126523,126532,126560,126556,126543,126531,126541,43943,126536,126538,126558,126539,126550,126551,126561,126565,126568,126570,126572,126574,44018,126575,126577,126578,126579,126585,126606,126588,126609,142281,126598,126589,126582,126581,126583,126590,126586,126594,126593,126602,126612,126608,126615,126623,126616,126624,126622,126601,126628,44147,126643,126670,126633,126634,126635,126637,126639,126648,126651,126638,126671,126641,126657,126656,126659,126658,19329,126667,126666,126672,126660,126676,44254,126689,126675,126678,126688,126690,126691,126696,126679,126681,126686,91826,126712,126699,126724,126709,126704,126718,126717,126730,126743,126735,126738,126752,126753,126750,126751,126772,126766,126764,98523,126769,126777,126780,126795,126784,126818,126789,126797,126805,126787,126819,126785,126809,126791,126793,126794,126801,126812,126810,126824,126822,126827,126861,126829,126830,126831,126856,126858,126833,126850,126834,126863,126869,126867,44690,126878,126892,126877,126908,126890,126895,126885,126893,126894,126896,126907,126912,136730,126901,126910,126900,126909,126904,126915,126913,44813,126957,126949,126945,126929,126940,126932,126960,126947,126924,126942,126950,126946,126964,126959,126979,126972,126978,126974,126975,126977,126984,126973,126986,44953,126989,126997,127009,127012,126995,105969,127000,127011,127017,127018}'::bigint[])))
  • Rows Removed by Filter: 340,377
  • Heap Blocks: exact=9,291
3. 21.877 21.877 ↓ 1.1 1,064,257 1 / 3

Bitmap Index Scan on payments_is_deleted_employee_id_payment_date (cost=0.00..37,067.93 rows=998,867 width=0) (actual time=65.631..65.631 rows=1,064,257 loops=1)

  • Index Cond: ("isDeleted" = false)
Planning time : 0.637 ms
Execution time : 684.788 ms