explain.depesz.com

PostgreSQL's explain analyze made readable

Result: DVqB

Settings
# exclusive inclusive rows x rows loops node
1. 897.372 159,132.067 ↑ 1.0 30 1

Limit (cost=101,965,035.34..101,965,035.41 rows=30 width=31) (actual time=158,234.695..159,132.067 rows=30 loops=1)

2. 0.066 158,234.695 ↑ 5.4 30 1

Sort (cost=101,965,035.34..101,965,035.74 rows=163 width=31) (actual time=158,234.693..158,234.695 rows=30 loops=1)

  • Sort Key: t_sys_users.c_username NULLS FIRST
  • Sort Method: top-N heapsort Memory: 27kB
3. 0.000 158,234.629 ↑ 2.6 63 1

Group (cost=101,965,011.37..101,965,030.52 rows=163 width=31) (actual time=158,234.561..158,234.629 rows=63 loops=1)

  • Group Key: t_sys_users.c_userid
4. 2,211.716 159,131.062 ↑ 1.3 126 1

Gather Merge (cost=101,965,011.37..101,965,030.11 rows=163 width=31) (actual time=158,234.559..159,131.062 rows=126 loops=1)

  • Workers Planned: 1
  • Workers Launched: 1
5. 0.065 156,919.346 ↑ 2.6 63 2 / 2

Sort (cost=101,964,011.36..101,964,011.77 rows=163 width=31) (actual time=156,919.336..156,919.346 rows=63 loops=2)

  • Sort Key: t_sys_users.c_userid
  • Sort Method: quicksort Memory: 29kB
  • Worker 0: Sort Method: quicksort Memory: 29kB
6. 17,738.326 156,919.281 ↑ 2.6 63 2 / 2

Partial HashAggregate (cost=101,964,003.74..101,964,005.37 rows=163 width=31) (actual time=156,919.269..156,919.281 rows=63 loops=2)

  • Group Key: t_sys_users.c_userid
7. 35,922.891 139,180.955 ↑ 60.6 112,010,536 2 / 2

Hash Join (cost=993,802.84..85,005,752.21 rows=6,783,300,611 width=31) (actual time=63,926.616..139,180.955 rows=112,010,536 loops=2)

  • Hash Cond: (t_e20so1_document_boolean.c_fieldid = t_e20so1_batchstatus.c_batchlabelid)
8. 67,329.883 102,987.960 ↑ 1.2 70,700,704 2 / 2

Parallel Hash Join (cost=930,689.78..5,884,647.88 rows=83,169,882 width=16) (actual time=63,637.878..102,987.960 rows=70,700,704 loops=2)

  • Hash Cond: (t_e20so1_document_boolean.c_documentid = t_e20so1_document.c_documentid)
9. 28,866.559 28,866.559 ↑ 1.2 70,700,704 2 / 2

Parallel Index Only Scan using uc_unique_t_e20so1_document_boolean_batches on t_e20so1_document_boolean_batches t_e20so1_document_boolean (cost=0.57..2,309,741.19 rows=83,169,882 width=24) (actual time=16.924..28,866.559 rows=70,700,704 loops=2)

  • Heap Fetches: 0
10. 2,121.741 6,791.518 ↑ 1.2 7,995,650 2 / 2

Parallel Hash (cost=776,344.67..776,344.67 rows=9,407,643 width=8) (actual time=6,791.517..6,791.518 rows=7,995,650 loops=2)

  • Buckets: 65536 Batches: 512 Memory Usage: 1760kB
11. 1,031.559 4,669.777 ↑ 1.2 7,995,650 2 / 2

Parallel Append (cost=0.00..776,344.67 rows=9,407,643 width=8) (actual time=0.041..4,669.777 rows=7,995,650 loops=2)

12. 3,638.218 3,638.218 ↑ 1.2 7,995,650 2 / 2

Parallel Seq Scan on t_e20so1_document_datastore_default t_e20so1_document (cost=0.00..729,306.46 rows=9,407,643 width=8) (actual time=0.040..3,638.218 rows=7,995,650 loops=2)

  • Filter: (c_datastoresid = 11)
  • Rows Removed by Filter: 1112
13. 133.832 270.104 ↑ 4.1 456,985 2 / 2

Hash (cost=23,018.91..23,018.91 rows=1,883,292 width=47) (actual time=270.104..270.104 rows=456,985 loops=2)

  • Buckets: 32768 Batches: 128 Memory Usage: 463kB
14. 68.022 136.272 ↑ 4.1 456,985 2 / 2

Hash Join (cost=27.83..23,018.91 rows=1,883,292 width=47) (actual time=2.048..136.272 rows=456,985 loops=2)

  • Hash Cond: (t_e20so1_batchstatus.c_teamid = t_e20so1_teamusers.c_teamid)
15. 2.660 67.067 ↑ 4.6 3,409 2 / 2

Hash Join (cost=5.67..662.31 rows=15,560 width=55) (actual time=0.848..67.067 rows=3,409 loops=2)

  • Hash Cond: (t_e20so1_batchstatus.c_userid = t_sys_users.c_userid)
16. 64.318 64.318 ↑ 1.0 18,612 2 / 2

Seq Scan on t_e20so1_batchstatus (cost=0.00..604.91 rows=19,304 width=32) (actual time=0.737..64.318 rows=18,612 loops=2)

  • Filter: ((c_userid IS NOT NULL) OR (c_acceptedby IS NOT NULL))
  • Rows Removed by Filter: 4479
17. 0.038 0.089 ↑ 1.0 163 2 / 2

Hash (cost=3.63..3.63 rows=163 width=31) (actual time=0.088..0.089 rows=163 loops=2)

  • Buckets: 1024 Batches: 1 Memory Usage: 19kB
18. 0.051 0.051 ↑ 1.0 163 2 / 2

Seq Scan on t_sys_users (cost=0.00..3.63 rows=163 width=31) (actual time=0.022..0.051 rows=163 loops=2)

19. 0.127 1.183 ↑ 1.0 674 2 / 2

Hash (cost=13.74..13.74 rows=674 width=8) (actual time=1.183..1.183 rows=674 loops=2)

  • Buckets: 1024 Batches: 1 Memory Usage: 35kB
20. 1.056 1.056 ↑ 1.0 674 2 / 2

Seq Scan on t_e20so1_teamusers (cost=0.00..13.74 rows=674 width=8) (actual time=0.625..1.056 rows=674 loops=2)

  • Filter: (c_userid IS NOT NULL)