explain.depesz.com

PostgreSQL's explain analyze made readable

Result: AahW

Settings
# exclusive inclusive rows x rows loops node
1. 0.004 193,583.365 ↑ 2.0 15 1

Limit (cost=12,127,310.65..12,127,310.72 rows=30 width=31) (actual time=193,583.362..193,583.365 rows=15 loops=1)

2. 0.041 193,583.361 ↑ 10.9 15 1

Sort (cost=12,127,310.65..12,127,311.06 rows=163 width=31) (actual time=193,583.360..193,583.361 rows=15 loops=1)

  • Sort Key: t_sys_users.c_username NULLS FIRST
  • Sort Method: quicksort Memory: 26kB
3. 0.000 193,583.320 ↑ 10.9 15 1

Group (cost=12,127,286.68..12,127,305.84 rows=163 width=31) (actual time=193,583.304..193,583.320 rows=15 loops=1)

  • Group Key: t_sys_users.c_userid
4. 837.331 194,416.089 ↑ 6.0 27 1

Gather Merge (cost=12,127,286.68..12,127,305.43 rows=163 width=31) (actual time=193,583.300..194,416.089 rows=27 loops=1)

  • Workers Planned: 1
  • Workers Launched: 1
5. 0.048 193,578.758 ↑ 11.6 14 2 / 2

Sort (cost=12,126,286.67..12,126,287.08 rows=163 width=31) (actual time=193,578.757..193,578.758 rows=14 loops=2)

  • Sort Key: t_sys_users.c_userid
  • Sort Method: quicksort Memory: 26kB
  • Worker 0: Sort Method: quicksort Memory: 26kB
6. 708.944 193,578.710 ↑ 11.6 14 2 / 2

Partial HashAggregate (cost=12,126,279.05..12,126,280.68 rows=163 width=31) (actual time=193,578.706..193,578.710 rows=14 loops=2)

  • Group Key: t_sys_users.c_userid
7. 6,403.475 192,869.766 ↑ 14.0 4,204,922 2 / 2

Hash Join (cost=931,016.02..11,978,666.58 rows=59,044,988 width=31) (actual time=167,414.054..192,869.766 rows=4,204,922 loops=2)

  • Hash Cond: (t_e20so1_document_boolean_history.c_createdby = t_sys_users.c_userid)
8. 37,443.122 186,466.192 ↑ 1.0 58,576,481 2 / 2

Parallel Hash Join (cost=931,010.36..11,819,637.91 rows=59,044,988 width=8) (actual time=167,413.871..186,466.192 rows=58,576,481 loops=2)

  • Hash Cond: (t_e20so1_document_boolean_history.c_docid = t_e20so1_document.c_documentid)
9. 31,536.764 135,557.292 ↑ 1.0 58,576,481 2 / 2

Hash Left Join (cost=321.15..9,116,164.32 rows=59,054,831 width=16) (actual time=32.268..135,557.292 rows=58,576,481 loops=2)

  • Hash Cond: (t_e20so1_document_boolean_history.c_fieldsid = t_sys_fieldpermission.c_fieldschemaid)
  • Filter: (((t_sys_fieldpermission.c_roleid = 2) AND t_sys_fieldpermission.c_isdisplay) OR (t_e20so1_fielddetails.c_isprivate AND (t_e20so1_fielddetails.c_createdby = 71939)))
  • Rows Removed by Filter: 74894784
10. 18,551.182 104,017.342 ↑ 1.2 58,646,099 2 / 2

Hash Left Join (cost=83.68..5,806,594.15 rows=68,960,564 width=41) (actual time=29.019..104,017.342 rows=58,646,099 loops=2)

  • Hash Cond: (t_e20so1_document_boolean_history.c_fieldsid = t_e20so1_fielddetails.c_fieldschemaid)
11. 85,464.999 85,464.999 ↑ 1.2 58,646,099 2 / 2

Parallel Seq Scan on t_e20so1_document_boolean_history_folders t_e20so1_document_boolean_history (cost=0.00..4,858,417.65 rows=68,960,564 width=32) (actual time=27.502..85,464.999 rows=58,646,099 loops=2)

  • Filter: (c_actiontype = 3)
  • Rows Removed by Filter: 29858327
12. 0.436 1.161 ↑ 1.0 2,297 2 / 2

Hash (cost=54.97..54.97 rows=2,297 width=25) (actual time=1.161..1.161 rows=2,297 loops=2)

  • Buckets: 4096 Batches: 1 Memory Usage: 174kB
13. 0.725 0.725 ↑ 1.0 2,297 2 / 2

Seq Scan on t_e20so1_fielddetails (cost=0.00..54.97 rows=2,297 width=25) (actual time=0.050..0.725 rows=2,297 loops=2)

14. 1.147 3.186 ↑ 1.0 6,154 2 / 2

Hash (cost=160.54..160.54 rows=6,154 width=25) (actual time=3.186..3.186 rows=6,154 loops=2)

  • Buckets: 8192 Batches: 1 Memory Usage: 407kB
15. 2.039 2.039 ↑ 1.0 6,154 2 / 2

Seq Scan on t_sys_fieldpermission (cost=0.00..160.54 rows=6,154 width=25) (actual time=0.039..2.039 rows=6,154 loops=2)

16. 2,526.091 13,465.778 ↑ 1.2 7,995,650 2 / 2

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

  • Buckets: 65536 Batches: 512 Memory Usage: 1760kB
17. 1,037.709 10,939.687 ↑ 1.2 7,995,650 2 / 2

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

18. 9,901.978 9,901.978 ↑ 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.034..9,901.978 rows=7,995,650 loops=2)

  • Filter: (c_datastoresid = 11)
  • Rows Removed by Filter: 1112
19. 0.037 0.099 ↑ 1.0 163 2 / 2

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

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

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

  • Filter: (c_userid IS NOT NULL)