explain.depesz.com

PostgreSQL's explain analyze made readable

Result: aF7E : 200ms

Settings
# exclusive inclusive rows x rows loops node
1. 0.019 222.516 ↓ 7.7 201 1

Limit (cost=8,419.52..8,419.58 rows=26 width=463) (actual time=222.484..222.516 rows=201 loops=1)

2. 5.972 222.497 ↓ 7.7 201 1

Sort (cost=8,419.52..8,419.58 rows=26 width=463) (actual time=222.483..222.497 rows=201 loops=1)

  • Sort Key: t2075.c1000000161, t2075.c1000000161 USING <
  • Sort Method: top-N heapsort Memory: 86kB
3. 2.628 216.525 ↓ 36.3 943 1

WindowAgg (cost=1,008.60..8,418.91 rows=26 width=463) (actual time=215.970..216.525 rows=943 loops=1)

4. 0.232 213.897 ↓ 36.3 943 1

Gather (cost=1,008.60..8,418.58 rows=26 width=423) (actual time=16.800..213.897 rows=943 loops=1)

  • Workers Planned: 4
  • Workers Launched: 0
5. 0.675 213.665 ↓ 157.2 943 1

Nested Loop Semi Join (cost=8.60..7,415.98 rows=6 width=423) (actual time=16.799..213.665 rows=943 loops=1)

6. 0.196 123.405 ↓ 41.0 943 1

Parallel Append (cost=0.00..7,173.65 rows=23 width=472) (actual time=15.845..123.405 rows=943 loops=1)

7. 7.917 23.626 ↓ 24.2 943 1

Parallel Bitmap Heap Scan on t2075 (cost=110.14..3,978.70 rows=39 width=450) (actual time=15.844..23.626 rows=943 loops=1)

  • Recheck Cond: ((((c1000000427 = 'SGP000000000115'::citext) AND (c230000009 = 'MAINCHANGE'::citext)) OR (c1000000079 = 'SGP000000000115'::citext) OR (c1000000079 = 'SGP000000000115'::citext)) OR (((c1000000079 = 'SGP000000000115'::citext) AND (c7 = 0)) OR ((c1000000079 = 'SGP000000000115'::citext) AND (c7 = 1)) OR ((c1000000079 = 'SGP000000000115'::citext) AND (c7 = 2)) OR ((c1000000079 = 'SGP000000000115'::citext) AND (c7 = 3))) OR (((c1000000427 = 'SGP000000000115'::citext) AND (c230000009 = 'MAINWORKORDER'::citext)) OR (c1000000079 = 'SGP000000000115'::citext)) OR ((c1000000079 = 'SGP000000000115'::citext) AND (c7 = 4)) OR (((c1000000079 = 'SGP000000000115'::citext) AND (c7 = 0)) OR ((c1000000079 = 'SGP000000000115'::citext) AND (c7 = 1)) OR ((c1000000079 = 'SGP000000000115'::citext) AND (c7 = 2))) OR (((c1000000079 = 'SGP000000000115'::citext) AND (c7 = 0)) OR ((c1000000079 = 'SGP000000000115'::citext) AND (c7 = 1)) OR ((c1000000079 = 'SGP000000000115'::citext) AND (c7 = 2)) OR ((c1000000079 = 'SGP000000000115'::citext) AND (c7 = 3)) OR ((c1000000079 = 'SGP000000000115'::citext) AND (c7 = 4)) OR ((c1000000079 = 'SGP000000000115'::citext) AND (c7 = 5))))
  • Filter: (((c230000009 = 'MAINCHANGE'::citext) AND ((c1000000427 = 'SGP000000000115'::citext) OR (c1000000079 = 'SGP000000000115'::citext) OR (c1000000079 = 'SGP000000000115'::citext)) AND ((c1000000427 = 'SGP000000000115'::citext) OR (c1000000079 = 'SGP000000000115'::citext) OR (c1000000079 = 'SGP000000000115'::citext)) AND ((c7 = 1) OR (c7 = 2) OR (c7 = 3) OR (c7 = 4) OR (c7 = 5) OR (c7 = 6) OR (c7 = 7) OR (c7 = 8) OR (c7 = 9))) OR ((c230000009 = 'MAINHELPDESK'::citext) AND (c1000000079 = 'SGP000000000115'::citext) AND ((c7 = 0) OR (c7 = 1) OR (c7 = 2) OR (c7 = 3))) OR ((c230000009 = 'MAINWORKORDER'::citext) AND ((c1000000427 = 'SGP000000000115'::citext) OR (c1000000079 = 'SGP000000000115'::citext)) AND ((c1000000427 = 'SGP000000000115'::citext) OR (c1000000079 = 'SGP000000000115'::citext)) AND ((c7 = 0) OR (c7 = 1) OR (c7 = 2) OR (c7 = 3) OR (c7 = 4))) OR ((c230000009 = 'MAINKNOWLEDGEDATABASE'::citext) AND (c1000000079 = 'SGP000000000115'::citext) AND (c7 = 4)) OR ((c230000009 = 'MAINKNOWNERROR'::citext) AND (c1000000079 = 'SGP000000000115'::citext) AND ((c7 = 0) OR (c7 = 1) OR (c7 = 2))) OR ((c230000009 = 'MAINPROBLEM'::citext) AND (c1000000079 = 'SGP000000000115'::citext) AND ((c7 = 0) OR (c7 = 1) OR (c7 = 2) OR (c7 = 3) OR (c7 = 4) OR (c7 = 5))))
  • Heap Blocks: exact=642
8. 0.195 15.709 ↓ 0.0 0 1

BitmapOr (cost=110.14..110.14 rows=3,512 width=0) (actual time=15.709..15.709 rows=0 loops=1)

9. 0.001 5.640 ↓ 0.0 0 1

BitmapOr (cost=43.26..43.26 rows=1,683 width=0) (actual time=5.640..5.640 rows=0 loops=1)

10. 2.226 2.226 ↓ 0.0 0 1

Bitmap Index Scan on i2075_0_1000000427 (cost=0.00..18.73 rows=1 width=0) (actual time=2.226..2.226 rows=0 loops=1)

  • Index Cond: ((c1000000427 = 'SGP000000000115'::citext) AND (c230000009 = 'MAINCHANGE'::citext))
11. 1.808 1.808 ↓ 1.3 1,076 1

Bitmap Index Scan on i2075_0_1000000079_558468152 (cost=0.00..12.23 rows=841 width=0) (actual time=1.807..1.808 rows=1,076 loops=1)

  • Index Cond: (c1000000079 = 'SGP000000000115'::citext)
12. 1.605 1.605 ↓ 1.3 1,076 1

Bitmap Index Scan on i2075_0_1000000079_558468152 (cost=0.00..12.23 rows=841 width=0) (actual time=1.605..1.605 rows=1,076 loops=1)

  • Index Cond: (c1000000079 = 'SGP000000000115'::citext)
13. 0.002 1.953 ↓ 0.0 0 1

BitmapOr (cost=7.16..7.16 rows=97 width=0) (actual time=1.953..1.953 rows=0 loops=1)

14. 0.062 0.062 ↓ 0.0 0 1

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

  • Index Cond: ((c1000000079 = 'SGP000000000115'::citext) AND (c7 = 0))
15. 1.765 1.765 ↓ 31.6 1,076 1

Bitmap Index Scan on i2075_0_1000000079 (cost=0.00..1.86 rows=34 width=0) (actual time=1.765..1.765 rows=1,076 loops=1)

  • Index Cond: ((c1000000079 = 'SGP000000000115'::citext) AND (c7 = 1))
16. 0.067 0.067 ↓ 0.0 0 1

Bitmap Index Scan on i2075_0_1000000079 (cost=0.00..1.82 rows=30 width=0) (actual time=0.067..0.067 rows=0 loops=1)

  • Index Cond: ((c1000000079 = 'SGP000000000115'::citext) AND (c7 = 2))
17. 0.057 0.057 ↓ 0.0 0 1

Bitmap Index Scan on i2075_0_1000000079 (cost=0.00..1.85 rows=33 width=0) (actual time=0.057..0.057 rows=0 loops=1)

  • Index Cond: ((c1000000079 = 'SGP000000000115'::citext) AND (c7 = 3))
18. 0.001 3.927 ↓ 0.0 0 1

BitmapOr (cost=31.01..31.01 rows=841 width=0) (actual time=3.927..3.927 rows=0 loops=1)

19. 2.280 2.280 ↓ 0.0 0 1

Bitmap Index Scan on i2075_0_1000000427 (cost=0.00..18.73 rows=1 width=0) (actual time=2.280..2.280 rows=0 loops=1)

  • Index Cond: ((c1000000427 = 'SGP000000000115'::citext) AND (c230000009 = 'MAINWORKORDER'::citext))
20. 1.646 1.646 ↓ 1.3 1,076 1

Bitmap Index Scan on i2075_0_1000000079_558468152 (cost=0.00..12.23 rows=841 width=0) (actual time=1.646..1.646 rows=1,076 loops=1)

  • Index Cond: (c1000000079 = 'SGP000000000115'::citext)
21. 0.064 0.064 ↓ 0.0 0 1

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

  • Index Cond: ((c1000000079 = 'SGP000000000115'::citext) AND (c7 = 4))
22. 0.001 1.927 ↓ 0.0 0 1

BitmapOr (cost=5.29..5.29 rows=64 width=0) (actual time=1.927..1.927 rows=0 loops=1)

23. 0.098 0.098 ↓ 0.0 0 1

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

  • Index Cond: ((c1000000079 = 'SGP000000000115'::citext) AND (c7 = 0))
24. 1.768 1.768 ↓ 31.6 1,076 1

Bitmap Index Scan on i2075_0_1000000079 (cost=0.00..1.86 rows=34 width=0) (actual time=1.768..1.768 rows=1,076 loops=1)

  • Index Cond: ((c1000000079 = 'SGP000000000115'::citext) AND (c7 = 1))
25. 0.060 0.060 ↓ 0.0 0 1

Bitmap Index Scan on i2075_0_1000000079 (cost=0.00..1.82 rows=30 width=0) (actual time=0.060..0.060 rows=0 loops=1)

  • Index Cond: ((c1000000079 = 'SGP000000000115'::citext) AND (c7 = 2))
26. 0.003 2.003 ↓ 0.0 0 1

BitmapOr (cost=20.86..20.86 rows=827 width=0) (actual time=2.003..2.003 rows=0 loops=1)

27. 0.055 0.055 ↓ 0.0 0 1

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

  • Index Cond: ((c1000000079 = 'SGP000000000115'::citext) AND (c7 = 0))
28. 1.698 1.698 ↓ 31.6 1,076 1

Bitmap Index Scan on i2075_0_1000000079 (cost=0.00..1.86 rows=34 width=0) (actual time=1.698..1.698 rows=1,076 loops=1)

  • Index Cond: ((c1000000079 = 'SGP000000000115'::citext) AND (c7 = 1))
29. 0.065 0.065 ↓ 0.0 0 1

Bitmap Index Scan on i2075_0_1000000079 (cost=0.00..1.82 rows=30 width=0) (actual time=0.065..0.065 rows=0 loops=1)

  • Index Cond: ((c1000000079 = 'SGP000000000115'::citext) AND (c7 = 2))
30. 0.067 0.067 ↓ 0.0 0 1

Bitmap Index Scan on i2075_0_1000000079 (cost=0.00..1.85 rows=33 width=0) (actual time=0.067..0.067 rows=0 loops=1)

  • Index Cond: ((c1000000079 = 'SGP000000000115'::citext) AND (c7 = 3))
31. 0.058 0.058 ↓ 0.0 0 1

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

  • Index Cond: ((c1000000079 = 'SGP000000000115'::citext) AND (c7 = 4))
32. 0.057 0.057 ↓ 0.0 0 1

Bitmap Index Scan on i2075_0_1000000079 (cost=0.00..12.12 rows=730 width=0) (actual time=0.057..0.057 rows=0 loops=1)

  • Index Cond: ((c1000000079 = 'SGP000000000115'::citext) AND (c7 = 5))
33. 0.002 0.199 ↓ 0.0 0 1

Parallel Bitmap Heap Scan on t1925 (cost=13.85..15.06 rows=1 width=518) (actual time=0.199..0.199 rows=0 loops=1)

  • Recheck Cond: (((c1000000079 = 'SGP000000000115'::citext) OR (c1000003234 = 'SGP000000000115'::citext) OR (c1000003259 = 'SGP000000000115'::citext)) OR (c1000003234 = 'SGP000000000115'::citext) OR ((c1000000079 = 'SGP000000000115'::citext) OR (c1000003234 = 'SGP000000000115'::citext)) OR (c7 = 4) OR (c1000003234 = 'SGP000000000115'::citext) OR (c1000003234 = 'SGP000000000115'::citext))
  • Filter: (((c230000009 = 'MAINCHANGE'::citext) AND ((c1000000079 = 'SGP000000000115'::citext) OR (c1000003234 = 'SGP000000000115'::citext) OR (c1000003259 = 'SGP000000000115'::citext)) AND ((c1000000079 = 'SGP000000000115'::citext) OR (c1000003234 = 'SGP000000000115'::citext) OR (c1000003259 = 'SGP000000000115'::citext)) AND ((c7 = 1) OR (c7 = 2) OR (c7 = 3) OR (c7 = 4) OR (c7 = 5) OR (c7 = 6) OR (c7 = 7) OR (c7 = 8) OR (c7 = 9))) OR ((c230000009 = 'MAINHELPDESK'::citext) AND (c1000003234 = 'SGP000000000115'::citext) AND ((c7 = 0) OR (c7 = 1) OR (c7 = 2) OR (c7 = 3))) OR ((c230000009 = 'MAINWORKORDER'::citext) AND ((c1000000079 = 'SGP000000000115'::citext) OR (c1000003234 = 'SGP000000000115'::citext)) AND ((c1000000079 = 'SGP000000000115'::citext) OR (c1000003234 = 'SGP000000000115'::citext)) AND ((c7 = 0) OR (c7 = 1) OR (c7 = 2) OR (c7 = 3) OR (c7 = 4))) OR ((c230000009 = 'MAINKNOWLEDGEDATABASE'::citext) AND (c1000003234 = 'SGP000000000115'::citext) AND (c7 = 4)) OR ((c230000009 = 'MAINKNOWNERROR'::citext) AND (c1000003234 = 'SGP000000000115'::citext) AND ((c7 = 0) OR (c7 = 1) OR (c7 = 2))) OR ((c230000009 = 'MAINPROBLEM'::citext) AND (c1000003234 = 'SGP000000000115'::citext) AND ((c7 = 0) OR (c7 = 1) OR (c7 = 2) OR (c7 = 3) OR (c7 = 4) OR (c7 = 5))))
34. 0.002 0.197 ↓ 0.0 0 1

BitmapOr (cost=13.85..13.85 rows=1 width=0) (actual time=0.197..0.197 rows=0 loops=1)

35. 0.001 0.071 ↓ 0.0 0 1

BitmapOr (cost=4.58..4.58 rows=1 width=0) (actual time=0.071..0.071 rows=0 loops=1)

36. 0.031 0.031 ↓ 0.0 0 1

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

  • Index Cond: (c1000000079 = 'SGP000000000115'::citext)
37. 0.033 0.033 ↓ 0.0 0 1

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

  • Index Cond: (c1000003234 = 'SGP000000000115'::citext)
38. 0.006 0.006 ↓ 0.0 0 1

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

  • Index Cond: (c1000003259 = 'SGP000000000115'::citext)
39. 0.021 0.021 ↓ 0.0 0 1

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

  • Index Cond: (c1000003234 = 'SGP000000000115'::citext)
40. 0.009 0.051 ↓ 0.0 0 1

BitmapOr (cost=3.05..3.05 rows=1 width=0) (actual time=0.051..0.051 rows=0 loops=1)

41. 0.021 0.021 ↓ 0.0 0 1

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

  • Index Cond: (c1000000079 = 'SGP000000000115'::citext)
42. 0.021 0.021 ↓ 0.0 0 1

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

  • Index Cond: (c1000003234 = 'SGP000000000115'::citext)
43. 0.004 0.004 ↓ 0.0 0 1

Bitmap Index Scan on i1925_7_1 (cost=0.00..1.40 rows=1 width=0) (actual time=0.004..0.004 rows=0 loops=1)

  • Index Cond: (c7 = 4)
44. 0.027 0.027 ↓ 0.0 0 1

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

  • Index Cond: (c1000003234 = 'SGP000000000115'::citext)
45. 0.021 0.021 ↓ 0.0 0 1

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

  • Index Cond: (c1000003234 = 'SGP000000000115'::citext)
46. 98.564 98.564 ↓ 0.0 0 1

Parallel Seq Scan on t2151 (cost=0.00..3,060.43 rows=1 width=614) (actual time=98.563..98.564 rows=0 loops=1)

  • Filter: (((c230000009 = 'MAINCHANGE'::citext) AND ((c1000000427 = 'SGP000000000115'::citext) OR (c1000000079 = 'SGP000000000115'::citext) OR (c1000000079 = 'SGP000000000115'::citext)) AND ((c1000000427 = 'SGP000000000115'::citext) OR (c1000000079 = 'SGP000000000115'::citext) OR (c1000000079 = 'SGP000000000115'::citext)) AND ((c7 = 1) OR (c7 = 2) OR (c7 = 3) OR (c7 = 4) OR (c7 = 5) OR (c7 = 6) OR (c7 = 7) OR (c7 = 8) OR (c7 = 9))) OR ((c230000009 = 'MAINHELPDESK'::citext) AND (c1000000079 = 'SGP000000000115'::citext) AND ((c7 = 0) OR (c7 = 1) OR (c7 = 2) OR (c7 = 3))) OR ((c230000009 = 'MAINWORKORDER'::citext) AND ((c1000000427 = 'SGP000000000115'::citext) OR (c1000000079 = 'SGP000000000115'::citext)) AND ((c1000000427 = 'SGP000000000115'::citext) OR (c1000000079 = 'SGP000000000115'::citext)) AND ((c7 = 0) OR (c7 = 1) OR (c7 = 2) OR (c7 = 3) OR (c7 = 4))) OR ((c230000009 = 'MAINKNOWLEDGEDATABASE'::citext) AND (c1000000079 = 'SGP000000000115'::citext) AND (c7 = 4)) OR ((c230000009 = 'MAINKNOWNERROR'::citext) AND (c1000000079 = 'SGP000000000115'::citext) AND ((c7 = 0) OR (c7 = 1) OR (c7 = 2))) OR ((c230000009 = 'MAINPROBLEM'::citext) AND (c1000000079 = 'SGP000000000115'::citext) AND ((c7 = 0) OR (c7 = 1) OR (c7 = 2) OR (c7 = 3) OR (c7 = 4) OR (c7 = 5))))
  • Rows Removed by Filter: 19150
47. 0.787 0.787 ↓ 0.0 0 1

Parallel Seq Scan on t1282 (cost=0.00..48.57 rows=1 width=599) (actual time=0.787..0.787 rows=0 loops=1)

  • Filter: (((c230000009 = 'MAINCHANGE'::citext) AND ((c10002505 = 'SGP000000000115'::citext) OR (c10002505 = 'SGP000000000115'::citext) OR (c10002505 = 'SGP000000000115'::citext)) AND ((c10002505 = 'SGP000000000115'::citext) OR (c10002505 = 'SGP000000000115'::citext) OR (c10002505 = 'SGP000000000115'::citext)) AND ((c7 = 1) OR (c7 = 2) OR (c7 = 3) OR (c7 = 4) OR (c7 = 5) OR (c7 = 6) OR (c7 = 7) OR (c7 = 8) OR (c7 = 9))) OR ((c230000009 = 'MAINHELPDESK'::citext) AND (c10002505 = 'SGP000000000115'::citext) AND ((c7 = 0) OR (c7 = 1) OR (c7 = 2) OR (c7 = 3))) OR ((c230000009 = 'MAINWORKORDER'::citext) AND ((c10002505 = 'SGP000000000115'::citext) OR (c10002505 = 'SGP000000000115'::citext)) AND ((c10002505 = 'SGP000000000115'::citext) OR (c10002505 = 'SGP000000000115'::citext)) AND ((c7 = 0) OR (c7 = 1) OR (c7 = 2) OR (c7 = 3) OR (c7 = 4))) OR ((c230000009 = 'MAINKNOWLEDGEDATABASE'::citext) AND (c10002505 = 'SGP000000000115'::citext) AND (c7 = 4)) OR ((c230000009 = 'MAINKNOWNERROR'::citext) AND (c10002505 = 'SGP000000000115'::citext) AND ((c7 = 0) OR (c7 = 1) OR (c7 = 2))) OR ((c230000009 = 'MAINPROBLEM'::citext) AND (c10002505 = 'SGP000000000115'::citext) AND ((c7 = 0) OR (c7 = 1) OR (c7 = 2) OR (c7 = 3) OR (c7 = 4) OR (c7 = 5))))
  • Rows Removed by Filter: 125
48. 0.004 0.004 ↓ 0.0 0 1

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

  • Filter: (((c230000009 = 'MAINCHANGE'::citext) AND ((c1000000079 = 'SGP000000000115'::citext) OR (c1000000079 = 'SGP000000000115'::citext) OR (c1000000079 = 'SGP000000000115'::citext)) AND ((c1000000079 = 'SGP000000000115'::citext) OR (c1000000079 = 'SGP000000000115'::citext) OR (c1000000079 = 'SGP000000000115'::citext)) AND ((c1000003561 = 1) OR (c1000003561 = 2) OR (c1000003561 = 3) OR (c1000003561 = 4) OR (c1000003561 = 5) OR (c1000003561 = 6) OR (c1000003561 = 7) OR (c1000003561 = 8) OR (c1000003561 = 9))) OR ((c230000009 = 'MAINHELPDESK'::citext) AND (c1000000079 = 'SGP000000000115'::citext) AND ((c1000003561 = 0) OR (c1000003561 = 1) OR (c1000003561 = 2) OR (c1000003561 = 3))) OR ((c230000009 = 'MAINWORKORDER'::citext) AND ((c1000000079 = 'SGP000000000115'::citext) OR (c1000000079 = 'SGP000000000115'::citext)) AND ((c1000000079 = 'SGP000000000115'::citext) OR (c1000000079 = 'SGP000000000115'::citext)) AND ((c1000003561 = 0) OR (c1000003561 = 1) OR (c1000003561 = 2) OR (c1000003561 = 3) OR (c1000003561 = 4))) OR ((c230000009 = 'MAINKNOWLEDGEDATABASE'::citext) AND (c1000000079 = 'SGP000000000115'::citext) AND (c1000003561 = 4)) OR ((c230000009 = 'MAINKNOWNERROR'::citext) AND (c1000000079 = 'SGP000000000115'::citext) AND ((c1000003561 = 0) OR (c1000003561 = 1) OR (c1000003561 = 2))) OR ((c230000009 = 'MAINPROBLEM'::citext) AND (c1000000079 = 'SGP000000000115'::citext) AND ((c1000003561 = 0) OR (c1000003561 = 1) OR (c1000003561 = 2) OR (c1000003561 = 3) OR (c1000003561 = 4) OR (c1000003561 = 5))))
49. 0.002 0.002 ↓ 0.0 0 1

Parallel Seq Scan on t2009 (cost=0.00..11.55 rows=1 width=764) (actual time=0.002..0.002 rows=0 loops=1)

  • Filter: (((c230000009 = 'MAINCHANGE'::citext) AND ((c1000000079 = 'SGP000000000115'::citext) OR (c1000000079 = 'SGP000000000115'::citext) OR (c1000000079 = 'SGP000000000115'::citext)) AND ((c1000000079 = 'SGP000000000115'::citext) OR (c1000000079 = 'SGP000000000115'::citext) OR (c1000000079 = 'SGP000000000115'::citext)) AND ((c7 = 1) OR (c7 = 2) OR (c7 = 3) OR (c7 = 4) OR (c7 = 5) OR (c7 = 6) OR (c7 = 7) OR (c7 = 8) OR (c7 = 9))) OR ((c230000009 = 'MAINHELPDESK'::citext) AND (c1000000079 = 'SGP000000000115'::citext) AND ((c7 = 0) OR (c7 = 1) OR (c7 = 2) OR (c7 = 3))) OR ((c230000009 = 'MAINWORKORDER'::citext) AND ((c1000000079 = 'SGP000000000115'::citext) OR (c1000000079 = 'SGP000000000115'::citext)) AND ((c1000000079 = 'SGP000000000115'::citext) OR (c1000000079 = 'SGP000000000115'::citext)) AND ((c7 = 0) OR (c7 = 1) OR (c7 = 2) OR (c7 = 3) OR (c7 = 4))) OR ((c230000009 = 'MAINKNOWLEDGEDATABASE'::citext) AND (c1000000079 = 'SGP000000000115'::citext) AND (c7 = 4)) OR ((c230000009 = 'MAINKNOWNERROR'::citext) AND (c1000000079 = 'SGP000000000115'::citext) AND ((c7 = 0) OR (c7 = 1) OR (c7 = 2))) OR ((c230000009 = 'MAINPROBLEM'::citext) AND (c1000000079 = 'SGP000000000115'::citext) AND ((c7 = 0) OR (c7 = 1) OR (c7 = 2) OR (c7 = 3) OR (c7 = 4) OR (c7 = 5))))
50. 0.005 0.005 ↓ 0.0 0 1

Parallel Seq Scan on t1789 (cost=0.00..11.55 rows=1 width=764) (actual time=0.005..0.005 rows=0 loops=1)

  • Filter: (((c230000009 = 'MAINCHANGE'::citext) AND ((c1000000079 = 'SGP000000000115'::citext) OR (c1000000079 = 'SGP000000000115'::citext) OR (c1000000079 = 'SGP000000000115'::citext)) AND ((c1000000079 = 'SGP000000000115'::citext) OR (c1000000079 = 'SGP000000000115'::citext) OR (c1000000079 = 'SGP000000000115'::citext)) AND ((c7 = 1) OR (c7 = 2) OR (c7 = 3) OR (c7 = 4) OR (c7 = 5) OR (c7 = 6) OR (c7 = 7) OR (c7 = 8) OR (c7 = 9))) OR ((c230000009 = 'MAINHELPDESK'::citext) AND (c1000000079 = 'SGP000000000115'::citext) AND ((c7 = 0) OR (c7 = 1) OR (c7 = 2) OR (c7 = 3))) OR ((c230000009 = 'MAINWORKORDER'::citext) AND ((c1000000079 = 'SGP000000000115'::citext) OR (c1000000079 = 'SGP000000000115'::citext)) AND ((c1000000079 = 'SGP000000000115'::citext) OR (c1000000079 = 'SGP000000000115'::citext)) AND ((c7 = 0) OR (c7 = 1) OR (c7 = 2) OR (c7 = 3) OR (c7 = 4))) OR ((c230000009 = 'MAINKNOWLEDGEDATABASE'::citext) AND (c1000000079 = 'SGP000000000115'::citext) AND (c7 = 4)) OR ((c230000009 = 'MAINKNOWNERROR'::citext) AND (c1000000079 = 'SGP000000000115'::citext) AND ((c7 = 0) OR (c7 = 1) OR (c7 = 2))) OR ((c230000009 = 'MAINPROBLEM'::citext) AND (c1000000079 = 'SGP000000000115'::citext) AND ((c7 = 0) OR (c7 = 1) OR (c7 = 2) OR (c7 = 3) OR (c7 = 4) OR (c7 = 5))))
51. 0.002 0.002 ↓ 0.0 0 1

Parallel Seq Scan on t1508 (cost=0.00..11.54 rows=1 width=764) (actual time=0.002..0.002 rows=0 loops=1)

  • Filter: (((c230000009 = 'MAINCHANGE'::citext) AND ((c1000000079 = 'SGP000000000115'::citext) OR (c1000000079 = 'SGP000000000115'::citext) OR (c1000000079 = 'SGP000000000115'::citext)) AND ((c1000000079 = 'SGP000000000115'::citext) OR (c1000000079 = 'SGP000000000115'::citext) OR (c1000000079 = 'SGP000000000115'::citext)) AND ((c7 = 1) OR (c7 = 2) OR (c7 = 3) OR (c7 = 4) OR (c7 = 5) OR (c7 = 6) OR (c7 = 7) OR (c7 = 8) OR (c7 = 9))) OR ((c230000009 = 'MAINHELPDESK'::citext) AND (c1000000079 = 'SGP000000000115'::citext) AND ((c7 = 0) OR (c7 = 1) OR (c7 = 2) OR (c7 = 3))) OR ((c230000009 = 'MAINWORKORDER'::citext) AND ((c1000000079 = 'SGP000000000115'::citext) OR (c1000000079 = 'SGP000000000115'::citext)) AND ((c1000000079 = 'SGP000000000115'::citext) OR (c1000000079 = 'SGP000000000115'::citext)) AND ((c7 = 0) OR (c7 = 1) OR (c7 = 2) OR (c7 = 3) OR (c7 = 4))) OR ((c230000009 = 'MAINKNOWLEDGEDATABASE'::citext) AND (c1000000079 = 'SGP000000000115'::citext) AND (c7 = 4)) OR ((c230000009 = 'MAINKNOWNERROR'::citext) AND (c1000000079 = 'SGP000000000115'::citext) AND ((c7 = 0) OR (c7 = 1) OR (c7 = 2))) OR ((c230000009 = 'MAINPROBLEM'::citext) AND (c1000000079 = 'SGP000000000115'::citext) AND ((c7 = 0) OR (c7 = 1) OR (c7 = 2) OR (c7 = 3) OR (c7 = 4) OR (c7 = 5))))
52. 0.002 0.002 ↓ 0.0 0 1

Parallel Seq Scan on t2149 (cost=0.00..11.54 rows=1 width=764) (actual time=0.002..0.002 rows=0 loops=1)

  • Filter: (((c230000009 = 'MAINCHANGE'::citext) AND ((c1000000427 = 'SGP000000000115'::citext) OR (c1000000079 = 'SGP000000000115'::citext) OR (c1000000079 = 'SGP000000000115'::citext)) AND ((c1000000427 = 'SGP000000000115'::citext) OR (c1000000079 = 'SGP000000000115'::citext) OR (c1000000079 = 'SGP000000000115'::citext)) AND ((c7 = 1) OR (c7 = 2) OR (c7 = 3) OR (c7 = 4) OR (c7 = 5) OR (c7 = 6) OR (c7 = 7) OR (c7 = 8) OR (c7 = 9))) OR ((c230000009 = 'MAINHELPDESK'::citext) AND (c1000000079 = 'SGP000000000115'::citext) AND ((c7 = 0) OR (c7 = 1) OR (c7 = 2) OR (c7 = 3))) OR ((c230000009 = 'MAINWORKORDER'::citext) AND ((c1000000427 = 'SGP000000000115'::citext) OR (c1000000079 = 'SGP000000000115'::citext)) AND ((c1000000427 = 'SGP000000000115'::citext) OR (c1000000079 = 'SGP000000000115'::citext)) AND ((c7 = 0) OR (c7 = 1) OR (c7 = 2) OR (c7 = 3) OR (c7 = 4))) OR ((c230000009 = 'MAINKNOWLEDGEDATABASE'::citext) AND (c1000000079 = 'SGP000000000115'::citext) AND (c7 = 4)) OR ((c230000009 = 'MAINKNOWNERROR'::citext) AND (c1000000079 = 'SGP000000000115'::citext) AND ((c7 = 0) OR (c7 = 1) OR (c7 = 2))) OR ((c230000009 = 'MAINPROBLEM'::citext) AND (c1000000079 = 'SGP000000000115'::citext) AND ((c7 = 0) OR (c7 = 1) OR (c7 = 2) OR (c7 = 3) OR (c7 = 4) OR (c7 = 5))))
53. 0.018 0.018 ↓ 0.0 0 1

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

  • Filter: (((c301722900 = 'MAINCHANGE'::citext) AND ((c1000000079 = 'SGP000000000115'::citext) OR (c1000000079 = 'SGP000000000115'::citext) OR (c1000000079 = 'SGP000000000115'::citext)) AND ((c1000000079 = 'SGP000000000115'::citext) OR (c1000000079 = 'SGP000000000115'::citext) OR (c1000000079 = 'SGP000000000115'::citext)) AND ((c1000002752 = 1) OR (c1000002752 = 2) OR (c1000002752 = 3) OR (c1000002752 = 4) OR (c1000002752 = 5) OR (c1000002752 = 6) OR (c1000002752 = 7) OR (c1000002752 = 8) OR (c1000002752 = 9))) OR ((c301722900 = 'MAINHELPDESK'::citext) AND (c1000000079 = 'SGP000000000115'::citext) AND ((c1000002752 = 0) OR (c1000002752 = 1) OR (c1000002752 = 2) OR (c1000002752 = 3))) OR ((c301722900 = 'MAINWORKORDER'::citext) AND ((c1000000079 = 'SGP000000000115'::citext) OR (c1000000079 = 'SGP000000000115'::citext)) AND ((c1000000079 = 'SGP000000000115'::citext) OR (c1000000079 = 'SGP000000000115'::citext)) AND ((c1000002752 = 0) OR (c1000002752 = 1) OR (c1000002752 = 2) OR (c1000002752 = 3) OR (c1000002752 = 4))) OR ((c301722900 = 'MAINKNOWLEDGEDATABASE'::citext) AND (c1000000079 = 'SGP000000000115'::citext) AND (c1000002752 = 4)) OR ((c301722900 = 'MAINKNOWNERROR'::citext) AND (c1000000079 = 'SGP000000000115'::citext) AND ((c1000002752 = 0) OR (c1000002752 = 1) OR (c1000002752 = 2))) OR ((c301722900 = 'MAINPROBLEM'::citext) AND (c1000000079 = 'SGP000000000115'::citext) AND ((c1000002752 = 0) OR (c1000002752 = 1) OR (c1000002752 = 2) OR (c1000002752 = 3) OR (c1000002752 = 4) OR (c1000002752 = 5))))
54. 3.074 89.585 ↑ 5.0 1 943

Hash Semi Join (cost=8.60..22.14 rows=5 width=48) (actual time=0.095..0.095 rows=1 loops=943)

  • Hash Cond: (s1282.labelvalue = "*VALUES*".column1)
55. 2.829 85.813 ↑ 10.0 1 943

Append (cost=0.28..13.73 rows=10 width=59) (actual time=0.091..0.091 rows=1 loops=943)

56. 14.145 14.145 ↓ 0.0 0 943

Index Only Scan using pk_s1282 on s1282 (cost=0.28..0.71 rows=1 width=59) (actual time=0.015..0.015 rows=0 loops=943)

  • Index Cond: (entryid = t2075.c1)
  • Filter: ((('View HPD:Help Desk'::citext) = 'View TMS:Task'::citext) AND (labelid = ANY ('{112,60900,60901,60989}'::integer[])))
  • Heap Fetches: 0
57. 0.943 0.943 ↓ 0.0 0 943

Index Only Scan using pk_s1508 on s1508 (cost=0.15..0.37 rows=1 width=96) (actual time=0.001..0.001 rows=0 loops=943)

  • Index Cond: (entryid = t2075.c1)
  • Filter: ((('View HPD:Help Desk'::citext) = 'View AAS:Activity'::citext) AND (labelid = ANY ('{112,60900,60901,60989}'::integer[])))
  • Heap Fetches: 0
58. 0.943 0.943 ↓ 0.0 0 943

Index Only Scan using pk_s1776 on s1776 (cost=0.15..0.37 rows=1 width=96) (actual time=0.001..0.001 rows=0 loops=943)

  • Index Cond: (entryid = t2075.c1)
  • Filter: ((('View HPD:Help Desk'::citext) = 'View AST:CI Unavailability'::citext) AND (labelid = ANY ('{112,60900,60901,60989}'::integer[])))
  • Heap Fetches: 0
59. 0.943 0.943 ↓ 0.0 0 943

Index Only Scan using pk_s1789 on s1789 (cost=0.15..0.37 rows=1 width=96) (actual time=0.001..0.001 rows=0 loops=943)

  • Index Cond: (entryid = t2075.c1)
  • Filter: ((('View HPD:Help Desk'::citext) = 'View AST:PurchaseRequisition'::citext) AND (labelid = ANY ('{112,60900,60901,60989}'::integer[])))
  • Heap Fetches: 0
60. 16.031 16.031 ↓ 0.0 0 943

Index Only Scan using pk_s1925 on s1925 (cost=0.42..3.54 rows=1 width=59) (actual time=0.017..0.017 rows=0 loops=943)

  • Index Cond: (entryid = t2075.c1)
  • Filter: ((('View HPD:Help Desk'::citext) = 'View CHG:Infrastructure Change'::citext) AND (labelid = ANY ('{112,60900,60901,60989}'::integer[])))
  • Heap Fetches: 0
61. 0.943 0.943 ↓ 0.0 0 943

Index Only Scan using pk_s2009 on s2009 (cost=0.15..0.37 rows=1 width=96) (actual time=0.001..0.001 rows=0 loops=943)

  • Index Cond: (entryid = t2075.c1)
  • Filter: ((('View HPD:Help Desk'::citext) = 'View RMS:Release'::citext) AND (labelid = ANY ('{112,60900,60901,60989}'::integer[])))
  • Heap Fetches: 0
62. 49.036 49.036 ↑ 1.0 1 943

Index Only Scan using pk_s2075 on s2075 (cost=0.43..4.15 rows=1 width=59) (actual time=0.051..0.052 rows=1 loops=943)

  • Index Cond: (entryid = t2075.c1)
  • Filter: ((('View HPD:Help Desk'::citext) = 'View HPD:Help Desk'::citext) AND (labelid = ANY ('{112,60900,60901,60989}'::integer[])))
  • Rows Removed by Filter: 2
  • Heap Fetches: 2960
63. 0.000 0.000 ↓ 0.0 0

Index Only Scan using pk_s2149 on s2149 (cost=0.15..0.37 rows=1 width=96) (never executed)

  • Index Cond: (entryid = t2075.c1)
  • Filter: ((('View HPD:Help Desk'::citext) = 'View PBM:Known Error'::citext) AND (labelid = ANY ('{112,60900,60901,60989}'::integer[])))
  • Heap Fetches: 0
64. 0.000 0.000 ↓ 0.0 0

Index Only Scan using pk_s2151 on s2151 (cost=0.41..3.08 rows=1 width=59) (never executed)

  • Index Cond: (entryid = t2075.c1)
  • Filter: ((('View HPD:Help Desk'::citext) = 'View PBM:Problem Investigation'::citext) AND (labelid = ANY ('{112,60900,60901,60989}'::integer[])))
  • Heap Fetches: 0
65. 0.000 0.000 ↓ 0.0 0

Index Only Scan using pk_s2152 on s2152 (cost=0.15..0.37 rows=1 width=96) (never executed)

  • Index Cond: (entryid = t2075.c1)
  • Filter: ((('View HPD:Help Desk'::citext) = 'View PBM:Solution Database'::citext) AND (labelid = ANY ('{112,60900,60901,60989}'::integer[])))
  • Heap Fetches: 0
66. 0.441 0.698 ↑ 1.0 333 1

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

  • Buckets: 1024 Batches: 1 Memory Usage: 22kB
67. 0.257 0.257 ↑ 1.0 333 1

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