explain.depesz.com

PostgreSQL's explain analyze made readable

Result: It8b

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

CTE Scan on rec (cost=17,921.93..18,976.93 rows=52,750 width=124) (actual time=2.374..614.334 rows=10,309 loops=1)

2.          

CTE rec

3. 3.500 610.322 ↑ 5.1 10,309 1

Recursive Union (cost=11.44..17,921.93 rows=52,750 width=75) (actual time=2.373..610.322 rows=10,309 loops=1)

4. 0.002 2.374 ↑ 20.0 2 1

Nested Loop (cost=11.44..459.95 rows=40 width=75) (actual time=2.371..2.374 rows=2 loops=1)

5. 1.300 2.366 ↑ 20.0 2 1

Hash Join (cost=11.15..444.91 rows=40 width=16) (actual time=2.365..2.366 rows=2 loops=1)

  • Hash Cond: (fed.fileid = fl.id)
6. 1.017 1.017 ↑ 1.0 22,572 1

Seq Scan on svnlogentrydetails fed (cost=0.00..348.72 rows=22,572 width=16) (actual time=0.011..1.017 rows=22,572 loops=1)

7. 0.003 0.049 ↑ 1.0 1 1

Hash (cost=11.14..11.14 rows=1 width=4) (actual time=0.049..0.049 rows=1 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
8. 0.046 0.046 ↑ 1.0 1 1

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

  • Filter: (name = 'UY2MV9ZXMY'::text)
  • Rows Removed by Filter: 570
9. 0.006 0.006 ↑ 1.0 1 2

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

  • Index Cond: (id = fed.logid)
  • Filter: (NOT isdeleted)
10. 117.605 604.448 ↑ 53.2 99 104

Hash Join (cost=824.48..1,640.70 rows=5,271 width=75) (actual time=5.039..5.812 rows=99 loops=104)

  • Hash Cond: (fe_1.id = fed_1.logid)
  • Join Filter: (fe_1.revision <= rec_1.copyrevision)
  • Rows Removed by Join Filter: 0
11. 233.707 233.707 ↑ 1.0 22,571 103

Seq Scan on svnlogentries fe_1 (cost=0.00..505.71 rows=22,571 width=63) (actual time=0.002..2.269 rows=22,571 loops=103)

  • Filter: (NOT isdeleted)
12. 2.080 253.136 ↑ 159.7 99 104

Hash (cost=626.83..626.83 rows=15,812 width=20) (actual time=2.434..2.434 rows=99 loops=104)

  • Buckets: 16384 Batches: 1 Memory Usage: 128kB
13. 141.864 251.056 ↑ 159.7 99 104

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

  • Hash Cond: (fed_1.fileid = fl_1.id)
14. 107.944 107.944 ↑ 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.048 rows=22,572 loops=103)

15. 0.104 1.248 ↑ 400.0 1 104

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

  • Buckets: 1024 Batches: 1 Memory Usage: 8kB
16. 0.499 1.144 ↑ 400.0 1 104

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

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

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

18. 0.062 0.125 ↑ 1.0 571 1

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

  • Buckets: 1024 Batches: 1 Memory Usage: 29kB
19. 0.063 0.063 ↑ 1.0 571 1

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