explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 4Vk

Settings
# exclusive inclusive rows x rows loops node
1. 0.025 30,540.602 ↑ 1.0 10 1

Limit (cost=1,262,838.32..1,272,418.64 rows=10 width=2,304) (actual time=29,028.950..30,540.602 rows=10 loops=1)

2. 0.099 30,540.577 ↑ 144,358.9 10 1

Nested Loop Left Join (cost=1,262,838.32..1,384,268,276.92 rows=1,443,589 width=2,304) (actual time=29,028.947..30,540.577 rows=10 loops=1)

3. 0.069 30,540.378 ↑ 144,358.9 10 1

Nested Loop Left Join (cost=1,262,838.03..1,383,805,520.44 rows=1,443,589 width=2,226) (actual time=29,028.932..30,540.378 rows=10 loops=1)

4. 0.074 30,540.219 ↑ 144,358.9 10 1

Nested Loop Left Join (cost=1,262,837.74..1,383,333,475.96 rows=1,443,589 width=2,039) (actual time=29,028.918..30,540.219 rows=10 loops=1)

5. 0.067 30,540.025 ↑ 144,358.9 10 1

Nested Loop Left Join (cost=1,262,837.31..1,382,597,002.00 rows=1,443,589 width=1,721) (actual time=29,028.902..30,540.025 rows=10 loops=1)

6. 0.096 30,539.718 ↑ 144,358.9 10 1

Nested Loop Left Join (cost=1,262,836.89..1,381,871,322.30 rows=1,443,589 width=1,716) (actual time=29,028.871..30,539.718 rows=10 loops=1)

7. 852.644 30,539.342 ↑ 144,358.9 10 1

Nested Loop Left Join (cost=1,262,836.46..1,381,150,771.58 rows=1,443,589 width=1,537) (actual time=29,028.838..30,539.342 rows=10 loops=1)

  • Join Filter: (t1.sitepageid = t15.sitepageid)
  • Rows Removed by Join Filter: 653380
8. 0.066 27,840.218 ↑ 144,358.9 10 1

Merge Left Join (cost=1,262,836.04..1,570,111.91 rows=1,443,589 width=1,505) (actual time=27,839.516..27,840.218 rows=10 loops=1)

  • Merge Cond: (t1.sitepageid = pb.sitepageid)
9. 0.055 27,840.078 ↑ 144,358.9 10 1

Merge Left Join (cost=1,262,822.49..1,498,875.80 rows=1,443,589 width=1,244) (actual time=27,839.495..27,840.078 rows=10 loops=1)

  • Merge Cond: (t1.sitepageid = pk.sitepageid)
10. 0.056 27,839.969 ↑ 144,358.9 10 1

Merge Left Join (cost=1,262,813.86..1,459,055.28 rows=1,443,589 width=994) (actual time=27,839.476..27,839.969 rows=10 loops=1)

  • Merge Cond: (t1.sitepageid = pd.sitepageid)
11. 0.067 27,839.845 ↑ 144,358.9 10 1

Merge Left Join (cost=1,262,801.35..1,406,665.89 rows=1,443,589 width=595) (actual time=27,839.453..27,839.845 rows=10 loops=1)

  • Merge Cond: (t1.sitepageid = pt.sitepageid)
12. 0.101 27,839.712 ↑ 144,358.9 10 1

Merge Left Join (cost=1,262,789.29..1,346,964.11 rows=1,443,589 width=368) (actual time=27,839.430..27,839.712 rows=10 loops=1)

  • Merge Cond: (t1.sitepageid = sitepagestatistics.sitepageid)
  • Join Filter: (t1.taskid = 51312)
  • Rows Removed by Join Filter: 10
13. 0.051 27,839.456 ↑ 144,358.9 10 1

Merge Left Join (cost=1,262,774.32..1,270,003.91 rows=1,443,589 width=254) (actual time=27,839.382..27,839.456 rows=10 loops=1)

  • Merge Cond: (t1.sitepageid = a.sitepageid)
14. 4,570.901 26,130.136 ↑ 144,358.9 10 1

Sort (cost=1,232,419.19..1,236,028.17 rows=1,443,589 width=186) (actual time=26,130.103..26,130.136 rows=10 loops=1)

  • Sort Key: t1.sitepageid
  • Sort Method: external merge Disk: 284856kB
15. 3,614.460 21,559.235 ↓ 1.0 1,476,139 1

Subquery Scan on t1 (cost=0.00..818,283.17 rows=1,443,589 width=186) (actual time=0.057..21,559.235 rows=1,476,139 loops=1)

16. 17,944.775 17,944.775 ↓ 1.0 1,476,139 1

Seq Scan on sitepage (cost=0.00..803,847.28 rows=1,443,589 width=326) (actual time=0.055..17,944.775 rows=1,476,139 loops=1)

17. 140.427 1,709.269 ↑ 776.0 1 1

Sort (cost=30,355.13..30,357.07 rows=776 width=76) (actual time=1,709.269..1,709.269 rows=1 loops=1)

  • Sort Key: a.sitepageid
  • Sort Method: external sort Disk: 6088kB
18. 263.233 1,568.842 ↓ 84.2 65,338 1

Subquery Scan on a (cost=24,885.32..30,317.88 rows=776 width=76) (actual time=623.859..1,568.842 rows=65,338 loops=1)

  • Filter: (a.rownum = 1)
  • Rows Removed by Filter: 88608
19. 459.037 1,305.609 ↑ 1.0 153,946 1

WindowAgg (cost=24,885.32..28,377.68 rows=155,216 width=94) (actual time=623.851..1,305.609 rows=153,946 loops=1)

20. 629.018 846.572 ↑ 1.0 153,946 1

Sort (cost=24,885.32..25,273.36 rows=155,216 width=86) (actual time=623.839..846.572 rows=153,946 loops=1)

  • Sort Key: pageredirectdetail.taskid, pageredirectdetail.sitepageid, pageredirectdetail.sort DESC
  • Sort Method: external sort Disk: 14624kB
21. 217.554 217.554 ↑ 1.0 153,946 1

Seq Scan on pageredirectdetail (cost=0.00..4,072.16 rows=155,216 width=86) (actual time=0.014..217.554 rows=153,946 loops=1)

22. 0.155 0.155 ↑ 60,563.4 11 1

Index Scan using sitepagestatistics_pkey on sitepagestatistics (cost=0.42..63,358.28 rows=666,197 width=130) (actual time=0.033..0.155 rows=11 loops=1)

23. 0.066 0.066 ↑ 64,103.0 10 1

Index Scan using pagetitledetail_pkey on pagetitledetail pt (cost=0.42..48,128.34 rows=641,030 width=235) (actual time=0.017..0.066 rows=10 loops=1)

24. 0.068 0.068 ↑ 52,916.4 10 1

Index Scan using pagedecriptiondetail_pkey on pagedecriptiondetail pd (cost=0.42..42,165.86 rows=529,164 width=407) (actual time=0.017..0.068 rows=10 loops=1)

25. 0.054 0.054 ↑ 55,604.3 10 1

Index Scan using pagekeyworddetail_pkey on pagekeyworddetail pk (cost=0.42..29,261.01 rows=556,043 width=258) (actual time=0.014..0.054 rows=10 loops=1)

26. 0.074 0.074 ↑ 65,602.1 10 1

Index Scan using sitepagebodydetail_pkey on sitepagebodydetail pb (cost=0.42..59,426.87 rows=656,021 width=269) (actual time=0.014..0.074 rows=10 loops=1)

27. 911.819 1,846.480 ↓ 1.0 65,338 10

Materialize (cost=0.42..14,991.10 rows=63,710 width=40) (actual time=0.014..184.648 rows=65,338 loops=10)

28. 140.185 934.661 ↓ 1.0 65,338 1

Subquery Scan on t15 (cost=0.42..14,672.55 rows=63,710 width=40) (actual time=0.053..934.661 rows=65,338 loops=1)

29. 535.410 794.476 ↓ 1.0 65,338 1

GroupAggregate (cost=0.42..14,035.45 rows=63,710 width=48) (actual time=0.050..794.476 rows=65,338 loops=1)

  • Group Key: pageredirectdetail_1.taskid, pageredirectdetail_1.sitepageid
30. 259.066 259.066 ↑ 1.0 153,946 1

Index Scan using pageredirectdetail_urlid_idx on pageredirectdetail pageredirectdetail_1 (cost=0.42..11,298.88 rows=155,216 width=22) (actual time=0.016..259.066 rows=153,946 loops=1)

31. 0.280 0.280 ↑ 1.0 1 10

Index Scan using pagehtagdetail_pkey on pagehtagdetail (cost=0.42..0.49 rows=1 width=187) (actual time=0.026..0.028 rows=1 loops=10)

  • Index Cond: (t1.sitepageid = sitepageid)
32. 0.240 0.240 ↑ 1.0 1 10

Index Scan using pagerobotsdetail_pkey on pagerobotsdetail (cost=0.42..0.49 rows=1 width=13) (actual time=0.022..0.024 rows=1 loops=10)

  • Index Cond: (t1.sitepageid = sitepageid)
33. 0.120 0.120 ↑ 1.0 1 10

Index Scan using pagelinkrefdetail_pkey on pagelinkrefdetail (cost=0.42..0.50 rows=1 width=326) (actual time=0.010..0.012 rows=1 loops=10)

  • Index Cond: (t1.sitepageid = sitepageid)
34. 0.090 0.090 ↑ 1.0 1 10

Index Scan using pagepagingdetail_pkey on pagepagingdetail (cost=0.29..0.32 rows=1 width=195) (actual time=0.007..0.009 rows=1 loops=10)

  • Index Cond: (t1.sitepageid = sitepageid)
35. 0.100 0.100 ↑ 1.0 1 10

Index Scan using pagehreflang_pkey on pagehreflang (cost=0.29..0.31 rows=1 width=88) (actual time=0.008..0.010 rows=1 loops=10)

  • Index Cond: (t1.sitepageid = sitepageid)
Planning time : 9.531 ms
Execution time : 30,612.557 ms