explain.depesz.com

PostgreSQL's explain analyze made readable

Result: KEQD

Settings
# exclusive inclusive rows x rows loops node
1. 0.020 6,604.891 ↑ 1.0 201 1

Limit (cost=151,599.07..151,599.57 rows=201 width=489) (actual time=6,604.854..6,604.891 rows=201 loops=1)

2. 228.373 6,604.871 ↑ 186.6 201 1

Sort (cost=151,599.07..151,692.85 rows=37,514 width=489) (actual time=6,604.852..6,604.871 rows=201 loops=1)

  • Sort Key: t2075.c1000000161, t2075.c1000000161 USING <
  • Sort Method: top-N heapsort Memory: 94kB
3. 178.963 6,376.498 ↓ 2.8 103,168 1

WindowAgg (cost=35,961.16..149,976.39 rows=37,514 width=489) (actual time=6,312.876..6,376.498 rows=103,168 loops=1)

4. 12.581 6,197.535 ↓ 2.8 103,168 1

Gather (cost=35,961.16..149,507.47 rows=37,514 width=449) (actual time=4,907.170..6,197.535 rows=103,168 loops=1)

  • Workers Planned: 4
  • Workers Launched: 0
5. 689.200 6,184.954 ↓ 11.0 103,168 1

Parallel Hash Semi Join (cost=34,961.16..144,756.07 rows=9,378 width=449) (actual time=4,907.166..6,184.954 rows=103,168 loops=1)

  • Hash Cond: ((t2075.c1 = s2075.entryid) AND (('View HPD:Help Desk'::citext) = ('View HPD:Help Desk'::citext)))
6. 11.223 1,431.351 ↓ 2.8 103,168 1

Parallel Append (cost=7.49..97,979.07 rows=37,513 width=496) (actual time=837.897..1,431.351 rows=103,168 loops=1)

7. 7.246 844.949 ↑ 12.9 922 1

Parallel Bitmap Heap Scan on t2075 (cost=29,664.90..66,144.14 rows=11,922 width=450) (actual time=837.894..844.949 rows=922 loops=1)

  • Recheck Cond: (((c7 >= 0) AND (c7 <= 12) AND (c230000009 = 'MAINCHANGE'::citext)) OR ((c1000000079 = 'SGP000000000114'::citext) AND (c7 >= 0) AND (c7 <= 3)) OR ((c7 >= 4) AND (c7 <= 4)) OR ((c7 >= 0) AND (c7 <= 2) AND (c230000009 = 'MAINKNOWNERROR'::citext)) OR ((c7 >= 0) AND (c7 <= 5) AND (c230000009 = 'MAINPROBLEM'::citext)) OR ((c7 >= 1000) AND (c7 <= 7000)))
  • Filter: (((c230000009 = 'MAINCHANGE'::citext) AND ((c1000000427 = 'SGP000000000114'::citext) OR (c1000000079 = 'SGP000000000114'::citext) OR (c1000000079 = 'SGP000000000114'::citext)) AND (c7 >= 0) AND (c7 <= 12)) OR ((c230000009 = 'MAINHELPDESK'::citext) AND (c1000000079 = 'SGP000000000114'::citext) AND (c7 >= 0) AND (c7 <= 3)) OR ((c230000009 = 'MAINKNOWLEDGEDATABASE'::citext) AND (c1000000079 = 'SGP000000000114'::citext) AND (c7 >= 4) AND (c7 <= 4)) OR ((c230000009 = 'MAINKNOWNERROR'::citext) AND (c1000000079 = 'SGP000000000114'::citext) AND (c7 >= 0) AND (c7 <= 2)) OR ((c230000009 = 'MAINPROBLEM'::citext) AND (c1000000079 = 'SGP000000000114'::citext) AND (c7 >= 0) AND (c7 <= 5)) OR ((c230000009 = 'TMSTASK'::citext) AND (c1000000079 = 'SGP000000000114'::citext) AND (c7 >= 1000) AND (c7 <= 7000)))
  • Rows Removed by Filter: 247
  • Heap Blocks: exact=750
8. 0.007 837.703 ↓ 0.0 0 1

BitmapOr (cost=29,664.90..29,664.90 rows=47,686 width=0) (actual time=837.703..837.703 rows=0 loops=1)

9. 393.370 393.370 ↓ 0.0 0 1

Bitmap Index Scan on i2075_4_1_new (cost=0.00..9,577.34 rows=1 width=0) (actual time=393.369..393.370 rows=0 loops=1)

  • Index Cond: ((c7 >= 0) AND (c7 <= 12) AND (c230000009 = 'MAINCHANGE'::citext))
10. 0.972 0.972 ↑ 50.9 936 1

Bitmap Index Scan on i2075_0_1000000079 (cost=0.00..858.30 rows=47,686 width=0) (actual time=0.972..0.972 rows=936 loops=1)

  • Index Cond: ((c1000000079 = 'SGP000000000114'::citext) AND (c7 >= 0) AND (c7 <= 3))
11. 0.028 0.028 ↓ 247.0 247 1

Bitmap Index Scan on i2075_7_1 (cost=0.00..1.53 rows=1 width=0) (actual time=0.028..0.028 rows=247 loops=1)

  • Index Cond: ((c7 >= 4) AND (c7 <= 4))
12. 84.589 84.589 ↓ 0.0 0 1

Bitmap Index Scan on i2075_4_1_new (cost=0.00..9,577.34 rows=1 width=0) (actual time=84.589..84.589 rows=0 loops=1)

  • Index Cond: ((c7 >= 0) AND (c7 <= 2) AND (c230000009 = 'MAINKNOWNERROR'::citext))
13. 358.725 358.725 ↓ 0.0 0 1

Bitmap Index Scan on i2075_4_1_new (cost=0.00..9,577.34 rows=1 width=0) (actual time=358.725..358.725 rows=0 loops=1)

  • Index Cond: ((c7 >= 0) AND (c7 <= 5) AND (c230000009 = 'MAINPROBLEM'::citext))
14. 0.012 0.012 ↓ 0.0 0 1

Bitmap Index Scan on i2075_7_1 (cost=0.00..1.53 rows=1 width=0) (actual time=0.012..0.012 rows=0 loops=1)

  • Index Cond: ((c7 >= 1000) AND (c7 <= 7000))
15. 0.003 0.028 ↓ 0.0 0 1

Parallel Bitmap Heap Scan on t2009 (cost=7.49..8.67 rows=1 width=764) (actual time=0.028..0.028 rows=0 loops=1)

  • Recheck Cond: (((c7 >= 0) AND (c7 <= 12)) OR ((c7 >= 0) AND (c7 <= 3)) OR ((c7 >= 4) AND (c7 <= 4)) OR ((c7 >= 0) AND (c7 <= 2)) OR ((c7 >= 0) AND (c7 <= 5)) OR ((c7 >= 1000) AND (c7 <= 7000)))
  • Filter: (((c230000009 = 'MAINCHANGE'::citext) AND ((c1000000079 = 'SGP000000000114'::citext) OR (c1000000079 = 'SGP000000000114'::citext) OR (c1000000079 = 'SGP000000000114'::citext)) AND (c7 >= 0) AND (c7 <= 12)) OR ((c230000009 = 'MAINHELPDESK'::citext) AND (c1000000079 = 'SGP000000000114'::citext) AND (c7 >= 0) AND (c7 <= 3)) OR ((c230000009 = 'MAINKNOWLEDGEDATABASE'::citext) AND (c1000000079 = 'SGP000000000114'::citext) AND (c7 >= 4) AND (c7 <= 4)) OR ((c230000009 = 'MAINKNOWNERROR'::citext) AND (c1000000079 = 'SGP000000000114'::citext) AND (c7 >= 0) AND (c7 <= 2)) OR ((c230000009 = 'MAINPROBLEM'::citext) AND (c1000000079 = 'SGP000000000114'::citext) AND (c7 >= 0) AND (c7 <= 5)) OR ((c230000009 = 'TMSTASK'::citext) AND (c1000000079 = 'SGP000000000114'::citext) AND (c7 >= 1000) AND (c7 <= 7000)))
16. 0.005 0.025 ↓ 0.0 0 1

BitmapOr (cost=7.49..7.49 rows=1 width=0) (actual time=0.025..0.025 rows=0 loops=1)

17. 0.010 0.010 ↓ 0.0 0 1

Bitmap Index Scan on i2009_7_1 (cost=0.00..1.25 rows=1 width=0) (actual time=0.010..0.010 rows=0 loops=1)

  • Index Cond: ((c7 >= 0) AND (c7 <= 12))
18. 0.002 0.002 ↓ 0.0 0 1

Bitmap Index Scan on i2009_7_1 (cost=0.00..1.25 rows=1 width=0) (actual time=0.002..0.002 rows=0 loops=1)

  • Index Cond: ((c7 >= 0) AND (c7 <= 3))
19. 0.002 0.002 ↓ 0.0 0 1

Bitmap Index Scan on i2009_7_1 (cost=0.00..1.25 rows=1 width=0) (actual time=0.002..0.002 rows=0 loops=1)

  • Index Cond: ((c7 >= 4) AND (c7 <= 4))
20. 0.002 0.002 ↓ 0.0 0 1

Bitmap Index Scan on i2009_7_1 (cost=0.00..1.25 rows=1 width=0) (actual time=0.002..0.002 rows=0 loops=1)

  • Index Cond: ((c7 >= 0) AND (c7 <= 2))
21. 0.002 0.002 ↓ 0.0 0 1

Bitmap Index Scan on i2009_7_1 (cost=0.00..1.25 rows=1 width=0) (actual time=0.002..0.002 rows=0 loops=1)

  • Index Cond: ((c7 >= 0) AND (c7 <= 5))
22. 0.002 0.002 ↓ 0.0 0 1

Bitmap Index Scan on i2009_7_1 (cost=0.00..1.25 rows=1 width=0) (actual time=0.002..0.002 rows=0 loops=1)

  • Index Cond: ((c7 >= 1000) AND (c7 <= 7000))
23. 0.009 0.031 ↓ 0.0 0 1

Parallel Bitmap Heap Scan on t1789 (cost=7.49..8.66 rows=1 width=764) (actual time=0.031..0.031 rows=0 loops=1)

  • Recheck Cond: (((c7 >= 0) AND (c7 <= 12)) OR ((c7 >= 0) AND (c7 <= 3)) OR ((c7 >= 4) AND (c7 <= 4)) OR ((c7 >= 0) AND (c7 <= 2)) OR ((c7 >= 0) AND (c7 <= 5)) OR ((c7 >= 1000) AND (c7 <= 7000)))
  • Filter: (((c230000009 = 'MAINCHANGE'::citext) AND ((c1000000079 = 'SGP000000000114'::citext) OR (c1000000079 = 'SGP000000000114'::citext) OR (c1000000079 = 'SGP000000000114'::citext)) AND (c7 >= 0) AND (c7 <= 12)) OR ((c230000009 = 'MAINHELPDESK'::citext) AND (c1000000079 = 'SGP000000000114'::citext) AND (c7 >= 0) AND (c7 <= 3)) OR ((c230000009 = 'MAINKNOWLEDGEDATABASE'::citext) AND (c1000000079 = 'SGP000000000114'::citext) AND (c7 >= 4) AND (c7 <= 4)) OR ((c230000009 = 'MAINKNOWNERROR'::citext) AND (c1000000079 = 'SGP000000000114'::citext) AND (c7 >= 0) AND (c7 <= 2)) OR ((c230000009 = 'MAINPROBLEM'::citext) AND (c1000000079 = 'SGP000000000114'::citext) AND (c7 >= 0) AND (c7 <= 5)) OR ((c230000009 = 'TMSTASK'::citext) AND (c1000000079 = 'SGP000000000114'::citext) AND (c7 >= 1000) AND (c7 <= 7000)))
24. 0.005 0.022 ↓ 0.0 0 1

BitmapOr (cost=7.49..7.49 rows=1 width=0) (actual time=0.022..0.022 rows=0 loops=1)

25. 0.008 0.008 ↓ 0.0 0 1

Bitmap Index Scan on i1789_7_1 (cost=0.00..1.25 rows=1 width=0) (actual time=0.008..0.008 rows=0 loops=1)

  • Index Cond: ((c7 >= 0) AND (c7 <= 12))
26. 0.002 0.002 ↓ 0.0 0 1

Bitmap Index Scan on i1789_7_1 (cost=0.00..1.25 rows=1 width=0) (actual time=0.002..0.002 rows=0 loops=1)

  • Index Cond: ((c7 >= 0) AND (c7 <= 3))
27. 0.001 0.001 ↓ 0.0 0 1

Bitmap Index Scan on i1789_7_1 (cost=0.00..1.25 rows=1 width=0) (actual time=0.001..0.001 rows=0 loops=1)

  • Index Cond: ((c7 >= 4) AND (c7 <= 4))
28. 0.002 0.002 ↓ 0.0 0 1

Bitmap Index Scan on i1789_7_1 (cost=0.00..1.25 rows=1 width=0) (actual time=0.002..0.002 rows=0 loops=1)

  • Index Cond: ((c7 >= 0) AND (c7 <= 2))
29. 0.002 0.002 ↓ 0.0 0 1

Bitmap Index Scan on i1789_7_1 (cost=0.00..1.25 rows=1 width=0) (actual time=0.002..0.002 rows=0 loops=1)

  • Index Cond: ((c7 >= 0) AND (c7 <= 5))
30. 0.002 0.002 ↓ 0.0 0 1

Bitmap Index Scan on i1789_7_1 (cost=0.00..1.25 rows=1 width=0) (actual time=0.002..0.002 rows=0 loops=1)

  • Index Cond: ((c7 >= 1000) AND (c7 <= 7000))
31. 0.006 0.038 ↓ 0.0 0 1

Parallel Bitmap Heap Scan on t1508 (cost=7.49..8.65 rows=1 width=764) (actual time=0.038..0.038 rows=0 loops=1)

  • Recheck Cond: (((c7 >= 0) AND (c7 <= 12)) OR ((c7 >= 0) AND (c7 <= 3)) OR ((c7 >= 4) AND (c7 <= 4)) OR ((c7 >= 0) AND (c7 <= 2)) OR ((c7 >= 0) AND (c7 <= 5)) OR ((c7 >= 1000) AND (c7 <= 7000)))
  • Filter: (((c230000009 = 'MAINCHANGE'::citext) AND ((c1000000079 = 'SGP000000000114'::citext) OR (c1000000079 = 'SGP000000000114'::citext) OR (c1000000079 = 'SGP000000000114'::citext)) AND (c7 >= 0) AND (c7 <= 12)) OR ((c230000009 = 'MAINHELPDESK'::citext) AND (c1000000079 = 'SGP000000000114'::citext) AND (c7 >= 0) AND (c7 <= 3)) OR ((c230000009 = 'MAINKNOWLEDGEDATABASE'::citext) AND (c1000000079 = 'SGP000000000114'::citext) AND (c7 >= 4) AND (c7 <= 4)) OR ((c230000009 = 'MAINKNOWNERROR'::citext) AND (c1000000079 = 'SGP000000000114'::citext) AND (c7 >= 0) AND (c7 <= 2)) OR ((c230000009 = 'MAINPROBLEM'::citext) AND (c1000000079 = 'SGP000000000114'::citext) AND (c7 >= 0) AND (c7 <= 5)) OR ((c230000009 = 'TMSTASK'::citext) AND (c1000000079 = 'SGP000000000114'::citext) AND (c7 >= 1000) AND (c7 <= 7000)))
32. 0.004 0.032 ↓ 0.0 0 1

BitmapOr (cost=7.49..7.49 rows=1 width=0) (actual time=0.032..0.032 rows=0 loops=1)

33. 0.008 0.008 ↓ 0.0 0 1

Bitmap Index Scan on i1508_7_1 (cost=0.00..1.25 rows=1 width=0) (actual time=0.007..0.008 rows=0 loops=1)

  • Index Cond: ((c7 >= 0) AND (c7 <= 12))
34. 0.002 0.002 ↓ 0.0 0 1

Bitmap Index Scan on i1508_7_1 (cost=0.00..1.25 rows=1 width=0) (actual time=0.002..0.002 rows=0 loops=1)

  • Index Cond: ((c7 >= 0) AND (c7 <= 3))
35. 0.002 0.002 ↓ 0.0 0 1

Bitmap Index Scan on i1508_7_1 (cost=0.00..1.25 rows=1 width=0) (actual time=0.002..0.002 rows=0 loops=1)

  • Index Cond: ((c7 >= 4) AND (c7 <= 4))
36. 0.002 0.002 ↓ 0.0 0 1

Bitmap Index Scan on i1508_7_1 (cost=0.00..1.25 rows=1 width=0) (actual time=0.002..0.002 rows=0 loops=1)

  • Index Cond: ((c7 >= 0) AND (c7 <= 2))
37. 0.012 0.012 ↓ 0.0 0 1

Bitmap Index Scan on i1508_7_1 (cost=0.00..1.25 rows=1 width=0) (actual time=0.012..0.012 rows=0 loops=1)

  • Index Cond: ((c7 >= 0) AND (c7 <= 5))
38. 0.002 0.002 ↓ 0.0 0 1

Bitmap Index Scan on i1508_7_1 (cost=0.00..1.25 rows=1 width=0) (actual time=0.002..0.002 rows=0 loops=1)

  • Index Cond: ((c7 >= 1000) AND (c7 <= 7000))
39. 0.006 0.028 ↓ 0.0 0 1

Parallel Bitmap Heap Scan on t2149 (cost=7.49..8.65 rows=1 width=764) (actual time=0.028..0.028 rows=0 loops=1)

  • Recheck Cond: (((c7 >= 0) AND (c7 <= 12)) OR ((c7 >= 0) AND (c7 <= 3)) OR ((c7 >= 4) AND (c7 <= 4)) OR ((c7 >= 0) AND (c7 <= 2)) OR ((c7 >= 0) AND (c7 <= 5)) OR ((c7 >= 1000) AND (c7 <= 7000)))
  • Filter: (((c230000009 = 'MAINCHANGE'::citext) AND ((c1000000427 = 'SGP000000000114'::citext) OR (c1000000079 = 'SGP000000000114'::citext) OR (c1000000079 = 'SGP000000000114'::citext)) AND (c7 >= 0) AND (c7 <= 12)) OR ((c230000009 = 'MAINHELPDESK'::citext) AND (c1000000079 = 'SGP000000000114'::citext) AND (c7 >= 0) AND (c7 <= 3)) OR ((c230000009 = 'MAINKNOWLEDGEDATABASE'::citext) AND (c1000000079 = 'SGP000000000114'::citext) AND (c7 >= 4) AND (c7 <= 4)) OR ((c230000009 = 'MAINKNOWNERROR'::citext) AND (c1000000079 = 'SGP000000000114'::citext) AND (c7 >= 0) AND (c7 <= 2)) OR ((c230000009 = 'MAINPROBLEM'::citext) AND (c1000000079 = 'SGP000000000114'::citext) AND (c7 >= 0) AND (c7 <= 5)) OR ((c230000009 = 'TMSTASK'::citext) AND (c1000000079 = 'SGP000000000114'::citext) AND (c7 >= 1000) AND (c7 <= 7000)))
40. 0.004 0.022 ↓ 0.0 0 1

BitmapOr (cost=7.49..7.49 rows=1 width=0) (actual time=0.022..0.022 rows=0 loops=1)

41. 0.008 0.008 ↓ 0.0 0 1

Bitmap Index Scan on i2149_7_1 (cost=0.00..1.25 rows=1 width=0) (actual time=0.008..0.008 rows=0 loops=1)

  • Index Cond: ((c7 >= 0) AND (c7 <= 12))
42. 0.002 0.002 ↓ 0.0 0 1

Bitmap Index Scan on i2149_7_1 (cost=0.00..1.25 rows=1 width=0) (actual time=0.002..0.002 rows=0 loops=1)

  • Index Cond: ((c7 >= 0) AND (c7 <= 3))
43. 0.002 0.002 ↓ 0.0 0 1

Bitmap Index Scan on i2149_7_1 (cost=0.00..1.25 rows=1 width=0) (actual time=0.002..0.002 rows=0 loops=1)

  • Index Cond: ((c7 >= 4) AND (c7 <= 4))
44. 0.002 0.002 ↓ 0.0 0 1

Bitmap Index Scan on i2149_7_1 (cost=0.00..1.25 rows=1 width=0) (actual time=0.002..0.002 rows=0 loops=1)

  • Index Cond: ((c7 >= 0) AND (c7 <= 2))
45. 0.002 0.002 ↓ 0.0 0 1

Bitmap Index Scan on i2149_7_1 (cost=0.00..1.25 rows=1 width=0) (actual time=0.002..0.002 rows=0 loops=1)

  • Index Cond: ((c7 >= 0) AND (c7 <= 5))
46. 0.002 0.002 ↓ 0.0 0 1

Bitmap Index Scan on i2149_7_1 (cost=0.00..1.25 rows=1 width=0) (actual time=0.002..0.002 rows=0 loops=1)

  • Index Cond: ((c7 >= 1000) AND (c7 <= 7000))
47. 478.382 478.382 ↓ 3.1 102,126 1

Parallel Seq Scan on t1925 (cost=0.00..29,105.42 rows=32,981 width=518) (actual time=0.060..478.382 rows=102,126 loops=1)

  • Filter: (((c230000009 = 'MAINCHANGE'::citext) AND ((c1000000079 = 'SGP000000000114'::citext) OR (c1000003234 = 'SGP000000000114'::citext) OR (c1000003259 = 'SGP000000000114'::citext)) AND (c7 >= 0) AND (c7 <= 12)) OR ((c230000009 = 'MAINHELPDESK'::citext) AND (c1000003234 = 'SGP000000000114'::citext) AND (c7 >= 0) AND (c7 <= 3)) OR ((c230000009 = 'MAINKNOWLEDGEDATABASE'::citext) AND (c1000003234 = 'SGP000000000114'::citext) AND (c7 >= 4) AND (c7 <= 4)) OR ((c230000009 = 'MAINKNOWNERROR'::citext) AND (c1000003234 = 'SGP000000000114'::citext) AND (c7 >= 0) AND (c7 <= 2)) OR ((c230000009 = 'MAINPROBLEM'::citext) AND (c1000003234 = 'SGP000000000114'::citext) AND (c7 >= 0) AND (c7 <= 5)) OR ((c230000009 = 'TMSTASK'::citext) AND (c1000003234 = 'SGP000000000114'::citext) AND (c7 >= 1000) AND (c7 <= 7000)))
  • Rows Removed by Filter: 55
48. 95.674 95.674 ↓ 0.0 0 1

Parallel Seq Scan on t2151 (cost=0.00..2,440.87 rows=1 width=614) (actual time=95.674..95.674 rows=0 loops=1)

  • Filter: (((c230000009 = 'MAINCHANGE'::citext) AND ((c1000000427 = 'SGP000000000114'::citext) OR (c1000000079 = 'SGP000000000114'::citext) OR (c1000000079 = 'SGP000000000114'::citext)) AND (c7 >= 0) AND (c7 <= 12)) OR ((c230000009 = 'MAINHELPDESK'::citext) AND (c1000000079 = 'SGP000000000114'::citext) AND (c7 >= 0) AND (c7 <= 3)) OR ((c230000009 = 'MAINKNOWLEDGEDATABASE'::citext) AND (c1000000079 = 'SGP000000000114'::citext) AND (c7 >= 4) AND (c7 <= 4)) OR ((c230000009 = 'MAINKNOWNERROR'::citext) AND (c1000000079 = 'SGP000000000114'::citext) AND (c7 >= 0) AND (c7 <= 2)) OR ((c230000009 = 'MAINPROBLEM'::citext) AND (c1000000079 = 'SGP000000000114'::citext) AND (c7 >= 0) AND (c7 <= 5)) OR ((c230000009 = 'TMSTASK'::citext) AND (c1000000079 = 'SGP000000000114'::citext) AND (c7 >= 1000) AND (c7 <= 7000)))
  • Rows Removed by Filter: 19150
49. 0.981 0.981 ↓ 1.6 120 1

Parallel Seq Scan on t1282 (cost=0.00..43.80 rows=74 width=599) (actual time=0.067..0.981 rows=120 loops=1)

  • Filter: (((c230000009 = 'MAINCHANGE'::citext) AND ((c10002505 = 'SGP000000000114'::citext) OR (c10002505 = 'SGP000000000114'::citext) OR (c10002505 = 'SGP000000000114'::citext)) AND (c7 >= 0) AND (c7 <= 12)) OR ((c230000009 = 'MAINHELPDESK'::citext) AND (c10002505 = 'SGP000000000114'::citext) AND (c7 >= 0) AND (c7 <= 3)) OR ((c230000009 = 'MAINKNOWLEDGEDATABASE'::citext) AND (c10002505 = 'SGP000000000114'::citext) AND (c7 >= 4) AND (c7 <= 4)) OR ((c230000009 = 'MAINKNOWNERROR'::citext) AND (c10002505 = 'SGP000000000114'::citext) AND (c7 >= 0) AND (c7 <= 2)) OR ((c230000009 = 'MAINPROBLEM'::citext) AND (c10002505 = 'SGP000000000114'::citext) AND (c7 >= 0) AND (c7 <= 5)) OR ((c230000009 = 'TMSTASK'::citext) AND (c10002505 = 'SGP000000000114'::citext) AND (c7 >= 1000) AND (c7 <= 7000)))
50. 0.008 0.008 ↓ 0.0 0 1

Parallel Seq Scan on t2152 (cost=0.00..11.77 rows=1 width=764) (actual time=0.008..0.008 rows=0 loops=1)

  • Filter: (((c230000009 = 'MAINCHANGE'::citext) AND ((c1000000079 = 'SGP000000000114'::citext) OR (c1000000079 = 'SGP000000000114'::citext) OR (c1000000079 = 'SGP000000000114'::citext)) AND (c1000003561 >= 0) AND (c1000003561 <= 12)) OR ((c230000009 = 'MAINHELPDESK'::citext) AND (c1000000079 = 'SGP000000000114'::citext) AND (c1000003561 >= 0) AND (c1000003561 <= 3)) OR ((c230000009 = 'MAINKNOWLEDGEDATABASE'::citext) AND (c1000000079 = 'SGP000000000114'::citext) AND (c1000003561 >= 4) AND (c1000003561 <= 4)) OR ((c230000009 = 'MAINKNOWNERROR'::citext) AND (c1000000079 = 'SGP000000000114'::citext) AND (c1000003561 >= 0) AND (c1000003561 <= 2)) OR ((c230000009 = 'MAINPROBLEM'::citext) AND (c1000000079 = 'SGP000000000114'::citext) AND (c1000003561 >= 0) AND (c1000003561 <= 5)) OR ((c230000009 = 'TMSTASK'::citext) AND (c1000000079 = 'SGP000000000114'::citext) AND (c1000003561 >= 1000) AND (c1000003561 <= 7000)))
51. 0.009 0.009 ↓ 0.0 0 1

Parallel Seq Scan on t1776 (cost=0.00..10.89 rows=1 width=764) (actual time=0.009..0.009 rows=0 loops=1)

  • Filter: (((c301722900 = 'MAINCHANGE'::citext) AND ((c1000000079 = 'SGP000000000114'::citext) OR (c1000000079 = 'SGP000000000114'::citext) OR (c1000000079 = 'SGP000000000114'::citext)) AND (c1000002752 >= 0) AND (c1000002752 <= 12)) OR ((c301722900 = 'MAINHELPDESK'::citext) AND (c1000000079 = 'SGP000000000114'::citext) AND (c1000002752 >= 0) AND (c1000002752 <= 3)) OR ((c301722900 = 'MAINKNOWLEDGEDATABASE'::citext) AND (c1000000079 = 'SGP000000000114'::citext) AND (c1000002752 >= 4) AND (c1000002752 <= 4)) OR ((c301722900 = 'MAINKNOWNERROR'::citext) AND (c1000000079 = 'SGP000000000114'::citext) AND (c1000002752 >= 0) AND (c1000002752 <= 2)) OR ((c301722900 = 'MAINPROBLEM'::citext) AND (c1000000079 = 'SGP000000000114'::citext) AND (c1000002752 >= 0) AND (c1000002752 <= 5)) OR ((c301722900 = 'TMSTASK'::citext) AND (c1000000079 = 'SGP000000000114'::citext) AND (c1000002752 >= 1000) AND (c1000002752 <= 7000)))
52. 1,686.160 4,064.403 ↓ 7.9 1,168,321 1

Parallel Hash (cost=32,741.60..32,741.60 rows=147,472 width=48) (actual time=4,064.403..4,064.403 rows=1,168,321 loops=1)

  • Buckets: 2097152 (originally 1048576) Batches: 2 (originally 1) Memory Usage: 70054kB
53. 1,733.013 2,378.243 ↓ 7.9 1,168,321 1

Hash Semi Join (cost=8.33..32,741.60 rows=147,472 width=48) (actual time=0.427..2,378.243 rows=1,168,321 loops=1)

  • Hash Cond: (s2075.labelvalue = "*VALUES*".column1)
54. 88.325 644.873 ↓ 4.0 1,176,943 1

Parallel Append (cost=0.00..30,318.42 rows=294,944 width=59) (actual time=0.038..644.873 rows=1,176,943 loops=1)

55. 452.877 452.877 ↓ 3.1 933,814 1

Parallel Seq Scan on s2075 (cost=0.00..22,804.30 rows=301,570 width=59) (actual time=0.036..452.877 rows=933,814 loops=1)

  • Filter: (labelid = ANY ('{112,60900,60901,60989}'::integer[]))
  • Rows Removed by Filter: 931077
56. 87.405 87.405 ↓ 1.7 204,417 1

Parallel Seq Scan on s1925 (cost=0.00..4,981.46 rows=121,306 width=59) (actual time=0.032..87.405 rows=204,417 loops=1)

  • Filter: (labelid = ANY ('{112,60900,60901,60989}'::integer[]))
  • Rows Removed by Filter: 102181
57. 16.015 16.015 ↓ 1.7 38,300 1

Parallel Seq Scan on s2151 (cost=0.00..929.91 rows=22,486 width=59) (actual time=0.018..16.015 rows=38,300 loops=1)

  • Filter: (labelid = ANY ('{112,60900,60901,60989}'::integer[]))
  • Rows Removed by Filter: 19150
58. 0.220 0.220 ↓ 1.9 412 1

Parallel Seq Scan on s1282 (cost=0.00..23.03 rows=214 width=59) (actual time=0.022..0.220 rows=412 loops=1)

  • Filter: (labelid = ANY ('{112,60900,60901,60989}'::integer[]))
  • Rows Removed by Filter: 240
59. 0.007 0.007 ↓ 0.0 0 1

Parallel Seq Scan on s1508 (cost=0.00..17.50 rows=10 width=96) (actual time=0.007..0.007 rows=0 loops=1)

  • Filter: (labelid = ANY ('{112,60900,60901,60989}'::integer[]))
60. 0.005 0.005 ↓ 0.0 0 1

Parallel Seq Scan on s1776 (cost=0.00..17.50 rows=10 width=96) (actual time=0.005..0.005 rows=0 loops=1)

  • Filter: (labelid = ANY ('{112,60900,60901,60989}'::integer[]))
61. 0.005 0.005 ↓ 0.0 0 1

Parallel Seq Scan on s1789 (cost=0.00..17.50 rows=10 width=96) (actual time=0.005..0.005 rows=0 loops=1)

  • Filter: (labelid = ANY ('{112,60900,60901,60989}'::integer[]))
62. 0.005 0.005 ↓ 0.0 0 1

Parallel Seq Scan on s2009 (cost=0.00..17.50 rows=10 width=96) (actual time=0.005..0.005 rows=0 loops=1)

  • Filter: (labelid = ANY ('{112,60900,60901,60989}'::integer[]))
63. 0.005 0.005 ↓ 0.0 0 1

Parallel Seq Scan on s2149 (cost=0.00..17.50 rows=10 width=96) (actual time=0.005..0.005 rows=0 loops=1)

  • Filter: (labelid = ANY ('{112,60900,60901,60989}'::integer[]))
64. 0.004 0.004 ↓ 0.0 0 1

Parallel Seq Scan on s2152 (cost=0.00..17.50 rows=10 width=96) (actual time=0.003..0.004 rows=0 loops=1)

  • Filter: (labelid = ANY ('{112,60900,60901,60989}'::integer[]))
65. 0.216 0.357 ↑ 1.0 333 1

Hash (cost=4.16..4.16 rows=333 width=32) (actual time=0.356..0.357 rows=333 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 22kB
66. 0.141 0.141 ↑ 1.0 333 1

Values Scan on "*VALUES*" (cost=0.00..4.16 rows=333 width=32) (actual time=0.006..0.141 rows=333 loops=1)