explain.depesz.com

PostgreSQL's explain analyze made readable

Result: cV64

Settings
# exclusive inclusive rows x rows loops node
1. 0.029 12,530.571 ↑ 1.0 10 1

Limit (cost=314,630.14..324,219.74 rows=10 width=2,304) (actual time=11,021.465..12,530.571 rows=10 loops=1)

2. 0.085 12,530.542 ↑ 34,535.5 10 1

Nested Loop Left Join (cost=314,630.14..331,496,283.22 rows=345,355 width=2,304) (actual time=11,021.461..12,530.542 rows=10 loops=1)

3. 0.055 12,522.757 ↑ 34,535.5 10 1

Nested Loop Left Join (cost=314,629.85..331,384,961.62 rows=345,355 width=2,226) (actual time=11,013.802..12,522.757 rows=10 loops=1)

4. 0.074 12,513.842 ↑ 34,535.5 10 1

Nested Loop Left Join (cost=314,629.56..331,264,352.02 rows=345,355 width=2,039) (actual time=11,004.994..12,513.842 rows=10 loops=1)

5. 0.069 12,507.128 ↑ 34,535.5 10 1

Nested Loop Left Join (cost=314,629.13..331,030,320.10 rows=345,355 width=1,721) (actual time=10,998.473..12,507.128 rows=10 loops=1)

6. 0.083 12,490.409 ↑ 34,535.5 10 1

Nested Loop Left Join (cost=314,628.71..330,834,538.32 rows=345,355 width=1,716) (actual time=10,982.034..12,490.409 rows=10 loops=1)

7. 860.059 12,482.926 ↑ 34,535.5 10 1

Nested Loop Left Join (cost=314,628.29..330,641,139.92 rows=345,355 width=1,537) (actual time=10,974.791..12,482.926 rows=10 loops=1)

  • Join Filter: (t1.sitepageid = t15.sitepageid)
  • Rows Removed by Join Filter: 653378
8. 100.894 9,771.007 ↑ 34,535.5 10 1

Merge Left Join (cost=314,627.87..587,802.34 rows=345,355 width=1,505) (actual time=9,770.321..9,771.007 rows=10 loops=1)

  • Merge Cond: (t1.sitepageid = pb.sitepageid)
9. 83.082 9,311.418 ↑ 34,535.5 10 1

Merge Left Join (cost=314,614.32..522,418.48 rows=345,355 width=1,244) (actual time=9,310.867..9,311.418 rows=10 loops=1)

  • Merge Cond: (t1.sitepageid = pk.sitepageid)
10. 82.618 8,932.441 ↑ 34,535.5 10 1

Merge Left Join (cost=314,605.68..487,450.42 rows=345,355 width=994) (actual time=8,931.957..8,932.441 rows=10 loops=1)

  • Merge Cond: (t1.sitepageid = pd.sitepageid)
11. 100.097 8,526.621 ↑ 34,535.5 10 1

Merge Left Join (cost=314,593.17..439,644.71 rows=345,355 width=595) (actual time=8,526.224..8,526.621 rows=10 loops=1)

  • Merge Cond: (t1.sitepageid = pt.sitepageid)
12. 110.210 8,060.436 ↑ 34,535.5 10 1

Merge Left Join (cost=314,581.11..385,645.26 rows=345,355 width=368) (actual time=8,060.154..8,060.436 rows=10 loops=1)

  • Merge Cond: (t1.sitepageid = sitepagestatistics.sitepageid)
13. 7.960 7,578.831 ↑ 34,535.5 10 1

Merge Left Join (cost=314,566.14..316,304.56 rows=345,355 width=246) (actual time=7,578.744..7,578.831 rows=10 loops=1)

  • Merge Cond: (t1.sitepageid = a.sitepageid)
14. 807.442 5,841.682 ↑ 34,535.5 10 1

Sort (cost=284,211.01..285,074.40 rows=345,355 width=178) (actual time=5,841.649..5,841.682 rows=10 loops=1)

  • Sort Key: t1.sitepageid
  • Sort Method: external merge Disk: 60792kB
15. 849.803 5,034.240 ↓ 1.0 350,119 1

Subquery Scan on t1 (cost=0.43..221,750.79 rows=345,355 width=178) (actual time=0.066..5,034.240 rows=350,119 loops=1)

16. 4,184.437 4,184.437 ↓ 1.0 350,119 1

Index Scan using sitepage_taskid_idx on sitepage (cost=0.43..218,297.24 rows=345,355 width=326) (actual time=0.062..4,184.437 rows=350,119 loops=1)

  • Index Cond: (taskid = 51312)
17. 152.983 1,729.189 ↓ 8.5 6,574 1

Sort (cost=30,355.13..30,357.07 rows=776 width=76) (actual time=1,719.698..1,729.189 rows=6,574 loops=1)

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

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

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

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

20. 634.177 852.293 ↑ 1.0 153,946 1

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

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

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

22. 371.395 371.395 ↑ 7.8 85,507 1

Index Scan using sitepagestatistics_pkey on sitepagestatistics (cost=0.42..63,358.28 rows=666,197 width=130) (actual time=0.046..371.395 rows=85,507 loops=1)

23. 366.088 366.088 ↑ 7.6 84,048 1

Index Scan using pagetitledetail_pkey on pagetitledetail pt (cost=0.42..48,128.34 rows=641,030 width=235) (actual time=0.022..366.088 rows=84,048 loops=1)

24. 323.202 323.202 ↑ 7.5 70,416 1

Index Scan using pagedecriptiondetail_pkey on pagedecriptiondetail pd (cost=0.42..42,165.86 rows=529,164 width=407) (actual time=0.019..323.202 rows=70,416 loops=1)

25. 295.895 295.895 ↑ 7.6 72,997 1

Index Scan using pagekeyworddetail_pkey on pagekeyworddetail pk (cost=0.42..29,261.01 rows=556,043 width=258) (actual time=0.017..295.895 rows=72,997 loops=1)

26. 358.695 358.695 ↑ 7.7 85,507 1

Index Scan using sitepagebodydetail_pkey on sitepagebodydetail pb (cost=0.42..59,426.87 rows=656,021 width=269) (actual time=0.019..358.695 rows=85,507 loops=1)

27. 899.932 1,851.860 ↓ 1.0 65,338 10

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

28. 141.765 951.928 ↓ 1.0 65,338 1

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

29. 546.363 810.163 ↓ 1.0 65,338 1

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

  • Group Key: pageredirectdetail_1.taskid, pageredirectdetail_1.sitepageid
30. 263.800 263.800 ↑ 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.013..263.800 rows=153,946 loops=1)

31. 7.400 7.400 ↓ 0.0 0 10

Index Scan using pagehtagdetail_pkey on pagehtagdetail (cost=0.42..0.55 rows=1 width=187) (actual time=0.739..0.740 rows=0 loops=10)

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

Index Scan using pagerobotsdetail_pkey on pagerobotsdetail (cost=0.42..0.56 rows=1 width=13) (actual time=1.664..1.665 rows=1 loops=10)

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

Index Scan using pagelinkrefdetail_pkey on pagelinkrefdetail (cost=0.42..0.67 rows=1 width=326) (actual time=0.663..0.664 rows=1 loops=10)

  • Index Cond: (t1.sitepageid = sitepageid)
34. 8.860 8.860 ↓ 0.0 0 10

Index Scan using pagepagingdetail_pkey on pagepagingdetail (cost=0.29..0.34 rows=1 width=195) (actual time=0.886..0.886 rows=0 loops=10)

  • Index Cond: (t1.sitepageid = sitepageid)
35. 7.700 7.700 ↓ 0.0 0 10

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

  • Index Cond: (t1.sitepageid = sitepageid)
Planning time : 9.455 ms
Execution time : 12,552.527 ms