explain.depesz.com

PostgreSQL's explain analyze made readable

Result: Q79c

Settings
# exclusive inclusive rows x rows loops node
1. 1.684 71.107 ↓ 82.6 6,770 1

Unique (cost=3,674.67..3,675.08 rows=82 width=5) (actual time=68.421..71.107 rows=6,770 loops=1)

2. 3.654 69.423 ↓ 89.5 7,338 1

Sort (cost=3,674.67..3,674.88 rows=82 width=5) (actual time=68.419..69.423 rows=7,338 loops=1)

  • Sort Key: a.assetid
  • Sort Method: quicksort Memory: 536kB
3. 4.707 65.769 ↓ 89.5 7,338 1

Nested Loop (cost=1.28..3,672.07 rows=82 width=5) (actual time=0.041..65.769 rows=7,338 loops=1)

4. 4.733 31.322 ↓ 9.3 7,435 1

Nested Loop (cost=0.84..2,546.61 rows=798 width=4) (actual time=0.029..31.322 rows=7,435 loops=1)

5. 4.284 4.284 ↓ 9.3 7,435 1

Index Scan using notereference_foreignidandtype_idx on notereference nr (cost=0.42..629.91 rows=798 width=4) (actual time=0.021..4.284 rows=7,435 loops=1)

  • Index Cond: ((foreigndescriptortypeid = 7,000) AND (foreignid = 10,000))
6. 22.305 22.305 ↑ 1.0 1 7,435

Index Scan using note_pk on note n (cost=0.42..2.39 rows=1 width=8) (actual time=0.003..0.003 rows=1 loops=7,435)

  • Index Cond: (noteid = nr.noteid)
7. 29.740 29.740 ↑ 1.0 1 7,435

Index Scan using asset_pk on asset a (cost=0.44..1.40 rows=1 width=4) (actual time=0.004..0.004 rows=1 loops=7,435)

  • Index Cond: (assetid = n.assetid)
  • Filter: (workid = 444)
  • Rows Removed by Filter: 0
Planning time : 0.590 ms
Execution time : 71.619 ms