explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 1GyX : Plan1

Settings
# exclusive inclusive rows x rows loops node
1. 0.019 6,878.851 ↑ 1.0 201 1

Limit (cost=153,585.75..153,586.25 rows=201 width=489) (actual time=6,878.814..6,878.851 rows=201 loops=1)

2. 225.592 6,878.832 ↑ 181.3 201 1

Sort (cost=153,585.75..153,676.83 rows=36,432 width=489) (actual time=6,878.811..6,878.832 rows=201 loops=1)

  • Sort Key: t2075.c1000000161, t2075.c1000000161 USING <
  • Sort Method: top-N heapsort Memory: 145kB
3. 175.265 6,653.240 ↓ 2.8 100,919 1

WindowAgg (cost=35,756.07..152,009.88 rows=36,432 width=489) (actual time=6,589.025..6,653.240 rows=100,919 loops=1)

4. 11.247 6,477.975 ↓ 2.8 100,919 1

Gather (cost=35,756.07..151,554.48 rows=36,432 width=449) (actual time=5,203.710..6,477.975 rows=100,919 loops=1)

  • Workers Planned: 4
  • Workers Launched: 0
5. 621.916 6,466.728 ↓ 11.1 100,919 1

Parallel Hash Semi Join (cost=34,756.07..146,911.28 rows=9,108 width=449) (actual time=5,203.707..6,466.728 rows=100,919 loops=1)

  • Hash Cond: ((t2075.c1 = s2075.entryid) AND (('View HPD:Help Desk'::citext) = ('View HPD:Help Desk'::citext)))
6. 10.160 1,887.969 ↓ 2.8 100,919 1

Parallel Append (cost=0.00..100,673.55 rows=36,429 width=497) (actual time=1,243.142..1,887.969 rows=100,919 loops=1)

7. 5.452 1,248.428 ↑ 12.5 914 1

Parallel Bitmap Heap Scan on t2075 (cost=29,538.31..66,487.40 rows=11,414 width=450) (actual time=1,243.139..1,248.428 rows=914 loops=1)

  • Recheck Cond: ((c230000009 = 'MAINCHANGE'::citext) OR (((c1000000079 = 'SGP000000000114'::citext) AND (c7 = 0)) OR ((c1000000079 = 'SGP000000000114'::citext) AND (c7 = 1)) OR ((c1000000079 = 'SGP000000000114'::citext) AND (c7 = 2)) OR ((c1000000079 = 'SGP000000000114'::citext) AND (c7 = 3))) OR (c230000009 = 'MAINWORKORDER'::citext) OR ((c1000000079 = 'SGP000000000114'::citext) AND (c7 = 4)) OR (c230000009 = 'MAINKNOWNERROR'::citext) OR (c230000009 = 'MAINPROBLEM'::citext))
  • Filter: (((c230000009 = 'MAINCHANGE'::citext) AND ((c1000000427 = 'SGP000000000114'::citext) OR (c1000000079 = 'SGP000000000114'::citext) OR (c1000000079 = 'SGP000000000114'::citext)) AND ((c1000000427 = 'SGP000000000114'::citext) OR (c1000000079 = 'SGP000000000114'::citext) OR (c1000000079 = 'SGP000000000114'::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 = 'SGP000000000114'::citext) AND ((c7 = 0) OR (c7 = 1) OR (c7 = 2) OR (c7 = 3))) OR ((c230000009 = 'MAINWORKORDER'::citext) AND ((c1000000427 = 'SGP000000000114'::citext) OR (c1000000079 = 'SGP000000000114'::citext)) AND ((c1000000427 = 'SGP000000000114'::citext) OR (c1000000079 = 'SGP000000000114'::citext)) AND ((c7 = 0) OR (c7 = 1) OR (c7 = 2) OR (c7 = 3) OR (c7 = 4))) OR ((c230000009 = 'MAINKNOWLEDGEDATABASE'::citext) AND (c1000000079 = 'SGP000000000114'::citext) AND (c7 = 4)) OR ((c230000009 = 'MAINKNOWNERROR'::citext) AND (c1000000079 = 'SGP000000000114'::citext) AND ((c7 = 0) OR (c7 = 1) OR (c7 = 2))) OR ((c230000009 = 'MAINPROBLEM'::citext) AND (c1000000079 = 'SGP000000000114'::citext) AND ((c7 = 0) OR (c7 = 1) OR (c7 = 2) OR (c7 = 3) OR (c7 = 4) OR (c7 = 5))))
  • Heap Blocks: exact=570
8. 0.110 1,242.976 ↓ 0.0 0 1

BitmapOr (cost=29,538.31..29,538.31 rows=47,465 width=0) (actual time=1,242.976..1,242.976 rows=0 loops=1)

9. 308.357 308.357 ↓ 0.0 0 1

Bitmap Index Scan on i2075_4_1_new (cost=0.00..7,174.19 rows=1 width=0) (actual time=308.357..308.357 rows=0 loops=1)

  • Index Cond: (c230000009 = 'MAINCHANGE'::citext)
10. 0.019 0.962 ↓ 0.0 0 1

BitmapOr (cost=782.56..782.56 rows=47,451 width=0) (actual time=0.962..0.962 rows=0 loops=1)

11. 0.038 0.038 ↓ 0.0 0 1

Bitmap Index Scan on i2075_0_1000000079 (cost=0.00..1.66 rows=14 width=0) (actual time=0.038..0.038 rows=0 loops=1)

  • Index Cond: ((c1000000079 = 'SGP000000000114'::citext) AND (c7 = 0))
12. 0.654 0.654 ↑ 23.5 708 1

Bitmap Index Scan on i2075_0_1000000079 (cost=0.00..258.36 rows=16,664 width=0) (actual time=0.653..0.654 rows=708 loops=1)

  • Index Cond: ((c1000000079 = 'SGP000000000114'::citext) AND (c7 = 1))
13. 0.231 0.231 ↑ 69.9 210 1

Bitmap Index Scan on i2075_0_1000000079 (cost=0.00..227.44 rows=14,672 width=0) (actual time=0.231..0.231 rows=210 loops=1)

  • Index Cond: ((c1000000079 = 'SGP000000000114'::citext) AND (c7 = 2))
14. 0.020 0.020 ↓ 0.0 0 1

Bitmap Index Scan on i2075_0_1000000079 (cost=0.00..249.43 rows=16,101 width=0) (actual time=0.020..0.020 rows=0 loops=1)

  • Index Cond: ((c1000000079 = 'SGP000000000114'::citext) AND (c7 = 3))
15. 310.379 310.379 ↓ 0.0 0 1

Bitmap Index Scan on i2075_4_1_new (cost=0.00..7,174.19 rows=1 width=0) (actual time=310.379..310.379 rows=0 loops=1)

  • Index Cond: (c230000009 = 'MAINWORKORDER'::citext)
16. 0.036 0.036 ↓ 0.0 0 1

Bitmap Index Scan on i2075_0_1000000079 (cost=0.00..1.66 rows=14 width=0) (actual time=0.036..0.036 rows=0 loops=1)

  • Index Cond: ((c1000000079 = 'SGP000000000114'::citext) AND (c7 = 4))
17. 318.468 318.468 ↓ 0.0 0 1

Bitmap Index Scan on i2075_4_1_new (cost=0.00..7,174.19 rows=1 width=0) (actual time=318.468..318.468 rows=0 loops=1)

  • Index Cond: (c230000009 = 'MAINKNOWNERROR'::citext)
18. 304.664 304.664 ↓ 0.0 0 1

Bitmap Index Scan on i2075_4_1_new (cost=0.00..7,174.19 rows=1 width=0) (actual time=304.664..304.664 rows=0 loops=1)

  • Index Cond: (c230000009 = 'MAINPROBLEM'::citext)
19. 541.812 541.812 ↓ 3.1 100,005 1

Parallel Seq Scan on t1925 (cost=0.00..30,867.34 rows=32,278 width=518) (actual time=0.111..541.812 rows=100,005 loops=1)

  • Filter: (((c230000009 = 'MAINCHANGE'::citext) AND ((c1000000079 = 'SGP000000000114'::citext) OR (c1000003234 = 'SGP000000000114'::citext) OR (c1000003259 = 'SGP000000000114'::citext)) AND ((c1000000079 = 'SGP000000000114'::citext) OR (c1000003234 = 'SGP000000000114'::citext) OR (c1000003259 = 'SGP000000000114'::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 = 'SGP000000000114'::citext) AND ((c7 = 0) OR (c7 = 1) OR (c7 = 2) OR (c7 = 3))) OR ((c230000009 = 'MAINWORKORDER'::citext) AND ((c1000000079 = 'SGP000000000114'::citext) OR (c1000003234 = 'SGP000000000114'::citext)) AND ((c1000000079 = 'SGP000000000114'::citext) OR (c1000003234 = 'SGP000000000114'::citext)) AND ((c7 = 0) OR (c7 = 1) OR (c7 = 2) OR (c7 = 3) OR (c7 = 4))) OR ((c230000009 = 'MAINKNOWLEDGEDATABASE'::citext) AND (c1000003234 = 'SGP000000000114'::citext) AND (c7 = 4)) OR ((c230000009 = 'MAINKNOWNERROR'::citext) AND (c1000003234 = 'SGP000000000114'::citext) AND ((c7 = 0) OR (c7 = 1) OR (c7 = 2))) OR ((c230000009 = 'MAINPROBLEM'::citext) AND (c1000003234 = 'SGP000000000114'::citext) AND ((c7 = 0) OR (c7 = 1) OR (c7 = 2) OR (c7 = 3) OR (c7 = 4) OR (c7 = 5))))
  • Rows Removed by Filter: 2133
20. 87.358 87.358 ↓ 0.0 0 1

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

  • Filter: (((c230000009 = 'MAINCHANGE'::citext) AND ((c1000000427 = 'SGP000000000114'::citext) OR (c1000000079 = 'SGP000000000114'::citext) OR (c1000000079 = 'SGP000000000114'::citext)) AND ((c1000000427 = 'SGP000000000114'::citext) OR (c1000000079 = 'SGP000000000114'::citext) OR (c1000000079 = 'SGP000000000114'::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 = 'SGP000000000114'::citext) AND ((c7 = 0) OR (c7 = 1) OR (c7 = 2) OR (c7 = 3))) OR ((c230000009 = 'MAINWORKORDER'::citext) AND ((c1000000427 = 'SGP000000000114'::citext) OR (c1000000079 = 'SGP000000000114'::citext)) AND ((c1000000427 = 'SGP000000000114'::citext) OR (c1000000079 = 'SGP000000000114'::citext)) AND ((c7 = 0) OR (c7 = 1) OR (c7 = 2) OR (c7 = 3) OR (c7 = 4))) OR ((c230000009 = 'MAINKNOWLEDGEDATABASE'::citext) AND (c1000000079 = 'SGP000000000114'::citext) AND (c7 = 4)) OR ((c230000009 = 'MAINKNOWNERROR'::citext) AND (c1000000079 = 'SGP000000000114'::citext) AND ((c7 = 0) OR (c7 = 1) OR (c7 = 2))) OR ((c230000009 = 'MAINPROBLEM'::citext) AND (c1000000079 = 'SGP000000000114'::citext) AND ((c7 = 0) OR (c7 = 1) OR (c7 = 2) OR (c7 = 3) OR (c7 = 4) OR (c7 = 5))))
  • Rows Removed by Filter: 19150
21. 0.010 0.010 ↓ 0.0 0 1

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

  • Filter: (((c230000009 = 'MAINCHANGE'::citext) AND ((c1000000079 = 'SGP000000000114'::citext) OR (c1000000079 = 'SGP000000000114'::citext) OR (c1000000079 = 'SGP000000000114'::citext)) AND ((c1000000079 = 'SGP000000000114'::citext) OR (c1000000079 = 'SGP000000000114'::citext) OR (c1000000079 = 'SGP000000000114'::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 = 'SGP000000000114'::citext) AND ((c1000003561 = 0) OR (c1000003561 = 1) OR (c1000003561 = 2) OR (c1000003561 = 3))) OR ((c230000009 = 'MAINWORKORDER'::citext) AND ((c1000000079 = 'SGP000000000114'::citext) OR (c1000000079 = 'SGP000000000114'::citext)) AND ((c1000000079 = 'SGP000000000114'::citext) OR (c1000000079 = 'SGP000000000114'::citext)) AND ((c1000003561 = 0) OR (c1000003561 = 1) OR (c1000003561 = 2) OR (c1000003561 = 3) OR (c1000003561 = 4))) OR ((c230000009 = 'MAINKNOWLEDGEDATABASE'::citext) AND (c1000000079 = 'SGP000000000114'::citext) AND (c1000003561 = 4)) OR ((c230000009 = 'MAINKNOWNERROR'::citext) AND (c1000000079 = 'SGP000000000114'::citext) AND ((c1000003561 = 0) OR (c1000003561 = 1) OR (c1000003561 = 2))) OR ((c230000009 = 'MAINPROBLEM'::citext) AND (c1000000079 = 'SGP000000000114'::citext) AND ((c1000003561 = 0) OR (c1000003561 = 1) OR (c1000003561 = 2) OR (c1000003561 = 3) OR (c1000003561 = 4) OR (c1000003561 = 5))))
22. 0.022 0.022 ↓ 0.0 0 1

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

  • Filter: (((c230000009 = 'MAINCHANGE'::citext) AND ((c1000000079 = 'SGP000000000114'::citext) OR (c1000000079 = 'SGP000000000114'::citext) OR (c1000000079 = 'SGP000000000114'::citext)) AND ((c1000000079 = 'SGP000000000114'::citext) OR (c1000000079 = 'SGP000000000114'::citext) OR (c1000000079 = 'SGP000000000114'::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 = 'SGP000000000114'::citext) AND ((c7 = 0) OR (c7 = 1) OR (c7 = 2) OR (c7 = 3))) OR ((c230000009 = 'MAINWORKORDER'::citext) AND ((c1000000079 = 'SGP000000000114'::citext) OR (c1000000079 = 'SGP000000000114'::citext)) AND ((c1000000079 = 'SGP000000000114'::citext) OR (c1000000079 = 'SGP000000000114'::citext)) AND ((c7 = 0) OR (c7 = 1) OR (c7 = 2) OR (c7 = 3) OR (c7 = 4))) OR ((c230000009 = 'MAINKNOWLEDGEDATABASE'::citext) AND (c1000000079 = 'SGP000000000114'::citext) AND (c7 = 4)) OR ((c230000009 = 'MAINKNOWNERROR'::citext) AND (c1000000079 = 'SGP000000000114'::citext) AND ((c7 = 0) OR (c7 = 1) OR (c7 = 2))) OR ((c230000009 = 'MAINPROBLEM'::citext) AND (c1000000079 = 'SGP000000000114'::citext) AND ((c7 = 0) OR (c7 = 1) OR (c7 = 2) OR (c7 = 3) OR (c7 = 4) OR (c7 = 5))))
23. 0.012 0.012 ↓ 0.0 0 1

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

  • Filter: (((c230000009 = 'MAINCHANGE'::citext) AND ((c1000000079 = 'SGP000000000114'::citext) OR (c1000000079 = 'SGP000000000114'::citext) OR (c1000000079 = 'SGP000000000114'::citext)) AND ((c1000000079 = 'SGP000000000114'::citext) OR (c1000000079 = 'SGP000000000114'::citext) OR (c1000000079 = 'SGP000000000114'::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 = 'SGP000000000114'::citext) AND ((c7 = 0) OR (c7 = 1) OR (c7 = 2) OR (c7 = 3))) OR ((c230000009 = 'MAINWORKORDER'::citext) AND ((c1000000079 = 'SGP000000000114'::citext) OR (c1000000079 = 'SGP000000000114'::citext)) AND ((c1000000079 = 'SGP000000000114'::citext) OR (c1000000079 = 'SGP000000000114'::citext)) AND ((c7 = 0) OR (c7 = 1) OR (c7 = 2) OR (c7 = 3) OR (c7 = 4))) OR ((c230000009 = 'MAINKNOWLEDGEDATABASE'::citext) AND (c1000000079 = 'SGP000000000114'::citext) AND (c7 = 4)) OR ((c230000009 = 'MAINKNOWNERROR'::citext) AND (c1000000079 = 'SGP000000000114'::citext) AND ((c7 = 0) OR (c7 = 1) OR (c7 = 2))) OR ((c230000009 = 'MAINPROBLEM'::citext) AND (c1000000079 = 'SGP000000000114'::citext) AND ((c7 = 0) OR (c7 = 1) OR (c7 = 2) OR (c7 = 3) OR (c7 = 4) OR (c7 = 5))))
24. 0.008 0.008 ↓ 0.0 0 1

Parallel Seq Scan on t1508 (cost=0.00..11.54 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 ((c1000000079 = 'SGP000000000114'::citext) OR (c1000000079 = 'SGP000000000114'::citext) OR (c1000000079 = 'SGP000000000114'::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 = 'SGP000000000114'::citext) AND ((c7 = 0) OR (c7 = 1) OR (c7 = 2) OR (c7 = 3))) OR ((c230000009 = 'MAINWORKORDER'::citext) AND ((c1000000079 = 'SGP000000000114'::citext) OR (c1000000079 = 'SGP000000000114'::citext)) AND ((c1000000079 = 'SGP000000000114'::citext) OR (c1000000079 = 'SGP000000000114'::citext)) AND ((c7 = 0) OR (c7 = 1) OR (c7 = 2) OR (c7 = 3) OR (c7 = 4))) OR ((c230000009 = 'MAINKNOWLEDGEDATABASE'::citext) AND (c1000000079 = 'SGP000000000114'::citext) AND (c7 = 4)) OR ((c230000009 = 'MAINKNOWNERROR'::citext) AND (c1000000079 = 'SGP000000000114'::citext) AND ((c7 = 0) OR (c7 = 1) OR (c7 = 2))) OR ((c230000009 = 'MAINPROBLEM'::citext) AND (c1000000079 = 'SGP000000000114'::citext) AND ((c7 = 0) OR (c7 = 1) OR (c7 = 2) OR (c7 = 3) OR (c7 = 4) OR (c7 = 5))))
25. 0.007 0.007 ↓ 0.0 0 1

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

  • Filter: (((c230000009 = 'MAINCHANGE'::citext) AND ((c1000000427 = 'SGP000000000114'::citext) OR (c1000000079 = 'SGP000000000114'::citext) OR (c1000000079 = 'SGP000000000114'::citext)) AND ((c1000000427 = 'SGP000000000114'::citext) OR (c1000000079 = 'SGP000000000114'::citext) OR (c1000000079 = 'SGP000000000114'::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 = 'SGP000000000114'::citext) AND ((c7 = 0) OR (c7 = 1) OR (c7 = 2) OR (c7 = 3))) OR ((c230000009 = 'MAINWORKORDER'::citext) AND ((c1000000427 = 'SGP000000000114'::citext) OR (c1000000079 = 'SGP000000000114'::citext)) AND ((c1000000427 = 'SGP000000000114'::citext) OR (c1000000079 = 'SGP000000000114'::citext)) AND ((c7 = 0) OR (c7 = 1) OR (c7 = 2) OR (c7 = 3) OR (c7 = 4))) OR ((c230000009 = 'MAINKNOWLEDGEDATABASE'::citext) AND (c1000000079 = 'SGP000000000114'::citext) AND (c7 = 4)) OR ((c230000009 = 'MAINKNOWNERROR'::citext) AND (c1000000079 = 'SGP000000000114'::citext) AND ((c7 = 0) OR (c7 = 1) OR (c7 = 2))) OR ((c230000009 = 'MAINPROBLEM'::citext) AND (c1000000079 = 'SGP000000000114'::citext) AND ((c7 = 0) OR (c7 = 1) OR (c7 = 2) OR (c7 = 3) OR (c7 = 4) OR (c7 = 5))))
26. 0.007 0.007 ↓ 0.0 0 1

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

  • Filter: (((c301722900 = 'MAINCHANGE'::citext) AND ((c1000000079 = 'SGP000000000114'::citext) OR (c1000000079 = 'SGP000000000114'::citext) OR (c1000000079 = 'SGP000000000114'::citext)) AND ((c1000000079 = 'SGP000000000114'::citext) OR (c1000000079 = 'SGP000000000114'::citext) OR (c1000000079 = 'SGP000000000114'::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 = 'SGP000000000114'::citext) AND ((c1000002752 = 0) OR (c1000002752 = 1) OR (c1000002752 = 2) OR (c1000002752 = 3))) OR ((c301722900 = 'MAINWORKORDER'::citext) AND ((c1000000079 = 'SGP000000000114'::citext) OR (c1000000079 = 'SGP000000000114'::citext)) AND ((c1000000079 = 'SGP000000000114'::citext) OR (c1000000079 = 'SGP000000000114'::citext)) AND ((c1000002752 = 0) OR (c1000002752 = 1) OR (c1000002752 = 2) OR (c1000002752 = 3) OR (c1000002752 = 4))) OR ((c301722900 = 'MAINKNOWLEDGEDATABASE'::citext) AND (c1000000079 = 'SGP000000000114'::citext) AND (c1000002752 = 4)) OR ((c301722900 = 'MAINKNOWNERROR'::citext) AND (c1000000079 = 'SGP000000000114'::citext) AND ((c1000002752 = 0) OR (c1000002752 = 1) OR (c1000002752 = 2))) OR ((c301722900 = 'MAINPROBLEM'::citext) AND (c1000000079 = 'SGP000000000114'::citext) AND ((c1000002752 = 0) OR (c1000002752 = 1) OR (c1000002752 = 2) OR (c1000002752 = 3) OR (c1000002752 = 4) OR (c1000002752 = 5))))
27. 0.145 0.145 ↓ 0.0 0 1

Parallel Seq Scan on t1282 (cost=0.00..5.46 rows=1 width=764) (actual time=0.145..0.145 rows=0 loops=1)

  • Filter: (((c230000009 = 'MAINCHANGE'::citext) AND ((c10002505 = 'SGP000000000114'::citext) OR (c10002505 = 'SGP000000000114'::citext) OR (c10002505 = 'SGP000000000114'::citext)) AND ((c10002505 = 'SGP000000000114'::citext) OR (c10002505 = 'SGP000000000114'::citext) OR (c10002505 = 'SGP000000000114'::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 = 'SGP000000000114'::citext) AND ((c7 = 0) OR (c7 = 1) OR (c7 = 2) OR (c7 = 3))) OR ((c230000009 = 'MAINWORKORDER'::citext) AND ((c10002505 = 'SGP000000000114'::citext) OR (c10002505 = 'SGP000000000114'::citext)) AND ((c10002505 = 'SGP000000000114'::citext) OR (c10002505 = 'SGP000000000114'::citext)) AND ((c7 = 0) OR (c7 = 1) OR (c7 = 2) OR (c7 = 3) OR (c7 = 4))) OR ((c230000009 = 'MAINKNOWLEDGEDATABASE'::citext) AND (c10002505 = 'SGP000000000114'::citext) AND (c7 = 4)) OR ((c230000009 = 'MAINKNOWNERROR'::citext) AND (c10002505 = 'SGP000000000114'::citext) AND ((c7 = 0) OR (c7 = 1) OR (c7 = 2))) OR ((c230000009 = 'MAINPROBLEM'::citext) AND (c10002505 = 'SGP000000000114'::citext) AND ((c7 = 0) OR (c7 = 1) OR (c7 = 2) OR (c7 = 3) OR (c7 = 4) OR (c7 = 5))))
  • Rows Removed by Filter: 20
28. 1,672.823 3,956.843 ↓ 8.0 1,172,152 1

Parallel Hash (cost=32,555.66..32,555.66 rows=146,694 width=48) (actual time=3,956.843..3,956.843 rows=1,172,152 loops=1)

  • Buckets: 2097152 (originally 1048576) Batches: 2 (originally 1) Memory Usage: 70004kB
29. 1,651.081 2,284.020 ↓ 8.0 1,172,152 1

Hash Semi Join (cost=8.35..32,555.66 rows=146,694 width=48) (actual time=0.406..2,284.020 rows=1,172,152 loops=1)

  • Hash Cond: (s2075.labelvalue = "*VALUES*".column1)
30. 86.764 632.601 ↓ 4.0 1,172,280 1

Parallel Append (cost=0.00..30,145.20 rows=293,387 width=59) (actual time=0.039..632.601 rows=1,172,280 loops=1)

31. 434.856 434.856 ↓ 3.1 929,616 1

Parallel Seq Scan on s2075 (cost=0.00..22,679.96 rows=299,925 width=59) (actual time=0.035..434.856 rows=929,616 loops=1)

  • Filter: (labelid = ANY ('{112,60900,60901,60989}'::integer[]))
  • Rows Removed by Filter: 929330
32. 96.286 96.286 ↓ 1.7 204,288 1

Parallel Seq Scan on s1925 (cost=0.00..4,961.69 rows=120,825 width=59) (actual time=0.035..96.286 rows=204,288 loops=1)

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

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

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

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

  • Filter: (labelid = ANY ('{112,60900,60901,60989}'::integer[]))
35. 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[]))
36. 0.007 0.007 ↓ 0.0 0 1

Parallel Seq Scan on s1789 (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[]))
37. 0.016 0.016 ↓ 0.0 0 1

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

  • Filter: (labelid = ANY ('{112,60900,60901,60989}'::integer[]))
38. 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[]))
39. 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.004..0.004 rows=0 loops=1)

  • Filter: (labelid = ANY ('{112,60900,60901,60989}'::integer[]))
40. 0.045 0.045 ↓ 2.5 76 1

Parallel Seq Scan on s1282 (cost=0.00..1.71 rows=31 width=59) (actual time=0.020..0.045 rows=76 loops=1)

  • Filter: (labelid = ANY ('{112,60900,60901,60989}'::integer[]))
  • Rows Removed by Filter: 40
41. 0.207 0.338 ↑ 1.0 334 1

Hash (cost=4.17..4.17 rows=334 width=32) (actual time=0.338..0.338 rows=334 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 22kB
42. 0.131 0.131 ↑ 1.0 334 1

Values Scan on "*VALUES*" (cost=0.00..4.17 rows=334 width=32) (actual time=0.007..0.131 rows=334 loops=1)