explain.depesz.com

PostgreSQL's explain analyze made readable

Result: Aecf

Settings
# exclusive inclusive rows x rows loops node
1. 602.235 602.235 ↑ 5.1 10,309 1

CTE Scan on rec (cost=29,940.88..30,995.88 rows=52,750 width=124) (actual time=0.063..602.235 rows=10,309 loops=1)

2.          

CTE rec

3. 2.140 598.124 ↑ 5.1 10,309 1

Recursive Union (cost=0.58..29,940.88 rows=52,750 width=67) (actual time=0.062..598.124 rows=10,309 loops=1)

4. 0.000 0.064 ↑ 20.0 2 1

Nested Loop (cost=0.58..55.82 rows=40 width=67) (actual time=0.061..0.064 rows=2 loops=1)

5. 0.001 0.058 ↑ 20.0 2 1

Nested Loop (cost=0.29..33.18 rows=40 width=16) (actual time=0.057..0.058 rows=2 loops=1)

6. 0.054 0.054 ↑ 1.0 1 1

Seq Scan on svnfiles fl (cost=0.00..11.14 rows=1 width=4) (actual time=0.054..0.054 rows=1 loops=1)

  • Filter: (name = 'UY2MV9ZXMY'::text)
  • Rows Removed by Filter: 570
7. 0.003 0.003 ↑ 20.0 2 1

Index Scan using idx_svn_log_entry_details_file_id on svnlogentrydetails fed (cost=0.29..21.64 rows=40 width=16) (actual time=0.002..0.003 rows=2 loops=1)

  • Index Cond: (fileid = fl.id)
8. 0.006 0.006 ↑ 1.0 1 2

Index Scan using svnlogentries_pkey on svnlogentries fe (cost=0.29..0.56 rows=1 width=55) (actual time=0.002..0.003 rows=1 loops=2)

  • Index Cond: (id = fed.logid)
  • Filter: (NOT isdeleted)
9. 70.928 595.920 ↑ 53.2 99 104

Merge Join (cost=1,729.93..2,883.01 rows=5,271 width=67) (actual time=5.589..5.730 rows=99 loops=104)

  • Merge Cond: (fe_1.id = fed_1.logid)
  • Join Filter: (fe_1.revision <= rec_1.copyrevision)
  • Rows Removed by Join Filter: 0
10. 272.584 272.584 ↑ 5.7 17,894 104

Index Scan using svnlogentries_pkey on svnlogentries fe_1 (cost=0.29..3,778.86 rows=102,571 width=55) (actual time=0.004..2.621 rows=17,894 loops=104)

  • Filter: (NOT isdeleted)
11. 3.744 252.408 ↑ 159.7 99 104

Sort (cost=1,729.62..1,769.15 rows=15,812 width=20) (actual time=2.420..2.427 rows=99 loops=104)

  • Sort Key: fed_1.logid
  • Sort Method: quicksort Memory: 25kB
12. 142.564 248.664 ↑ 159.7 99 104

Hash Join (cost=35.35..626.83 rows=15,812 width=20) (actual time=1.834..2.391 rows=99 loops=104)

  • Hash Cond: (fed_1.fileid = fl_1.id)
13. 105.060 105.060 ↑ 1.0 22,572 103

Seq Scan on svnlogentrydetails fed_1 (cost=0.00..348.72 rows=22,572 width=16) (actual time=0.003..1.020 rows=22,572 loops=103)

14. 0.104 1.040 ↑ 400.0 1 104

Hash (cost=30.35..30.35 rows=400 width=12) (actual time=0.010..0.010 rows=1 loops=104)

  • Buckets: 1024 Batches: 1 Memory Usage: 8kB
15. 0.415 0.936 ↑ 400.0 1 104

Hash Join (cost=16.85..30.35 rows=400 width=12) (actual time=0.003..0.009 rows=1 loops=104)

  • Hash Cond: (rec_1.copyfile = fl_1.id)
16. 0.416 0.416 ↑ 4.0 99 104

WorkTable Scan on rec rec_1 (cost=0.00..8.00 rows=400 width=8) (actual time=0.000..0.004 rows=99 loops=104)

17. 0.057 0.105 ↑ 1.0 571 1

Hash (cost=9.71..9.71 rows=571 width=4) (actual time=0.105..0.105 rows=571 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 29kB
18. 0.048 0.048 ↑ 1.0 571 1

Seq Scan on svnfiles fl_1 (cost=0.00..9.71 rows=571 width=4) (actual time=0.007..0.048 rows=571 loops=1)