explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 5dlF

Settings
# exclusive inclusive rows x rows loops node
1. 238.269 55,834.544 ↑ 656,452.8 105 1

Gather (cost=2,855,302.85..19,330,051.49 rows=68,927,546 width=537) (actual time=55,629.934..55,834.544 rows=105 loops=1)

  • Workers Planned: 5
  • Workers Launched: 5
2. 2.717 55,596.275 ↑ 765,861.6 18 6 / 6

Hash Left Join (cost=2,854,302.85..12,436,296.89 rows=13,785,509 width=537) (actual time=55,588.666..55,596.275 rows=18 loops=6)

  • Hash Cond: ((widget_part_hash_5.id)::text = (gp.widget_id)::text)
3. 5.528 54,175.816 ↑ 761.9 18 6 / 6

Merge Left Join (cost=1,856,224.38..1,857,252.91 rows=13,714 width=225) (actual time=54,168.826..54,175.816 rows=18 loops=6)

  • Merge Cond: ((widget_part_hash_5.id)::text = (ep.widget_id)::text)
  • Filter: (COALESCE((ep.ts_clicks)::integer, 0) > 50)
  • Rows Removed by Filter: 4292
4. 14.286 223.139 ↑ 9.5 4,309 6 / 6

Sort (cost=551,960.06..552,062.91 rows=41,141 width=164) (actual time=222.001..223.139 rows=4,309 loops=6)

  • Sort Key: widget_part_hash_5.id
  • Sort Method: quicksort Memory: 1333kB
  • Worker 0: Sort Method: quicksort Memory: 1351kB
  • Worker 1: Sort Method: quicksort Memory: 1310kB
  • Worker 2: Sort Method: quicksort Memory: 1430kB
  • Worker 3: Sort Method: quicksort Memory: 1155kB
  • Worker 4: Sort Method: quicksort Memory: 1348kB
5. 0.504 208.853 ↑ 9.5 4,309 6 / 6

Parallel Append (cost=593.07..548,806.95 rows=41,141 width=164) (actual time=44.384..208.853 rows=4,309 loops=6)

6. 196.728 204.465 ↑ 1.8 4,309 6 / 6

Parallel Bitmap Heap Scan on widget_part_hash_5 (cost=908.60..45,595.66 rows=7,618 width=163) (actual time=40.496..204.465 rows=4,309 loops=6)

  • Recheck Cond: ((campaign_id)::text = ANY ('{da3da707479185cb64d94bb4e6ecf490,d1dcb3b5ffe112e555fbdaa0b79241a8,c120838d777795ab2a47ac99a52f5b92,eb1d203d78a4f69282704c8ffbd97ea9,c7c0fd20e8d5ede3e300e28f3382c274,cb97a87ff64196b87179f7005cd758e2,c33001f76ffc53ad31c0f36990ff5f57,35de04d0d083965adb1e8f25e4c68077,7700a5048a845a67b4344611589b320e,ac1ade63dbf740f15e3ec8c4574f1822}'::text[]))
  • Heap Blocks: exact=1130
7. 7.737 7.737 ↓ 1.3 30,059 1 / 6

Bitmap Index Scan on widget_part_hash_5_campaign_id_idx (cost=0.00..902.70 rows=23,615 width=0) (actual time=46.424..46.424 rows=30,059 loops=1)

  • Index Cond: ((campaign_id)::text = ANY ('{da3da707479185cb64d94bb4e6ecf490,d1dcb3b5ffe112e555fbdaa0b79241a8,c120838d777795ab2a47ac99a52f5b92,eb1d203d78a4f69282704c8ffbd97ea9,c7c0fd20e8d5ede3e300e28f3382c274,cb97a87ff64196b87179f7005cd758e2,c33001f76ffc53ad31c0f36990ff5f57,35de04d0d083965adb1e8f25e4c68077,7700a5048a845a67b4344611589b320e,ac1ade63dbf740f15e3ec8c4574f1822}'::text[]))
8. 0.001 0.256 ↓ 0.0 0 1 / 6

Parallel Bitmap Heap Scan on widget_part_hash_10 (cost=759.95..55,417.31 rows=6,425 width=154) (actual time=1.533..1.533 rows=0 loops=1)

  • Recheck Cond: ((campaign_id)::text = ANY ('{da3da707479185cb64d94bb4e6ecf490,d1dcb3b5ffe112e555fbdaa0b79241a8,c120838d777795ab2a47ac99a52f5b92,eb1d203d78a4f69282704c8ffbd97ea9,c7c0fd20e8d5ede3e300e28f3382c274,cb97a87ff64196b87179f7005cd758e2,c33001f76ffc53ad31c0f36990ff5f57,35de04d0d083965adb1e8f25e4c68077,7700a5048a845a67b4344611589b320e,ac1ade63dbf740f15e3ec8c4574f1822}'::text[]))
9. 0.254 0.254 ↓ 0.0 0 1 / 6

Bitmap Index Scan on widget_part_hash_10_campaign_id_idx (cost=0.00..754.98 rows=19,917 width=0) (actual time=1.526..1.526 rows=0 loops=1)

  • Index Cond: ((campaign_id)::text = ANY ('{da3da707479185cb64d94bb4e6ecf490,d1dcb3b5ffe112e555fbdaa0b79241a8,c120838d777795ab2a47ac99a52f5b92,eb1d203d78a4f69282704c8ffbd97ea9,c7c0fd20e8d5ede3e300e28f3382c274,cb97a87ff64196b87179f7005cd758e2,c33001f76ffc53ad31c0f36990ff5f57,35de04d0d083965adb1e8f25e4c68077,7700a5048a845a67b4344611589b320e,ac1ade63dbf740f15e3ec8c4574f1822}'::text[]))
10. 0.000 0.152 ↓ 0.0 0 1 / 6

Parallel Bitmap Heap Scan on widget_part_hash_19 (cost=615.39..45,023.70 rows=5,402 width=155) (actual time=0.912..0.912 rows=0 loops=1)

  • Recheck Cond: ((campaign_id)::text = ANY ('{da3da707479185cb64d94bb4e6ecf490,d1dcb3b5ffe112e555fbdaa0b79241a8,c120838d777795ab2a47ac99a52f5b92,eb1d203d78a4f69282704c8ffbd97ea9,c7c0fd20e8d5ede3e300e28f3382c274,cb97a87ff64196b87179f7005cd758e2,c33001f76ffc53ad31c0f36990ff5f57,35de04d0d083965adb1e8f25e4c68077,7700a5048a845a67b4344611589b320e,ac1ade63dbf740f15e3ec8c4574f1822}'::text[]))
11. 0.152 0.152 ↓ 0.0 0 1 / 6

Bitmap Index Scan on widget_part_hash_19_campaign_id_idx (cost=0.00..611.20 rows=16,745 width=0) (actual time=0.910..0.910 rows=0 loops=1)

  • Index Cond: ((campaign_id)::text = ANY ('{da3da707479185cb64d94bb4e6ecf490,d1dcb3b5ffe112e555fbdaa0b79241a8,c120838d777795ab2a47ac99a52f5b92,eb1d203d78a4f69282704c8ffbd97ea9,c7c0fd20e8d5ede3e300e28f3382c274,cb97a87ff64196b87179f7005cd758e2,c33001f76ffc53ad31c0f36990ff5f57,35de04d0d083965adb1e8f25e4c68077,7700a5048a845a67b4344611589b320e,ac1ade63dbf740f15e3ec8c4574f1822}'::text[]))
12. 0.001 0.060 ↓ 0.0 0 1 / 6

Parallel Bitmap Heap Scan on widget_part_hash_14 (cost=611.28..47,087.73 rows=5,232 width=150) (actual time=0.363..0.363 rows=0 loops=1)

  • Recheck Cond: ((campaign_id)::text = ANY ('{da3da707479185cb64d94bb4e6ecf490,d1dcb3b5ffe112e555fbdaa0b79241a8,c120838d777795ab2a47ac99a52f5b92,eb1d203d78a4f69282704c8ffbd97ea9,c7c0fd20e8d5ede3e300e28f3382c274,cb97a87ff64196b87179f7005cd758e2,c33001f76ffc53ad31c0f36990ff5f57,35de04d0d083965adb1e8f25e4c68077,7700a5048a845a67b4344611589b320e,ac1ade63dbf740f15e3ec8c4574f1822}'::text[]))
13. 0.060 0.060 ↓ 0.0 0 1 / 6

Bitmap Index Scan on widget_part_hash_14_campaign_id_idx (cost=0.00..607.23 rows=16,220 width=0) (actual time=0.358..0.358 rows=0 loops=1)

  • Index Cond: ((campaign_id)::text = ANY ('{da3da707479185cb64d94bb4e6ecf490,d1dcb3b5ffe112e555fbdaa0b79241a8,c120838d777795ab2a47ac99a52f5b92,eb1d203d78a4f69282704c8ffbd97ea9,c7c0fd20e8d5ede3e300e28f3382c274,cb97a87ff64196b87179f7005cd758e2,c33001f76ffc53ad31c0f36990ff5f57,35de04d0d083965adb1e8f25e4c68077,7700a5048a845a67b4344611589b320e,ac1ade63dbf740f15e3ec8c4574f1822}'::text[]))
14. 0.000 0.212 ↓ 0.0 0 1 / 6

Parallel Bitmap Heap Scan on widget_part_hash_0 (cost=593.07..39,862.36 rows=4,476 width=160) (actual time=1.275..1.275 rows=0 loops=1)

  • Recheck Cond: ((campaign_id)::text = ANY ('{da3da707479185cb64d94bb4e6ecf490,d1dcb3b5ffe112e555fbdaa0b79241a8,c120838d777795ab2a47ac99a52f5b92,eb1d203d78a4f69282704c8ffbd97ea9,c7c0fd20e8d5ede3e300e28f3382c274,cb97a87ff64196b87179f7005cd758e2,c33001f76ffc53ad31c0f36990ff5f57,35de04d0d083965adb1e8f25e4c68077,7700a5048a845a67b4344611589b320e,ac1ade63dbf740f15e3ec8c4574f1822}'::text[]))
15. 0.212 0.212 ↓ 0.0 0 1 / 6

Bitmap Index Scan on widget_part_hash_0_campaign_id_idx (cost=0.00..589.60 rows=13,875 width=0) (actual time=1.273..1.273 rows=0 loops=1)

  • Index Cond: ((campaign_id)::text = ANY ('{da3da707479185cb64d94bb4e6ecf490,d1dcb3b5ffe112e555fbdaa0b79241a8,c120838d777795ab2a47ac99a52f5b92,eb1d203d78a4f69282704c8ffbd97ea9,c7c0fd20e8d5ede3e300e28f3382c274,cb97a87ff64196b87179f7005cd758e2,c33001f76ffc53ad31c0f36990ff5f57,35de04d0d083965adb1e8f25e4c68077,7700a5048a845a67b4344611589b320e,ac1ade63dbf740f15e3ec8c4574f1822}'::text[]))
16. 0.001 0.197 ↓ 0.0 0 1 / 6

Parallel Bitmap Heap Scan on widget_part_hash_9 (cost=547.41..38,785.90 rows=4,238 width=155) (actual time=1.179..1.179 rows=0 loops=1)

  • Recheck Cond: ((campaign_id)::text = ANY ('{da3da707479185cb64d94bb4e6ecf490,d1dcb3b5ffe112e555fbdaa0b79241a8,c120838d777795ab2a47ac99a52f5b92,eb1d203d78a4f69282704c8ffbd97ea9,c7c0fd20e8d5ede3e300e28f3382c274,cb97a87ff64196b87179f7005cd758e2,c33001f76ffc53ad31c0f36990ff5f57,35de04d0d083965adb1e8f25e4c68077,7700a5048a845a67b4344611589b320e,ac1ade63dbf740f15e3ec8c4574f1822}'::text[]))
17. 0.196 0.196 ↓ 0.0 0 1 / 6

Bitmap Index Scan on widget_part_hash_9_campaign_id_idx (cost=0.00..544.12 rows=13,139 width=0) (actual time=1.174..1.174 rows=0 loops=1)

  • Index Cond: ((campaign_id)::text = ANY ('{da3da707479185cb64d94bb4e6ecf490,d1dcb3b5ffe112e555fbdaa0b79241a8,c120838d777795ab2a47ac99a52f5b92,eb1d203d78a4f69282704c8ffbd97ea9,c7c0fd20e8d5ede3e300e28f3382c274,cb97a87ff64196b87179f7005cd758e2,c33001f76ffc53ad31c0f36990ff5f57,35de04d0d083965adb1e8f25e4c68077,7700a5048a845a67b4344611589b320e,ac1ade63dbf740f15e3ec8c4574f1822}'::text[]))
18. 0.001 0.087 ↓ 0.0 0 1 / 6

Parallel Bitmap Heap Scan on widget_part_hash_4 (cost=458.24..28,798.96 rows=3,857 width=159) (actual time=0.523..0.523 rows=0 loops=1)

  • Recheck Cond: ((campaign_id)::text = ANY ('{da3da707479185cb64d94bb4e6ecf490,d1dcb3b5ffe112e555fbdaa0b79241a8,c120838d777795ab2a47ac99a52f5b92,eb1d203d78a4f69282704c8ffbd97ea9,c7c0fd20e8d5ede3e300e28f3382c274,cb97a87ff64196b87179f7005cd758e2,c33001f76ffc53ad31c0f36990ff5f57,35de04d0d083965adb1e8f25e4c68077,7700a5048a845a67b4344611589b320e,ac1ade63dbf740f15e3ec8c4574f1822}'::text[]))
19. 0.087 0.087 ↓ 0.0 0 1 / 6

Bitmap Index Scan on widget_part_hash_4_campaign_id_idx (cost=0.00..455.25 rows=11,958 width=0) (actual time=0.520..0.520 rows=0 loops=1)

  • Index Cond: ((campaign_id)::text = ANY ('{da3da707479185cb64d94bb4e6ecf490,d1dcb3b5ffe112e555fbdaa0b79241a8,c120838d777795ab2a47ac99a52f5b92,eb1d203d78a4f69282704c8ffbd97ea9,c7c0fd20e8d5ede3e300e28f3382c274,cb97a87ff64196b87179f7005cd758e2,c33001f76ffc53ad31c0f36990ff5f57,35de04d0d083965adb1e8f25e4c68077,7700a5048a845a67b4344611589b320e,ac1ade63dbf740f15e3ec8c4574f1822}'::text[]))
20. 0.001 0.323 ↓ 0.0 0 1 / 6

Parallel Bitmap Heap Scan on widget_part_hash_17 (cost=457.85..31,454.84 rows=3,843 width=167) (actual time=1.938..1.938 rows=0 loops=1)

  • Recheck Cond: ((campaign_id)::text = ANY ('{da3da707479185cb64d94bb4e6ecf490,d1dcb3b5ffe112e555fbdaa0b79241a8,c120838d777795ab2a47ac99a52f5b92,eb1d203d78a4f69282704c8ffbd97ea9,c7c0fd20e8d5ede3e300e28f3382c274,cb97a87ff64196b87179f7005cd758e2,c33001f76ffc53ad31c0f36990ff5f57,35de04d0d083965adb1e8f25e4c68077,7700a5048a845a67b4344611589b320e,ac1ade63dbf740f15e3ec8c4574f1822}'::text[]))
21. 0.323 0.323 ↓ 0.0 0 1 / 6

Bitmap Index Scan on widget_part_hash_17_campaign_id_idx (cost=0.00..454.88 rows=11,913 width=0) (actual time=1.935..1.935 rows=0 loops=1)

  • Index Cond: ((campaign_id)::text = ANY ('{da3da707479185cb64d94bb4e6ecf490,d1dcb3b5ffe112e555fbdaa0b79241a8,c120838d777795ab2a47ac99a52f5b92,eb1d203d78a4f69282704c8ffbd97ea9,c7c0fd20e8d5ede3e300e28f3382c274,cb97a87ff64196b87179f7005cd758e2,c33001f76ffc53ad31c0f36990ff5f57,35de04d0d083965adb1e8f25e4c68077,7700a5048a845a67b4344611589b320e,ac1ade63dbf740f15e3ec8c4574f1822}'::text[]))
22. 0.002 0.354 ↓ 0.0 0 1 / 6

Parallel Bitmap Heap Scan on widget_part_hash_2 (cost=452.50..31,932.92 rows=3,619 width=166) (actual time=2.127..2.127 rows=0 loops=1)

  • Recheck Cond: ((campaign_id)::text = ANY ('{da3da707479185cb64d94bb4e6ecf490,d1dcb3b5ffe112e555fbdaa0b79241a8,c120838d777795ab2a47ac99a52f5b92,eb1d203d78a4f69282704c8ffbd97ea9,c7c0fd20e8d5ede3e300e28f3382c274,cb97a87ff64196b87179f7005cd758e2,c33001f76ffc53ad31c0f36990ff5f57,35de04d0d083965adb1e8f25e4c68077,7700a5048a845a67b4344611589b320e,ac1ade63dbf740f15e3ec8c4574f1822}'::text[]))
23. 0.353 0.353 ↓ 0.0 0 1 / 6

Bitmap Index Scan on widget_part_hash_2_campaign_id_idx (cost=0.00..449.70 rows=11,220 width=0) (actual time=2.117..2.117 rows=0 loops=1)

  • Index Cond: ((campaign_id)::text = ANY ('{da3da707479185cb64d94bb4e6ecf490,d1dcb3b5ffe112e555fbdaa0b79241a8,c120838d777795ab2a47ac99a52f5b92,eb1d203d78a4f69282704c8ffbd97ea9,c7c0fd20e8d5ede3e300e28f3382c274,cb97a87ff64196b87179f7005cd758e2,c33001f76ffc53ad31c0f36990ff5f57,35de04d0d083965adb1e8f25e4c68077,7700a5048a845a67b4344611589b320e,ac1ade63dbf740f15e3ec8c4574f1822}'::text[]))
24. 0.000 0.066 ↓ 0.0 0 1 / 6

Parallel Bitmap Heap Scan on widget_part_hash_16 (cost=431.66..23,297.57 rows=3,553 width=164) (actual time=0.398..0.398 rows=0 loops=1)

  • Recheck Cond: ((campaign_id)::text = ANY ('{da3da707479185cb64d94bb4e6ecf490,d1dcb3b5ffe112e555fbdaa0b79241a8,c120838d777795ab2a47ac99a52f5b92,eb1d203d78a4f69282704c8ffbd97ea9,c7c0fd20e8d5ede3e300e28f3382c274,cb97a87ff64196b87179f7005cd758e2,c33001f76ffc53ad31c0f36990ff5f57,35de04d0d083965adb1e8f25e4c68077,7700a5048a845a67b4344611589b320e,ac1ade63dbf740f15e3ec8c4574f1822}'::text[]))
25. 0.066 0.066 ↓ 0.0 0 1 / 6

Bitmap Index Scan on widget_part_hash_16_campaign_id_idx (cost=0.00..429.53 rows=8,528 width=0) (actual time=0.396..0.396 rows=0 loops=1)

  • Index Cond: ((campaign_id)::text = ANY ('{da3da707479185cb64d94bb4e6ecf490,d1dcb3b5ffe112e555fbdaa0b79241a8,c120838d777795ab2a47ac99a52f5b92,eb1d203d78a4f69282704c8ffbd97ea9,c7c0fd20e8d5ede3e300e28f3382c274,cb97a87ff64196b87179f7005cd758e2,c33001f76ffc53ad31c0f36990ff5f57,35de04d0d083965adb1e8f25e4c68077,7700a5048a845a67b4344611589b320e,ac1ade63dbf740f15e3ec8c4574f1822}'::text[]))
26. 0.001 0.202 ↓ 0.0 0 1 / 6

Parallel Bitmap Heap Scan on widget_part_hash_11 (cost=390.07..20,898.99 rows=3,540 width=181) (actual time=1.214..1.214 rows=0 loops=1)

  • Recheck Cond: ((campaign_id)::text = ANY ('{da3da707479185cb64d94bb4e6ecf490,d1dcb3b5ffe112e555fbdaa0b79241a8,c120838d777795ab2a47ac99a52f5b92,eb1d203d78a4f69282704c8ffbd97ea9,c7c0fd20e8d5ede3e300e28f3382c274,cb97a87ff64196b87179f7005cd758e2,c33001f76ffc53ad31c0f36990ff5f57,35de04d0d083965adb1e8f25e4c68077,7700a5048a845a67b4344611589b320e,ac1ade63dbf740f15e3ec8c4574f1822}'::text[]))
27. 0.201 0.201 ↓ 0.0 0 1 / 6

Bitmap Index Scan on widget_part_hash_11_campaign_id_idx (cost=0.00..387.95 rows=8,495 width=0) (actual time=1.208..1.208 rows=0 loops=1)

  • Index Cond: ((campaign_id)::text = ANY ('{da3da707479185cb64d94bb4e6ecf490,d1dcb3b5ffe112e555fbdaa0b79241a8,c120838d777795ab2a47ac99a52f5b92,eb1d203d78a4f69282704c8ffbd97ea9,c7c0fd20e8d5ede3e300e28f3382c274,cb97a87ff64196b87179f7005cd758e2,c33001f76ffc53ad31c0f36990ff5f57,35de04d0d083965adb1e8f25e4c68077,7700a5048a845a67b4344611589b320e,ac1ade63dbf740f15e3ec8c4574f1822}'::text[]))
28. 0.000 0.252 ↓ 0.0 0 1 / 6

Parallel Bitmap Heap Scan on widget_part_hash_3 (cost=339.54..19,406.88 rows=2,903 width=181) (actual time=1.509..1.509 rows=0 loops=1)

  • Recheck Cond: ((campaign_id)::text = ANY ('{da3da707479185cb64d94bb4e6ecf490,d1dcb3b5ffe112e555fbdaa0b79241a8,c120838d777795ab2a47ac99a52f5b92,eb1d203d78a4f69282704c8ffbd97ea9,c7c0fd20e8d5ede3e300e28f3382c274,cb97a87ff64196b87179f7005cd758e2,c33001f76ffc53ad31c0f36990ff5f57,35de04d0d083965adb1e8f25e4c68077,7700a5048a845a67b4344611589b320e,ac1ade63dbf740f15e3ec8c4574f1822}'::text[]))
29. 0.251 0.251 ↓ 0.0 0 1 / 6

Bitmap Index Scan on widget_part_hash_3_campaign_id_idx (cost=0.00..337.80 rows=6,967 width=0) (actual time=1.507..1.507 rows=0 loops=1)

  • Index Cond: ((campaign_id)::text = ANY ('{da3da707479185cb64d94bb4e6ecf490,d1dcb3b5ffe112e555fbdaa0b79241a8,c120838d777795ab2a47ac99a52f5b92,eb1d203d78a4f69282704c8ffbd97ea9,c7c0fd20e8d5ede3e300e28f3382c274,cb97a87ff64196b87179f7005cd758e2,c33001f76ffc53ad31c0f36990ff5f57,35de04d0d083965adb1e8f25e4c68077,7700a5048a845a67b4344611589b320e,ac1ade63dbf740f15e3ec8c4574f1822}'::text[]))
30. 0.001 0.153 ↓ 0.0 0 1 / 6

Parallel Bitmap Heap Scan on widget_part_hash_12 (cost=299.69..18,228.15 rows=2,981 width=173) (actual time=0.921..0.921 rows=0 loops=1)

  • Recheck Cond: ((campaign_id)::text = ANY ('{da3da707479185cb64d94bb4e6ecf490,d1dcb3b5ffe112e555fbdaa0b79241a8,c120838d777795ab2a47ac99a52f5b92,eb1d203d78a4f69282704c8ffbd97ea9,c7c0fd20e8d5ede3e300e28f3382c274,cb97a87ff64196b87179f7005cd758e2,c33001f76ffc53ad31c0f36990ff5f57,35de04d0d083965adb1e8f25e4c68077,7700a5048a845a67b4344611589b320e,ac1ade63dbf740f15e3ec8c4574f1822}'::text[]))
31. 0.153 0.153 ↓ 0.0 0 1 / 6

Bitmap Index Scan on widget_part_hash_12_campaign_id_idx (cost=0.00..297.90 rows=7,155 width=0) (actual time=0.916..0.916 rows=0 loops=1)

  • Index Cond: ((campaign_id)::text = ANY ('{da3da707479185cb64d94bb4e6ecf490,d1dcb3b5ffe112e555fbdaa0b79241a8,c120838d777795ab2a47ac99a52f5b92,eb1d203d78a4f69282704c8ffbd97ea9,c7c0fd20e8d5ede3e300e28f3382c274,cb97a87ff64196b87179f7005cd758e2,c33001f76ffc53ad31c0f36990ff5f57,35de04d0d083965adb1e8f25e4c68077,7700a5048a845a67b4344611589b320e,ac1ade63dbf740f15e3ec8c4574f1822}'::text[]))
32. 0.001 0.141 ↓ 0.0 0 1 / 6

Parallel Bitmap Heap Scan on widget_part_hash_6 (cost=292.64..15,797.42 rows=2,602 width=181) (actual time=0.848..0.848 rows=0 loops=1)

  • Recheck Cond: ((campaign_id)::text = ANY ('{da3da707479185cb64d94bb4e6ecf490,d1dcb3b5ffe112e555fbdaa0b79241a8,c120838d777795ab2a47ac99a52f5b92,eb1d203d78a4f69282704c8ffbd97ea9,c7c0fd20e8d5ede3e300e28f3382c274,cb97a87ff64196b87179f7005cd758e2,c33001f76ffc53ad31c0f36990ff5f57,35de04d0d083965adb1e8f25e4c68077,7700a5048a845a67b4344611589b320e,ac1ade63dbf740f15e3ec8c4574f1822}'::text[]))
33. 0.141 0.141 ↓ 0.0 0 1 / 6

Bitmap Index Scan on widget_part_hash_6_campaign_id_idx (cost=0.00..291.07 rows=6,244 width=0) (actual time=0.845..0.845 rows=0 loops=1)

  • Index Cond: ((campaign_id)::text = ANY ('{da3da707479185cb64d94bb4e6ecf490,d1dcb3b5ffe112e555fbdaa0b79241a8,c120838d777795ab2a47ac99a52f5b92,eb1d203d78a4f69282704c8ffbd97ea9,c7c0fd20e8d5ede3e300e28f3382c274,cb97a87ff64196b87179f7005cd758e2,c33001f76ffc53ad31c0f36990ff5f57,35de04d0d083965adb1e8f25e4c68077,7700a5048a845a67b4344611589b320e,ac1ade63dbf740f15e3ec8c4574f1822}'::text[]))
34. 0.000 0.211 ↓ 0.0 0 1 / 6

Parallel Bitmap Heap Scan on widget_part_hash_18 (cost=249.31..16,540.02 rows=2,354 width=175) (actual time=1.266..1.266 rows=0 loops=1)

  • Recheck Cond: ((campaign_id)::text = ANY ('{da3da707479185cb64d94bb4e6ecf490,d1dcb3b5ffe112e555fbdaa0b79241a8,c120838d777795ab2a47ac99a52f5b92,eb1d203d78a4f69282704c8ffbd97ea9,c7c0fd20e8d5ede3e300e28f3382c274,cb97a87ff64196b87179f7005cd758e2,c33001f76ffc53ad31c0f36990ff5f57,35de04d0d083965adb1e8f25e4c68077,7700a5048a845a67b4344611589b320e,ac1ade63dbf740f15e3ec8c4574f1822}'::text[]))
35. 0.211 0.211 ↓ 0.0 0 1 / 6

Bitmap Index Scan on widget_part_hash_18_campaign_id_idx (cost=0.00..247.90 rows=5,650 width=0) (actual time=1.264..1.264 rows=0 loops=1)

  • Index Cond: ((campaign_id)::text = ANY ('{da3da707479185cb64d94bb4e6ecf490,d1dcb3b5ffe112e555fbdaa0b79241a8,c120838d777795ab2a47ac99a52f5b92,eb1d203d78a4f69282704c8ffbd97ea9,c7c0fd20e8d5ede3e300e28f3382c274,cb97a87ff64196b87179f7005cd758e2,c33001f76ffc53ad31c0f36990ff5f57,35de04d0d083965adb1e8f25e4c68077,7700a5048a845a67b4344611589b320e,ac1ade63dbf740f15e3ec8c4574f1822}'::text[]))
36. 0.001 0.365 ↓ 0.0 0 1 / 6

Parallel Bitmap Heap Scan on widget_part_hash_13 (cost=248.33..17,962.03 rows=2,301 width=171) (actual time=2.190..2.190 rows=0 loops=1)

  • Recheck Cond: ((campaign_id)::text = ANY ('{da3da707479185cb64d94bb4e6ecf490,d1dcb3b5ffe112e555fbdaa0b79241a8,c120838d777795ab2a47ac99a52f5b92,eb1d203d78a4f69282704c8ffbd97ea9,c7c0fd20e8d5ede3e300e28f3382c274,cb97a87ff64196b87179f7005cd758e2,c33001f76ffc53ad31c0f36990ff5f57,35de04d0d083965adb1e8f25e4c68077,7700a5048a845a67b4344611589b320e,ac1ade63dbf740f15e3ec8c4574f1822}'::text[]))
37. 0.364 0.364 ↓ 0.0 0 1 / 6

Bitmap Index Scan on widget_part_hash_13_campaign_id_idx (cost=0.00..246.95 rows=5,522 width=0) (actual time=2.184..2.184 rows=0 loops=1)

  • Index Cond: ((campaign_id)::text = ANY ('{da3da707479185cb64d94bb4e6ecf490,d1dcb3b5ffe112e555fbdaa0b79241a8,c120838d777795ab2a47ac99a52f5b92,eb1d203d78a4f69282704c8ffbd97ea9,c7c0fd20e8d5ede3e300e28f3382c274,cb97a87ff64196b87179f7005cd758e2,c33001f76ffc53ad31c0f36990ff5f57,35de04d0d083965adb1e8f25e4c68077,7700a5048a845a67b4344611589b320e,ac1ade63dbf740f15e3ec8c4574f1822}'::text[]))
38. 0.000 0.153 ↓ 0.0 0 1 / 6

Parallel Bitmap Heap Scan on widget_part_hash_8 (cost=248.14..15,844.41 rows=2,359 width=185) (actual time=0.918..0.918 rows=0 loops=1)

  • Recheck Cond: ((campaign_id)::text = ANY ('{da3da707479185cb64d94bb4e6ecf490,d1dcb3b5ffe112e555fbdaa0b79241a8,c120838d777795ab2a47ac99a52f5b92,eb1d203d78a4f69282704c8ffbd97ea9,c7c0fd20e8d5ede3e300e28f3382c274,cb97a87ff64196b87179f7005cd758e2,c33001f76ffc53ad31c0f36990ff5f57,35de04d0d083965adb1e8f25e4c68077,7700a5048a845a67b4344611589b320e,ac1ade63dbf740f15e3ec8c4574f1822}'::text[]))
39. 0.153 0.153 ↓ 0.0 0 1 / 6

Bitmap Index Scan on widget_part_hash_8_campaign_id_idx (cost=0.00..246.72 rows=5,662 width=0) (actual time=0.916..0.916 rows=0 loops=1)

  • Index Cond: ((campaign_id)::text = ANY ('{da3da707479185cb64d94bb4e6ecf490,d1dcb3b5ffe112e555fbdaa0b79241a8,c120838d777795ab2a47ac99a52f5b92,eb1d203d78a4f69282704c8ffbd97ea9,c7c0fd20e8d5ede3e300e28f3382c274,cb97a87ff64196b87179f7005cd758e2,c33001f76ffc53ad31c0f36990ff5f57,35de04d0d083965adb1e8f25e4c68077,7700a5048a845a67b4344611589b320e,ac1ade63dbf740f15e3ec8c4574f1822}'::text[]))
40. 0.001 0.283 ↓ 0.0 0 1 / 6

Parallel Bitmap Heap Scan on widget_part_hash_1 (cost=242.75..15,685.15 rows=2,000 width=177) (actual time=1.699..1.699 rows=0 loops=1)

  • Recheck Cond: ((campaign_id)::text = ANY ('{da3da707479185cb64d94bb4e6ecf490,d1dcb3b5ffe112e555fbdaa0b79241a8,c120838d777795ab2a47ac99a52f5b92,eb1d203d78a4f69282704c8ffbd97ea9,c7c0fd20e8d5ede3e300e28f3382c274,cb97a87ff64196b87179f7005cd758e2,c33001f76ffc53ad31c0f36990ff5f57,35de04d0d083965adb1e8f25e4c68077,7700a5048a845a67b4344611589b320e,ac1ade63dbf740f15e3ec8c4574f1822}'::text[]))
41. 0.282 0.282 ↓ 0.0 0 1 / 6

Bitmap Index Scan on widget_part_hash_1_campaign_id_idx (cost=0.00..241.55 rows=4,800 width=0) (actual time=1.693..1.693 rows=0 loops=1)

  • Index Cond: ((campaign_id)::text = ANY ('{da3da707479185cb64d94bb4e6ecf490,d1dcb3b5ffe112e555fbdaa0b79241a8,c120838d777795ab2a47ac99a52f5b92,eb1d203d78a4f69282704c8ffbd97ea9,c7c0fd20e8d5ede3e300e28f3382c274,cb97a87ff64196b87179f7005cd758e2,c33001f76ffc53ad31c0f36990ff5f57,35de04d0d083965adb1e8f25e4c68077,7700a5048a845a67b4344611589b320e,ac1ade63dbf740f15e3ec8c4574f1822}'::text[]))
42. 0.000 0.096 ↓ 0.0 0 1 / 6

Parallel Bitmap Heap Scan on widget_part_hash_15 (cost=241.91..10,697.77 rows=2,025 width=179) (actual time=0.575..0.575 rows=0 loops=1)

  • Recheck Cond: ((campaign_id)::text = ANY ('{da3da707479185cb64d94bb4e6ecf490,d1dcb3b5ffe112e555fbdaa0b79241a8,c120838d777795ab2a47ac99a52f5b92,eb1d203d78a4f69282704c8ffbd97ea9,c7c0fd20e8d5ede3e300e28f3382c274,cb97a87ff64196b87179f7005cd758e2,c33001f76ffc53ad31c0f36990ff5f57,35de04d0d083965adb1e8f25e4c68077,7700a5048a845a67b4344611589b320e,ac1ade63dbf740f15e3ec8c4574f1822}'::text[]))
43. 0.095 0.095 ↓ 0.0 0 1 / 6

Bitmap Index Scan on widget_part_hash_15_campaign_id_idx (cost=0.00..240.70 rows=4,860 width=0) (actual time=0.573..0.573 rows=0 loops=1)

  • Index Cond: ((campaign_id)::text = ANY ('{da3da707479185cb64d94bb4e6ecf490,d1dcb3b5ffe112e555fbdaa0b79241a8,c120838d777795ab2a47ac99a52f5b92,eb1d203d78a4f69282704c8ffbd97ea9,c7c0fd20e8d5ede3e300e28f3382c274,cb97a87ff64196b87179f7005cd758e2,c33001f76ffc53ad31c0f36990ff5f57,35de04d0d083965adb1e8f25e4c68077,7700a5048a845a67b4344611589b320e,ac1ade63dbf740f15e3ec8c4574f1822}'::text[]))
44. 0.043 0.319 ↓ 0.0 0 1 / 6

Parallel Bitmap Heap Scan on widget_part_hash_7 (cost=150.56..10,283.48 rows=1,346 width=176) (actual time=1.913..1.913 rows=0 loops=1)

  • Recheck Cond: ((campaign_id)::text = ANY ('{da3da707479185cb64d94bb4e6ecf490,d1dcb3b5ffe112e555fbdaa0b79241a8,c120838d777795ab2a47ac99a52f5b92,eb1d203d78a4f69282704c8ffbd97ea9,c7c0fd20e8d5ede3e300e28f3382c274,cb97a87ff64196b87179f7005cd758e2,c33001f76ffc53ad31c0f36990ff5f57,35de04d0d083965adb1e8f25e4c68077,7700a5048a845a67b4344611589b320e,ac1ade63dbf740f15e3ec8c4574f1822}'::text[]))
45. 0.276 0.276 ↓ 0.0 0 1 / 6

Bitmap Index Scan on widget_part_hash_7_campaign_id_idx (cost=0.00..149.75 rows=3,231 width=0) (actual time=1.654..1.654 rows=0 loops=1)

  • Index Cond: ((campaign_id)::text = ANY ('{da3da707479185cb64d94bb4e6ecf490,d1dcb3b5ffe112e555fbdaa0b79241a8,c120838d777795ab2a47ac99a52f5b92,eb1d203d78a4f69282704c8ffbd97ea9,c7c0fd20e8d5ede3e300e28f3382c274,cb97a87ff64196b87179f7005cd758e2,c33001f76ffc53ad31c0f36990ff5f57,35de04d0d083965adb1e8f25e4c68077,7700a5048a845a67b4344611589b320e,ac1ade63dbf740f15e3ec8c4574f1822}'::text[]))
46. 18.852 53,947.149 ↓ 33.3 6,666 6 / 6

Sort (cost=1,304,264.33..1,304,264.83 rows=200 width=93) (actual time=53,946.060..53,947.149 rows=6,666 loops=6)

  • Sort Key: ep.widget_id
  • Sort Method: quicksort Memory: 1130kB
  • Worker 0: Sort Method: quicksort Memory: 1130kB
  • Worker 1: Sort Method: quicksort Memory: 1130kB
  • Worker 2: Sort Method: quicksort Memory: 1130kB
  • Worker 3: Sort Method: quicksort Memory: 1130kB
  • Worker 4: Sort Method: quicksort Memory: 1130kB
47. 0.862 53,928.297 ↓ 33.3 6,667 6 / 6

Subquery Scan on ep (cost=1,304,252.68..1,304,256.68 rows=200 width=93) (actual time=53,924.692..53,928.297 rows=6,667 loops=6)

48. 92.816 53,927.435 ↓ 33.3 6,667 6 / 6

HashAggregate (cost=1,304,252.68..1,304,254.68 rows=200 width=93) (actual time=53,924.685..53,927.435 rows=6,667 loops=6)

  • Group Key: widget_performance_20191104_20191111.widget_id
49. 80.049 53,834.619 ↑ 413.2 71,770 6 / 6

Nested Loop (cost=553,138.11..562,920.53 rows=29,653,286 width=69) (actual time=92.999..53,834.619 rows=71,770 loops=6)

50. 62.132 133.374 ↓ 129.3 25,854 6 / 6

HashAggregate (cost=553,137.55..553,139.55 rows=200 width=33) (actual time=85.805..133.374 rows=25,854 loops=6)

  • Group Key: (widget_part_hash_0_1.id)::text
51. 2.784 71.242 ↑ 8.0 25,854 6 / 6

Result (cost=593.07..552,623.26 rows=205,716 width=33) (actual time=7.603..71.242 rows=25,854 loops=6)

52. 1.967 68.458 ↑ 8.0 25,854 6 / 6

Append (cost=593.07..552,623.26 rows=205,716 width=33) (actual time=7.598..68.458 rows=25,854 loops=6)

53. 0.005 0.302 ↓ 0.0 0 6 / 6

Bitmap Heap Scan on widget_part_hash_0 widget_part_hash_0_1 (cost=593.07..40,073.84 rows=13,875 width=33) (actual time=0.302..0.302 rows=0 loops=6)

  • Recheck Cond: ((campaign_id)::text = ANY ('{da3da707479185cb64d94bb4e6ecf490,d1dcb3b5ffe112e555fbdaa0b79241a8,c120838d777795ab2a47ac99a52f5b92,eb1d203d78a4f69282704c8ffbd97ea9,c7c0fd20e8d5ede3e300e28f3382c274,cb97a87ff64196b87179f7005cd758e2,c33001f76ffc53ad31c0f36990ff5f57,35de04d0d083965adb1e8f25e4c68077,7700a5048a845a67b4344611589b320e,ac1ade63dbf740f15e3ec8c4574f1822}'::text[]))
54. 0.297 0.297 ↓ 0.0 0 6 / 6

Bitmap Index Scan on widget_part_hash_0_campaign_id_idx (cost=0.00..589.60 rows=13,875 width=0) (actual time=0.297..0.297 rows=0 loops=6)

  • Index Cond: ((campaign_id)::text = ANY ('{da3da707479185cb64d94bb4e6ecf490,d1dcb3b5ffe112e555fbdaa0b79241a8,c120838d777795ab2a47ac99a52f5b92,eb1d203d78a4f69282704c8ffbd97ea9,c7c0fd20e8d5ede3e300e28f3382c274,cb97a87ff64196b87179f7005cd758e2,c33001f76ffc53ad31c0f36990ff5f57,35de04d0d083965adb1e8f25e4c68077,7700a5048a845a67b4344611589b320e,ac1ade63dbf740f15e3ec8c4574f1822}'::text[]))
55. 0.001 0.259 ↓ 0.0 0 6 / 6

Bitmap Heap Scan on widget_part_hash_1 widget_part_hash_1_1 (cost=242.75..15,748.15 rows=4,800 width=33) (actual time=0.259..0.259 rows=0 loops=6)

  • Recheck Cond: ((campaign_id)::text = ANY ('{da3da707479185cb64d94bb4e6ecf490,d1dcb3b5ffe112e555fbdaa0b79241a8,c120838d777795ab2a47ac99a52f5b92,eb1d203d78a4f69282704c8ffbd97ea9,c7c0fd20e8d5ede3e300e28f3382c274,cb97a87ff64196b87179f7005cd758e2,c33001f76ffc53ad31c0f36990ff5f57,35de04d0d083965adb1e8f25e4c68077,7700a5048a845a67b4344611589b320e,ac1ade63dbf740f15e3ec8c4574f1822}'::text[]))
56. 0.258 0.258 ↓ 0.0 0 6 / 6

Bitmap Index Scan on widget_part_hash_1_campaign_id_idx (cost=0.00..241.55 rows=4,800 width=0) (actual time=0.258..0.258 rows=0 loops=6)

  • Index Cond: ((campaign_id)::text = ANY ('{da3da707479185cb64d94bb4e6ecf490,d1dcb3b5ffe112e555fbdaa0b79241a8,c120838d777795ab2a47ac99a52f5b92,eb1d203d78a4f69282704c8ffbd97ea9,c7c0fd20e8d5ede3e300e28f3382c274,cb97a87ff64196b87179f7005cd758e2,c33001f76ffc53ad31c0f36990ff5f57,35de04d0d083965adb1e8f25e4c68077,7700a5048a845a67b4344611589b320e,ac1ade63dbf740f15e3ec8c4574f1822}'::text[]))
57. 0.003 0.251 ↓ 0.0 0 6 / 6

Bitmap Heap Scan on widget_part_hash_2 widget_part_hash_2_1 (cost=452.50..32,103.93 rows=11,220 width=33) (actual time=0.251..0.251 rows=0 loops=6)

  • Recheck Cond: ((campaign_id)::text = ANY ('{da3da707479185cb64d94bb4e6ecf490,d1dcb3b5ffe112e555fbdaa0b79241a8,c120838d777795ab2a47ac99a52f5b92,eb1d203d78a4f69282704c8ffbd97ea9,c7c0fd20e8d5ede3e300e28f3382c274,cb97a87ff64196b87179f7005cd758e2,c33001f76ffc53ad31c0f36990ff5f57,35de04d0d083965adb1e8f25e4c68077,7700a5048a845a67b4344611589b320e,ac1ade63dbf740f15e3ec8c4574f1822}'::text[]))
58. 0.248 0.248 ↓ 0.0 0 6 / 6

Bitmap Index Scan on widget_part_hash_2_campaign_id_idx (cost=0.00..449.70 rows=11,220 width=0) (actual time=0.248..0.248 rows=0 loops=6)

  • Index Cond: ((campaign_id)::text = ANY ('{da3da707479185cb64d94bb4e6ecf490,d1dcb3b5ffe112e555fbdaa0b79241a8,c120838d777795ab2a47ac99a52f5b92,eb1d203d78a4f69282704c8ffbd97ea9,c7c0fd20e8d5ede3e300e28f3382c274,cb97a87ff64196b87179f7005cd758e2,c33001f76ffc53ad31c0f36990ff5f57,35de04d0d083965adb1e8f25e4c68077,7700a5048a845a67b4344611589b320e,ac1ade63dbf740f15e3ec8c4574f1822}'::text[]))
59. 0.003 0.235 ↓ 0.0 0 6 / 6

Bitmap Heap Scan on widget_part_hash_3 widget_part_hash_3_1 (cost=339.54..19,498.32 rows=6,967 width=33) (actual time=0.234..0.235 rows=0 loops=6)

  • Recheck Cond: ((campaign_id)::text = ANY ('{da3da707479185cb64d94bb4e6ecf490,d1dcb3b5ffe112e555fbdaa0b79241a8,c120838d777795ab2a47ac99a52f5b92,eb1d203d78a4f69282704c8ffbd97ea9,c7c0fd20e8d5ede3e300e28f3382c274,cb97a87ff64196b87179f7005cd758e2,c33001f76ffc53ad31c0f36990ff5f57,35de04d0d083965adb1e8f25e4c68077,7700a5048a845a67b4344611589b320e,ac1ade63dbf740f15e3ec8c4574f1822}'::text[]))
60. 0.232 0.232 ↓ 0.0 0 6 / 6

Bitmap Index Scan on widget_part_hash_3_campaign_id_idx (cost=0.00..337.80 rows=6,967 width=0) (actual time=0.232..0.232 rows=0 loops=6)

  • Index Cond: ((campaign_id)::text = ANY ('{da3da707479185cb64d94bb4e6ecf490,d1dcb3b5ffe112e555fbdaa0b79241a8,c120838d777795ab2a47ac99a52f5b92,eb1d203d78a4f69282704c8ffbd97ea9,c7c0fd20e8d5ede3e300e28f3382c274,cb97a87ff64196b87179f7005cd758e2,c33001f76ffc53ad31c0f36990ff5f57,35de04d0d083965adb1e8f25e4c68077,7700a5048a845a67b4344611589b320e,ac1ade63dbf740f15e3ec8c4574f1822}'::text[]))
61. 0.002 0.247 ↓ 0.0 0 6 / 6

Bitmap Heap Scan on widget_part_hash_4 widget_part_hash_4_1 (cost=458.24..28,981.22 rows=11,958 width=33) (actual time=0.246..0.247 rows=0 loops=6)

  • Recheck Cond: ((campaign_id)::text = ANY ('{da3da707479185cb64d94bb4e6ecf490,d1dcb3b5ffe112e555fbdaa0b79241a8,c120838d777795ab2a47ac99a52f5b92,eb1d203d78a4f69282704c8ffbd97ea9,c7c0fd20e8d5ede3e300e28f3382c274,cb97a87ff64196b87179f7005cd758e2,c33001f76ffc53ad31c0f36990ff5f57,35de04d0d083965adb1e8f25e4c68077,7700a5048a845a67b4344611589b320e,ac1ade63dbf740f15e3ec8c4574f1822}'::text[]))
62. 0.245 0.245 ↓ 0.0 0 6 / 6

Bitmap Index Scan on widget_part_hash_4_campaign_id_idx (cost=0.00..455.25 rows=11,958 width=0) (actual time=0.245..0.245 rows=0 loops=6)

  • Index Cond: ((campaign_id)::text = ANY ('{da3da707479185cb64d94bb4e6ecf490,d1dcb3b5ffe112e555fbdaa0b79241a8,c120838d777795ab2a47ac99a52f5b92,eb1d203d78a4f69282704c8ffbd97ea9,c7c0fd20e8d5ede3e300e28f3382c274,cb97a87ff64196b87179f7005cd758e2,c33001f76ffc53ad31c0f36990ff5f57,35de04d0d083965adb1e8f25e4c68077,7700a5048a845a67b4344611589b320e,ac1ade63dbf740f15e3ec8c4574f1822}'::text[]))
63. 56.621 61.743 ↓ 1.1 25,854 6 / 6

Bitmap Heap Scan on widget_part_hash_5 widget_part_hash_5_1 (cost=908.60..45,955.60 rows=23,615 width=33) (actual time=6.301..61.743 rows=25,854 loops=6)

  • Recheck Cond: ((campaign_id)::text = ANY ('{da3da707479185cb64d94bb4e6ecf490,d1dcb3b5ffe112e555fbdaa0b79241a8,c120838d777795ab2a47ac99a52f5b92,eb1d203d78a4f69282704c8ffbd97ea9,c7c0fd20e8d5ede3e300e28f3382c274,cb97a87ff64196b87179f7005cd758e2,c33001f76ffc53ad31c0f36990ff5f57,35de04d0d083965adb1e8f25e4c68077,7700a5048a845a67b4344611589b320e,ac1ade63dbf740f15e3ec8c4574f1822}'::text[]))
  • Heap Blocks: exact=7019
64. 5.122 5.122 ↓ 1.3 30,059 6 / 6

Bitmap Index Scan on widget_part_hash_5_campaign_id_idx (cost=0.00..902.70 rows=23,615 width=0) (actual time=5.122..5.122 rows=30,059 loops=6)

  • Index Cond: ((campaign_id)::text = ANY ('{da3da707479185cb64d94bb4e6ecf490,d1dcb3b5ffe112e555fbdaa0b79241a8,c120838d777795ab2a47ac99a52f5b92,eb1d203d78a4f69282704c8ffbd97ea9,c7c0fd20e8d5ede3e300e28f3382c274,cb97a87ff64196b87179f7005cd758e2,c33001f76ffc53ad31c0f36990ff5f57,35de04d0d083965adb1e8f25e4c68077,7700a5048a845a67b4344611589b320e,ac1ade63dbf740f15e3ec8c4574f1822}'::text[]))
65. 0.002 0.250 ↓ 0.0 0 6 / 6

Bitmap Heap Scan on widget_part_hash_6 widget_part_hash_6_1 (cost=292.64..15,879.37 rows=6,244 width=33) (actual time=0.250..0.250 rows=0 loops=6)

  • Recheck Cond: ((campaign_id)::text = ANY ('{da3da707479185cb64d94bb4e6ecf490,d1dcb3b5ffe112e555fbdaa0b79241a8,c120838d777795ab2a47ac99a52f5b92,eb1d203d78a4f69282704c8ffbd97ea9,c7c0fd20e8d5ede3e300e28f3382c274,cb97a87ff64196b87179f7005cd758e2,c33001f76ffc53ad31c0f36990ff5f57,35de04d0d083965adb1e8f25e4c68077,7700a5048a845a67b4344611589b320e,ac1ade63dbf740f15e3ec8c4574f1822}'::text[]))
66. 0.248 0.248 ↓ 0.0 0 6 / 6

Bitmap Index Scan on widget_part_hash_6_campaign_id_idx (cost=0.00..291.07 rows=6,244 width=0) (actual time=0.248..0.248 rows=0 loops=6)

  • Index Cond: ((campaign_id)::text = ANY ('{da3da707479185cb64d94bb4e6ecf490,d1dcb3b5ffe112e555fbdaa0b79241a8,c120838d777795ab2a47ac99a52f5b92,eb1d203d78a4f69282704c8ffbd97ea9,c7c0fd20e8d5ede3e300e28f3382c274,cb97a87ff64196b87179f7005cd758e2,c33001f76ffc53ad31c0f36990ff5f57,35de04d0d083965adb1e8f25e4c68077,7700a5048a845a67b4344611589b320e,ac1ade63dbf740f15e3ec8c4574f1822}'::text[]))
67. 0.002 0.279 ↓ 0.0 0 6 / 6

Bitmap Heap Scan on widget_part_hash_7 widget_part_hash_7_1 (cost=150.56..10,325.88 rows=3,231 width=33) (actual time=0.279..0.279 rows=0 loops=6)

  • Recheck Cond: ((campaign_id)::text = ANY ('{da3da707479185cb64d94bb4e6ecf490,d1dcb3b5ffe112e555fbdaa0b79241a8,c120838d777795ab2a47ac99a52f5b92,eb1d203d78a4f69282704c8ffbd97ea9,c7c0fd20e8d5ede3e300e28f3382c274,cb97a87ff64196b87179f7005cd758e2,c33001f76ffc53ad31c0f36990ff5f57,35de04d0d083965adb1e8f25e4c68077,7700a5048a845a67b4344611589b320e,ac1ade63dbf740f15e3ec8c4574f1822}'::text[]))
68. 0.277 0.277 ↓ 0.0 0 6 / 6

Bitmap Index Scan on widget_part_hash_7_campaign_id_idx (cost=0.00..149.75 rows=3,231 width=0) (actual time=0.277..0.277 rows=0 loops=6)

  • Index Cond: ((campaign_id)::text = ANY ('{da3da707479185cb64d94bb4e6ecf490,d1dcb3b5ffe112e555fbdaa0b79241a8,c120838d777795ab2a47ac99a52f5b92,eb1d203d78a4f69282704c8ffbd97ea9,c7c0fd20e8d5ede3e300e28f3382c274,cb97a87ff64196b87179f7005cd758e2,c33001f76ffc53ad31c0f36990ff5f57,35de04d0d083965adb1e8f25e4c68077,7700a5048a845a67b4344611589b320e,ac1ade63dbf740f15e3ec8c4574f1822}'::text[]))
69. 0.002 0.217 ↓ 0.0 0 6 / 6

Bitmap Heap Scan on widget_part_hash_8 widget_part_hash_8_1 (cost=248.14..15,918.72 rows=5,662 width=33) (actual time=0.217..0.217 rows=0 loops=6)

  • Recheck Cond: ((campaign_id)::text = ANY ('{da3da707479185cb64d94bb4e6ecf490,d1dcb3b5ffe112e555fbdaa0b79241a8,c120838d777795ab2a47ac99a52f5b92,eb1d203d78a4f69282704c8ffbd97ea9,c7c0fd20e8d5ede3e300e28f3382c274,cb97a87ff64196b87179f7005cd758e2,c33001f76ffc53ad31c0f36990ff5f57,35de04d0d083965adb1e8f25e4c68077,7700a5048a845a67b4344611589b320e,ac1ade63dbf740f15e3ec8c4574f1822}'::text[]))
70. 0.215 0.215 ↓ 0.0 0 6 / 6

Bitmap Index Scan on widget_part_hash_8_campaign_id_idx (cost=0.00..246.72 rows=5,662 width=0) (actual time=0.215..0.215 rows=0 loops=6)

  • Index Cond: ((campaign_id)::text = ANY ('{da3da707479185cb64d94bb4e6ecf490,d1dcb3b5ffe112e555fbdaa0b79241a8,c120838d777795ab2a47ac99a52f5b92,eb1d203d78a4f69282704c8ffbd97ea9,c7c0fd20e8d5ede3e300e28f3382c274,cb97a87ff64196b87179f7005cd758e2,c33001f76ffc53ad31c0f36990ff5f57,35de04d0d083965adb1e8f25e4c68077,7700a5048a845a67b4344611589b320e,ac1ade63dbf740f15e3ec8c4574f1822}'::text[]))
71. 0.001 0.266 ↓ 0.0 0 6 / 6

Bitmap Heap Scan on widget_part_hash_9 widget_part_hash_9_1 (cost=547.41..38,986.16 rows=13,139 width=33) (actual time=0.266..0.266 rows=0 loops=6)

  • Recheck Cond: ((campaign_id)::text = ANY ('{da3da707479185cb64d94bb4e6ecf490,d1dcb3b5ffe112e555fbdaa0b79241a8,c120838d777795ab2a47ac99a52f5b92,eb1d203d78a4f69282704c8ffbd97ea9,c7c0fd20e8d5ede3e300e28f3382c274,cb97a87ff64196b87179f7005cd758e2,c33001f76ffc53ad31c0f36990ff5f57,35de04d0d083965adb1e8f25e4c68077,7700a5048a845a67b4344611589b320e,ac1ade63dbf740f15e3ec8c4574f1822}'::text[]))
72. 0.265 0.265 ↓ 0.0 0 6 / 6

Bitmap Index Scan on widget_part_hash_9_campaign_id_idx (cost=0.00..544.12 rows=13,139 width=0) (actual time=0.265..0.265 rows=0 loops=6)

  • Index Cond: ((campaign_id)::text = ANY ('{da3da707479185cb64d94bb4e6ecf490,d1dcb3b5ffe112e555fbdaa0b79241a8,c120838d777795ab2a47ac99a52f5b92,eb1d203d78a4f69282704c8ffbd97ea9,c7c0fd20e8d5ede3e300e28f3382c274,cb97a87ff64196b87179f7005cd758e2,c33001f76ffc53ad31c0f36990ff5f57,35de04d0d083965adb1e8f25e4c68077,7700a5048a845a67b4344611589b320e,ac1ade63dbf740f15e3ec8c4574f1822}'::text[]))
73. 0.001 0.280 ↓ 0.0 0 6 / 6

Bitmap Heap Scan on widget_part_hash_10 widget_part_hash_10_1 (cost=759.95..55,720.88 rows=19,917 width=33) (actual time=0.280..0.280 rows=0 loops=6)

  • Recheck Cond: ((campaign_id)::text = ANY ('{da3da707479185cb64d94bb4e6ecf490,d1dcb3b5ffe112e555fbdaa0b79241a8,c120838d777795ab2a47ac99a52f5b92,eb1d203d78a4f69282704c8ffbd97ea9,c7c0fd20e8d5ede3e300e28f3382c274,cb97a87ff64196b87179f7005cd758e2,c33001f76ffc53ad31c0f36990ff5f57,35de04d0d083965adb1e8f25e4c68077,7700a5048a845a67b4344611589b320e,ac1ade63dbf740f15e3ec8c4574f1822}'::text[]))
74. 0.279 0.279 ↓ 0.0 0 6 / 6

Bitmap Index Scan on widget_part_hash_10_campaign_id_idx (cost=0.00..754.98 rows=19,917 width=0) (actual time=0.279..0.279 rows=0 loops=6)

  • Index Cond: ((campaign_id)::text = ANY ('{da3da707479185cb64d94bb4e6ecf490,d1dcb3b5ffe112e555fbdaa0b79241a8,c120838d777795ab2a47ac99a52f5b92,eb1d203d78a4f69282704c8ffbd97ea9,c7c0fd20e8d5ede3e300e28f3382c274,cb97a87ff64196b87179f7005cd758e2,c33001f76ffc53ad31c0f36990ff5f57,35de04d0d083965adb1e8f25e4c68077,7700a5048a845a67b4344611589b320e,ac1ade63dbf740f15e3ec8c4574f1822}'::text[]))
75. 0.003 0.225 ↓ 0.0 0 6 / 6

Bitmap Heap Scan on widget_part_hash_11 widget_part_hash_11_1 (cost=390.07..21,010.49 rows=8,495 width=33) (actual time=0.225..0.225 rows=0 loops=6)

  • Recheck Cond: ((campaign_id)::text = ANY ('{da3da707479185cb64d94bb4e6ecf490,d1dcb3b5ffe112e555fbdaa0b79241a8,c120838d777795ab2a47ac99a52f5b92,eb1d203d78a4f69282704c8ffbd97ea9,c7c0fd20e8d5ede3e300e28f3382c274,cb97a87ff64196b87179f7005cd758e2,c33001f76ffc53ad31c0f36990ff5f57,35de04d0d083965adb1e8f25e4c68077,7700a5048a845a67b4344611589b320e,ac1ade63dbf740f15e3ec8c4574f1822}'::text[]))
76. 0.222 0.222 ↓ 0.0 0 6 / 6

Bitmap Index Scan on widget_part_hash_11_campaign_id_idx (cost=0.00..387.95 rows=8,495 width=0) (actual time=0.222..0.222 rows=0 loops=6)

  • Index Cond: ((campaign_id)::text = ANY ('{da3da707479185cb64d94bb4e6ecf490,d1dcb3b5ffe112e555fbdaa0b79241a8,c120838d777795ab2a47ac99a52f5b92,eb1d203d78a4f69282704c8ffbd97ea9,c7c0fd20e8d5ede3e300e28f3382c274,cb97a87ff64196b87179f7005cd758e2,c33001f76ffc53ad31c0f36990ff5f57,35de04d0d083965adb1e8f25e4c68077,7700a5048a845a67b4344611589b320e,ac1ade63dbf740f15e3ec8c4574f1822}'::text[]))
77. 0.001 0.191 ↓ 0.0 0 6 / 6

Bitmap Heap Scan on widget_part_hash_12 widget_part_hash_12_1 (cost=299.69..18,322.06 rows=7,155 width=33) (actual time=0.191..0.191 rows=0 loops=6)

  • Recheck Cond: ((campaign_id)::text = ANY ('{da3da707479185cb64d94bb4e6ecf490,d1dcb3b5ffe112e555fbdaa0b79241a8,c120838d777795ab2a47ac99a52f5b92,eb1d203d78a4f69282704c8ffbd97ea9,c7c0fd20e8d5ede3e300e28f3382c274,cb97a87ff64196b87179f7005cd758e2,c33001f76ffc53ad31c0f36990ff5f57,35de04d0d083965adb1e8f25e4c68077,7700a5048a845a67b4344611589b320e,ac1ade63dbf740f15e3ec8c4574f1822}'::text[]))
78. 0.190 0.190 ↓ 0.0 0 6 / 6

Bitmap Index Scan on widget_part_hash_12_campaign_id_idx (cost=0.00..297.90 rows=7,155 width=0) (actual time=0.190..0.190 rows=0 loops=6)

  • Index Cond: ((campaign_id)::text = ANY ('{da3da707479185cb64d94bb4e6ecf490,d1dcb3b5ffe112e555fbdaa0b79241a8,c120838d777795ab2a47ac99a52f5b92,eb1d203d78a4f69282704c8ffbd97ea9,c7c0fd20e8d5ede3e300e28f3382c274,cb97a87ff64196b87179f7005cd758e2,c33001f76ffc53ad31c0f36990ff5f57,35de04d0d083965adb1e8f25e4c68077,7700a5048a845a67b4344611589b320e,ac1ade63dbf740f15e3ec8c4574f1822}'::text[]))
79. 0.001 0.258 ↓ 0.0 0 6 / 6

Bitmap Heap Scan on widget_part_hash_13 widget_part_hash_13_1 (cost=248.33..18,034.51 rows=5,522 width=33) (actual time=0.258..0.258 rows=0 loops=6)

  • Recheck Cond: ((campaign_id)::text = ANY ('{da3da707479185cb64d94bb4e6ecf490,d1dcb3b5ffe112e555fbdaa0b79241a8,c120838d777795ab2a47ac99a52f5b92,eb1d203d78a4f69282704c8ffbd97ea9,c7c0fd20e8d5ede3e300e28f3382c274,cb97a87ff64196b87179f7005cd758e2,c33001f76ffc53ad31c0f36990ff5f57,35de04d0d083965adb1e8f25e4c68077,7700a5048a845a67b4344611589b320e,ac1ade63dbf740f15e3ec8c4574f1822}'::text[]))
80. 0.257 0.257 ↓ 0.0 0 6 / 6

Bitmap Index Scan on widget_part_hash_13_campaign_id_idx (cost=0.00..246.95 rows=5,522 width=0) (actual time=0.257..0.257 rows=0 loops=6)

  • Index Cond: ((campaign_id)::text = ANY ('{da3da707479185cb64d94bb4e6ecf490,d1dcb3b5ffe112e555fbdaa0b79241a8,c120838d777795ab2a47ac99a52f5b92,eb1d203d78a4f69282704c8ffbd97ea9,c7c0fd20e8d5ede3e300e28f3382c274,cb97a87ff64196b87179f7005cd758e2,c33001f76ffc53ad31c0f36990ff5f57,35de04d0d083965adb1e8f25e4c68077,7700a5048a845a67b4344611589b320e,ac1ade63dbf740f15e3ec8c4574f1822}'::text[]))
81. 0.002 0.270 ↓ 0.0 0 6 / 6

Bitmap Heap Scan on widget_part_hash_14 widget_part_hash_14_1 (cost=611.28..47,334.96 rows=16,220 width=33) (actual time=0.269..0.270 rows=0 loops=6)

  • Recheck Cond: ((campaign_id)::text = ANY ('{da3da707479185cb64d94bb4e6ecf490,d1dcb3b5ffe112e555fbdaa0b79241a8,c120838d777795ab2a47ac99a52f5b92,eb1d203d78a4f69282704c8ffbd97ea9,c7c0fd20e8d5ede3e300e28f3382c274,cb97a87ff64196b87179f7005cd758e2,c33001f76ffc53ad31c0f36990ff5f57,35de04d0d083965adb1e8f25e4c68077,7700a5048a845a67b4344611589b320e,ac1ade63dbf740f15e3ec8c4574f1822}'::text[]))
82. 0.268 0.268 ↓ 0.0 0 6 / 6

Bitmap Index Scan on widget_part_hash_14_campaign_id_idx (cost=0.00..607.23 rows=16,220 width=0) (actual time=0.268..0.268 rows=0 loops=6)

  • Index Cond: ((campaign_id)::text = ANY ('{da3da707479185cb64d94bb4e6ecf490,d1dcb3b5ffe112e555fbdaa0b79241a8,c120838d777795ab2a47ac99a52f5b92,eb1d203d78a4f69282704c8ffbd97ea9,c7c0fd20e8d5ede3e300e28f3382c274,cb97a87ff64196b87179f7005cd758e2,c33001f76ffc53ad31c0f36990ff5f57,35de04d0d083965adb1e8f25e4c68077,7700a5048a845a67b4344611589b320e,ac1ade63dbf740f15e3ec8c4574f1822}'::text[]))
83. 0.002 0.224 ↓ 0.0 0 6 / 6

Bitmap Heap Scan on widget_part_hash_15 widget_part_hash_15_1 (cost=241.91..10,761.56 rows=4,860 width=33) (actual time=0.224..0.224 rows=0 loops=6)

  • Recheck Cond: ((campaign_id)::text = ANY ('{da3da707479185cb64d94bb4e6ecf490,d1dcb3b5ffe112e555fbdaa0b79241a8,c120838d777795ab2a47ac99a52f5b92,eb1d203d78a4f69282704c8ffbd97ea9,c7c0fd20e8d5ede3e300e28f3382c274,cb97a87ff64196b87179f7005cd758e2,c33001f76ffc53ad31c0f36990ff5f57,35de04d0d083965adb1e8f25e4c68077,7700a5048a845a67b4344611589b320e,ac1ade63dbf740f15e3ec8c4574f1822}'::text[]))
84. 0.222 0.222 ↓ 0.0 0 6 / 6

Bitmap Index Scan on widget_part_hash_15_campaign_id_idx (cost=0.00..240.70 rows=4,860 width=0) (actual time=0.222..0.222 rows=0 loops=6)

  • Index Cond: ((campaign_id)::text = ANY ('{da3da707479185cb64d94bb4e6ecf490,d1dcb3b5ffe112e555fbdaa0b79241a8,c120838d777795ab2a47ac99a52f5b92,eb1d203d78a4f69282704c8ffbd97ea9,c7c0fd20e8d5ede3e300e28f3382c274,cb97a87ff64196b87179f7005cd758e2,c33001f76ffc53ad31c0f36990ff5f57,35de04d0d083965adb1e8f25e4c68077,7700a5048a845a67b4344611589b320e,ac1ade63dbf740f15e3ec8c4574f1822}'::text[]))
85. 0.010 0.260 ↓ 0.0 0 6 / 6

Bitmap Heap Scan on widget_part_hash_16 widget_part_hash_16_1 (cost=431.66..23,409.50 rows=8,528 width=33) (actual time=0.260..0.260 rows=0 loops=6)

  • Recheck Cond: ((campaign_id)::text = ANY ('{da3da707479185cb64d94bb4e6ecf490,d1dcb3b5ffe112e555fbdaa0b79241a8,c120838d777795ab2a47ac99a52f5b92,eb1d203d78a4f69282704c8ffbd97ea9,c7c0fd20e8d5ede3e300e28f3382c274,cb97a87ff64196b87179f7005cd758e2,c33001f76ffc53ad31c0f36990ff5f57,35de04d0d083965adb1e8f25e4c68077,7700a5048a845a67b4344611589b320e,ac1ade63dbf740f15e3ec8c4574f1822}'::text[]))
86. 0.250 0.250 ↓ 0.0 0 6 / 6

Bitmap Index Scan on widget_part_hash_16_campaign_id_idx (cost=0.00..429.53 rows=8,528 width=0) (actual time=0.250..0.250 rows=0 loops=6)

  • Index Cond: ((campaign_id)::text = ANY ('{da3da707479185cb64d94bb4e6ecf490,d1dcb3b5ffe112e555fbdaa0b79241a8,c120838d777795ab2a47ac99a52f5b92,eb1d203d78a4f69282704c8ffbd97ea9,c7c0fd20e8d5ede3e300e28f3382c274,cb97a87ff64196b87179f7005cd758e2,c33001f76ffc53ad31c0f36990ff5f57,35de04d0d083965adb1e8f25e4c68077,7700a5048a845a67b4344611589b320e,ac1ade63dbf740f15e3ec8c4574f1822}'::text[]))
87. 0.003 0.226 ↓ 0.0 0 6 / 6

Bitmap Heap Scan on widget_part_hash_17 widget_part_hash_17_1 (cost=457.85..31,636.42 rows=11,913 width=33) (actual time=0.226..0.226 rows=0 loops=6)

  • Recheck Cond: ((campaign_id)::text = ANY ('{da3da707479185cb64d94bb4e6ecf490,d1dcb3b5ffe112e555fbdaa0b79241a8,c120838d777795ab2a47ac99a52f5b92,eb1d203d78a4f69282704c8ffbd97ea9,c7c0fd20e8d5ede3e300e28f3382c274,cb97a87ff64196b87179f7005cd758e2,c33001f76ffc53ad31c0f36990ff5f57,35de04d0d083965adb1e8f25e4c68077,7700a5048a845a67b4344611589b320e,ac1ade63dbf740f15e3ec8c4574f1822}'::text[]))
88. 0.223 0.223 ↓ 0.0 0 6 / 6

Bitmap Index Scan on widget_part_hash_17_campaign_id_idx (cost=0.00..454.88 rows=11,913 width=0) (actual time=0.223..0.223 rows=0 loops=6)

  • Index Cond: ((campaign_id)::text = ANY ('{da3da707479185cb64d94bb4e6ecf490,d1dcb3b5ffe112e555fbdaa0b79241a8,c120838d777795ab2a47ac99a52f5b92,eb1d203d78a4f69282704c8ffbd97ea9,c7c0fd20e8d5ede3e300e28f3382c274,cb97a87ff64196b87179f7005cd758e2,c33001f76ffc53ad31c0f36990ff5f57,35de04d0d083965adb1e8f25e4c68077,7700a5048a845a67b4344611589b320e,ac1ade63dbf740f15e3ec8c4574f1822}'::text[]))
89. 0.003 0.246 ↓ 0.0 0 6 / 6

Bitmap Heap Scan on widget_part_hash_18 widget_part_hash_18_1 (cost=249.31..16,614.18 rows=5,650 width=33) (actual time=0.246..0.246 rows=0 loops=6)

  • Recheck Cond: ((campaign_id)::text = ANY ('{da3da707479185cb64d94bb4e6ecf490,d1dcb3b5ffe112e555fbdaa0b79241a8,c120838d777795ab2a47ac99a52f5b92,eb1d203d78a4f69282704c8ffbd97ea9,c7c0fd20e8d5ede3e300e28f3382c274,cb97a87ff64196b87179f7005cd758e2,c33001f76ffc53ad31c0f36990ff5f57,35de04d0d083965adb1e8f25e4c68077,7700a5048a845a67b4344611589b320e,ac1ade63dbf740f15e3ec8c4574f1822}'::text[]))
90. 0.243 0.243 ↓ 0.0 0 6 / 6

Bitmap Index Scan on widget_part_hash_18_campaign_id_idx (cost=0.00..247.90 rows=5,650 width=0) (actual time=0.243..0.243 rows=0 loops=6)

  • Index Cond: ((campaign_id)::text = ANY ('{da3da707479185cb64d94bb4e6ecf490,d1dcb3b5ffe112e555fbdaa0b79241a8,c120838d777795ab2a47ac99a52f5b92,eb1d203d78a4f69282704c8ffbd97ea9,c7c0fd20e8d5ede3e300e28f3382c274,cb97a87ff64196b87179f7005cd758e2,c33001f76ffc53ad31c0f36990ff5f57,35de04d0d083965adb1e8f25e4c68077,7700a5048a845a67b4344611589b320e,ac1ade63dbf740f15e3ec8c4574f1822}'::text[]))
91. 0.002 0.262 ↓ 0.0 0 6 / 6

Bitmap Heap Scan on widget_part_hash_19 widget_part_hash_19_1 (cost=615.39..45,278.93 rows=16,745 width=33) (actual time=0.262..0.262 rows=0 loops=6)

  • Recheck Cond: ((campaign_id)::text = ANY ('{da3da707479185cb64d94bb4e6ecf490,d1dcb3b5ffe112e555fbdaa0b79241a8,c120838d777795ab2a47ac99a52f5b92,eb1d203d78a4f69282704c8ffbd97ea9,c7c0fd20e8d5ede3e300e28f3382c274,cb97a87ff64196b87179f7005cd758e2,c33001f76ffc53ad31c0f36990ff5f57,35de04d0d083965adb1e8f25e4c68077,7700a5048a845a67b4344611589b320e,ac1ade63dbf740f15e3ec8c4574f1822}'::text[]))
92. 0.260 0.260 ↓ 0.0 0 6 / 6

Bitmap Index Scan on widget_part_hash_19_campaign_id_idx (cost=0.00..611.20 rows=16,745 width=0) (actual time=0.260..0.260 rows=0 loops=6)

  • Index Cond: ((campaign_id)::text = ANY ('{da3da707479185cb64d94bb4e6ecf490,d1dcb3b5ffe112e555fbdaa0b79241a8,c120838d777795ab2a47ac99a52f5b92,eb1d203d78a4f69282704c8ffbd97ea9,c7c0fd20e8d5ede3e300e28f3382c274,cb97a87ff64196b87179f7005cd758e2,c33001f76ffc53ad31c0f36990ff5f57,35de04d0d083965adb1e8f25e4c68077,7700a5048a845a67b4344611589b320e,ac1ade63dbf740f15e3ec8c4574f1822}'::text[]))
93. 361.956 53,621.196 ↑ 17.3 3 155,124 / 6

Append (cost=0.56..48.38 rows=52 width=69) (actual time=1.580..2.074 rows=3 loops=155,124)

94. 3,981.516 3,981.516 ↓ 0.0 0 155,124 / 6

Index Scan using widget_performance_20191104_20191111_widget_id_date_key on widget_performance_20191104_20191111 (cost=0.56..2.43 rows=1 width=69) (actual time=0.154..0.154 rows=0 loops=155,124)

  • Index Cond: (((widget_id)::text = (widget_part_hash_0_1.id)::text) AND (date >= '2019-11-10'::date) AND (date <= '2020-02-07'::date))
  • Filter: ((impressions > 0) OR (ts_clicks <> 0) OR (tr_conversions <> 0) OR (tr_clicks <> 0))
95. 4,421.034 4,421.034 ↓ 0.0 0 155,124 / 6

Index Scan using widget_performance_20191111_20191118_widget_id_idx on widget_performance_20191111_20191118 (cost=0.56..2.58 rows=4 width=69) (actual time=0.157..0.171 rows=0 loops=155,124)

  • Index Cond: ((widget_id)::text = (widget_part_hash_0_1.id)::text)
  • Filter: ((date >= '2019-11-10'::date) AND (date <= '2020-02-07'::date) AND ((impressions > 0) OR (ts_clicks <> 0) OR (tr_conversions <> 0) OR (tr_clicks <> 0)))
96. 4,472.742 4,472.742 ↓ 0.0 0 155,124 / 6

Index Scan using widget_performance_20191118_20191125_widget_id_idx on widget_performance_20191118_20191125 (cost=0.56..2.57 rows=4 width=69) (actual time=0.158..0.173 rows=0 loops=155,124)

  • Index Cond: ((widget_id)::text = (widget_part_hash_0_1.id)::text)
  • Filter: ((date >= '2019-11-10'::date) AND (date <= '2020-02-07'::date) AND ((impressions > 0) OR (ts_clicks <> 0) OR (tr_conversions <> 0) OR (tr_clicks <> 0)))
97. 4,136.640 4,136.640 ↓ 0.0 0 155,124 / 6

Index Scan using widget_performance_20191125_20191202_widget_id_idx on widget_performance_20191125_20191202 (cost=0.56..2.55 rows=4 width=69) (actual time=0.145..0.160 rows=0 loops=155,124)

  • Index Cond: ((widget_id)::text = (widget_part_hash_0_1.id)::text)
  • Filter: ((date >= '2019-11-10'::date) AND (date <= '2020-02-07'::date) AND ((impressions > 0) OR (ts_clicks <> 0) OR (tr_conversions <> 0) OR (tr_clicks <> 0)))
98. 4,602.012 4,602.012 ↓ 0.0 0 155,124 / 6

Index Scan using widget_performance_20191202_20191209_widget_id_idx on widget_performance_20191202_20191209 (cost=0.56..2.70 rows=4 width=69) (actual time=0.165..0.178 rows=0 loops=155,124)

  • Index Cond: ((widget_id)::text = (widget_part_hash_0_1.id)::text)
  • Filter: ((date >= '2019-11-10'::date) AND (date <= '2020-02-07'::date) AND ((impressions > 0) OR (ts_clicks <> 0) OR (tr_conversions <> 0) OR (tr_clicks <> 0)))
99. 4,912.260 4,912.260 ↓ 0.0 0 155,124 / 6

Index Scan using widget_performance_20191209_20191216_widget_id_idx on widget_performance_20191209_20191216 (cost=0.56..2.88 rows=4 width=69) (actual time=0.176..0.190 rows=0 loops=155,124)

  • Index Cond: ((widget_id)::text = (widget_part_hash_0_1.id)::text)
  • Filter: ((date >= '2019-11-10'::date) AND (date <= '2020-02-07'::date) AND ((impressions > 0) OR (ts_clicks <> 0) OR (tr_conversions <> 0) OR (tr_clicks <> 0)))
100. 4,214.202 4,214.202 ↓ 0.0 0 155,124 / 6

Index Scan using widget_performance_20191216_20191223_widget_id_idx on widget_performance_20191216_20191223 (cost=0.56..2.84 rows=4 width=69) (actual time=0.154..0.163 rows=0 loops=155,124)

  • Index Cond: ((widget_id)::text = (widget_part_hash_0_1.id)::text)
  • Filter: ((date >= '2019-11-10'::date) AND (date <= '2020-02-07'::date) AND ((impressions > 0) OR (ts_clicks <> 0) OR (tr_conversions <> 0) OR (tr_clicks <> 0)))
101. 4,576.158 4,576.158 ↓ 0.0 0 155,124 / 6

Index Scan using widget_performance_20191223_20191230_widget_id_idx on widget_performance_20191223_20191230 (cost=0.56..2.89 rows=4 width=69) (actual time=0.168..0.177 rows=0 loops=155,124)

  • Index Cond: ((widget_id)::text = (widget_part_hash_0_1.id)::text)
  • Filter: ((date >= '2019-11-10'::date) AND (date <= '2020-02-07'::date) AND ((impressions > 0) OR (ts_clicks <> 0) OR (tr_conversions <> 0) OR (tr_clicks <> 0)))
102. 5,558.610 5,558.610 ↓ 0.0 0 155,124 / 6

Index Scan using widget_performance_20191230_20200106_widget_id_date_key on widget_performance_20191230_20200106 (cost=0.56..3.49 rows=4 width=69) (actual time=0.197..0.215 rows=0 loops=155,124)

  • Index Cond: (((widget_id)::text = (widget_part_hash_0_1.id)::text) AND (date >= '2019-11-10'::date) AND (date <= '2020-02-07'::date))
  • Filter: ((impressions > 0) OR (ts_clicks <> 0) OR (tr_conversions <> 0) OR (tr_clicks <> 0))
103. 4,343.472 4,343.472 ↓ 0.0 0 155,124 / 6

Index Scan using widget_performance_20200106_20200113_widget_id_date_key on widget_performance_20200106_20200113 (cost=0.56..3.81 rows=4 width=69) (actual time=0.157..0.168 rows=0 loops=155,124)

  • Index Cond: (((widget_id)::text = (widget_part_hash_0_1.id)::text) AND (date >= '2019-11-10'::date) AND (date <= '2020-02-07'::date))
  • Filter: ((impressions > 0) OR (ts_clicks <> 0) OR (tr_conversions <> 0) OR (tr_clicks <> 0))
104. 2,818.086 2,818.086 ↓ 0.0 0 155,124 / 6

Index Scan using widget_performance_20200113_20200120_widget_id_date_key on widget_performance_20200113_20200120 (cost=0.56..4.20 rows=4 width=69) (actual time=0.096..0.109 rows=0 loops=155,124)

  • Index Cond: (((widget_id)::text = (widget_part_hash_0_1.id)::text) AND (date >= '2019-11-10'::date) AND (date <= '2020-02-07'::date))
  • Filter: ((impressions > 0) OR (ts_clicks <> 0) OR (tr_conversions <> 0) OR (tr_clicks <> 0))
105. 2,507.838 2,507.838 ↓ 0.0 0 155,124 / 6

Index Scan using widget_performance_20200120_20200127_widget_id_date_key on widget_performance_20200120_20200127 (cost=0.56..4.48 rows=4 width=69) (actual time=0.081..0.097 rows=0 loops=155,124)

  • Index Cond: (((widget_id)::text = (widget_part_hash_0_1.id)::text) AND (date >= '2019-11-10'::date) AND (date <= '2020-02-07'::date))
  • Filter: ((impressions > 0) OR (ts_clicks <> 0) OR (tr_conversions <> 0) OR (tr_clicks <> 0))
106. 2,223.444 2,223.444 ↓ 0.0 0 155,124 / 6

Index Scan using widget_performance_20200127_20200203_widget_id_date_key on widget_performance_20200127_20200203 (cost=0.56..4.95 rows=4 width=69) (actual time=0.084..0.086 rows=0 loops=155,124)

  • Index Cond: (((widget_id)::text = (widget_part_hash_0_1.id)::text) AND (date >= '2019-11-10'::date) AND (date <= '2020-02-07'::date))
  • Filter: ((impressions > 0) OR (ts_clicks <> 0) OR (tr_conversions <> 0) OR (tr_clicks <> 0))
107. 491.226 491.226 ↓ 0.0 0 155,124 / 6

Index Scan using widget_performance_20200203_20200210_widget_id_date_key on widget_performance_20200203_20200210 (cost=0.56..5.74 rows=3 width=69) (actual time=0.019..0.019 rows=0 loops=155,124)

  • Index Cond: (((widget_id)::text = (widget_part_hash_0_1.id)::text) AND (date >= '2019-11-10'::date) AND (date <= '2020-02-07'::date))
  • Filter: ((impressions > 0) OR (ts_clicks <> 0) OR (tr_conversions <> 0) OR (tr_clicks <> 0))
108. 0.725 1,417.742 ↑ 230.5 872 6 / 6

Hash (cost=995,565.50..995,565.50 rows=201,037 width=165) (actual time=1,417.742..1,417.742 rows=872 loops=6)

  • Buckets: 262144 Batches: 1 Memory Usage: 2220kB
109. 0.214 1,417.017 ↑ 230.5 872 6 / 6

Subquery Scan on gp (cost=847,838.68..995,565.50 rows=201,037 width=165) (actual time=1,413.543..1,417.017 rows=872 loops=6)

110. 3.214 1,416.803 ↑ 230.5 872 6 / 6

GroupAggregate (cost=847,838.68..993,555.13 rows=201,037 width=165) (actual time=1,413.536..1,416.803 rows=872 loops=6)

  • Group Key: widget_performance_ga.widget_id
111. 5.181 1,413.589 ↑ 767.7 2,023 6 / 6

Sort (cost=847,838.68..851,721.27 rows=1,553,039 width=157) (actual time=1,413.455..1,413.589 rows=2,023 loops=6)

  • Sort Key: widget_performance_ga.widget_id
  • Sort Method: quicksort Memory: 586kB
  • Worker 0: Sort Method: quicksort Memory: 586kB
  • Worker 1: Sort Method: quicksort Memory: 586kB
  • Worker 2: Sort Method: quicksort Memory: 586kB
  • Worker 3: Sort Method: quicksort Memory: 586kB
  • Worker 4: Sort Method: quicksort Memory: 586kB
112. 21.088 1,408.408 ↑ 767.7 2,023 6 / 6

Nested Loop (cost=553,138.11..566,044.03 rows=1,553,039 width=157) (actual time=52.466..1,408.408 rows=2,023 loops=6)

113. 34.937 68.766 ↓ 129.3 25,854 6 / 6

HashAggregate (cost=553,137.55..553,139.55 rows=200 width=33) (actual time=48.586..68.766 rows=25,854 loops=6)

  • Group Key: (widget_part_hash_0_2.id)::text
114. 2.383 33.829 ↑ 8.0 25,854 6 / 6

Result (cost=593.07..552,623.26 rows=205,716 width=33) (actual time=5.837..33.829 rows=25,854 loops=6)

115. 1.843 31.446 ↑ 8.0 25,854 6 / 6

Append (cost=593.07..552,623.26 rows=205,716 width=33) (actual time=5.833..31.446 rows=25,854 loops=6)

116. 0.006 0.114 ↓ 0.0 0 6 / 6

Bitmap Heap Scan on widget_part_hash_0 widget_part_hash_0_2 (cost=593.07..40,073.84 rows=13,875 width=33) (actual time=0.114..0.114 rows=0 loops=6)

  • Recheck Cond: ((campaign_id)::text = ANY ('{da3da707479185cb64d94bb4e6ecf490,d1dcb3b5ffe112e555fbdaa0b79241a8,c120838d777795ab2a47ac99a52f5b92,eb1d203d78a4f69282704c8ffbd97ea9,c7c0fd20e8d5ede3e300e28f3382c274,cb97a87ff64196b87179f7005cd758e2,c33001f76ffc53ad31c0f36990ff5f57,35de04d0d083965adb1e8f25e4c68077,7700a5048a845a67b4344611589b320e,ac1ade63dbf740f15e3ec8c4574f1822}'::text[]))
117. 0.108 0.108 ↓ 0.0 0 6 / 6

Bitmap Index Scan on widget_part_hash_0_campaign_id_idx (cost=0.00..589.60 rows=13,875 width=0) (actual time=0.107..0.108 rows=0 loops=6)

  • Index Cond: ((campaign_id)::text = ANY ('{da3da707479185cb64d94bb4e6ecf490,d1dcb3b5ffe112e555fbdaa0b79241a8,c120838d777795ab2a47ac99a52f5b92,eb1d203d78a4f69282704c8ffbd97ea9,c7c0fd20e8d5ede3e300e28f3382c274,cb97a87ff64196b87179f7005cd758e2,c33001f76ffc53ad31c0f36990ff5f57,35de04d0d083965adb1e8f25e4c68077,7700a5048a845a67b4344611589b320e,ac1ade63dbf740f15e3ec8c4574f1822}'::text[]))
118. 0.003 0.097 ↓ 0.0 0 6 / 6

Bitmap Heap Scan on widget_part_hash_1 widget_part_hash_1_2 (cost=242.75..15,748.15 rows=4,800 width=33) (actual time=0.097..0.097 rows=0 loops=6)

  • Recheck Cond: ((campaign_id)::text = ANY ('{da3da707479185cb64d94bb4e6ecf490,d1dcb3b5ffe112e555fbdaa0b79241a8,c120838d777795ab2a47ac99a52f5b92,eb1d203d78a4f69282704c8ffbd97ea9,c7c0fd20e8d5ede3e300e28f3382c274,cb97a87ff64196b87179f7005cd758e2,c33001f76ffc53ad31c0f36990ff5f57,35de04d0d083965adb1e8f25e4c68077,7700a5048a845a67b4344611589b320e,ac1ade63dbf740f15e3ec8c4574f1822}'::text[]))
119. 0.094 0.094 ↓ 0.0 0 6 / 6

Bitmap Index Scan on widget_part_hash_1_campaign_id_idx (cost=0.00..241.55 rows=4,800 width=0) (actual time=0.094..0.094 rows=0 loops=6)

  • Index Cond: ((campaign_id)::text = ANY ('{da3da707479185cb64d94bb4e6ecf490,d1dcb3b5ffe112e555fbdaa0b79241a8,c120838d777795ab2a47ac99a52f5b92,eb1d203d78a4f69282704c8ffbd97ea9,c7c0fd20e8d5ede3e300e28f3382c274,cb97a87ff64196b87179f7005cd758e2,c33001f76ffc53ad31c0f36990ff5f57,35de04d0d083965adb1e8f25e4c68077,7700a5048a845a67b4344611589b320e,ac1ade63dbf740f15e3ec8c4574f1822}'::text[]))
120. 0.006 0.099 ↓ 0.0 0 6 / 6

Bitmap Heap Scan on widget_part_hash_2 widget_part_hash_2_2 (cost=452.50..32,103.93 rows=11,220 width=33) (actual time=0.099..0.099 rows=0 loops=6)

  • Recheck Cond: ((campaign_id)::text = ANY ('{da3da707479185cb64d94bb4e6ecf490,d1dcb3b5ffe112e555fbdaa0b79241a8,c120838d777795ab2a47ac99a52f5b92,eb1d203d78a4f69282704c8ffbd97ea9,c7c0fd20e8d5ede3e300e28f3382c274,cb97a87ff64196b87179f7005cd758e2,c33001f76ffc53ad31c0f36990ff5f57,35de04d0d083965adb1e8f25e4c68077,7700a5048a845a67b4344611589b320e,ac1ade63dbf740f15e3ec8c4574f1822}'::text[]))
121. 0.093 0.093 ↓ 0.0 0 6 / 6

Bitmap Index Scan on widget_part_hash_2_campaign_id_idx (cost=0.00..449.70 rows=11,220 width=0) (actual time=0.093..0.093 rows=0 loops=6)

  • Index Cond: ((campaign_id)::text = ANY ('{da3da707479185cb64d94bb4e6ecf490,d1dcb3b5ffe112e555fbdaa0b79241a8,c120838d777795ab2a47ac99a52f5b92,eb1d203d78a4f69282704c8ffbd97ea9,c7c0fd20e8d5ede3e300e28f3382c274,cb97a87ff64196b87179f7005cd758e2,c33001f76ffc53ad31c0f36990ff5f57,35de04d0d083965adb1e8f25e4c68077,7700a5048a845a67b4344611589b320e,ac1ade63dbf740f15e3ec8c4574f1822}'::text[]))
122. 0.003 0.084 ↓ 0.0 0 6 / 6

Bitmap Heap Scan on widget_part_hash_3 widget_part_hash_3_2 (cost=339.54..19,498.32 rows=6,967 width=33) (actual time=0.084..0.084 rows=0 loops=6)

  • Recheck Cond: ((campaign_id)::text = ANY ('{da3da707479185cb64d94bb4e6ecf490,d1dcb3b5ffe112e555fbdaa0b79241a8,c120838d777795ab2a47ac99a52f5b92,eb1d203d78a4f69282704c8ffbd97ea9,c7c0fd20e8d5ede3e300e28f3382c274,cb97a87ff64196b87179f7005cd758e2,c33001f76ffc53ad31c0f36990ff5f57,35de04d0d083965adb1e8f25e4c68077,7700a5048a845a67b4344611589b320e,ac1ade63dbf740f15e3ec8c4574f1822}'::text[]))
123. 0.081 0.081 ↓ 0.0 0 6 / 6

Bitmap Index Scan on widget_part_hash_3_campaign_id_idx (cost=0.00..337.80 rows=6,967 width=0) (actual time=0.080..0.081 rows=0 loops=6)

  • Index Cond: ((campaign_id)::text = ANY ('{da3da707479185cb64d94bb4e6ecf490,d1dcb3b5ffe112e555fbdaa0b79241a8,c120838d777795ab2a47ac99a52f5b92,eb1d203d78a4f69282704c8ffbd97ea9,c7c0fd20e8d5ede3e300e28f3382c274,cb97a87ff64196b87179f7005cd758e2,c33001f76ffc53ad31c0f36990ff5f57,35de04d0d083965adb1e8f25e4c68077,7700a5048a845a67b4344611589b320e,ac1ade63dbf740f15e3ec8c4574f1822}'::text[]))
124. 0.001 0.085 ↓ 0.0 0 6 / 6

Bitmap Heap Scan on widget_part_hash_4 widget_part_hash_4_2 (cost=458.24..28,981.22 rows=11,958 width=33) (actual time=0.085..0.085 rows=0 loops=6)

  • Recheck Cond: ((campaign_id)::text = ANY ('{da3da707479185cb64d94bb4e6ecf490,d1dcb3b5ffe112e555fbdaa0b79241a8,c120838d777795ab2a47ac99a52f5b92,eb1d203d78a4f69282704c8ffbd97ea9,c7c0fd20e8d5ede3e300e28f3382c274,cb97a87ff64196b87179f7005cd758e2,c33001f76ffc53ad31c0f36990ff5f57,35de04d0d083965adb1e8f25e4c68077,7700a5048a845a67b4344611589b320e,ac1ade63dbf740f15e3ec8c4574f1822}'::text[]))
125. 0.084 0.084 ↓ 0.0 0 6 / 6

Bitmap Index Scan on widget_part_hash_4_campaign_id_idx (cost=0.00..455.25 rows=11,958 width=0) (actual time=0.084..0.084 rows=0 loops=6)

  • Index Cond: ((campaign_id)::text = ANY ('{da3da707479185cb64d94bb4e6ecf490,d1dcb3b5ffe112e555fbdaa0b79241a8,c120838d777795ab2a47ac99a52f5b92,eb1d203d78a4f69282704c8ffbd97ea9,c7c0fd20e8d5ede3e300e28f3382c274,cb97a87ff64196b87179f7005cd758e2,c33001f76ffc53ad31c0f36990ff5f57,35de04d0d083965adb1e8f25e4c68077,7700a5048a845a67b4344611589b320e,ac1ade63dbf740f15e3ec8c4574f1822}'::text[]))
126. 23.229 27.385 ↓ 1.1 25,854 6 / 6

Bitmap Heap Scan on widget_part_hash_5 widget_part_hash_5_2 (cost=908.60..45,955.60 rows=23,615 width=33) (actual time=5.341..27.385 rows=25,854 loops=6)

  • Recheck Cond: ((campaign_id)::text = ANY ('{da3da707479185cb64d94bb4e6ecf490,d1dcb3b5ffe112e555fbdaa0b79241a8,c120838d777795ab2a47ac99a52f5b92,eb1d203d78a4f69282704c8ffbd97ea9,c7c0fd20e8d5ede3e300e28f3382c274,cb97a87ff64196b87179f7005cd758e2,c33001f76ffc53ad31c0f36990ff5f57,35de04d0d083965adb1e8f25e4c68077,7700a5048a845a67b4344611589b320e,ac1ade63dbf740f15e3ec8c4574f1822}'::text[]))
  • Heap Blocks: exact=7019
127. 4.156 4.156 ↓ 1.3 30,059 6 / 6

Bitmap Index Scan on widget_part_hash_5_campaign_id_idx (cost=0.00..902.70 rows=23,615 width=0) (actual time=4.156..4.156 rows=30,059 loops=6)

  • Index Cond: ((campaign_id)::text = ANY ('{da3da707479185cb64d94bb4e6ecf490,d1dcb3b5ffe112e555fbdaa0b79241a8,c120838d777795ab2a47ac99a52f5b92,eb1d203d78a4f69282704c8ffbd97ea9,c7c0fd20e8d5ede3e300e28f3382c274,cb97a87ff64196b87179f7005cd758e2,c33001f76ffc53ad31c0f36990ff5f57,35de04d0d083965adb1e8f25e4c68077,7700a5048a845a67b4344611589b320e,ac1ade63dbf740f15e3ec8c4574f1822}'::text[]))
128. 0.004 0.122 ↓ 0.0 0 6 / 6

Bitmap Heap Scan on widget_part_hash_6 widget_part_hash_6_2 (cost=292.64..15,879.37 rows=6,244 width=33) (actual time=0.122..0.122 rows=0 loops=6)

  • Recheck Cond: ((campaign_id)::text = ANY ('{da3da707479185cb64d94bb4e6ecf490,d1dcb3b5ffe112e555fbdaa0b79241a8,c120838d777795ab2a47ac99a52f5b92,eb1d203d78a4f69282704c8ffbd97ea9,c7c0fd20e8d5ede3e300e28f3382c274,cb97a87ff64196b87179f7005cd758e2,c33001f76ffc53ad31c0f36990ff5f57,35de04d0d083965adb1e8f25e4c68077,7700a5048a845a67b4344611589b320e,ac1ade63dbf740f15e3ec8c4574f1822}'::text[]))
129. 0.118 0.118 ↓ 0.0 0 6 / 6

Bitmap Index Scan on widget_part_hash_6_campaign_id_idx (cost=0.00..291.07 rows=6,244 width=0) (actual time=0.118..0.118 rows=0 loops=6)

  • Index Cond: ((campaign_id)::text = ANY ('{da3da707479185cb64d94bb4e6ecf490,d1dcb3b5ffe112e555fbdaa0b79241a8,c120838d777795ab2a47ac99a52f5b92,eb1d203d78a4f69282704c8ffbd97ea9,c7c0fd20e8d5ede3e300e28f3382c274,cb97a87ff64196b87179f7005cd758e2,c33001f76ffc53ad31c0f36990ff5f57,35de04d0d083965adb1e8f25e4c68077,7700a5048a845a67b4344611589b320e,ac1ade63dbf740f15e3ec8c4574f1822}'::text[]))
130. 0.003 0.129 ↓ 0.0 0 6 / 6

Bitmap Heap Scan on widget_part_hash_7 widget_part_hash_7_2 (cost=150.56..10,325.88 rows=3,231 width=33) (actual time=0.129..0.129 rows=0 loops=6)

  • Recheck Cond: ((campaign_id)::text = ANY ('{da3da707479185cb64d94bb4e6ecf490,d1dcb3b5ffe112e555fbdaa0b79241a8,c120838d777795ab2a47ac99a52f5b92,eb1d203d78a4f69282704c8ffbd97ea9,c7c0fd20e8d5ede3e300e28f3382c274,cb97a87ff64196b87179f7005cd758e2,c33001f76ffc53ad31c0f36990ff5f57,35de04d0d083965adb1e8f25e4c68077,7700a5048a845a67b4344611589b320e,ac1ade63dbf740f15e3ec8c4574f1822}'::text[]))
131. 0.126 0.126 ↓ 0.0 0 6 / 6

Bitmap Index Scan on widget_part_hash_7_campaign_id_idx (cost=0.00..149.75 rows=3,231 width=0) (actual time=0.126..0.126 rows=0 loops=6)

  • Index Cond: ((campaign_id)::text = ANY ('{da3da707479185cb64d94bb4e6ecf490,d1dcb3b5ffe112e555fbdaa0b79241a8,c120838d777795ab2a47ac99a52f5b92,eb1d203d78a4f69282704c8ffbd97ea9,c7c0fd20e8d5ede3e300e28f3382c274,cb97a87ff64196b87179f7005cd758e2,c33001f76ffc53ad31c0f36990ff5f57,35de04d0d083965adb1e8f25e4c68077,7700a5048a845a67b4344611589b320e,ac1ade63dbf740f15e3ec8c4574f1822}'::text[]))
132. 0.003 0.112 ↓ 0.0 0 6 / 6

Bitmap Heap Scan on widget_part_hash_8 widget_part_hash_8_2 (cost=248.14..15,918.72 rows=5,662 width=33) (actual time=0.112..0.112 rows=0 loops=6)

  • Recheck Cond: ((campaign_id)::text = ANY ('{da3da707479185cb64d94bb4e6ecf490,d1dcb3b5ffe112e555fbdaa0b79241a8,c120838d777795ab2a47ac99a52f5b92,eb1d203d78a4f69282704c8ffbd97ea9,c7c0fd20e8d5ede3e300e28f3382c274,cb97a87ff64196b87179f7005cd758e2,c33001f76ffc53ad31c0f36990ff5f57,35de04d0d083965adb1e8f25e4c68077,7700a5048a845a67b4344611589b320e,ac1ade63dbf740f15e3ec8c4574f1822}'::text[]))
133. 0.109 0.109 ↓ 0.0 0 6 / 6

Bitmap Index Scan on widget_part_hash_8_campaign_id_idx (cost=0.00..246.72 rows=5,662 width=0) (actual time=0.109..0.109 rows=0 loops=6)

  • Index Cond: ((campaign_id)::text = ANY ('{da3da707479185cb64d94bb4e6ecf490,d1dcb3b5ffe112e555fbdaa0b79241a8,c120838d777795ab2a47ac99a52f5b92,eb1d203d78a4f69282704c8ffbd97ea9,c7c0fd20e8d5ede3e300e28f3382c274,cb97a87ff64196b87179f7005cd758e2,c33001f76ffc53ad31c0f36990ff5f57,35de04d0d083965adb1e8f25e4c68077,7700a5048a845a67b4344611589b320e,ac1ade63dbf740f15e3ec8c4574f1822}'::text[]))
134. 0.002 0.134 ↓ 0.0 0 6 / 6

Bitmap Heap Scan on widget_part_hash_9 widget_part_hash_9_2 (cost=547.41..38,986.16 rows=13,139 width=33) (actual time=0.134..0.134 rows=0 loops=6)

  • Recheck Cond: ((campaign_id)::text = ANY ('{da3da707479185cb64d94bb4e6ecf490,d1dcb3b5ffe112e555fbdaa0b79241a8,c120838d777795ab2a47ac99a52f5b92,eb1d203d78a4f69282704c8ffbd97ea9,c7c0fd20e8d5ede3e300e28f3382c274,cb97a87ff64196b87179f7005cd758e2,c33001f76ffc53ad31c0f36990ff5f57,35de04d0d083965adb1e8f25e4c68077,7700a5048a845a67b4344611589b320e,ac1ade63dbf740f15e3ec8c4574f1822}'::text[]))
135. 0.132 0.132 ↓ 0.0 0 6 / 6

Bitmap Index Scan on widget_part_hash_9_campaign_id_idx (cost=0.00..544.12 rows=13,139 width=0) (actual time=0.132..0.132 rows=0 loops=6)

  • Index Cond: ((campaign_id)::text = ANY ('{da3da707479185cb64d94bb4e6ecf490,d1dcb3b5ffe112e555fbdaa0b79241a8,c120838d777795ab2a47ac99a52f5b92,eb1d203d78a4f69282704c8ffbd97ea9,c7c0fd20e8d5ede3e300e28f3382c274,cb97a87ff64196b87179f7005cd758e2,c33001f76ffc53ad31c0f36990ff5f57,35de04d0d083965adb1e8f25e4c68077,7700a5048a845a67b4344611589b320e,ac1ade63dbf740f15e3ec8c4574f1822}'::text[]))
136. 0.001 0.144 ↓ 0.0 0 6 / 6

Bitmap Heap Scan on widget_part_hash_10 widget_part_hash_10_2 (cost=759.95..55,720.88 rows=19,917 width=33) (actual time=0.144..0.144 rows=0 loops=6)

  • Recheck Cond: ((campaign_id)::text = ANY ('{da3da707479185cb64d94bb4e6ecf490,d1dcb3b5ffe112e555fbdaa0b79241a8,c120838d777795ab2a47ac99a52f5b92,eb1d203d78a4f69282704c8ffbd97ea9,c7c0fd20e8d5ede3e300e28f3382c274,cb97a87ff64196b87179f7005cd758e2,c33001f76ffc53ad31c0f36990ff5f57,35de04d0d083965adb1e8f25e4c68077,7700a5048a845a67b4344611589b320e,ac1ade63dbf740f15e3ec8c4574f1822}'::text[]))
137. 0.143 0.143 ↓ 0.0 0 6 / 6

Bitmap Index Scan on widget_part_hash_10_campaign_id_idx (cost=0.00..754.98 rows=19,917 width=0) (actual time=0.143..0.143 rows=0 loops=6)

  • Index Cond: ((campaign_id)::text = ANY ('{da3da707479185cb64d94bb4e6ecf490,d1dcb3b5ffe112e555fbdaa0b79241a8,c120838d777795ab2a47ac99a52f5b92,eb1d203d78a4f69282704c8ffbd97ea9,c7c0fd20e8d5ede3e300e28f3382c274,cb97a87ff64196b87179f7005cd758e2,c33001f76ffc53ad31c0f36990ff5f57,35de04d0d083965adb1e8f25e4c68077,7700a5048a845a67b4344611589b320e,ac1ade63dbf740f15e3ec8c4574f1822}'::text[]))
138. 0.005 0.117 ↓ 0.0 0 6 / 6

Bitmap Heap Scan on widget_part_hash_11 widget_part_hash_11_2 (cost=390.07..21,010.49 rows=8,495 width=33) (actual time=0.117..0.117 rows=0 loops=6)

  • Recheck Cond: ((campaign_id)::text = ANY ('{da3da707479185cb64d94bb4e6ecf490,d1dcb3b5ffe112e555fbdaa0b79241a8,c120838d777795ab2a47ac99a52f5b92,eb1d203d78a4f69282704c8ffbd97ea9,c7c0fd20e8d5ede3e300e28f3382c274,cb97a87ff64196b87179f7005cd758e2,c33001f76ffc53ad31c0f36990ff5f57,35de04d0d083965adb1e8f25e4c68077,7700a5048a845a67b4344611589b320e,ac1ade63dbf740f15e3ec8c4574f1822}'::text[]))
139. 0.112 0.112 ↓ 0.0 0 6 / 6

Bitmap Index Scan on widget_part_hash_11_campaign_id_idx (cost=0.00..387.95 rows=8,495 width=0) (actual time=0.112..0.112 rows=0 loops=6)

  • Index Cond: ((campaign_id)::text = ANY ('{da3da707479185cb64d94bb4e6ecf490,d1dcb3b5ffe112e555fbdaa0b79241a8,c120838d777795ab2a47ac99a52f5b92,eb1d203d78a4f69282704c8ffbd97ea9,c7c0fd20e8d5ede3e300e28f3382c274,cb97a87ff64196b87179f7005cd758e2,c33001f76ffc53ad31c0f36990ff5f57,35de04d0d083965adb1e8f25e4c68077,7700a5048a845a67b4344611589b320e,ac1ade63dbf740f15e3ec8c4574f1822}'::text[]))
140. 0.003 0.108 ↓ 0.0 0 6 / 6

Bitmap Heap Scan on widget_part_hash_12 widget_part_hash_12_2 (cost=299.69..18,322.06 rows=7,155 width=33) (actual time=0.107..0.108 rows=0 loops=6)

  • Recheck Cond: ((campaign_id)::text = ANY ('{da3da707479185cb64d94bb4e6ecf490,d1dcb3b5ffe112e555fbdaa0b79241a8,c120838d777795ab2a47ac99a52f5b92,eb1d203d78a4f69282704c8ffbd97ea9,c7c0fd20e8d5ede3e300e28f3382c274,cb97a87ff64196b87179f7005cd758e2,c33001f76ffc53ad31c0f36990ff5f57,35de04d0d083965adb1e8f25e4c68077,7700a5048a845a67b4344611589b320e,ac1ade63dbf740f15e3ec8c4574f1822}'::text[]))
141. 0.105 0.105 ↓ 0.0 0 6 / 6

Bitmap Index Scan on widget_part_hash_12_campaign_id_idx (cost=0.00..297.90 rows=7,155 width=0) (actual time=0.105..0.105 rows=0 loops=6)

  • Index Cond: ((campaign_id)::text = ANY ('{da3da707479185cb64d94bb4e6ecf490,d1dcb3b5ffe112e555fbdaa0b79241a8,c120838d777795ab2a47ac99a52f5b92,eb1d203d78a4f69282704c8ffbd97ea9,c7c0fd20e8d5ede3e300e28f3382c274,cb97a87ff64196b87179f7005cd758e2,c33001f76ffc53ad31c0f36990ff5f57,35de04d0d083965adb1e8f25e4c68077,7700a5048a845a67b4344611589b320e,ac1ade63dbf740f15e3ec8c4574f1822}'::text[]))
142. 0.006 0.141 ↓ 0.0 0 6 / 6

Bitmap Heap Scan on widget_part_hash_13 widget_part_hash_13_2 (cost=248.33..18,034.51 rows=5,522 width=33) (actual time=0.141..0.141 rows=0 loops=6)

  • Recheck Cond: ((campaign_id)::text = ANY ('{da3da707479185cb64d94bb4e6ecf490,d1dcb3b5ffe112e555fbdaa0b79241a8,c120838d777795ab2a47ac99a52f5b92,eb1d203d78a4f69282704c8ffbd97ea9,c7c0fd20e8d5ede3e300e28f3382c274,cb97a87ff64196b87179f7005cd758e2,c33001f76ffc53ad31c0f36990ff5f57,35de04d0d083965adb1e8f25e4c68077,7700a5048a845a67b4344611589b320e,ac1ade63dbf740f15e3ec8c4574f1822}'::text[]))
143. 0.135 0.135 ↓ 0.0 0 6 / 6

Bitmap Index Scan on widget_part_hash_13_campaign_id_idx (cost=0.00..246.95 rows=5,522 width=0) (actual time=0.135..0.135 rows=0 loops=6)

  • Index Cond: ((campaign_id)::text = ANY ('{da3da707479185cb64d94bb4e6ecf490,d1dcb3b5ffe112e555fbdaa0b79241a8,c120838d777795ab2a47ac99a52f5b92,eb1d203d78a4f69282704c8ffbd97ea9,c7c0fd20e8d5ede3e300e28f3382c274,cb97a87ff64196b87179f7005cd758e2,c33001f76ffc53ad31c0f36990ff5f57,35de04d0d083965adb1e8f25e4c68077,7700a5048a845a67b4344611589b320e,ac1ade63dbf740f15e3ec8c4574f1822}'::text[]))
144. 0.001 0.126 ↓ 0.0 0 6 / 6

Bitmap Heap Scan on widget_part_hash_14 widget_part_hash_14_2 (cost=611.28..47,334.96 rows=16,220 width=33) (actual time=0.126..0.126 rows=0 loops=6)

  • Recheck Cond: ((campaign_id)::text = ANY ('{da3da707479185cb64d94bb4e6ecf490,d1dcb3b5ffe112e555fbdaa0b79241a8,c120838d777795ab2a47ac99a52f5b92,eb1d203d78a4f69282704c8ffbd97ea9,c7c0fd20e8d5ede3e300e28f3382c274,cb97a87ff64196b87179f7005cd758e2,c33001f76ffc53ad31c0f36990ff5f57,35de04d0d083965adb1e8f25e4c68077,7700a5048a845a67b4344611589b320e,ac1ade63dbf740f15e3ec8c4574f1822}'::text[]))
145. 0.125 0.125 ↓ 0.0 0 6 / 6

Bitmap Index Scan on widget_part_hash_14_campaign_id_idx (cost=0.00..607.23 rows=16,220 width=0) (actual time=0.125..0.125 rows=0 loops=6)

  • Index Cond: ((campaign_id)::text = ANY ('{da3da707479185cb64d94bb4e6ecf490,d1dcb3b5ffe112e555fbdaa0b79241a8,c120838d777795ab2a47ac99a52f5b92,eb1d203d78a4f69282704c8ffbd97ea9,c7c0fd20e8d5ede3e300e28f3382c274,cb97a87ff64196b87179f7005cd758e2,c33001f76ffc53ad31c0f36990ff5f57,35de04d0d083965adb1e8f25e4c68077,7700a5048a845a67b4344611589b320e,ac1ade63dbf740f15e3ec8c4574f1822}'::text[]))
146. 0.002 0.103 ↓ 0.0 0 6 / 6

Bitmap Heap Scan on widget_part_hash_15 widget_part_hash_15_2 (cost=241.91..10,761.56 rows=4,860 width=33) (actual time=0.102..0.103 rows=0 loops=6)

  • Recheck Cond: ((campaign_id)::text = ANY ('{da3da707479185cb64d94bb4e6ecf490,d1dcb3b5ffe112e555fbdaa0b79241a8,c120838d777795ab2a47ac99a52f5b92,eb1d203d78a4f69282704c8ffbd97ea9,c7c0fd20e8d5ede3e300e28f3382c274,cb97a87ff64196b87179f7005cd758e2,c33001f76ffc53ad31c0f36990ff5f57,35de04d0d083965adb1e8f25e4c68077,7700a5048a845a67b4344611589b320e,ac1ade63dbf740f15e3ec8c4574f1822}'::text[]))
147. 0.101 0.101 ↓ 0.0 0 6 / 6

Bitmap Index Scan on widget_part_hash_15_campaign_id_idx (cost=0.00..240.70 rows=4,860 width=0) (actual time=0.101..0.101 rows=0 loops=6)

  • Index Cond: ((campaign_id)::text = ANY ('{da3da707479185cb64d94bb4e6ecf490,d1dcb3b5ffe112e555fbdaa0b79241a8,c120838d777795ab2a47ac99a52f5b92,eb1d203d78a4f69282704c8ffbd97ea9,c7c0fd20e8d5ede3e300e28f3382c274,cb97a87ff64196b87179f7005cd758e2,c33001f76ffc53ad31c0f36990ff5f57,35de04d0d083965adb1e8f25e4c68077,7700a5048a845a67b4344611589b320e,ac1ade63dbf740f15e3ec8c4574f1822}'::text[]))
148. 0.004 0.127 ↓ 0.0 0 6 / 6

Bitmap Heap Scan on widget_part_hash_16 widget_part_hash_16_2 (cost=431.66..23,409.50 rows=8,528 width=33) (actual time=0.127..0.127 rows=0 loops=6)

  • Recheck Cond: ((campaign_id)::text = ANY ('{da3da707479185cb64d94bb4e6ecf490,d1dcb3b5ffe112e555fbdaa0b79241a8,c120838d777795ab2a47ac99a52f5b92,eb1d203d78a4f69282704c8ffbd97ea9,c7c0fd20e8d5ede3e300e28f3382c274,cb97a87ff64196b87179f7005cd758e2,c33001f76ffc53ad31c0f36990ff5f57,35de04d0d083965adb1e8f25e4c68077,7700a5048a845a67b4344611589b320e,ac1ade63dbf740f15e3ec8c4574f1822}'::text[]))
149. 0.123 0.123 ↓ 0.0 0 6 / 6

Bitmap Index Scan on widget_part_hash_16_campaign_id_idx (cost=0.00..429.53 rows=8,528 width=0) (actual time=0.123..0.123 rows=0 loops=6)

  • Index Cond: ((campaign_id)::text = ANY ('{da3da707479185cb64d94bb4e6ecf490,d1dcb3b5ffe112e555fbdaa0b79241a8,c120838d777795ab2a47ac99a52f5b92,eb1d203d78a4f69282704c8ffbd97ea9,c7c0fd20e8d5ede3e300e28f3382c274,cb97a87ff64196b87179f7005cd758e2,c33001f76ffc53ad31c0f36990ff5f57,35de04d0d083965adb1e8f25e4c68077,7700a5048a845a67b4344611589b320e,ac1ade63dbf740f15e3ec8c4574f1822}'::text[]))
150. 0.002 0.121 ↓ 0.0 0 6 / 6

Bitmap Heap Scan on widget_part_hash_17 widget_part_hash_17_2 (cost=457.85..31,636.42 rows=11,913 width=33) (actual time=0.121..0.121 rows=0 loops=6)

  • Recheck Cond: ((campaign_id)::text = ANY ('{da3da707479185cb64d94bb4e6ecf490,d1dcb3b5ffe112e555fbdaa0b79241a8,c120838d777795ab2a47ac99a52f5b92,eb1d203d78a4f69282704c8ffbd97ea9,c7c0fd20e8d5ede3e300e28f3382c274,cb97a87ff64196b87179f7005cd758e2,c33001f76ffc53ad31c0f36990ff5f57,35de04d0d083965adb1e8f25e4c68077,7700a5048a845a67b4344611589b320e,ac1ade63dbf740f15e3ec8c4574f1822}'::text[]))
151. 0.119 0.119 ↓ 0.0 0 6 / 6

Bitmap Index Scan on widget_part_hash_17_campaign_id_idx (cost=0.00..454.88 rows=11,913 width=0) (actual time=0.119..0.119 rows=0 loops=6)

  • Index Cond: ((campaign_id)::text = ANY ('{da3da707479185cb64d94bb4e6ecf490,d1dcb3b5ffe112e555fbdaa0b79241a8,c120838d777795ab2a47ac99a52f5b92,eb1d203d78a4f69282704c8ffbd97ea9,c7c0fd20e8d5ede3e300e28f3382c274,cb97a87ff64196b87179f7005cd758e2,c33001f76ffc53ad31c0f36990ff5f57,35de04d0d083965adb1e8f25e4c68077,7700a5048a845a67b4344611589b320e,ac1ade63dbf740f15e3ec8c4574f1822}'::text[]))
152. 0.004 0.127 ↓ 0.0 0 6 / 6

Bitmap Heap Scan on widget_part_hash_18 widget_part_hash_18_2 (cost=249.31..16,614.18 rows=5,650 width=33) (actual time=0.127..0.127 rows=0 loops=6)

  • Recheck Cond: ((campaign_id)::text = ANY ('{da3da707479185cb64d94bb4e6ecf490,d1dcb3b5ffe112e555fbdaa0b79241a8,c120838d777795ab2a47ac99a52f5b92,eb1d203d78a4f69282704c8ffbd97ea9,c7c0fd20e8d5ede3e300e28f3382c274,cb97a87ff64196b87179f7005cd758e2,c33001f76ffc53ad31c0f36990ff5f57,35de04d0d083965adb1e8f25e4c68077,7700a5048a845a67b4344611589b320e,ac1ade63dbf740f15e3ec8c4574f1822}'::text[]))
153. 0.123 0.123 ↓ 0.0 0 6 / 6

Bitmap Index Scan on widget_part_hash_18_campaign_id_idx (cost=0.00..247.90 rows=5,650 width=0) (actual time=0.122..0.123 rows=0 loops=6)

  • Index Cond: ((campaign_id)::text = ANY ('{da3da707479185cb64d94bb4e6ecf490,d1dcb3b5ffe112e555fbdaa0b79241a8,c120838d777795ab2a47ac99a52f5b92,eb1d203d78a4f69282704c8ffbd97ea9,c7c0fd20e8d5ede3e300e28f3382c274,cb97a87ff64196b87179f7005cd758e2,c33001f76ffc53ad31c0f36990ff5f57,35de04d0d083965adb1e8f25e4c68077,7700a5048a845a67b4344611589b320e,ac1ade63dbf740f15e3ec8c4574f1822}'::text[]))
154. 0.002 0.128 ↓ 0.0 0 6 / 6

Bitmap Heap Scan on widget_part_hash_19 widget_part_hash_19_2 (cost=615.39..45,278.93 rows=16,745 width=33) (actual time=0.128..0.128 rows=0 loops=6)

  • Recheck Cond: ((campaign_id)::text = ANY ('{da3da707479185cb64d94bb4e6ecf490,d1dcb3b5ffe112e555fbdaa0b79241a8,c120838d777795ab2a47ac99a52f5b92,eb1d203d78a4f69282704c8ffbd97ea9,c7c0fd20e8d5ede3e300e28f3382c274,cb97a87ff64196b87179f7005cd758e2,c33001f76ffc53ad31c0f36990ff5f57,35de04d0d083965adb1e8f25e4c68077,7700a5048a845a67b4344611589b320e,ac1ade63dbf740f15e3ec8c4574f1822}'::text[]))
155. 0.126 0.126 ↓ 0.0 0 6 / 6

Bitmap Index Scan on widget_part_hash_19_campaign_id_idx (cost=0.00..611.20 rows=16,745 width=0) (actual time=0.126..0.126 rows=0 loops=6)

  • Index Cond: ((campaign_id)::text = ANY ('{da3da707479185cb64d94bb4e6ecf490,d1dcb3b5ffe112e555fbdaa0b79241a8,c120838d777795ab2a47ac99a52f5b92,eb1d203d78a4f69282704c8ffbd97ea9,c7c0fd20e8d5ede3e300e28f3382c274,cb97a87ff64196b87179f7005cd758e2,c33001f76ffc53ad31c0f36990ff5f57,35de04d0d083965adb1e8f25e4c68077,7700a5048a845a67b4344611589b320e,ac1ade63dbf740f15e3ec8c4574f1822}'::text[]))
156. 1,318.554 1,318.554 ↓ 0.0 0 155,124 / 6

Index Scan using widget_performance_ga_widget_id_date_view_id_unique on widget_performance_ga (cost=0.56..64.37 rows=15 width=157) (actual time=0.044..0.051 rows=0 loops=155,124)

  • Index Cond: (((widget_id)::text = (widget_part_hash_0_2.id)::text) AND (date >= '2019-11-10'::date) AND (date <= '2020-02-07'::date))
  • Filter: ("ga:sessions" > 0)
  • Rows Removed by Filter: 0
Planning time : 41.561 ms
Execution time : 55,841.728 ms