explain.depesz.com

PostgreSQL's explain analyze made readable

Result: aWyR

Settings
# exclusive inclusive rows x rows loops node
1. 165.119 317.905 ↑ 9.9 4,557 1

Gather (cost=17,978.22..46,143.06 rows=45,094 width=1,527) (actual time=245.733..317.905 rows=4,557 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
2. 0.963 152.786 ↑ 12.4 1,519 3

Hash Left Join (cost=16,978.22..40,633.66 rows=18,789 width=1,527) (actual time=108.289..152.786 rows=1,519 loops=3)

  • Hash Cond: (mv.mediavariantid = mvs.mediavariantid)
3. 0.638 150.836 ↑ 12.4 1,519 3

Hash Left Join (cost=16,913.12..40,471.49 rows=18,789 width=1,203) (actual time=107.274..150.836 rows=1,519 loops=3)

  • Hash Cond: (mgc.gradecourseid = gc.gradecourseid)
4. 5.389 148.353 ↑ 12.4 1,519 3

Nested Loop Left Join (cost=16,901.36..40,409.60 rows=18,789 width=1,193) (actual time=105.414..148.353 rows=1,519 loops=3)

5. 0.675 142.961 ↑ 3.3 1,519 3

Hash Left Join (cost=16,900.94..35,503.34 rows=5,055 width=1,185) (actual time=103.790..142.961 rows=1,519 loops=3)

  • Hash Cond: (svst_i.tagid = vst_i.stimulustagid)
6. 0.842 138.971 ↑ 3.3 1,519 3

Hash Left Join (cost=16,416.90..35,006.03 rows=5,055 width=1,171) (actual time=100.409..138.971 rows=1,519 loops=3)

  • Hash Cond: (mv.mediavariantid = svst_i.mediavariantid)
7. 3.368 136.176 ↑ 3.3 1,516 3

Parallel Hash Left Join (cost=16,243.53..33,970.96 rows=5,055 width=1,163) (actual time=98.417..136.176 rows=1,516 loops=3)

  • Hash Cond: (mv.mediavariantid = mvauthor.mediavariantid)
8. 0.834 84.785 ↑ 3.3 1,516 3

Hash Left Join (cost=8,293.19..26,007.35 rows=5,055 width=1,149) (actual time=49.721..84.785 rows=1,516 loops=3)

  • Hash Cond: (mv.mediaid = mst_i.mediaid)
9. 4.540 76.133 ↑ 3.3 1,515 3

Nested Loop Left Join (cost=7,666.18..25,296.38 rows=5,055 width=1,135) (actual time=41.847..76.133 rows=1,515 loops=3)

10. 0.601 71.591 ↑ 3.3 1,513 3

Hash Left Join (cost=7,665.77..22,898.11 rows=4,974 width=1,135) (actual time=41.827..71.591 rows=1,513 loops=3)

  • Hash Cond: (mca.contentareaid = ca.contentareaid)
11. 2.930 70.437 ↑ 3.3 1,513 3

Nested Loop Left Join (cost=7,662.64..22,880.83 rows=4,974 width=917) (actual time=41.260..70.437 rows=1,513 loops=3)

12. 0.754 67.506 ↑ 3.3 1,513 3

Hash Join (cost=7,662.35..21,147.79 rows=4,974 width=909) (actual time=41.250..67.506 rows=1,513 loops=3)

  • Hash Cond: (mt.systemrecordid = srt.id)
13. 0.753 66.106 ↑ 3.3 1,513 3

Hash Join (cost=7,634.95..21,107.25 rows=4,974 width=911) (actual time=40.583..66.106 rows=1,513 loops=3)

  • Hash Cond: (m.mediatypeid = mt.mediatypeid)
14. 3.501 64.839 ↑ 3.3 1,513 3

Nested Loop Left Join (cost=7,621.31..21,080.36 rows=4,974 width=892) (actual time=40.059..64.839 rows=1,513 loops=3)

15. 4.237 61.336 ↑ 2.0 1,513 3

Nested Loop Left Join (cost=7,620.89..14,255.06 rows=3,065 width=884) (actual time=40.035..61.336 rows=1,513 loops=3)

16. 0.720 57.097 ↑ 2.0 1,513 3

Hash Join (cost=7,620.60..11,739.05 rows=3,065 width=884) (actual time=40.008..57.097 rows=1,513 loops=3)

  • Hash Cond: (mv.varianttypeid = vt.varianttypeid)
17. 0.759 55.991 ↑ 2.0 1,513 3

Hash Join (cost=7,618.88..11,728.21 rows=3,065 width=674) (actual time=39.606..55.991 rows=1,513 loops=3)

  • Hash Cond: (mf.systemrecordid = sr.id)
18. 0.812 55.018 ↑ 2.0 1,513 3

Hash Join (cost=7,591.48..11,692.71 rows=3,065 width=676) (actual time=39.376..55.018 rows=1,513 loops=3)

  • Hash Cond: (m.mediaformatid = mf.mediaformatid)
19. 0.676 53.810 ↑ 2.0 1,513 3

Hash Join (cost=7,588.08..11,680.73 rows=3,065 width=648) (actual time=38.922..53.810 rows=1,513 loops=3)

  • Hash Cond: (m.organizationid = org.organizationid)
20. 7.767 52.558 ↑ 2.0 1,513 3

Parallel Hash Join (cost=7,586.54..11,669.72 rows=3,065 width=438) (actual time=38.334..52.558 rows=1,513 loops=3)

  • Hash Cond: (m.mediaid = mv.mediaid)
21. 6.575 6.575 ↑ 1.3 42,542 3

Parallel Seq Scan on media m (cost=0.00..3,870.93 rows=53,193 width=43) (actual time=0.008..6.575 rows=42,542 loops=3)

22. 1.449 38.216 ↑ 2.0 1,513 3

Parallel Hash (cost=7,548.23..7,548.23 rows=3,065 width=395) (actual time=38.216..38.216 rows=1,513 loops=3)

  • Buckets: 8192 Batches: 1 Memory Usage: 1504kB
23. 36.767 36.767 ↑ 2.0 1,513 3

Parallel Seq Scan on mediavariant mv (cost=0.00..7,548.23 rows=3,065 width=395) (actual time=0.724..36.767 rows=1,513 loops=3)

  • Filter: (inuse AND (groupid = ANY ('{16007,15914}'::bigint[])) AND (organizationid = 12508))
  • Rows Removed by Filter: 41380
24. 0.016 0.576 ↑ 1.0 24 3

Hash (cost=1.24..1.24 rows=24 width=226) (actual time=0.576..0.576 rows=24 loops=3)

  • Buckets: 1024 Batches: 1 Memory Usage: 10kB
25. 0.560 0.560 ↑ 1.0 24 3

Seq Scan on organization_ org (cost=0.00..1.24 rows=24 width=226) (actual time=0.554..0.560 rows=24 loops=3)

26. 0.023 0.396 ↑ 1.0 62 3

Hash (cost=2.62..2.62 rows=62 width=28) (actual time=0.396..0.396 rows=62 loops=3)

  • Buckets: 1024 Batches: 1 Memory Usage: 12kB
27. 0.373 0.373 ↑ 1.0 62 3

Seq Scan on mediaformat mf (cost=0.00..2.62 rows=62 width=28) (actual time=0.360..0.373 rows=62 loops=3)

28. 0.108 0.214 ↓ 1.0 641 3

Hash (cost=19.40..19.40 rows=640 width=14) (actual time=0.214..0.214 rows=641 loops=3)

  • Buckets: 1024 Batches: 1 Memory Usage: 40kB
29. 0.106 0.106 ↓ 1.0 641 3

Seq Scan on systemrecord sr (cost=0.00..19.40 rows=640 width=14) (actual time=0.010..0.106 rows=641 loops=3)

30. 0.016 0.386 ↑ 1.0 32 3

Hash (cost=1.32..1.32 rows=32 width=226) (actual time=0.386..0.386 rows=32 loops=3)

  • Buckets: 1024 Batches: 1 Memory Usage: 10kB
31. 0.370 0.370 ↑ 1.0 32 3

Seq Scan on varianttype vt (cost=0.00..1.32 rows=32 width=226) (actual time=0.362..0.370 rows=32 loops=3)

32. 0.002 0.002 ↑ 1.0 1 4,539

Index Scan using ix_mediavariantattachment_mediavariantid on mediavariantattachment mva (cost=0.29..0.81 rows=1 width=16) (actual time=0.002..0.002 rows=1 loops=4,539)

  • Index Cond: (mv.mediavariantid = mediavariantid)
33. 0.002 0.002 ↓ 0.0 0 4,539

Index Scan using ix_testletmediavariant_mediavariantid on testletmediavariant testletmv (cost=0.42..2.10 rows=13 width=16) (actual time=0.002..0.002 rows=0 loops=4,539)

  • Index Cond: (mv.mediavariantid = mediavariantid)
34. 0.067 0.514 ↓ 1.0 296 3

Hash (cost=9.95..9.95 rows=295 width=27) (actual time=0.514..0.514 rows=296 loops=3)

  • Buckets: 1024 Batches: 1 Memory Usage: 26kB
35. 0.447 0.447 ↓ 1.0 296 3

Seq Scan on mediatype mt (cost=0.00..9.95 rows=295 width=27) (actual time=0.377..0.447 rows=296 loops=3)

36. 0.098 0.646 ↓ 1.0 641 3

Hash (cost=19.40..19.40 rows=640 width=14) (actual time=0.646..0.646 rows=641 loops=3)

  • Buckets: 1024 Batches: 1 Memory Usage: 40kB
37. 0.548 0.548 ↓ 1.0 641 3

Seq Scan on systemrecord srt (cost=0.00..19.40 rows=640 width=14) (actual time=0.453..0.548 rows=641 loops=3)

38. 0.001 0.001 ↓ 0.0 0 4,539

Index Scan using ix_mediacontentarea_mediaid on mediacontentarea mca (cost=0.29..0.34 rows=1 width=16) (actual time=0.001..0.001 rows=0 loops=4,539)

  • Index Cond: (m.mediaid = mediaid)
39. 0.018 0.553 ↑ 1.0 50 3

Hash (cost=2.50..2.50 rows=50 width=226) (actual time=0.553..0.553 rows=50 loops=3)

  • Buckets: 1024 Batches: 1 Memory Usage: 11kB
40. 0.535 0.535 ↑ 1.0 50 3

Seq Scan on contentarea ca (cost=0.00..2.50 rows=50 width=226) (actual time=0.528..0.535 rows=50 loops=3)

41. 0.002 0.002 ↑ 1.0 1 4,539

Index Scan using ix_mediatestingprogram_mediaid on mediatestingprogram mtp (cost=0.42..0.47 rows=1 width=16) (actual time=0.002..0.002 rows=1 loops=4,539)

  • Index Cond: (m.mediaid = mediaid)
42. 0.895 7.818 ↑ 1.0 4,536 3

Hash (cost=570.30..570.30 rows=4,536 width=30) (actual time=7.818..7.818 rows=4,536 loops=3)

  • Buckets: 8192 Batches: 1 Memory Usage: 350kB
43. 1.225 6.923 ↑ 1.0 4,536 3

Hash Left Join (cost=484.04..570.30 rows=4,536 width=30) (actual time=5.414..6.923 rows=4,536 loops=3)

  • Hash Cond: (mst_i.tagid = st_i.stimulustagid)
44. 0.828 0.828 ↑ 1.0 4,536 3

Seq Scan on mediatag mst_i (cost=0.00..74.36 rows=4,536 width=16) (actual time=0.437..0.828 rows=4,536 loops=3)

45. 2.048 4.870 ↑ 1.0 12,935 3

Hash (cost=322.35..322.35 rows=12,935 width=22) (actual time=4.870..4.870 rows=12,935 loops=3)

  • Buckets: 16384 Batches: 1 Memory Usage: 864kB
46. 2.822 2.822 ↑ 1.0 12,935 3

Seq Scan on stimulustag st_i (cost=0.00..322.35 rows=12,935 width=22) (actual time=0.556..2.822 rows=12,935 loops=3)

47. 0.000 48.023 ↑ 1.2 42,893 3

Parallel Hash (cost=7,280.15..7,280.15 rows=53,615 width=22) (actual time=48.023..48.023 rows=42,893 loops=3)

  • Buckets: 131072 Batches: 1 Memory Usage: 8384kB
48. 109.505 109.505 ↓ 2.4 128,678 1

Parallel Seq Scan on mediavariant mvauthor (cost=0.00..7,280.15 rows=53,615 width=22) (actual time=0.037..109.505 rows=128,678 loops=1)

49. 0.799 1.953 ↑ 1.0 5,972 3

Hash (cost=98.72..98.72 rows=5,972 width=16) (actual time=1.953..1.953 rows=5,972 loops=3)

  • Buckets: 8192 Batches: 1 Memory Usage: 344kB
50. 1.154 1.154 ↑ 1.0 5,972 3

Seq Scan on mediavarianttag svst_i (cost=0.00..98.72 rows=5,972 width=16) (actual time=0.488..1.154 rows=5,972 loops=3)

51. 1.692 3.315 ↑ 1.0 12,935 3

Hash (cost=322.35..322.35 rows=12,935 width=22) (actual time=3.315..3.315 rows=12,935 loops=3)

  • Buckets: 16384 Batches: 1 Memory Usage: 864kB
52. 1.623 1.623 ↑ 1.0 12,935 3

Seq Scan on stimulustag vst_i (cost=0.00..322.35 rows=12,935 width=22) (actual time=0.015..1.623 rows=12,935 loops=3)

53. 0.003 0.003 ↓ 0.0 0 4,557

Index Scan using ix_mediagradecourse_mediaid on mediagradecourse mgc (cost=0.42..0.82 rows=15 width=16) (actual time=0.003..0.003 rows=0 loops=4,557)

  • Index Cond: (m.mediaid = mediaid)
54. 0.044 1.845 ↑ 1.0 256 3

Hash (cost=8.56..8.56 rows=256 width=18) (actual time=1.845..1.845 rows=256 loops=3)

  • Buckets: 1024 Batches: 1 Memory Usage: 21kB
55. 1.801 1.801 ↑ 1.0 256 3

Seq Scan on gradecourse gc (cost=0.00..8.56 rows=256 width=18) (actual time=1.758..1.801 rows=256 loops=3)

56. 0.232 0.987 ↑ 1.0 2,138 3

Hash (cost=38.38..38.38 rows=2,138 width=8) (actual time=0.987..0.987 rows=2,138 loops=3)

  • Buckets: 4096 Batches: 1 Memory Usage: 116kB
57. 0.755 0.755 ↑ 1.0 2,138 3

Seq Scan on mediavariantshare mvs (cost=0.00..38.38 rows=2,138 width=8) (actual time=0.568..0.755 rows=2,138 loops=3)

Planning time : 7.773 ms
Execution time : 319.045 ms