explain.depesz.com

PostgreSQL's explain analyze made readable

Result: qMug

Settings
# exclusive inclusive rows x rows loops node
1. 0.010 760,840.767 ↑ 6.0 5 1

Limit (cost=2,664,654.07..2,664,654.14 rows=30 width=33) (actual time=760,840.756..760,840.767 rows=5 loops=1)

2. 0.142 760,840.757 ↑ 8.8 5 1

Sort (cost=2,664,654.07..2,664,654.18 rows=44 width=33) (actual time=760,840.753..760,840.757 rows=5 loops=1)

  • Sort Key: t_sys_users.c_username NULLS FIRST
  • Sort Method: quicksort Memory: 25kB
3. 16,331.037 760,840.615 ↑ 8.8 5 1

HashAggregate (cost=2,664,652.42..2,664,652.86 rows=44 width=33) (actual time=760,840.610..760,840.615 rows=5 loops=1)

  • Group Key: t_sys_users.c_username, t_sys_users.c_userid
4. 26,843.999 744,509.578 ↓ 1.1 19,009,137 1

Gather (cost=268,521.98..2,578,910.53 rows=17,148,379 width=33) (actual time=666,787.807..744,509.578 rows=19,009,137 loops=1)

  • Workers Planned: 6
  • Workers Launched: 0
5. 28,639.679 717,665.579 ↓ 6.7 19,009,137 1

Hash Join (cost=267,521.98..863,072.63 rows=2,858,063 width=33) (actual time=666,787.213..717,665.579 rows=19,009,137 loops=1)

  • Hash Cond: (t_e20so1_document_boolean_history.c_createdby = t_sys_users.c_userid)
6. 336,177.254 689,025.801 ↓ 6.5 19,009,137 1

Parallel Hash Join (cost=267,519.99..854,702.36 rows=2,912,628 width=8) (actual time=666,787.080..689,025.801 rows=19,009,137 loops=1)

  • Hash Cond: (t_e20so1_document_boolean_history.c_docid = t_e20so1_document.c_documentid)
7. 39,156.857 133,746.727 ↓ 6.4 19,009,137 1

Parallel Hash Left Join (cost=8,044.65..538,298.91 rows=2,968,840 width=16) (actual time=92.857..133,746.727 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
8. 37,500.576 94,559.367 ↓ 6.0 19,268,597 1

Hash Left Join (cost=209.32..456,705.55 rows=3,214,035 width=41) (actual time=10.305..94,559.367 rows=19,268,597 loops=1)

  • Hash Cond: (t_e20so1_document_boolean_history.c_fieldsid = t_e20so1_fielddetails.c_fieldschemaid)
9. 33,122.581 57,049.202 ↓ 6.0 19,268,597 1

Parallel Append (cost=0.00..388,782.11 rows=3,214,035 width=32) (actual time=0.679..57,049.202 rows=19,268,597 loops=1)

10. 23,926.621 23,926.621 ↓ 6.0 19,268,597 1

Parallel Seq Scan on t_e20so1_document_boolean_history_issues t_e20so1_document_boolean_history (cost=0.00..372,711.93 rows=3,214,035 width=32) (actual time=0.675..23,926.621 rows=19,268,597 loops=1)

  • Filter: ((c_actiontype = 11) AND (c_tablegroupid = 'c0b2f85c-bc93-466b-a54d-b1330440db98'::uuid))
  • Rows Removed by Filter: 445179
11. 4.753 9.589 ↓ 1.0 5,283 1

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

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

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

13. 9.587 30.503 ↓ 1.8 9,568 1

Parallel Hash (cost=7,768.30..7,768.30 rows=5,362 width=25) (actual time=30.502..30.503 rows=9,568 loops=1)

  • Buckets: 16384 Batches: 1 Memory Usage: 736kB
14. 20.916 20.916 ↓ 1.8 9,568 1

Parallel Index Scan using "UQ_8cf37391-dff4-4d53-975c-0e8ddc9a64fe" on t_sys_fieldpermission (cost=0.29..7,768.30 rows=5,362 width=25) (actual time=0.036..20.916 rows=9,568 loops=1)

15. 177,412.291 219,101.820 ↓ 7.0 15,981,478 1

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

  • Buckets: 32768 Batches: 1024 Memory Usage: 896kB
16. 25,980.489 41,689.529 ↓ 7.0 15,981,478 1

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

17. 15,709.040 15,709.040 ↓ 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.031..15,709.040 rows=15,981,478 loops=1)

  • Index Cond: (c_datastoresid = 2)
  • Heap Fetches: 0
18. 0.049 0.099 ↓ 1.1 48 1

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

  • Buckets: 1024 Batches: 1 Memory Usage: 12kB
19. 0.050 0.050 ↓ 1.1 48 1

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

  • Filter: (c_userid IS NOT NULL)