explain.depesz.com

PostgreSQL's explain analyze made readable

Result: Tkcz

Settings
# exclusive inclusive rows x rows loops node
1. 0.011 688,562.785 ↑ 6.0 5 1

Limit (cost=885,179.66..885,179.73 rows=30 width=33) (actual time=688,562.773..688,562.785 rows=5 loops=1)

2. 0.020 688,562.774 ↑ 8.8 5 1

Sort (cost=885,179.66..885,179.77 rows=44 width=33) (actual time=688,562.770..688,562.774 rows=5 loops=1)

  • Sort Key: t_sys_users.c_username NULLS FIRST
  • Sort Method: quicksort Memory: 25kB
3. 0.000 688,562.754 ↑ 8.8 5 1

Group (cost=885,145.60..885,178.45 rows=44 width=33) (actual time=688,562.728..688,562.754 rows=5 loops=1)

  • Group Key: t_sys_users.c_userid
4. 338.292 688,900.361 ↑ 52.8 5 1

Gather Merge (cost=885,145.60..885,177.79 rows=264 width=33) (actual time=688,562.725..688,900.361 rows=5 loops=1)

  • Workers Planned: 6
  • Workers Launched: 0
5. 0.024 688,562.069 ↑ 8.8 5 1

Sort (cost=884,145.50..884,145.61 rows=44 width=33) (actual time=688,562.065..688,562.069 rows=5 loops=1)

  • Sort Key: t_sys_users.c_userid
  • Sort Method: quicksort Memory: 25kB
6. 15,445.123 688,562.045 ↑ 8.8 5 1

Partial HashAggregate (cost=884,143.86..884,144.30 rows=44 width=33) (actual time=688,562.040..688,562.045 rows=5 loops=1)

  • Group Key: t_sys_users.c_userid
7. 27,954.180 673,116.922 ↓ 6.5 19,009,137 1

Hash Join (cost=260,062.74..876,851.80 rows=2,916,824 width=33) (actual time=626,000.586..673,116.922 rows=19,009,137 loops=1)

  • Hash Cond: (t_e20so1_document_boolean_history.c_createdby = t_sys_users.c_userid)
8. 332,600.061 645,162.642 ↓ 6.4 19,009,137 1

Parallel Hash Join (cost=260,060.75..868,363.19 rows=2,952,052 width=8) (actual time=626,000.451..645,162.642 rows=19,009,137 loops=1)

  • Hash Cond: (t_e20so1_document_boolean_history.c_docid = t_e20so1_document.c_documentid)
9. 40,213.914 102,767.104 ↓ 6.4 19,009,137 1

Hash Left Join (cost=585.41..551,625.09 rows=2,987,706 width=16) (actual time=77.763..102,767.104 rows=19,009,137 loops=1)

  • 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: 8395988
10. 38,797.223 62,535.825 ↓ 6.0 19,268,597 1

Hash Left Join (cost=209.32..433,004.12 rows=3,214,035 width=41) (actual time=12.905..62,535.825 rows=19,268,597 loops=1)

  • Hash Cond: (t_e20so1_document_boolean_history.c_fieldsid = t_e20so1_fielddetails.c_fieldschemaid)
11. 23,726.777 23,726.777 ↓ 6.0 19,268,597 1

Parallel Seq Scan on t_e20so1_document_boolean_history_issues t_e20so1_document_boolean_history (cost=0.00..364,497.78 rows=3,214,035 width=32) (actual time=0.992..23,726.777 rows=19,268,597 loops=1)

  • Filter: (c_actiontype = 11)
  • Rows Removed by Filter: 445179
12. 6.931 11.825 ↓ 1.0 5,283 1

Hash (cost=144.70..144.70 rows=5,170 width=25) (actual time=11.823..11.825 rows=5,283 loops=1)

  • Buckets: 8192 Batches: 1 Memory Usage: 391kB
13. 4.894 4.894 ↓ 1.0 5,283 1

Seq Scan on t_e20so1_fielddetails (cost=0.00..144.70 rows=5,170 width=25) (actual time=0.027..4.894 rows=5,283 loops=1)

14. 8.655 17.365 ↓ 1.0 9,568 1

Hash (cost=262.15..262.15 rows=9,115 width=25) (actual time=17.364..17.365 rows=9,568 loops=1)

  • Buckets: 16384 Batches: 1 Memory Usage: 661kB
15. 8.710 8.710 ↓ 1.0 9,568 1

Seq Scan on t_sys_fieldpermission (cost=0.00..262.15 rows=9,115 width=25) (actual time=0.028..8.710 rows=9,568 loops=1)

16. 168,575.513 209,795.477 ↓ 7.0 15,981,478 1

Parallel Hash (cost=221,975.40..221,975.40 rows=2,285,675 width=8) (actual time=209,795.476..209,795.477 rows=15,981,478 loops=1)

  • Buckets: 32768 Batches: 1024 Memory Usage: 896kB
17. 25,770.249 41,219.964 ↓ 7.0 15,981,478 1

Parallel Append (cost=0.56..221,975.40 rows=2,285,675 width=8) (actual time=0.035..41,219.964 rows=15,981,478 loops=1)

18. 15,449.715 15,449.715 ↓ 7.0 15,981,478 1

Parallel Index Only Scan using t_e20so1_document_datastore_2_pkey on t_e20so1_document_datastore_2 t_e20so1_document (cost=0.56..210,547.03 rows=2,285,675 width=8) (actual time=0.032..15,449.715 rows=15,981,478 loops=1)

  • Index Cond: (c_datastoresid = 2)
  • Heap Fetches: 0
19. 0.048 0.100 ↓ 1.1 48 1

Hash (cost=1.44..1.44 rows=44 width=33) (actual time=0.099..0.100 rows=48 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 12kB
20. 0.052 0.052 ↓ 1.1 48 1

Seq Scan on t_sys_users (cost=0.00..1.44 rows=44 width=33) (actual time=0.011..0.052 rows=48 loops=1)

  • Filter: (c_userid IS NOT NULL)