explain.depesz.com

PostgreSQL's explain analyze made readable

Result: RA5h

Settings
# exclusive inclusive rows x rows loops node
1. 566.916 20,591.555 ↑ 13,532,375.6 178 1

GroupAggregate (cost=616,159,199.61..700,465,899.89 rows=2,408,762,865 width=70) (actual time=18,940.197..20,591.555 rows=178 loops=1)

  • Group Key: rumpagetable_clovia.pageid, (split_part(inq2.name, '/'::text, 1)), rumsessiontable_clovia.contype, rumsessiontable_clovia.mobileappversion
2. 7,283.023 20,024.639 ↑ 1,660.1 1,451,015 1

Sort (cost=616,159,199.61..622,181,106.78 rows=2,408,762,865 width=70) (actual time=18,940.163..20,024.639 rows=1,451,015 loops=1)

  • Sort Key: rumpagetable_clovia.pageid, (split_part(inq2.name, '/'::text, 1)), rumsessiontable_clovia.contype, rumsessiontable_clovia.mobileappversion
  • Sort Method: external merge Disk: 70,904kB
3. 1,488.279 12,741.616 ↑ 1,660.1 1,451,015 1

Merge Join (cost=821,029.20..43,212,125.20 rows=2,408,762,865 width=70) (actual time=8,207.184..12,741.616 rows=1,451,015 loops=1)

  • Merge Cond: (rumsessiontable_clovia.sid = rumpagetable_clovia.sid)
4. 31.135 105.549 ↑ 1.0 36,412 1

Sort (cost=9,175.04..9,266.27 rows=36,491 width=21) (actual time=97.840..105.549 rows=36,412 loops=1)

  • Sort Key: rumsessiontable_clovia.sid
  • Sort Method: quicksort Memory: 4,383kB
5. 3.744 74.414 ↑ 1.0 36,429 1

Append (cost=0.00..6,409.89 rows=36,491 width=21) (actual time=0.038..74.414 rows=36,429 loops=1)

6. 0.002 0.002 ↓ 0.0 0 1

Seq Scan on rumsessiontable_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. 0.000 0.000 ↓ 0.0 0 1

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

  • Filter: ((sessionstarttime >= 210,247,860) AND (sessionstarttime < 210334320))
8. 0.000 0.000 ↓ 0.0 0 1

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

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

Index Scan using rumsessiontable_2020083008000_sessionstarttime_storeid_term_idx on rumsessiontable_20200830080001_clovia (cost=0.29..646.44 rows=347 width=20) (actual time=0.036..1.290 rows=656 loops=1)

  • Index Cond: ((sessionstarttime >= 210,247,860) AND (sessionstarttime < 210334320))
10. 37.629 37.629 ↓ 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.016..37.629 rows=19,463 loops=1)

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

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

  • Filter: ((sessionstarttime >= 210,247,860) AND (sessionstarttime < 210334320))
12. 28.335 28.335 ↑ 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.016..28.335 rows=14,512 loops=1)

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

Materialize (cost=811,854.15..1,082,422.19 rows=13,201,956 width=88) (actual time=8,074.553..11,147.788 rows=1,470,198 loops=1)

14. 883.651 10,734.038 ↑ 9.0 1,470,010 1

Merge Join (cost=811,854.15..1,049,417.30 rows=13,201,956 width=88) (actual time=8,074.546..10,734.038 rows=1,470,010 loops=1)

  • Merge Cond: ((rumpagetable_clovia.sid = nvxhrdatatable_clovia.sid) AND (rumpagetable_clovia.pageinstance = nvxhrdatatable_clovia.pageinstance))
15. 537.022 812.799 ↑ 1.0 318,924 1

Sort (cost=51,490.52..52,289.00 rows=319,392 width=27) (actual time=749.250..812.799 rows=318,924 loops=1)

  • Sort Key: rumpagetable_clovia.sid, rumpagetable_clovia.pageinstance
  • Sort Method: quicksort Memory: 32,481kB
16. 28.109 275.777 ↑ 1.0 318,958 1

Append (cost=0.00..22,290.16 rows=319,392 width=27) (actual time=0.047..275.777 rows=318,958 loops=1)

17. 0.001 0.001 ↓ 0.0 0 1

Seq Scan on rumpagetable_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))
18. 0.001 0.001 ↓ 0.0 0 1

Seq Scan on rumpagetable_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))
19. 0.000 0.000 ↓ 0.0 0 1

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

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

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

  • Index Cond: ((navigationstarttime >= 210,247,860) AND (navigationstarttime < 210334320))
21. 128.277 128.277 ↓ 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.022..128.277 rows=169,881 loops=1)

  • Filter: ((navigationstarttime >= 210,247,860) AND (navigationstarttime < 210334320))
22. 14.516 14.516 ↑ 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.014..14.516 rows=19,228 loops=1)

  • Filter: ((navigationstarttime >= 210,247,860) AND (navigationstarttime < 210334320))
23. 97.905 97.905 ↑ 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.013..97.905 rows=122,971 loops=1)

  • Filter: ((navigationstarttime >= 210,247,860) AND (navigationstarttime < 210334320))
  • Rows Removed by Filter: 6,899
24. 225.830 9,037.588 ↑ 1.0 1,631,870 1

Materialize (cost=760,363.63..768,630.56 rows=1,653,386 width=69) (actual time=7,325.079..9,037.588 rows=1,631,870 loops=1)

25. 5,300.982 8,811.758 ↑ 1.0 1,625,368 1

Sort (cost=760,363.63..764,497.09 rows=1,653,386 width=69) (actual time=7,325.072..8,811.758 rows=1,625,368 loops=1)

  • Sort Key: nvxhrdatatable_clovia.sid, nvxhrdatatable_clovia.pageinstance
  • Sort Method: external merge Disk: 131,960kB
26. 1,090.877 3,510.776 ↑ 1.0 1,625,368 1

Hash Join (cost=28,457.53..521,777.72 rows=1,653,386 width=69) (actual time=409.555..3,510.776 rows=1,625,368 loops=1)

  • Hash Cond: (nvxhrdatatable_clovia.resourceid = inq2.id)
27. 156.396 2,011.219 ↓ 1.0 1,625,368 1

Append (cost=0.00..361,381.76 rows=1,624,420 width=25) (actual time=0.061..2,011.219 rows=1,625,368 loops=1)

28. 0.001 0.001 ↓ 0.0 0 1

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

  • Filter: (("timestamp" >= 210,247,860) AND ("timestamp" < 210334320))
29. 0.000 0.000 ↓ 0.0 0 1

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

  • Filter: (("timestamp" >= 210,247,860) AND ("timestamp" < 210334320))
30. 0.001 0.001 ↓ 0.0 0 1

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

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

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

  • Index Cond: (("timestamp" >= 210,247,860) AND ("timestamp" < 210334320))
32. 985.290 985.290 ↓ 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.024..985.290 rows=875,038 loops=1)

  • Filter: (("timestamp" >= 210,247,860) AND ("timestamp" < 210334320))
33. 70.174 70.174 ↑ 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.031..70.174 rows=101,153 loops=1)

  • Filter: (("timestamp" >= 210,247,860) AND ("timestamp" < 210334320))
34. 767.616 767.616 ↓ 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.031..767.616 rows=613,939 loops=1)

  • Filter: (("timestamp" >= 210,247,860) AND ("timestamp" < 210334320))
  • Rows Removed by Filter: 34,574
35. 196.432 408.680 ↓ 1.0 603,043 1

Hash (cost=15,046.62..15,046.62 rows=602,312 width=52) (actual time=408.680..408.680 rows=603,043 loops=1)

  • Buckets: 524,288 Batches: 2 Memory Usage: 29,712kB
36. 212.248 212.248 ↓ 1.0 603,043 1

Seq Scan on nvdynamicmetadatatable_clovia inq2 (cost=0.00..15,046.62 rows=602,312 width=52) (actual time=0.032..212.248 rows=603,043 loops=1)

  • Filter: (entity_type = 103)
  • Rows Removed by Filter: 5,710
Planning time : 164.461 ms
Execution time : 20,635.589 ms