explain.depesz.com

PostgreSQL's explain analyze made readable

Result: ajuE

Settings
# exclusive inclusive rows x rows loops node
1. 2.970 50.386 ↑ 1.0 700 1

Limit (cost=10,908.41..10,992.95 rows=700 width=583) (actual time=46.01..50.386 rows=700 loops=1)

  • Buffers: shared hit=28379, temp read=1349 written=1976
2. 0.000 47.416 ↑ 16.7 1,200 1

Aggregate (cost=10,848.03..13,263.06 rows=19,997 width=583) (actual time=44.872..47.416 rows=1,200 loops=1)

  • Buffers: shared hit=12754, temp read=379 written=914
3. 0.000 49.780 ↑ 13.9 1,201 1

Gather Merge (cost=10,848.03..12,938.11 rows=16,664 width=583) (actual time=44.857..49.78 rows=1,201 loops=1)

  • Buffers: shared hit=28379, temp read=1349 written=1976
4. 3.072 123.597 ↑ 17.1 488 3

Aggregate (cost=9,848.01..10,014.65 rows=8,332 width=583) (actual time=39.494..41.199 rows=488 loops=3)

  • Buffers: shared hit=28379, temp read=1349 written=1976
5. 63.978 120.525 ↑ 2.1 3,905 3

Sort (cost=9,848.01..9,868.84 rows=8,332 width=583) (actual time=39.48..40.175 rows=3,905 loops=3)

  • Sort Key: v.video_id, vc.content_id
  • Sort Method: external merge Disk: 7296kB
  • Buffers: shared hit=28379, temp read=1349 written=1976
6. 9.138 56.547 ↓ 1.8 15,092 3

Hash Join (cost=21.99..7,138.91 rows=8,332 width=583) (actual time=0.241..18.849 rows=15,092 loops=3)

  • Buffers: shared hit=28347
7. 3.486 47.076 ↓ 1.3 1,892 3

Nested Loop (cost=16.56..7,032.36 rows=1,426 width=583) (actual time=0.116..15.692 rows=1,892 loops=3)

  • Buffers: shared hit=28341
8. 8.289 32.238 ↓ 1.1 1,892 3

Hash Join (cost=16.15..6,056.44 rows=1,665 width=575) (actual time=0.1..10.746 rows=1,892 loops=3)

  • Buffers: shared hit=5635
9. 23.748 23.748 ↑ 1.3 20,599 3

Seq Scan on video v (cost=0..5,926.93 rows=25,790 width=579) (actual time=0.007..7.916 rows=20,599 loops=3)

  • Filter: (NOT v.draft)
  • Buffers: shared hit=5579
10. 0.039 0.201 ↑ 1.0 33 3

Hash (cost=15.73..15.73 rows=33 width=4) (actual time=0.067..0.067 rows=33 loops=3)

  • Buffers: shared hit=38
11. 0.024 0.162 ↑ 1.0 33 3

Nested Loop (cost=4.53..15.73 rows=33 width=4) (actual time=0.031..0.054 rows=33 loops=3)

  • Buffers: shared hit=38
12. 0.042 0.042 ↑ 1.0 1 3

Seq Scan on customer c (cost=0..2.46 rows=1 width=4) (actual time=0.009..0.014 rows=1 loops=3)

  • Filter: (c.customer_id = 6)
  • Buffers: shared hit=6
13. 0.054 0.096 ↑ 1.0 33 3

Bitmap Heap Scan on user u (cost=4.53..12.94 rows=33 width=8) (actual time=0.02..0.032 rows=33 loops=3)

  • Buffers: shared hit=32
14. 0.042 0.042 ↑ 1.0 33 3

Bitmap Index Scan on account_user_customer_idx (cost=0..4.52 rows=33 width=0) (actual time=0.014..0.014 rows=33 loops=3)

  • Index Cond: (u.customer_id = 6)
  • Buffers: shared hit=8
15. 11.352 11.352 ↑ 1.0 1 5,676

Index Scan using content_pkey on content vc (cost=0.42..0.59 rows=1 width=16) (actual time=0.002..0.002 rows=1 loops=5,676)

  • Index Cond: (vc.content_id = v.active_content_id)
  • Filter: (vc.content_status_id = 6)
  • Buffers: shared hit=22706
16. 0.069 0.333 ↑ 1.0 96 3

Hash (cost=4.22..4.22 rows=96 width=8) (actual time=0.111..0.111 rows=96 loops=3)

  • Buffers: shared hit=6
17. 0.135 0.264 ↑ 1.0 96 3

Hash Join (cost=1.99..4.22 rows=96 width=8) (actual time=0.047..0.088 rows=96 loops=3)

  • Buffers: shared hit=6
18. 0.042 0.042 ↑ 1.0 96 3

Seq Scan on preset_rendition pr (cost=0..1.96 rows=96 width=8) (actual time=0.005..0.014 rows=96 loops=3)

  • Buffers: shared hit=3
19. 0.039 0.087 ↑ 1.0 44 3

Hash (cost=1.44..1.44 rows=44 width=8) (actual time=0.029..0.029 rows=44 loops=3)

  • Buffers: shared hit=3
20. 0.048 0.048 ↑ 1.0 44 3

Seq Scan on rendition r (cost=0..1.44 rows=44 width=8) (actual time=0.008..0.016 rows=44 loops=3)

  • Buffers: shared hit=3