explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 2q6l

Settings
# exclusive inclusive rows x rows loops node
1. 547.182 10,585.511 ↑ 13,531,544.9 178 1

GroupAggregate (cost=517,225,642.34..601,527,167.20 rows=2,408,614,996 width=70) (actual time=9,887.107..10,585.511 rows=178 loops=1)

  • Group Key: rumpagetable_08_2020_clovia.pageid, (split_part(inq2.name, '/'::text, 1)), rumsessiontable_08_2020_clovia.contype, rumsessiontable_08_2020_clovia.mobileappversion
2. 1,015.032 10,038.329 ↑ 1,660.0 1,451,015 1

Sort (cost=517,225,642.34..523,247,179.83 rows=2,408,614,996 width=70) (actual time=9,887.087..10,038.329 rows=1,451,015 loops=1)

  • Sort Key: rumpagetable_08_2020_clovia.pageid, (split_part(inq2.name, '/'::text, 1)), rumsessiontable_08_2020_clovia.contype, rumsessiontable_08_2020_clovia.mobileappversion
  • Sort Method: quicksort Memory: 162,513kB
3. 1,328.212 9,023.297 ↑ 1,660.0 1,451,015 1

Merge Join (cost=721,284.34..43,105,657.20 rows=2,408,614,996 width=70) (actual time=6,206.328..9,023.297 rows=1,451,015 loops=1)

  • Merge Cond: (rumsessiontable_08_2020_clovia.sid = rumpagetable_08_2020_clovia.sid)
4. 27.635 91.105 ↑ 1.0 36,412 1

Sort (cost=9,171.34..9,262.56 rows=36,489 width=21) (actual time=85.207..91.105 rows=36,412 loops=1)

  • Sort Key: rumsessiontable_08_2020_clovia.sid
  • Sort Method: quicksort Memory: 4,383kB
5. 3.604 63.470 ↑ 1.0 36,429 1

Append (cost=0.00..6,406.36 rows=36,489 width=21) (actual time=0.048..63.470 rows=36,429 loops=1)

6. 0.002 0.002 ↓ 0.0 0 1

Seq Scan on rumsessiontable_08_2020_clovia (cost=0.00..0.00 rows=1 width=54) (actual time=0.002..0.002 rows=0 loops=1)

  • Filter: ((sessionstarttime >= 210,247,860) AND (sessionstarttime < 210334320))
7. 1.129 1.129 ↓ 1.9 656 1

Index Scan using rumsessiontable_2020083008000_sessionstarttime_storeid_term_idx on rumsessiontable_20200830080001_clovia (cost=0.29..642.90 rows=347 width=20) (actual time=0.046..1.129 rows=656 loops=1)

  • Index Cond: ((sessionstarttime >= 210,247,860) AND (sessionstarttime < 210334320))
8. 37.325 37.325 ↓ 1.0 19,463 1

Seq Scan on rumsessiontable_20200830160001_clovia (cost=0.00..3,072.93 rows=19,462 width=21) (actual time=0.018..37.325 rows=19,463 loops=1)

  • Filter: ((sessionstarttime >= 210,247,860) AND (sessionstarttime < 210334320))
9. 3.512 3.512 ↓ 1.0 1,798 1

Seq Scan on rumsessiontable_20200831000001_clovia (cost=0.00..283.91 rows=1,794 width=21) (actual time=0.022..3.512 rows=1,798 loops=1)

  • Filter: ((sessionstarttime >= 210,247,860) AND (sessionstarttime < 210334320))
10. 17.898 17.898 ↑ 1.0 14,512 1

Seq Scan on rumsessiontable_20200831080001_clovia (cost=0.00..2,406.61 rows=14,885 width=21) (actual time=0.015..17.898 rows=14,512 loops=1)

  • Filter: ((sessionstarttime >= 210,247,860) AND (sessionstarttime < 210334320))
  • Rows Removed by Filter: 728
11. 371.545 7,603.980 ↑ 9.0 1,470,198 1

Materialize (cost=712,112.99..978,545.75 rows=13,201,869 width=88) (actual time=6,098.729..7,603.980 rows=1,470,198 loops=1)

12. 751.797 7,232.435 ↑ 9.0 1,470,010 1

Merge Join (cost=712,112.99..945,541.07 rows=13,201,869 width=88) (actual time=6,098.724..7,232.435 rows=1,470,010 loops=1)

  • Merge Cond: ((rumpagetable_08_2020_clovia.sid = nvxhrdatatable_08_2020_clovia.sid) AND (rumpagetable_08_2020_clovia.pageinstance = nvxhrdatatable_08_2020_clovia.pageinstance))
13. 518.337 727.479 ↑ 1.0 318,924 1

Sort (cost=51,453.23..52,251.71 rows=319,390 width=27) (actual time=682.268..727.479 rows=318,924 loops=1)

  • Sort Key: rumpagetable_08_2020_clovia.sid, rumpagetable_08_2020_clovia.pageinstance
  • Sort Method: quicksort Memory: 37,207kB
14. 27.657 209.142 ↑ 1.0 318,958 1

Append (cost=0.00..22,253.07 rows=319,390 width=27) (actual time=0.024..209.142 rows=318,958 loops=1)

15. 0.001 0.001 ↓ 0.0 0 1

Seq Scan on rumpagetable_08_2020_clovia (cost=0.00..0.00 rows=1 width=34) (actual time=0.001..0.001 rows=0 loops=1)

  • Filter: ((navigationstarttime >= 210,247,860) AND (navigationstarttime < 210334320))
16. 6.907 6.907 ↓ 2.6 6,878 1

Index Scan using rumpagetable_20200830080001_clov_navigationstarttime_pageid_idx on rumpagetable_20200830080001_clovia (cost=0.42..4,613.84 rows=2,613 width=26) (actual time=0.023..6.907 rows=6,878 loops=1)

  • Index Cond: ((navigationstarttime >= 210,247,860) AND (navigationstarttime < 210334320))
17. 93.679 93.679 ↓ 1.0 169,881 1

Seq Scan on rumpagetable_20200830160001_clovia (cost=0.00..9,394.18 rows=169,879 width=27) (actual time=0.013..93.679 rows=169,881 loops=1)

  • Filter: ((navigationstarttime >= 210,247,860) AND (navigationstarttime < 210334320))
18. 10.635 10.635 ↑ 1.0 19,228 1

Seq Scan on rumpagetable_20200831000001_clovia (cost=0.00..1,064.57 rows=19,238 width=27) (actual time=0.015..10.635 rows=19,228 loops=1)

  • Filter: ((navigationstarttime >= 210,247,860) AND (navigationstarttime < 210334320))
19. 70.263 70.263 ↑ 1.0 122,971 1

Seq Scan on rumpagetable_20200831080001_clovia (cost=0.00..7,180.47 rows=127,659 width=27) (actual time=0.009..70.263 rows=122,971 loops=1)

  • Filter: ((navigationstarttime >= 210,247,860) AND (navigationstarttime < 210334320))
  • Rows Removed by Filter: 6,899
20. 2,803.977 5,753.159 ↑ 1.0 1,631,870 1

Sort (cost=660,659.76..664,793.22 rows=1,653,385 width=69) (actual time=5,416.344..5,753.159 rows=1,631,870 loops=1)

  • Sort Key: nvxhrdatatable_08_2020_clovia.sid, nvxhrdatatable_08_2020_clovia.pageinstance
  • Sort Method: quicksort Memory: 293,125kB
21. 680.128 2,949.182 ↑ 1.0 1,625,368 1

Hash Join (cost=23,109.21..489,889.96 rows=1,653,385 width=69) (actual time=377.382..2,949.182 rows=1,625,368 loops=1)

  • Hash Cond: (nvxhrdatatable_08_2020_clovia.resourceid = inq2.id)
22. 152.045 1,895.839 ↓ 1.0 1,625,368 1

Append (cost=0.00..360,903.91 rows=1,624,418 width=25) (actual time=0.034..1,895.839 rows=1,625,368 loops=1)

23. 0.002 0.002 ↓ 0.0 0 1

Seq Scan on nvxhrdatatable_08_2020_clovia (cost=0.00..0.00 rows=1 width=32) (actual time=0.002..0.002 rows=0 loops=1)

  • Filter: (("timestamp" >= 210,247,860) AND ("timestamp" < 210334320))
24. 29.595 29.595 ↓ 1.0 35,238 1

Index Scan using nvxhrdatatable_20200830080001_clovia_timestamp_domainid_idx on nvxhrdatatable_20200830080001_clovia (cost=0.42..63,335.03 rows=34,727 width=24) (actual time=0.032..29.595 rows=35,238 loops=1)

  • Index Cond: (("timestamp" >= 210,247,860) AND ("timestamp" < 210334320))
25. 962.454 962.454 ↓ 1.0 875,038 1

Seq Scan on nvxhrdatatable_20200830160001_clovia (cost=0.00..160,286.33 rows=874,889 width=25) (actual time=0.044..962.454 rows=875,038 loops=1)

  • Filter: (("timestamp" >= 210,247,860) AND ("timestamp" < 210334320))
26. 64.455 64.455 ↑ 1.0 101,153 1

Seq Scan on nvxhrdatatable_20200831000001_clovia (cost=0.00..18,567.31 rows=101,154 width=25) (actual time=0.014..64.455 rows=101,153 loops=1)

  • Filter: (("timestamp" >= 210,247,860) AND ("timestamp" < 210334320))
27. 687.288 687.288 ↓ 1.0 613,939 1

Seq Scan on nvxhrdatatable_20200831080001_clovia (cost=0.00..118,715.24 rows=613,647 width=25) (actual time=0.052..687.288 rows=613,939 loops=1)

  • Filter: (("timestamp" >= 210,247,860) AND ("timestamp" < 210334320))
  • Rows Removed by Filter: 34,574
28. 191.045 373.215 ↓ 1.0 617,691 1

Hash (cost=15,402.33..15,402.33 rows=616,551 width=52) (actual time=373.215..373.215 rows=617,691 loops=1)

  • Buckets: 1,048,576 Batches: 1 Memory Usage: 60,675kB
29. 182.170 182.170 ↓ 1.0 617,691 1

Seq Scan on nvdynamicmetadatatable_clovia inq2 (cost=0.00..15,402.33 rows=616,551 width=52) (actual time=0.025..182.170 rows=617,691 loops=1)

  • Filter: (entity_type = 103)
  • Rows Removed by Filter: 5,797
Planning time : 73.450 ms
Execution time : 10,612.089 ms