explain.depesz.com

PostgreSQL's explain analyze made readable

Result: hMgl

Settings
# exclusive inclusive rows x rows loops node
1. 67.009 143.933 ↓ 2.6 14,954 1

Sort (cost=1,456.41..1,470.99 rows=5,834 width=475) (actual time=137.455..143.933 rows=14,954 loops=1)

  • Sort Key: t.specificationname
  • Sort Method: external merge Disk: 7000kB
2. 10.052 76.924 ↓ 2.6 14,954 1

Hash Left Join (cost=611.22..1,091.48 rows=5,834 width=475) (actual time=21.028..76.924 rows=14,954 loops=1)

  • Hash Cond: (t.gradebandid = syst.id)
3. 10.290 66.462 ↓ 2.6 14,954 1

Hash Left Join (cost=584.03..990.64 rows=5,834 width=460) (actual time=20.606..66.462 rows=14,954 loops=1)

  • Hash Cond: (t.cognitivetaxonomyid = ct.cognitivetaxonomyid)
4. 10.161 56.147 ↓ 2.6 14,954 1

Hash Left Join (cost=582.40..917.06 rows=5,834 width=453) (actual time=20.568..56.147 rows=14,954 loops=1)

  • Hash Cond: (t.frameworklevelid = fl.frameworklevelid)
5. 10.039 45.745 ↓ 2.6 14,954 1

Hash Left Join (cost=568.38..829.54 rows=5,834 width=444) (actual time=20.314..45.745 rows=14,954 loops=1)

  • Hash Cond: (tstp.statementofpurposeid = stp.statementofpurposeid)
6. 13.882 35.622 ↓ 2.6 14,954 1

Hash Right Join (cost=562.88..750.86 rows=5,834 width=431) (actual time=20.219..35.622 rows=14,954 loops=1)

  • Hash Cond: (tstp.testspecificationid = t.testspecificationid)
7. 1.558 1.558 ↓ 1.0 6,045 1

Seq Scan on testspecstatementofpurpose tstp (cost=0.00..99.43 rows=6,043 width=16) (actual time=0.005..1.558 rows=6,045 loops=1)

8. 2.744 20.182 ↓ 1.1 2,791 1

Hash (cost=531.52..531.52 rows=2,509 width=423) (actual time=20.182..20.182 rows=2,791 loops=1)

  • Buckets: 4096 Batches: 1 Memory Usage: 1241kB
9. 1.921 17.438 ↓ 1.1 2,791 1

Hash Left Join (cost=366.13..531.52 rows=2,509 width=423) (actual time=10.804..17.438 rows=2,791 loops=1)

  • Hash Cond: (tstr.typeofreportingid = tyrp.typeofreportingid)
10. 3.459 15.454 ↓ 1.1 2,791 1

Hash Right Join (cost=362.49..496.50 rows=2,509 width=405) (actual time=10.729..15.454 rows=2,791 loops=1)

  • Hash Cond: (tstr.testspecificationid = t.testspecificationid)
11. 1.290 1.290 ↓ 1.0 5,447 1

Seq Scan on testspectypeofreporting tstr (cost=0.00..88.76 rows=5,376 width=16) (actual time=0.005..1.290 rows=5,447 loops=1)

12. 1.332 10.705 ↓ 1.1 1,309 1

Hash (cost=347.33..347.33 rows=1,213 width=397) (actual time=10.705..10.705 rows=1,309 loops=1)

  • Buckets: 2048 Batches: 1 Memory Usage: 548kB
13. 0.966 9.373 ↓ 1.1 1,309 1

Hash Left Join (cost=98.41..347.33 rows=1,213 width=397) (actual time=1.607..9.373 rows=1,309 loops=1)

  • Hash Cond: (t.testpopulationid = tpp.testpopulationid)
14. 0.967 8.383 ↓ 1.1 1,309 1

Hash Left Join (cost=96.80..330.79 rows=1,213 width=382) (actual time=1.574..8.383 rows=1,309 loops=1)

  • Hash Cond: (t.contentframeworkid = cf.contentframeworkid)
15. 0.910 6.930 ↓ 1.1 1,309 1

Hash Left Join (cost=74.73..292.61 rows=1,213 width=355) (actual time=1.079..6.930 rows=1,309 loops=1)

  • Hash Cond: (t.gradecourseid = gc.gradecourseid)
16. 0.882 5.843 ↓ 1.1 1,309 1

Hash Left Join (cost=62.99..265.59 rows=1,213 width=337) (actual time=0.893..5.843 rows=1,309 loops=1)

  • Hash Cond: (t.contentareaid = ca.contentareaid)
17. 0.876 4.923 ↓ 1.1 1,309 1

Hash Left Join (cost=59.87..247.36 rows=1,213 width=312) (actual time=0.847..4.923 rows=1,309 loops=1)

  • Hash Cond: (t.organizationid = org.organizationid)
18. 0.933 4.027 ↓ 1.1 1,309 1

Hash Left Join (cost=58.33..230.96 rows=1,213 width=294) (actual time=0.812..4.027 rows=1,309 loops=1)

  • Hash Cond: (t.testingprogramid = tp.testingprogramid)
19. 1.056 2.601 ↓ 1.1 1,309 1

Hash Left Join (cost=27.09..183.08 rows=1,213 width=271) (actual time=0.308..2.601 rows=1,309 loops=1)

  • Hash Cond: (t.testformatid = tf.testformatid)
20. 1.261 1.261 ↓ 1.1 1,309 1

Seq Scan on testspecification t (cost=0.00..139.99 rows=1,213 width=247) (actual time=0.013..1.261 rows=1,309 loops=1)

  • Filter: (inuse AND (organizationid = ANY ('{12508,15009}'::bigint[])) AND (approvedstatus = 0))
  • Rows Removed by Filter: 1284
21. 0.017 0.284 ↑ 1.0 36 1

Hash (cost=26.64..26.64 rows=36 width=32) (actual time=0.284..0.284 rows=36 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 11kB
22. 0.087 0.267 ↑ 1.0 36 1

Merge Right Join (cost=8.50..26.64 rows=36 width=32) (actual time=0.104..0.267 rows=36 loops=1)

  • Merge Cond: (sys.id = tf.systemrecordid)
23. 0.123 0.123 ↑ 2.2 287 1

Index Scan using systemrecord_pkey on systemrecord sys (cost=0.28..50.71 rows=631 width=14) (actual time=0.010..0.123 rows=287 loops=1)

24. 0.039 0.057 ↑ 1.0 36 1

Sort (cost=2.29..2.38 rows=36 width=26) (actual time=0.050..0.057 rows=36 loops=1)

  • Sort Key: tf.systemrecordid
  • Sort Method: quicksort Memory: 27kB
25. 0.018 0.018 ↑ 1.0 36 1

Seq Scan on testformat tf (cost=0.00..1.36 rows=36 width=26) (actual time=0.003..0.018 rows=36 loops=1)

26. 0.038 0.493 ↑ 1.0 58 1

Hash (cost=30.51..30.51 rows=58 width=31) (actual time=0.493..0.493 rows=58 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 12kB
27. 0.049 0.455 ↑ 1.0 58 1

Hash Left Join (cost=27.20..30.51 rows=58 width=31) (actual time=0.403..0.455 rows=58 loops=1)

  • Hash Cond: (tp.systemrecordid = systp.id)
28. 0.017 0.017 ↑ 1.0 58 1

Seq Scan on testingprogram tp (cost=0.00..2.58 rows=58 width=25) (actual time=0.003..0.017 rows=58 loops=1)

29. 0.202 0.389 ↓ 1.0 637 1

Hash (cost=19.31..19.31 rows=631 width=14) (actual time=0.389..0.389 rows=637 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 39kB
30. 0.187 0.187 ↓ 1.0 637 1

Seq Scan on systemrecord systp (cost=0.00..19.31 rows=631 width=14) (actual time=0.002..0.187 rows=637 loops=1)

31. 0.010 0.020 ↓ 1.0 25 1

Hash (cost=1.24..1.24 rows=24 width=26) (actual time=0.020..0.020 rows=25 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 10kB
32. 0.010 0.010 ↓ 1.0 25 1

Seq Scan on organization_ org (cost=0.00..1.24 rows=24 width=26) (actual time=0.003..0.010 rows=25 loops=1)

33. 0.019 0.038 ↓ 1.0 51 1

Hash (cost=2.50..2.50 rows=50 width=25) (actual time=0.038..0.038 rows=51 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 11kB
34. 0.019 0.019 ↓ 1.0 51 1

Seq Scan on contentarea ca (cost=0.00..2.50 rows=50 width=25) (actual time=0.002..0.019 rows=51 loops=1)

35. 0.084 0.177 ↓ 1.0 258 1

Hash (cost=8.55..8.55 rows=255 width=18) (actual time=0.177..0.177 rows=258 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 21kB
36. 0.093 0.093 ↓ 1.0 258 1

Seq Scan on gradecourse gc (cost=0.00..8.55 rows=255 width=18) (actual time=0.003..0.093 rows=258 loops=1)

37. 0.118 0.486 ↓ 1.1 349 1

Hash (cost=17.95..17.95 rows=330 width=27) (actual time=0.486..0.486 rows=349 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 29kB
38. 0.217 0.368 ↓ 1.1 349 1

Hash Left Join (cost=3.53..17.95 rows=330 width=27) (actual time=0.065..0.368 rows=349 loops=1)

  • Hash Cond: (cf.frameworktypeid = ft.frameworktypeid)
39. 0.098 0.098 ↓ 1.1 349 1

Seq Scan on contentframework cf (cost=0.00..10.30 rows=330 width=16) (actual time=0.003..0.098 rows=349 loops=1)

40. 0.026 0.053 ↓ 1.0 71 1

Hash (cost=2.68..2.68 rows=68 width=19) (actual time=0.053..0.053 rows=71 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 12kB
41. 0.027 0.027 ↓ 1.0 71 1

Seq Scan on frameworktype ft (cost=0.00..2.68 rows=68 width=19) (actual time=0.003..0.027 rows=71 loops=1)

42. 0.013 0.024 ↑ 1.0 27 1

Hash (cost=1.27..1.27 rows=27 width=23) (actual time=0.024..0.024 rows=27 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 10kB
43. 0.011 0.011 ↑ 1.0 27 1

Seq Scan on testpopulation tpp (cost=0.00..1.27 rows=27 width=23) (actual time=0.003..0.011 rows=27 loops=1)

44. 0.028 0.063 ↑ 1.0 73 1

Hash (cost=2.73..2.73 rows=73 width=26) (actual time=0.063..0.063 rows=73 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 13kB
45. 0.035 0.035 ↑ 1.0 73 1

Seq Scan on typeofreporting tyrp (cost=0.00..2.73 rows=73 width=26) (actual time=0.007..0.035 rows=73 loops=1)

46. 0.040 0.084 ↑ 1.0 111 1

Hash (cost=4.11..4.11 rows=111 width=21) (actual time=0.084..0.084 rows=111 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 14kB
47. 0.044 0.044 ↑ 1.0 111 1

Seq Scan on statementofpurpose stp (cost=0.00..4.11 rows=111 width=21) (actual time=0.004..0.044 rows=111 loops=1)

48. 0.106 0.241 ↓ 1.0 322 1

Hash (cost=10.12..10.12 rows=312 width=17) (actual time=0.241..0.241 rows=322 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 24kB
49. 0.135 0.135 ↓ 1.0 322 1

Seq Scan on frameworklevel fl (cost=0.00..10.12 rows=312 width=17) (actual time=0.004..0.135 rows=322 loops=1)

50. 0.012 0.025 ↓ 1.0 29 1

Hash (cost=1.28..1.28 rows=28 width=15) (actual time=0.025..0.025 rows=29 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 10kB
51. 0.013 0.013 ↓ 1.0 29 1

Seq Scan on cognitivetaxonomy ct (cost=0.00..1.28 rows=28 width=15) (actual time=0.004..0.013 rows=29 loops=1)

52. 0.221 0.410 ↓ 1.0 637 1

Hash (cost=19.31..19.31 rows=631 width=23) (actual time=0.410..0.410 rows=637 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 45kB
53. 0.189 0.189 ↓ 1.0 637 1

Seq Scan on systemrecord syst (cost=0.00..19.31 rows=631 width=23) (actual time=0.003..0.189 rows=637 loops=1)