explain.depesz.com

PostgreSQL's explain analyze made readable

Result: Yssx

Settings
# exclusive inclusive rows x rows loops node
1. 0.007 0.118 ↓ 1.1 30 1

Unique (cost=7.79..8.03 rows=27 width=1,457) (actual time=0.110..0.118 rows=30 loops=1)

2. 0.034 0.111 ↓ 1.0 50 1

Sort (cost=7.79..7.91 rows=48 width=1,457) (actual time=0.109..0.111 rows=50 loops=1)

  • Sort Key: artists.id
  • Sort Method: quicksort Memory: 50kB
3. 0.024 0.077 ↓ 1.0 50 1

Hash Join (cost=3.68..6.45 rows=48 width=1,457) (actual time=0.038..0.077 rows=50 loops=1)

  • Hash Cond: (library_files__artists.library_file__id = libraries_files.id)
4. 0.021 0.034 ↓ 1.0 50 1

Hash Join (cost=1.61..4.24 rows=48 width=1,186) (actual time=0.014..0.034 rows=50 loops=1)

  • Hash Cond: (library_files__artists.artist__id = artists.id)
5. 0.006 0.006 ↓ 1.0 50 1

Seq Scan on library_files__artists (cost=0.00..2.48 rows=48 width=74) (actual time=0.002..0.006 rows=50 loops=1)

6. 0.004 0.007 ↓ 1.1 31 1

Hash (cost=1.27..1.27 rows=27 width=1,112) (actual time=0.006..0.007 rows=31 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 12kB
7. 0.003 0.003 ↓ 1.1 31 1

Seq Scan on artists (cost=0.00..1.27 rows=27 width=1,112) (actual time=0.002..0.003 rows=31 loops=1)

8. 0.007 0.019 ↓ 1.0 44 1

Hash (cost=1.54..1.54 rows=43 width=255) (actual time=0.019..0.019 rows=44 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 15kB
9. 0.012 0.012 ↓ 1.0 44 1

Seq Scan on libraries_files (cost=0.00..1.54 rows=43 width=255) (actual time=0.008..0.012 rows=44 loops=1)

  • Filter: (library_id = '4697b1b3-6b46-47ac-98d9-ef4a5003d9ca'::uuid)
Planning time : 0.273 ms
Execution time : 0.163 ms