explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 9oHe

Settings
# exclusive inclusive rows x rows loops node
1. 0.010 13,996.679 ↑ 1.0 10 1

Limit (cost=909,574.12..909,574.15 rows=10 width=168) (actual time=13,996.671..13,996.679 rows=10 loops=1)

  • Buffers: shared hit=38841 read=914048 dirtied=3703 written=765826
2. 0.049 13,996.669 ↑ 2.0 10 1

Sort (cost=909,574.12..909,574.17 rows=20 width=168) (actual time=13,996.669..13,996.669 rows=10 loops=1)

  • Sort Key: ((SubPlan 1)), ((SubPlan 2)) DESC
  • Sort Method: quicksort Memory: 30kB
  • Buffers: shared hit=38841 read=914048 dirtied=3703 written=765826
3. 0.023 13,996.620 ↑ 1.0 20 1

WindowAgg (cost=909,521.84..909,573.69 rows=20 width=168) (actual time=13,996.568..13,996.620 rows=20 loops=1)

  • Buffers: shared hit=38838 read=914048 dirtied=3703 written=765826
4. 0.025 13,996.537 ↑ 1.0 20 1

GroupAggregate (cost=909,521.84..909,522.74 rows=20 width=148) (actual time=13,996.522..13,996.537 rows=20 loops=1)

  • Group Key: sm.keyword_name
  • Buffers: shared hit=38838 read=914048 dirtied=3703 written=765826
5. 0.032 13,996.512 ↑ 1.0 20 1

Sort (cost=909,521.84..909,521.89 rows=20 width=36) (actual time=13,996.512..13,996.512 rows=20 loops=1)

  • Sort Key: sm.keyword_name
  • Sort Method: quicksort Memory: 26kB
  • Buffers: shared hit=38838 read=914048 dirtied=3703 written=765826
6. 0.007 13,996.480 ↑ 1.0 20 1

Subquery Scan on sm (cost=909,518.81..909,521.41 rows=20 width=36) (actual time=13,763.480..13,996.480 rows=20 loops=1)

  • Buffers: shared hit=38838 read=914048 dirtied=3703 written=765826
7. 0.010 13,996.473 ↑ 1.0 20 1

Limit (cost=909,518.81..909,521.21 rows=20 width=36) (actual time=13,763.475..13,996.473 rows=20 loops=1)

  • Buffers: shared hit=38838 read=914048 dirtied=3703 written=765826
8. 0.000 13,996.463 ↑ 41,924.8 20 1

Gather Merge (cost=909,518.81..1,009,915.83 rows=838,496 width=36) (actual time=13,763.474..13,996.463 rows=20 loops=1)

  • Workers Planned: 4
  • Workers Launched: 4
  • Buffers: shared hit=38838 read=914048 dirtied=3703 written=765826
9. 319.540 68,736.395 ↑ 13,101.5 16 5

Sort (cost=908,518.75..909,042.81 rows=209,624 width=36) (actual time=13,747.278..13,747.279 rows=16 loops=5)

  • Sort Key: keywords_indexation_2019_07_29.application_position, keywords_indexation_2019_07_29.search_volume
  • Sort Method: top-N heapsort Memory: 28kB
  • Worker 0: Sort Method: top-N heapsort Memory: 27kB
  • Worker 1: Sort Method: top-N heapsort Memory: 28kB
  • Worker 2: Sort Method: top-N heapsort Memory: 27kB
  • Worker 3: Sort Method: top-N heapsort Memory: 28kB
  • Buffers: shared hit=38838 read=914048 dirtied=3703 written=765826
10. 108.504 68,416.855 ↑ 1.1 192,252 5

Parallel Append (cost=917.69..902,940.73 rows=209,624 width=36) (actual time=1,058.566..13,683.371 rows=192,252 loops=5)

  • Buffers: shared hit=38810 read=914048 dirtied=3703 written=765826
11. 4,622.130 6,468.195 ↓ 3.9 82,938 1

Parallel Bitmap Heap Scan on keywords_indexation_2019_07_29 (cost=1,139.56..90,940.27 rows=21,235 width=36) (actual time=1,885.908..6,468.195 rows=82,938 loops=1)

  • Recheck Cond: (application_id = '4dfa1260-de4d-68c2-fc5c-7112cbb265e7'::uuid)
  • Filter: ((date >= '2019-07-20'::date) AND (date <= '2019-08-04'::date))
  • Buffers: shared hit=1 read=83126 written=71663
12. 1,846.065 1,846.065 ↑ 1.0 82,938 1

Bitmap Index Scan on keywords_indexation_2019_07_29_application_id_idx1 (cost=0.00..1,118.33 rows=84,941 width=0) (actual time=1,846.065..1,846.065 rows=82,938 loops=1)

  • Index Cond: (application_id = '4dfa1260-de4d-68c2-fc5c-7112cbb265e7'::uuid)
  • Buffers: shared hit=1 read=389 written=263
13. 4,748.869 6,187.856 ↓ 3.5 72,217 1

Parallel Bitmap Heap Scan on keywords_indexation_2019_08_02 (cost=1,115.66..88,884.09 rows=20,784 width=36) (actual time=1,589.235..6,187.856 rows=72,217 loops=1)

  • Recheck Cond: (application_id = '4dfa1260-de4d-68c2-fc5c-7112cbb265e7'::uuid)
  • Filter: ((date >= '2019-07-20'::date) AND (date <= '2019-08-04'::date))
  • Buffers: shared hit=1 read=72370 written=62954
14. 1,438.987 1,438.987 ↑ 1.2 72,217 1

Bitmap Index Scan on keywords_indexation_2019_08_02_application_id_idx1 (cost=0.00..1,094.88 rows=83,135 width=0) (actual time=1,438.987..1,438.987 rows=72,217 loops=1)

  • Index Cond: (application_id = '4dfa1260-de4d-68c2-fc5c-7112cbb265e7'::uuid)
  • Buffers: shared hit=1 read=356 written=232
15. 4,670.614 6,351.152 ↓ 4.0 77,123 1

Parallel Bitmap Heap Scan on keywords_indexation_2019_07_27 (cost=1,025.43..81,972.79 rows=19,115 width=36) (actual time=1,763.268..6,351.152 rows=77,123 loops=1)

  • Recheck Cond: (application_id = '4dfa1260-de4d-68c2-fc5c-7112cbb265e7'::uuid)
  • Filter: ((date >= '2019-07-20'::date) AND (date <= '2019-08-04'::date))
  • Buffers: shared hit=1 read=77331 written=67801
16. 1,680.538 1,680.538 ↓ 1.0 77,123 1

Bitmap Index Scan on keywords_indexation_2019_07_27_application_id_idx1 (cost=0.00..1,006.32 rows=76,460 width=0) (actual time=1,680.538..1,680.538 rows=77,123 loops=1)

  • Index Cond: (application_id = '4dfa1260-de4d-68c2-fc5c-7112cbb265e7'::uuid)
  • Buffers: shared hit=1 read=365 written=241
17. 1,863.247 1,888.547 ↓ 3.3 62,337 1

Parallel Bitmap Heap Scan on keywords_indexation_2019_07_20 (cost=917.69..81,914.71 rows=19,117 width=38) (actual time=38.429..1,888.547 rows=62,337 loops=1)

  • Recheck Cond: (application_id = '4dfa1260-de4d-68c2-fc5c-7112cbb265e7'::uuid)
  • Filter: ((date >= '2019-07-20'::date) AND (date <= '2019-08-04'::date))
  • Buffers: shared hit=1 read=62483 written=56859
18. 25.300 25.300 ↑ 1.2 62,337 1

Bitmap Index Scan on keywords_indexation_2019_07_20_application_id_idx1 (cost=0.00..898.57 rows=76,467 width=0) (actual time=25.300..25.300 rows=62,337 loops=1)

  • Index Cond: (application_id = '4dfa1260-de4d-68c2-fc5c-7112cbb265e7'::uuid)
  • Buffers: shared hit=1 read=243
19. 5,603.745 10,212.415 ↓ 7.6 126,312 1

Parallel Bitmap Heap Scan on keywords_indexation_2019_08_01 (cost=893.99..72,852.08 rows=16,720 width=36) (actual time=4,641.143..10,212.415 rows=126,312 loops=1)

  • Recheck Cond: (application_id = '4dfa1260-de4d-68c2-fc5c-7112cbb265e7'::uuid)
  • Filter: ((date >= '2019-07-20'::date) AND (date <= '2019-08-04'::date))
  • Buffers: shared hit=1 read=126521 written=100409
20. 4,608.670 4,608.670 ↓ 1.9 126,312 1

Bitmap Index Scan on keywords_indexation_2019_08_01_application_id_idx1 (cost=0.00..877.27 rows=66,880 width=0) (actual time=4,608.669..4,608.670 rows=126,312 loops=1)

  • Index Cond: (application_id = '4dfa1260-de4d-68c2-fc5c-7112cbb265e7'::uuid)
  • Buffers: shared hit=1 read=589 written=511
21. 5,160.002 8,180.166 ↓ 2.2 35,936 2

Parallel Bitmap Heap Scan on keywords_indexation_2019_07_31 (cost=891.82..71,548.56 rows=16,614 width=36) (actual time=1,651.691..4,090.083 rows=35,936 loops=2)

  • Recheck Cond: (application_id = '4dfa1260-de4d-68c2-fc5c-7112cbb265e7'::uuid)
  • Filter: ((date >= '2019-07-20'::date) AND (date <= '2019-08-04'::date))
  • Buffers: shared hit=1 read=72059 written=59980
22. 3,020.164 3,020.164 ↓ 1.1 71,872 1

Bitmap Index Scan on keywords_indexation_2019_07_31_application_id_idx1 (cost=0.00..875.20 rows=66,458 width=0) (actual time=3,020.164..3,020.164 rows=71,872 loops=1)

  • Index Cond: (application_id = '4dfa1260-de4d-68c2-fc5c-7112cbb265e7'::uuid)
  • Buffers: shared hit=1 read=336 written=268
23. 2,415.026 2,553.544 ↓ 3.8 70,343 1

Parallel Bitmap Heap Scan on keywords_indexation_2019_07_24 (cost=877.24..78,369.71 rows=18,273 width=36) (actual time=180.988..2,553.544 rows=70,343 loops=1)

  • Recheck Cond: (application_id = '4dfa1260-de4d-68c2-fc5c-7112cbb265e7'::uuid)
  • Filter: ((date >= '2019-07-20'::date) AND (date <= '2019-08-04'::date))
  • Buffers: shared hit=1 read=70493 written=56203
24. 138.518 138.518 ↑ 1.0 70,343 1

Bitmap Index Scan on keywords_indexation_2019_07_24_application_id_idx1 (cost=0.00..858.97 rows=73,093 width=0) (actual time=138.518..138.518 rows=70,343 loops=1)

  • Index Cond: (application_id = '4dfa1260-de4d-68c2-fc5c-7112cbb265e7'::uuid)
  • Buffers: shared hit=1 read=274 written=239
25. 427.543 445.275 ↓ 5.2 73,733 1

Parallel Bitmap Heap Scan on keywords_indexation_2019_08_04 (cost=758.80..61,171.77 rows=14,133 width=36) (actual time=32.071..445.275 rows=73,733 loops=1)

  • Recheck Cond: (application_id = '4dfa1260-de4d-68c2-fc5c-7112cbb265e7'::uuid)
  • Filter: ((date >= '2019-07-20'::date) AND (date <= '2019-08-04'::date))
  • Buffers: shared hit=38801 read=24731 dirtied=3703 written=23302
26. 17.732 17.732 ↓ 1.3 73,733 1

Bitmap Index Scan on keywords_indexation_2019_08_04_application_id_idx1 (cost=0.00..744.67 rows=56,533 width=0) (actual time=17.732..17.732 rows=73,733 loops=1)

  • Index Cond: (application_id = '4dfa1260-de4d-68c2-fc5c-7112cbb265e7'::uuid)
  • Buffers: shared hit=100 read=255 written=223
27. 3,458.857 3,809.179 ↓ 4.6 72,621 1

Parallel Bitmap Heap Scan on keywords_indexation_2019_07_25 (cost=756.44..67,878.79 rows=15,760 width=36) (actual time=429.121..3,809.179 rows=72,621 loops=1)

  • Recheck Cond: (application_id = '4dfa1260-de4d-68c2-fc5c-7112cbb265e7'::uuid)
  • Filter: ((date >= '2019-07-20'::date) AND (date <= '2019-08-04'::date))
  • Buffers: shared hit=1 read=72674 written=53110
28. 350.322 350.322 ↓ 1.2 72,621 1

Bitmap Index Scan on keywords_indexation_2019_07_25_application_id_idx1 (cost=0.00..740.68 rows=63,041 width=0) (actual time=350.322..350.322 rows=72,621 loops=1)

  • Index Cond: (application_id = '4dfa1260-de4d-68c2-fc5c-7112cbb265e7'::uuid)
  • Buffers: shared hit=1 read=283 written=223
29. 5,374.266 8,488.020 ↓ 1.0 13,932 5

Parallel Bitmap Heap Scan on keywords_indexation_2019_07_30 (cost=721.89..58,019.12 rows=13,440 width=34) (actual time=629.145..1,697.604 rows=13,932 loops=5)

  • Recheck Cond: (application_id = '4dfa1260-de4d-68c2-fc5c-7112cbb265e7'::uuid)
  • Filter: ((date >= '2019-07-20'::date) AND (date <= '2019-08-04'::date))
  • Heap Blocks: exact=20726
  • Buffers: shared read=69808 written=58004
30. 3,113.754 3,113.754 ↓ 1.3 69,662 1

Bitmap Index Scan on keywords_indexation_2019_07_30_application_id_idx1 (cost=0.00..708.45 rows=53,758 width=0) (actual time=3,113.754..3,113.754 rows=69,662 loops=1)

  • Index Cond: (application_id = '4dfa1260-de4d-68c2-fc5c-7112cbb265e7'::uuid)
  • Buffers: shared read=334 written=267
31. 4,705.684 8,078.598 ↓ 3.8 38,344 2

Parallel Bitmap Heap Scan on keywords_indexation_2019_07_28 (cost=536.41..43,470.24 rows=9,976 width=36) (actual time=1,698.646..4,039.299 rows=38,344 loops=2)

  • Recheck Cond: (application_id = '4dfa1260-de4d-68c2-fc5c-7112cbb265e7'::uuid)
  • Filter: ((date >= '2019-07-20'::date) AND (date <= '2019-08-04'::date))
  • Heap Blocks: exact=57910
  • Buffers: shared read=76893 written=62672
32. 3,372.914 3,372.914 ↓ 1.9 76,687 1

Bitmap Index Scan on keywords_indexation_2019_07_28_application_id_idx1 (cost=0.00..526.43 rows=39,902 width=0) (actual time=3,372.914..3,372.914 rows=76,687 loops=1)

  • Index Cond: (application_id = '4dfa1260-de4d-68c2-fc5c-7112cbb265e7'::uuid)
  • Buffers: shared read=364 written=293
33. 3,082.925 3,218.439 ↓ 4.0 40,546 1

Parallel Bitmap Heap Scan on keywords_indexation_2019_07_23 (cost=487.41..43,386.34 rows=10,134 width=35) (actual time=163.538..3,218.439 rows=40,546 loops=1)

  • Recheck Cond: (application_id = '4dfa1260-de4d-68c2-fc5c-7112cbb265e7'::uuid)
  • Filter: ((date >= '2019-07-20'::date) AND (date <= '2019-08-04'::date))
  • Heap Blocks: exact=40441
  • Buffers: shared read=40601 written=36069
34. 135.514 135.514 ↓ 1.0 40,546 1

Bitmap Index Scan on keywords_indexation_2019_07_23_application_id_idx1 (cost=0.00..477.28 rows=40,535 width=0) (actual time=135.514..135.514 rows=40,546 loops=1)

  • Index Cond: (application_id = '4dfa1260-de4d-68c2-fc5c-7112cbb265e7'::uuid)
  • Buffers: shared read=160 written=149
35. 1,181.795 1,309.011 ↓ 3.1 26,576 1

Parallel Bitmap Heap Scan on keywords_indexation_2019_07_26 (cost=323.27..28,713.48 rows=8,671 width=33) (actual time=131.863..1,309.011 rows=26,576 loops=1)

  • Recheck Cond: (application_id = '4dfa1260-de4d-68c2-fc5c-7112cbb265e7'::uuid)
  • Filter: ((date >= '2019-07-20'::date) AND (date <= '2019-08-04'::date))
  • Heap Blocks: exact=26489
  • Buffers: shared read=26595 written=21977
36. 127.216 127.216 ↑ 1.0 26,576 1

Bitmap Index Scan on keywords_indexation_2019_07_26_application_id_idx1 (cost=0.00..316.56 rows=26,879 width=0) (actual time=127.216..127.216 rows=26,576 loops=1)

  • Index Cond: (application_id = '4dfa1260-de4d-68c2-fc5c-7112cbb265e7'::uuid)
  • Buffers: shared read=106 written=100
37. 747.715 822.233 ↓ 4.5 27,319 1

Parallel Bitmap Heap Scan on keywords_indexation_2019_08_03 (cost=256.82..20,574.68 rows=6,134 width=34) (actual time=79.262..822.233 rows=27,319 loops=1)

  • Recheck Cond: (application_id = '4dfa1260-de4d-68c2-fc5c-7112cbb265e7'::uuid)
  • Filter: ((date >= '2019-07-20'::date) AND (date <= '2019-08-04'::date))
  • Heap Blocks: exact=27227
  • Buffers: shared read=27363 written=25922
38. 74.518 74.518 ↓ 1.4 27,319 1

Bitmap Index Scan on keywords_indexation_2019_08_03_application_id_idx1 (cost=0.00..252.07 rows=19,014 width=0) (actual time=74.518..74.518 rows=27,319 loops=1)

  • Index Cond: (application_id = '4dfa1260-de4d-68c2-fc5c-7112cbb265e7'::uuid)
  • Buffers: shared read=136 written=125
39. 286.393 295.323 ↓ 3.0 10,975 1

Parallel Bitmap Heap Scan on keywords_indexation_2019_07_22 (cost=137.28..12,191.56 rows=3,676 width=33) (actual time=15.584..295.323 rows=10,975 loops=1)

  • Recheck Cond: (application_id = '4dfa1260-de4d-68c2-fc5c-7112cbb265e7'::uuid)
  • Filter: ((date >= '2019-07-20'::date) AND (date <= '2019-08-04'::date))
  • Heap Blocks: exact=10954
  • Buffers: shared read=11000 written=8901
40. 8.930 8.930 ↑ 1.0 10,975 1

Bitmap Index Scan on keywords_indexation_2019_07_22_application_id_idx1 (cost=0.00..134.43 rows=11,396 width=0) (actual time=8.930..8.930 rows=10,975 loops=1)

  • Index Cond: (application_id = '4dfa1260-de4d-68c2-fc5c-7112cbb265e7'::uuid)
  • Buffers: shared read=46
41. 0.392 0.398 ↓ 0.0 0 1

Parallel Bitmap Heap Scan on keywords_indexation_2019_07_21 (cost=1.27..4.44 rows=1 width=48) (actual time=0.398..0.398 rows=0 loops=1)

  • Recheck Cond: (application_id = '4dfa1260-de4d-68c2-fc5c-7112cbb265e7'::uuid)
  • Filter: ((date >= '2019-07-20'::date) AND (date <= '2019-08-04'::date))
  • Buffers: shared hit=1
42. 0.006 0.006 ↓ 0.0 0 1

Bitmap Index Scan on keywords_indexation_2019_07_21_application_id_idx1 (cost=0.00..1.27 rows=3 width=0) (actual time=0.006..0.006 rows=0 loops=1)

  • Index Cond: (application_id = '4dfa1260-de4d-68c2-fc5c-7112cbb265e7'::uuid)
  • Buffers: shared hit=1
43.          

SubPlan (forWindowAgg)

44. 0.020 0.040 ↑ 1.0 1 20

Aggregate (cost=1.25..1.27 rows=1 width=8) (actual time=0.002..0.002 rows=1 loops=20)

45. 0.020 0.020 ↑ 100.0 1 20

Function Scan on unnest n (cost=0.00..1.00 rows=100 width=4) (actual time=0.001..0.001 rows=1 loops=20)

46. 0.000 0.020 ↑ 1.0 1 20

Aggregate (cost=1.25..1.27 rows=1 width=4) (actual time=0.001..0.001 rows=1 loops=20)

47. 0.020 0.020 ↑ 100.0 1 20

Function Scan on unnest n_1 (cost=0.00..1.00 rows=100 width=4) (actual time=0.000..0.001 rows=1 loops=20)

Planning time : 42.529 ms
Execution time : 13,997.041 ms