explain.depesz.com

PostgreSQL's explain analyze made readable

Result: XoZd

Settings

Optimization(s) for this plan:

# exclusive inclusive rows x rows loops node
1. 12.090 36.961 ↑ 1.0 398 1

Merge Left Join (cost=78.57..80.62 rows=399 width=129) (actual time=20.412..36.961 rows=398 loops=1)

  • Merge Cond: (artists.id = paths."artistId")
2. 11.932 18.012 ↑ 1.0 398 1

Sort (cost=77.30..78.29 rows=399 width=109) (actual time=13.497..18.012 rows=398 loops=1)

  • Sort Key: artists.id DESC
  • Sort Method: quicksort Memory: 94kB
3. 6.080 6.080 ↑ 1.0 398 1

Seq Scan on artists (cost=0.00..60.06 rows=399 width=109) (actual time=0.940..6.080 rows=398 loops=1)

  • Filter: ("aliasId" IS NULL)
  • Rows Removed by Filter: 9
4. 0.239 6.859 ↑ 1.0 8 1

Sort (cost=1.25..1.27 rows=8 width=24) (actual time=6.782..6.859 rows=8 loops=1)

  • Sort Key: paths."artistId" DESC
  • Sort Method: quicksort Memory: 25kB
5. 6.620 6.620 ↑ 1.0 8 1

Seq Scan on paths (cost=0.00..1.13 rows=8 width=24) (actual time=6.530..6.620 rows=8 loops=1)

  • Filter: "isPrimary
  • Rows Removed by Filter: 9
Planning time : 67.325 ms
Execution time : 40.916 ms