explain.depesz.com

PostgreSQL's explain analyze made readable

Result: f9ye

Settings
# exclusive inclusive rows x rows loops node
1. 60.498 705.601 ↓ 37.9 7,584 1

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

  • Group Key: cii.contentitemid
2. 35.598 645.103 ↑ 39.5 8,503 1

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

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

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

4. 3.414 247.916 ↑ 11.0 2,378 1

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

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

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

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

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

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

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

8. 3.510 93.445 ↓ 1.2 2,974 1

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

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

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

Planning time : 0.948 ms