explain.depesz.com

PostgreSQL's explain analyze made readable

Result: inN

Settings
# exclusive inclusive rows x rows loops node
1. 1.093 42.909 ↓ 82.6 6,770 1

Group (cost=3,674.67..3,675.08 rows=82 width=5) (actual time=41.253..42.909 rows=6,770 loops=1)

  • Group Key: a.assetid
2. 2.280 41.816 ↓ 89.5 7,338 1

Sort (cost=3,674.67..3,674.88 rows=82 width=4) (actual time=41.252..41.816 rows=7,338 loops=1)

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

Nested Loop (cost=1.28..3,672.07 rows=82 width=4) (actual time=0.031..39.536 rows=7,338 loops=1)

4. 0.844 18.654 ↓ 9.3 7,435 1

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

5. 2.940 2.940 ↓ 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.016..2.940 rows=7,435 loops=1)

  • Index Cond: ((foreigndescriptortypeid = 7,000) AND (foreignid = 10,000))
6. 14.870 14.870 ↑ 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.002..0.002 rows=1 loops=7,435)

  • Index Cond: (noteid = nr.noteid)
7. 22.305 22.305 ↑ 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.002..0.003 rows=1 loops=7,435)

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