explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 7glO

Settings
# exclusive inclusive rows x rows loops node
1. 36.732 482.392 ↓ 37.9 7,584 1

GroupAggregate (cost=3,043.10..12,373.25 rows=200 width=40) (actual time=152.519..482.392 rows=7,584 loops=1)

  • Group Key: cii.contentitemid
2. 17.417 445.660 ↑ 39.5 8,503 1

Merge Left Join (cost=3,043.10..8,176.51 rows=335,539 width=16) (actual time=152.496..445.660 rows=8,503 loops=1)

  • Merge Cond: (cii.contentitemid = t2ci.contentitemid)
3. 281.363 281.363 ↓ 3.0 7,584 1

Foreign Scan on contentitem cii (cost=100.00..193.92 rows=2,560 width=8) (actual time=6.754..281.363 rows=7,584 loops=1)

4. 4.928 146.880 ↑ 11.0 2,378 1

Sort (cost=2,943.10..3,008.64 rows=26,214 width=16) (actual time=145.738..146.880 rows=2,378 loops=1)

  • Sort Key: t2ci.contentitemid
  • Sort Method: quicksort Memory: 208kB
5. 3.200 141.952 ↑ 11.0 2,378 1

Merge Left Join (cost=615.80..1,019.25 rows=26,214 width=16) (actual time=134.276..141.952 rows=2,378 loops=1)

  • Merge Cond: (t2ci.termid = cit.termid)
6. 2.444 91.126 ↓ 1.2 2,378 1

Sort (cost=284.08..289.20 rows=2,048 width=16) (actual time=90.049..91.126 rows=2,378 loops=1)

  • Sort Key: t2ci.termid
  • Sort Method: quicksort Memory: 208kB
7. 88.682 88.682 ↓ 1.2 2,378 1

Foreign Scan on term_to_contentitem t2ci (cost=100.00..171.44 rows=2,048 width=16) (actual time=5.439..88.682 rows=2,378 loops=1)

8. 4.400 47.626 ↓ 1.2 2,974 1

Sort (cost=331.72..338.12 rows=2,560 width=8) (actual time=44.206..47.626 rows=2,974 loops=1)

  • Sort Key: cit.termid
  • Sort Method: quicksort Memory: 112kB
9. 43.226 43.226 ↑ 1.9 1,354 1

Foreign Scan on term cit (cost=100.00..186.80 rows=2,560 width=8) (actual time=5.625..43.226 rows=1,354 loops=1)

Planning time : 0.320 ms