explain.depesz.com

PostgreSQL's explain analyze made readable

Result: Az1u

Settings
# exclusive inclusive rows x rows loops node
1. 32.976 927.959 ↓ 37.9 7,584 1

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

  • Group Key: cii.contentitemid
2. 117.811 894.983 ↑ 39.5 8,503 1

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

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

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

4. 3.425 184.795 ↑ 11.0 2,378 1

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

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

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

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

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

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

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

8. 3.140 48.379 ↓ 1.2 2,974 1

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

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

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

Planning time : 0.336 ms