explain.depesz.com

PostgreSQL's explain analyze made readable

Result: msMQ

Settings
# exclusive inclusive rows x rows loops node
1. 22,765.171 820,101.774 ↓ 0.0 0 1

Insert on castoncast_central.dss_metric_results (cost=7,784,968.55..7,822,438.14 rows=8,234 width=24) (actual time=820,101.774..820,101.774 rows=0 loops=1)

  • Buffers: shared hit=110742 read=2613712 dirtied=3941 written=3831
2. 23.782 797,336.603 ↓ 1.0 8,239 1

Subquery Scan on *SELECT* (cost=7,784,968.55..7,822,438.14 rows=8,234 width=24) (actual time=796,693.888..797,336.603 rows=8,239 loops=1)

  • Output: "*SELECT*".i_metric_id, "*SELECT*".object_id, "*SELECT*".i_metric_value_index, "*SELECT*".count, 'NULL'::character varying(1000), 0, "*SELECT*".i_snapshot_id, 0
  • Buffers: shared hit=56515 read=2609737 written=3831
3. 87.947 797,312.821 ↓ 1.0 8,239 1

GroupAggregate (cost=7,784,968.55..7,822,335.22 rows=8,234 width=8) (actual time=796,693.877..797,312.821 rows=8,239 loops=1)

  • Output: ra.object_id, 67011, 1, count(DISTINCT r.metric_id), 92
  • Buffers: shared hit=56515 read=2609737 written=3831
4. 252.017 797,224.874 ↓ 1.4 11,140 1

Merge Join (cost=7,784,968.55..7,822,211.71 rows=8,234 width=8) (actual time=796,693.484..797,224.874 rows=11,140 loops=1)

  • Output: ra.object_id, r.metric_id
  • Merge Cond: (ra.object_id = r.object_id)
  • Buffers: shared hit=56515 read=2609737 written=3831
5. 522.346 1,584.259 ↑ 1.0 193,570 1

Sort (cost=98,543.12..99,040.62 rows=199,000 width=4) (actual time=1,327.288..1,584.259 rows=193,570 loops=1)

  • Output: ra.object_id
  • Sort Key: ra.object_id
  • Sort Method: quicksort Memory: 15221kB
  • Buffers: shared hit=28096
6. 399.494 1,061.913 ↑ 1.0 193,627 1

Append (cost=0.00..81,028.72 rows=199,000 width=4) (actual time=0.016..1,061.913 rows=193,627 loops=1)

  • Buffers: shared hit=28096
7. 662.419 662.419 ↑ 1.0 193,627 1

Seq Scan on castoncast_central.dss_metric_results ra (cost=0.00..81,028.72 rows=199,000 width=4) (actual time=0.012..662.419 rows=193,627 loops=1)

  • Output: ra.object_id
  • Filter: ((ra.snapshot_id = 92) AND (ra.metric_value_index = 1) AND (ra.metric_id = 65005))
  • Rows Removed by Filter: 2829915
  • Buffers: shared hit=28096
8. 46.396 795,388.598 ↑ 42.2 16,144 1

Sort (cost=7,686,425.43..7,688,129.42 rows=681,596 width=8) (actual time=795,366.060..795,388.598 rows=16,144 loops=1)

  • Output: r.metric_id, r.object_id
  • Sort Key: r.object_id
  • Sort Method: quicksort Memory: 1141kB
  • Buffers: shared hit=28419 read=2609737 written=3831
9. 3,190.524 795,342.202 ↑ 42.2 16,144 1

Hash Join (cost=2,081.98..7,620,383.69 rows=681,596 width=8) (actual time=7.196..795,342.202 rows=16,144 loops=1)

  • Output: r.metric_id, r.object_id
  • Hash Cond: (r.metric_id = (ht.metric_id + 1))
  • Buffers: shared hit=28419 read=2609737 written=3831
10. 6,005.774 792,146.183 ↓ 2.1 2,896,264 1

Append (cost=0.00..7,611,439.31 rows=1,363,191 width=8) (actual time=0.020..792,146.183 rows=2,896,264 loops=1)

  • Buffers: shared hit=28096 read=2609737 written=3831
11. 3,602.593 3,602.593 ↓ 200.3 2,896,264 1

Seq Scan on castoncast_central.dss_metric_results r (cost=0.00..81,028.72 rows=14,462 width=8) (actual time=0.016..3,602.593 rows=2,896,264 loops=1)

  • Output: r.metric_id, r.object_id
  • Filter: ((r.metric_value_index = 1) AND ((r.snapshot_id + 0) = 92))
  • Rows Removed by Filter: 127278
  • Buffers: shared hit=28096
12. 15,540.365 15,540.365 ↓ 0.0 0 1

Seq Scan on castoncast_central.dss_metric_results_1 r (cost=0.00..77,991.79 rows=14,037 width=8) (actual time=15,540.365..15,540.365 rows=0 loops=1)

  • Output: r.metric_id, r.object_id
  • Filter: ((r.metric_value_index = 1) AND ((r.snapshot_id + 0) = 92))
  • Rows Removed by Filter: 2923131
  • Buffers: shared read=26837
13. 14,883.363 14,883.363 ↓ 0.0 0 1

Seq Scan on castoncast_central.dss_metric_results_2 r (cost=0.00..78,206.84 rows=14,113 width=8) (actual time=14,883.363..14,883.363 rows=0 loops=1)

  • Output: r.metric_id, r.object_id
  • Filter: ((r.metric_value_index = 1) AND ((r.snapshot_id + 0) = 92))
  • Rows Removed by Filter: 2931191
  • Buffers: shared read=26911
14. 10,213.912 10,213.912 ↓ 0.0 0 1

Seq Scan on castoncast_central.dss_metric_results_3 r (cost=0.00..72,677.43 rows=13,107 width=8) (actual time=10,213.912..10,213.912 rows=0 loops=1)

  • Output: r.metric_id, r.object_id
  • Filter: ((r.metric_value_index = 1) AND ((r.snapshot_id + 0) = 92))
  • Rows Removed by Filter: 2718996
  • Buffers: shared read=25095
15. 8,901.845 8,901.845 ↓ 0.0 0 1

Seq Scan on castoncast_central.dss_metric_results_4 r (cost=0.00..70,626.62 rows=12,731 width=8) (actual time=8,901.845..8,901.845 rows=0 loops=1)

  • Output: r.metric_id, r.object_id
  • Filter: ((r.metric_value_index = 1) AND ((r.snapshot_id + 0) = 92))
  • Rows Removed by Filter: 2642207
  • Buffers: shared read=24388
16. 11,210.985 11,210.985 ↓ 0.0 0 1

Seq Scan on castoncast_central.dss_metric_results_5 r (cost=0.00..70,714.52 rows=12,742 width=8) (actual time=11,210.985..11,210.985 rows=0 loops=1)

  • Output: r.metric_id, r.object_id
  • Filter: ((r.metric_value_index = 1) AND ((r.snapshot_id + 0) = 92))
  • Rows Removed by Filter: 2645458
  • Buffers: shared read=24419
17. 7,519.042 7,519.042 ↓ 0.0 0 1

Seq Scan on castoncast_central.dss_metric_results_6 r (cost=0.00..66,608.88 rows=11,990 width=8) (actual time=7,519.042..7,519.042 rows=0 loops=1)

  • Output: r.metric_id, r.object_id
  • Filter: ((r.metric_value_index = 1) AND ((r.snapshot_id + 0) = 92))
  • Rows Removed by Filter: 2490393
  • Buffers: shared read=23027
18. 5,963.307 5,963.307 ↓ 0.0 0 1

Seq Scan on castoncast_central.dss_metric_results_7 r (cost=0.00..66,593.41 rows=11,985 width=8) (actual time=5,963.307..5,963.307 rows=0 loops=1)

  • Output: r.metric_id, r.object_id
  • Filter: ((r.metric_value_index = 1) AND ((r.snapshot_id + 0) = 92))
  • Rows Removed by Filter: 2489795
  • Buffers: shared read=23022
19. 6,239.854 6,239.854 ↓ 0.0 0 1

Seq Scan on castoncast_central.dss_metric_results_8 r (cost=0.00..66,516.01 rows=11,985 width=8) (actual time=6,239.854..6,239.854 rows=0 loops=1)

  • Output: r.metric_id, r.object_id
  • Filter: ((r.metric_value_index = 1) AND ((r.snapshot_id + 0) = 92))
  • Rows Removed by Filter: 2486915
  • Buffers: shared read=22995
20. 6,282.463 6,282.463 ↓ 0.0 0 1

Seq Scan on castoncast_central.dss_metric_results_9 r (cost=0.00..66,906.11 rows=12,060 width=8) (actual time=6,282.463..6,282.463 rows=0 loops=1)

  • Output: r.metric_id, r.object_id
  • Filter: ((r.metric_value_index = 1) AND ((r.snapshot_id + 0) = 92))
  • Rows Removed by Filter: 2501549
  • Buffers: shared read=23129
21. 7,129.019 7,129.019 ↓ 0.0 0 1

Seq Scan on castoncast_central.dss_metric_results_10 r (cost=0.00..69,576.65 rows=12,574 width=8) (actual time=7,129.019..7,129.019 rows=0 loops=1)

  • Output: r.metric_id, r.object_id
  • Filter: ((r.metric_value_index = 1) AND ((r.snapshot_id + 0) = 92))
  • Rows Removed by Filter: 2601237
  • Buffers: shared read=24055
22. 5,951.526 5,951.526 ↓ 0.0 0 1

Seq Scan on castoncast_central.dss_metric_results_11 r (cost=0.00..69,539.57 rows=12,542 width=8) (actual time=5,951.526..5,951.526 rows=0 loops=1)

  • Output: r.metric_id, r.object_id
  • Filter: ((r.metric_value_index = 1) AND ((r.snapshot_id + 0) = 92))
  • Rows Removed by Filter: 2599918
  • Buffers: shared read=24041
23. 6,226.234 6,226.234 ↓ 0.0 0 1

Seq Scan on castoncast_central.dss_metric_results_12 r (cost=0.00..69,760.98 rows=12,594 width=8) (actual time=6,226.234..6,226.234 rows=0 loops=1)

  • Output: r.metric_id, r.object_id
  • Filter: ((r.metric_value_index = 1) AND ((r.snapshot_id + 0) = 92))
  • Rows Removed by Filter: 2608170
  • Buffers: shared read=24118
24. 2,992.720 2,992.720 ↓ 0.0 0 1

Seq Scan on castoncast_central.dss_metric_results_13 r (cost=0.00..69,687.85 rows=12,550 width=8) (actual time=2,992.720..2,992.720 rows=0 loops=1)

  • Output: r.metric_id, r.object_id
  • Filter: ((r.metric_value_index = 1) AND ((r.snapshot_id + 0) = 92))
  • Rows Removed by Filter: 2605363
  • Buffers: shared read=24094
25. 5,235.502 5,235.502 ↓ 0.0 0 1

Seq Scan on castoncast_central.dss_metric_results_14 r (cost=0.00..70,081.64 rows=12,630 width=8) (actual time=5,235.502..5,235.502 rows=0 loops=1)

  • Output: r.metric_id, r.object_id
  • Filter: ((r.metric_value_index = 1) AND ((r.snapshot_id + 0) = 92))
  • Rows Removed by Filter: 2620151
  • Buffers: shared read=24229
26. 5,997.867 5,997.867 ↓ 0.0 0 1

Seq Scan on castoncast_central.dss_metric_results_15 r (cost=0.00..84,391.04 rows=15,284 width=8) (actual time=5,997.867..5,997.867 rows=0 loops=1)

  • Output: r.metric_id, r.object_id
  • Filter: ((r.metric_value_index = 1) AND ((r.snapshot_id + 0) = 92))
  • Rows Removed by Filter: 3153145
  • Buffers: shared read=29211
27. 5,535.209 5,535.209 ↓ 0.0 0 1

Seq Scan on castoncast_central.dss_metric_results_16 r (cost=0.00..82,728.81 rows=14,995 width=8) (actual time=5,535.209..5,535.209 rows=0 loops=1)

  • Output: r.metric_id, r.object_id
  • Filter: ((r.metric_value_index = 1) AND ((r.snapshot_id + 0) = 92))
  • Rows Removed by Filter: 3091075
  • Buffers: shared read=28635
28. 4,336.777 4,336.777 ↓ 0.0 0 1

Seq Scan on castoncast_central.dss_metric_results_17 r (cost=0.00..82,760.80 rows=15,004 width=8) (actual time=4,336.777..4,336.777 rows=0 loops=1)

  • Output: r.metric_id, r.object_id
  • Filter: ((r.metric_value_index = 1) AND ((r.snapshot_id + 0) = 92))
  • Rows Removed by Filter: 3092274
  • Buffers: shared read=28646 written=1831
29. 14,277.729 14,277.729 ↓ 0.0 0 1

Seq Scan on castoncast_central.dss_metric_results_18 r (cost=0.00..82,567.17 rows=14,932 width=8) (actual time=14,277.729..14,277.729 rows=0 loops=1)

  • Output: r.metric_id, r.object_id
  • Filter: ((r.metric_value_index = 1) AND ((r.snapshot_id + 0) = 92))
  • Rows Removed by Filter: 3085038
  • Buffers: shared read=28579 written=3
30. 10,516.529 10,516.529 ↓ 0.0 0 1

Seq Scan on castoncast_central.dss_metric_results_19 r (cost=0.00..87,275.07 rows=15,799 width=8) (actual time=10,516.529..10,516.529 rows=0 loops=1)

  • Output: r.metric_id, r.object_id
  • Filter: ((r.metric_value_index = 1) AND ((r.snapshot_id + 0) = 92))
  • Rows Removed by Filter: 3260461
  • Buffers: shared read=30217
31. 7,238.237 7,238.237 ↓ 0.0 0 1

Seq Scan on castoncast_central.dss_metric_results_20 r (cost=0.00..87,188.30 rows=15,757 width=8) (actual time=7,238.237..7,238.237 rows=0 loops=1)

  • Output: r.metric_id, r.object_id
  • Filter: ((r.metric_value_index = 1) AND ((r.snapshot_id + 0) = 92))
  • Rows Removed by Filter: 3257217
  • Buffers: shared read=30187
32. 6,621.629 6,621.629 ↓ 0.0 0 1

Seq Scan on castoncast_central.dss_metric_results_21 r (cost=0.00..76,344.74 rows=13,717 width=8) (actual time=6,621.629..6,621.629 rows=0 loops=1)

  • Output: r.metric_id, r.object_id
  • Filter: ((r.metric_value_index = 1) AND ((r.snapshot_id + 0) = 92))
  • Rows Removed by Filter: 2851071
  • Buffers: shared read=26451 written=1997
33. 5,285.259 5,285.259 ↓ 0.0 0 1

Seq Scan on castoncast_central.dss_metric_results_22 r (cost=0.00..75,797.05 rows=13,574 width=8) (actual time=5,285.259..5,285.259 rows=0 loops=1)

  • Output: r.metric_id, r.object_id
  • Filter: ((r.metric_value_index = 1) AND ((r.snapshot_id + 0) = 92))
  • Rows Removed by Filter: 2830574
  • Buffers: shared read=26262
34. 3,323.269 3,323.269 ↓ 0.0 0 1

Seq Scan on castoncast_central.dss_metric_results_23 r (cost=0.00..75,980.22 rows=13,626 width=8) (actual time=3,323.269..3,323.269 rows=0 loops=1)

  • Output: r.metric_id, r.object_id
  • Filter: ((r.metric_value_index = 1) AND ((r.snapshot_id + 0) = 92))
  • Rows Removed by Filter: 2837441
  • Buffers: shared read=26325
35. 5,981.560 5,981.560 ↓ 0.0 0 1

Seq Scan on castoncast_central.dss_metric_results_24 r (cost=0.00..76,073.19 rows=13,620 width=8) (actual time=5,981.560..5,981.560 rows=0 loops=1)

  • Output: r.metric_id, r.object_id
  • Filter: ((r.metric_value_index = 1) AND ((r.snapshot_id + 0) = 92))
  • Rows Removed by Filter: 2840925
  • Buffers: shared read=26357
36. 7,795.560 7,795.560 ↓ 0.0 0 1

Seq Scan on castoncast_central.dss_metric_results_25 r (cost=0.00..77,055.32 rows=13,797 width=8) (actual time=7,795.560..7,795.560 rows=0 loops=1)

  • Output: r.metric_id, r.object_id
  • Filter: ((r.metric_value_index = 1) AND ((r.snapshot_id + 0) = 92))
  • Rows Removed by Filter: 2877447
  • Buffers: shared read=26700
37. 6,858.582 6,858.582 ↓ 0.0 0 1

Seq Scan on castoncast_central.dss_metric_results_26 r (cost=0.00..81,398.69 rows=14,579 width=8) (actual time=6,858.582..6,858.582 rows=0 loops=1)

  • Output: r.metric_id, r.object_id
  • Filter: ((r.metric_value_index = 1) AND ((r.snapshot_id + 0) = 92))
  • Rows Removed by Filter: 3034668
  • Buffers: shared read=28292
38. 11,759.063 11,759.063 ↓ 0.0 0 1

Seq Scan on castoncast_central.dss_metric_results_27 r (cost=0.00..78,904.61 rows=14,100 width=8) (actual time=11,759.063..11,759.063 rows=0 loops=1)

  • Output: r.metric_id, r.object_id
  • Filter: ((r.metric_value_index = 1) AND ((r.snapshot_id + 0) = 92))
  • Rows Removed by Filter: 2941749
  • Buffers: shared read=27424
39. 10,900.635 10,900.635 ↓ 0.0 0 1

Seq Scan on castoncast_central.dss_metric_results_28 r (cost=0.00..78,962.48 rows=14,109 width=8) (actual time=10,900.635..10,900.635 rows=0 loops=1)

  • Output: r.metric_id, r.object_id
  • Filter: ((r.metric_value_index = 1) AND ((r.snapshot_id + 0) = 92))
  • Rows Removed by Filter: 2943913
  • Buffers: shared read=27444
40. 8,010.272 8,010.272 ↓ 0.0 0 1

Seq Scan on castoncast_central.dss_metric_results_29 r (cost=0.00..81,182.11 rows=14,531 width=8) (actual time=8,010.272..8,010.272 rows=0 loops=1)

  • Output: r.metric_id, r.object_id
  • Filter: ((r.metric_value_index = 1) AND ((r.snapshot_id + 0) = 92))
  • Rows Removed by Filter: 3026235
  • Buffers: shared read=28223
41. 8,077.599 8,077.599 ↓ 0.0 0 1

Seq Scan on castoncast_central.dss_metric_results_30 r (cost=0.00..80,967.58 rows=14,495 width=8) (actual time=8,077.599..8,077.599 rows=0 loops=1)

  • Output: r.metric_id, r.object_id
  • Filter: ((r.metric_value_index = 1) AND ((r.snapshot_id + 0) = 92))
  • Rows Removed by Filter: 3018719
  • Buffers: shared read=28140
42. 9,392.963 9,392.963 ↓ 0.0 0 1

Seq Scan on castoncast_central.dss_metric_results_31 r (cost=0.00..81,550.45 rows=14,631 width=8) (actual time=9,392.963..9,392.963 rows=0 loops=1)

  • Output: r.metric_id, r.object_id
  • Filter: ((r.metric_value_index = 1) AND ((r.snapshot_id + 0) = 92))
  • Rows Removed by Filter: 3040483
  • Buffers: shared read=28342
43. 9,146.560 9,146.560 ↓ 0.0 0 1

Seq Scan on castoncast_central.dss_metric_results_32 r (cost=0.00..82,068.80 rows=14,686 width=8) (actual time=9,146.560..9,146.560 rows=0 loops=1)

  • Output: r.metric_id, r.object_id
  • Filter: ((r.metric_value_index = 1) AND ((r.snapshot_id + 0) = 92))
  • Rows Removed by Filter: 3059817
  • Buffers: shared read=28522
44. 11,227.495 11,227.495 ↓ 0.0 0 1

Seq Scan on castoncast_central.dss_metric_results_33 r (cost=0.00..81,625.40 rows=14,636 width=8) (actual time=11,227.495..11,227.495 rows=0 loops=1)

  • Output: r.metric_id, r.object_id
  • Filter: ((r.metric_value_index = 1) AND ((r.snapshot_id + 0) = 92))
  • Rows Removed by Filter: 3043280
  • Buffers: shared read=28368
45. 8,261.449 8,261.449 ↓ 0.0 0 1

Seq Scan on castoncast_central.dss_metric_results_34 r (cost=0.00..81,586.80 rows=14,613 width=8) (actual time=8,261.449..8,261.449 rows=0 loops=1)

  • Output: r.metric_id, r.object_id
  • Filter: ((r.metric_value_index = 1) AND ((r.snapshot_id + 0) = 92))
  • Rows Removed by Filter: 3041817
  • Buffers: shared read=28355
46. 7,757.973 7,757.973 ↓ 0.0 0 1

Seq Scan on castoncast_central.dss_metric_results_35 r (cost=0.00..78,805.10 rows=14,100 width=8) (actual time=7,757.973..7,757.973 rows=0 loops=1)

  • Output: r.metric_id, r.object_id
  • Filter: ((r.metric_value_index = 1) AND ((r.snapshot_id + 0) = 92))
  • Rows Removed by Filter: 2942120
  • Buffers: shared read=27318
47. 7,470.467 7,470.467 ↓ 0.0 0 1

Seq Scan on castoncast_central.dss_metric_results_36 r (cost=0.00..79,264.32 rows=14,191 width=8) (actual time=7,470.467..7,470.467 rows=0 loops=1)

  • Output: r.metric_id, r.object_id
  • Filter: ((r.metric_value_index = 1) AND ((r.snapshot_id + 0) = 92))
  • Rows Removed by Filter: 2959618
  • Buffers: shared read=27471
48. 7,344.240 7,344.240 ↓ 0.0 0 1

Seq Scan on castoncast_central.dss_metric_results_37 r (cost=0.00..79,108.89 rows=14,161 width=8) (actual time=7,344.240..7,344.240 rows=0 loops=1)

  • Output: r.metric_id, r.object_id
  • Filter: ((r.metric_value_index = 1) AND ((r.snapshot_id + 0) = 92))
  • Rows Removed by Filter: 2953822
  • Buffers: shared read=27417
49. 6,617.981 6,617.981 ↓ 0.0 0 1

Seq Scan on castoncast_central.dss_metric_results_38 r (cost=0.00..79,415.81 rows=14,186 width=8) (actual time=6,617.981..6,617.981 rows=0 loops=1)

  • Output: r.metric_id, r.object_id
  • Filter: ((r.metric_value_index = 1) AND ((r.snapshot_id + 0) = 92))
  • Rows Removed by Filter: 2965246
  • Buffers: shared read=27524
50. 6,660.766 6,660.766 ↓ 0.0 0 1

Seq Scan on castoncast_central.dss_metric_results_39 r (cost=0.00..79,568.75 rows=14,222 width=8) (actual time=6,660.766..6,660.766 rows=0 loops=1)

  • Output: r.metric_id, r.object_id
  • Filter: ((r.metric_value_index = 1) AND ((r.snapshot_id + 0) = 92))
  • Rows Removed by Filter: 2970957
  • Buffers: shared read=27577
51. 6,823.018 6,823.018 ↓ 0.0 0 1

Seq Scan on castoncast_central.dss_metric_results_40 r (cost=0.00..84,622.20 rows=15,133 width=8) (actual time=6,823.018..6,823.018 rows=0 loops=1)

  • Output: r.metric_id, r.object_id
  • Filter: ((r.metric_value_index = 1) AND ((r.snapshot_id + 0) = 92))
  • Rows Removed by Filter: 3158297
  • Buffers: shared read=29352
52. 7,244.856 7,244.856 ↓ 0.0 0 1

Seq Scan on castoncast_central.dss_metric_results_41 r (cost=0.00..84,478.55 rows=15,147 width=8) (actual time=7,244.856..7,244.856 rows=0 loops=1)

  • Output: r.metric_id, r.object_id
  • Filter: ((r.metric_value_index = 1) AND ((r.snapshot_id + 0) = 92))
  • Rows Removed by Filter: 3153460
  • Buffers: shared read=29293
53. 8,326.518 8,326.518 ↓ 0.0 0 1

Seq Scan on castoncast_central.dss_metric_results_42 r (cost=0.00..83,602.10 rows=14,961 width=8) (actual time=8,326.518..8,326.518 rows=0 loops=1)

  • Output: r.metric_id, r.object_id
  • Filter: ((r.metric_value_index = 1) AND ((r.snapshot_id + 0) = 92))
  • Rows Removed by Filter: 3120634
  • Buffers: shared read=28991
54. 6,408.544 6,408.544 ↓ 0.0 0 1

Seq Scan on castoncast_central.dss_metric_results_43 r (cost=0.00..83,469.77 rows=14,942 width=8) (actual time=6,408.544..6,408.544 rows=0 loops=1)

  • Output: r.metric_id, r.object_id
  • Filter: ((r.metric_value_index = 1) AND ((r.snapshot_id + 0) = 92))
  • Rows Removed by Filter: 3115701
  • Buffers: shared read=28945
55. 6,454.138 6,454.138 ↓ 0.0 0 1

Seq Scan on castoncast_central.dss_metric_results_44 r (cost=0.00..85,754.00 rows=15,366 width=8) (actual time=6,454.138..6,454.138 rows=0 loops=1)

  • Output: r.metric_id, r.object_id
  • Filter: ((r.metric_value_index = 1) AND ((r.snapshot_id + 0) = 92))
  • Rows Removed by Filter: 3200857
  • Buffers: shared read=29739
56. 6,221.783 6,221.783 ↓ 0.0 0 1

Seq Scan on castoncast_central.dss_metric_results_45 r (cost=0.00..85,371.50 rows=15,318 width=8) (actual time=6,221.783..6,221.783 rows=0 loops=1)

  • Output: r.metric_id, r.object_id
  • Filter: ((r.metric_value_index = 1) AND ((r.snapshot_id + 0) = 92))
  • Rows Removed by Filter: 3186543
  • Buffers: shared read=29607
57. 7,561.188 7,561.188 ↓ 0.0 0 1

Seq Scan on castoncast_central.dss_metric_results_46 r (cost=0.00..85,256.87 rows=15,264 width=8) (actual time=7,561.188..7,561.188 rows=0 loops=1)

  • Output: r.metric_id, r.object_id
  • Filter: ((r.metric_value_index = 1) AND ((r.snapshot_id + 0) = 92))
  • Rows Removed by Filter: 3182278
  • Buffers: shared read=29567
58. 4,866.644 4,866.644 ↓ 0.0 0 1

Seq Scan on castoncast_central.dss_metric_results_47 r (cost=0.00..85,256.99 rows=15,306 width=8) (actual time=4,866.644..4,866.644 rows=0 loops=1)

  • Output: r.metric_id, r.object_id
  • Filter: ((r.metric_value_index = 1) AND ((r.snapshot_id + 0) = 92))
  • Rows Removed by Filter: 3182285
  • Buffers: shared read=29567
59. 6,688.985 6,688.985 ↓ 0.0 0 1

Seq Scan on castoncast_central.dss_metric_results_48 r (cost=0.00..85,425.36 rows=15,303 width=8) (actual time=6,688.985..6,688.985 rows=0 loops=1)

  • Output: r.metric_id, r.object_id
  • Filter: ((r.metric_value_index = 1) AND ((r.snapshot_id + 0) = 92))
  • Rows Removed by Filter: 3188592
  • Buffers: shared read=29625
60. 7,188.567 7,188.567 ↓ 0.0 0 1

Seq Scan on castoncast_central.dss_metric_results_49 r (cost=0.00..85,373.78 rows=15,314 width=8) (actual time=7,188.567..7,188.567 rows=0 loops=1)

  • Output: r.metric_id, r.object_id
  • Filter: ((r.metric_value_index = 1) AND ((r.snapshot_id + 0) = 92))
  • Rows Removed by Filter: 3186673
  • Buffers: shared read=29607
61. 9,594.911 9,594.911 ↓ 0.0 0 1

Seq Scan on castoncast_central.dss_metric_results_50 r (cost=0.00..85,315.77 rows=15,342 width=8) (actual time=9,594.911..9,594.911 rows=0 loops=1)

  • Output: r.metric_id, r.object_id
  • Filter: ((r.metric_value_index = 1) AND ((r.snapshot_id + 0) = 92))
  • Rows Removed by Filter: 3184044
  • Buffers: shared read=29595
62. 8,470.925 8,470.925 ↓ 0.0 0 1

Seq Scan on castoncast_central.dss_metric_results_51 r (cost=0.00..85,352.48 rows=15,301 width=8) (actual time=8,470.925..8,470.925 rows=0 loops=1)

  • Output: r.metric_id, r.object_id
  • Filter: ((r.metric_value_index = 1) AND ((r.snapshot_id + 0) = 92))
  • Rows Removed by Filter: 3185399
  • Buffers: shared read=29608
63. 10,220.922 10,220.922 ↓ 0.0 0 1

Seq Scan on castoncast_central.dss_metric_results_52 r (cost=0.00..80,599.40 rows=14,442 width=8) (actual time=10,220.922..10,220.922 rows=0 loops=1)

  • Output: r.metric_id, r.object_id
  • Filter: ((r.metric_value_index = 1) AND ((r.snapshot_id + 0) = 92))
  • Rows Removed by Filter: 3008366
  • Buffers: shared read=27953
64. 11,910.089 11,910.089 ↓ 0.0 0 1

Seq Scan on castoncast_central.dss_metric_results_53 r (cost=0.00..85,458.59 rows=15,327 width=8) (actual time=11,910.089..11,910.089 rows=0 loops=1)

  • Output: r.metric_id, r.object_id
  • Filter: ((r.metric_value_index = 1) AND ((r.snapshot_id + 0) = 92))
  • Rows Removed by Filter: 3189348
  • Buffers: shared read=29645
65. 12,483.155 12,483.155 ↓ 0.0 0 1

Seq Scan on castoncast_central.dss_metric_results_54 r (cost=0.00..85,246.60 rows=15,259 width=8) (actual time=12,483.155..12,483.155 rows=0 loops=1)

  • Output: r.metric_id, r.object_id
  • Filter: ((r.metric_value_index = 1) AND ((r.snapshot_id + 0) = 92))
  • Rows Removed by Filter: 3181463
  • Buffers: shared read=29571
66. 10,323.896 10,323.896 ↓ 0.0 0 1

Seq Scan on castoncast_central.dss_metric_results_55 r (cost=0.00..84,909.21 rows=15,217 width=8) (actual time=10,323.896..10,323.896 rows=0 loops=1)

  • Output: r.metric_id, r.object_id
  • Filter: ((r.metric_value_index = 1) AND ((r.snapshot_id + 0) = 92))
  • Rows Removed by Filter: 3168812
  • Buffers: shared read=29455
67. 7,261.154 7,261.154 ↓ 0.0 0 1

Seq Scan on castoncast_central.dss_metric_results_56 r (cost=0.00..83,148.03 rows=14,880 width=8) (actual time=7,261.154..7,261.154 rows=0 loops=1)

  • Output: r.metric_id, r.object_id
  • Filter: ((r.metric_value_index = 1) AND ((r.snapshot_id + 0) = 92))
  • Rows Removed by Filter: 3103259
  • Buffers: shared read=28841
68. 6,768.718 6,768.718 ↓ 0.0 0 1

Seq Scan on castoncast_central.dss_metric_results_57 r (cost=0.00..82,774.29 rows=14,795 width=8) (actual time=6,768.718..6,768.718 rows=0 loops=1)

  • Output: r.metric_id, r.object_id
  • Filter: ((r.metric_value_index = 1) AND ((r.snapshot_id + 0) = 92))
  • Rows Removed by Filter: 3089331
  • Buffers: shared read=28711
69. 6,597.187 6,597.187 ↓ 0.0 0 1

Seq Scan on castoncast_central.dss_metric_results_58 r (cost=0.00..82,966.87 rows=14,848 width=8) (actual time=6,597.187..6,597.187 rows=0 loops=1)

  • Output: r.metric_id, r.object_id
  • Filter: ((r.metric_value_index = 1) AND ((r.snapshot_id + 0) = 92))
  • Rows Removed by Filter: 3096507
  • Buffers: shared read=28778
70. 5,086.184 5,086.184 ↓ 0.0 0 1

Seq Scan on castoncast_central.dss_metric_results_59 r (cost=0.00..82,956.47 rows=14,832 width=8) (actual time=5,086.184..5,086.184 rows=0 loops=1)

  • Output: r.metric_id, r.object_id
  • Filter: ((r.metric_value_index = 1) AND ((r.snapshot_id + 0) = 92))
  • Rows Removed by Filter: 3096084
  • Buffers: shared read=28775
71. 5,963.067 5,963.067 ↓ 0.0 0 1

Seq Scan on castoncast_central.dss_metric_results_60 r (cost=0.00..82,948.50 rows=14,866 width=8) (actual time=5,963.067..5,963.067 rows=0 loops=1)

  • Output: r.metric_id, r.object_id
  • Filter: ((r.metric_value_index = 1) AND ((r.snapshot_id + 0) = 92))
  • Rows Removed by Filter: 3096257
  • Buffers: shared read=28764
72. 5,987.247 5,987.247 ↓ 0.0 0 1

Seq Scan on castoncast_central.dss_metric_results_61 r (cost=0.00..82,927.21 rows=14,821 width=8) (actual time=5,987.247..5,987.247 rows=0 loops=1)

  • Output: r.metric_id, r.object_id
  • Filter: ((r.metric_value_index = 1) AND ((r.snapshot_id + 0) = 92))
  • Rows Removed by Filter: 3095498
  • Buffers: shared read=28756
73. 7,215.829 7,215.829 ↓ 0.0 0 1

Seq Scan on castoncast_central.dss_metric_results_62 r (cost=0.00..84,843.50 rows=15,191 width=8) (actual time=7,215.829..7,215.829 rows=0 loops=1)

  • Output: r.metric_id, r.object_id
  • Filter: ((r.metric_value_index = 1) AND ((r.snapshot_id + 0) = 92))
  • Rows Removed by Filter: 3168257
  • Buffers: shared read=29399
74. 6,805.879 6,805.879 ↓ 0.0 0 1

Seq Scan on castoncast_central.dss_metric_results_63 r (cost=0.00..84,389.24 rows=15,138 width=8) (actual time=6,805.879..6,805.879 rows=0 loops=1)

  • Output: r.metric_id, r.object_id
  • Filter: ((r.metric_value_index = 1) AND ((r.snapshot_id + 0) = 92))
  • Rows Removed by Filter: 3151328
  • Buffers: shared read=29241
75. 7,586.661 7,586.661 ↓ 0.0 0 1

Seq Scan on castoncast_central.dss_metric_results_64 r (cost=0.00..84,203.33 rows=15,097 width=8) (actual time=7,586.661..7,586.661 rows=0 loops=1)

  • Output: r.metric_id, r.object_id
  • Filter: ((r.metric_value_index = 1) AND ((r.snapshot_id + 0) = 92))
  • Rows Removed by Filter: 3144419
  • Buffers: shared read=29176
76. 7,933.546 7,933.546 ↓ 0.0 0 1

Seq Scan on castoncast_central.dss_metric_results_65 r (cost=0.00..84,471.63 rows=15,111 width=8) (actual time=7,933.546..7,933.546 rows=0 loops=1)

  • Output: r.metric_id, r.object_id
  • Filter: ((r.metric_value_index = 1) AND ((r.snapshot_id + 0) = 92))
  • Rows Removed by Filter: 3154436
  • Buffers: shared read=29269
77. 6,837.935 6,837.935 ↓ 0.0 0 1

Seq Scan on castoncast_central.dss_metric_results_66 r (cost=0.00..89,084.79 rows=15,933 width=8) (actual time=6,837.935..6,837.935 rows=0 loops=1)

  • Output: r.metric_id, r.object_id
  • Filter: ((r.metric_value_index = 1) AND ((r.snapshot_id + 0) = 92))
  • Rows Removed by Filter: 3326845
  • Buffers: shared read=30865
78. 7,799.701 7,799.701 ↓ 0.0 0 1

Seq Scan on castoncast_central.dss_metric_results_67 r (cost=0.00..88,881.73 rows=15,891 width=8) (actual time=7,799.701..7,799.701 rows=0 loops=1)

  • Output: r.metric_id, r.object_id
  • Filter: ((r.metric_value_index = 1) AND ((r.snapshot_id + 0) = 92))
  • Rows Removed by Filter: 3319299
  • Buffers: shared read=30794
79. 7,221.152 7,221.152 ↓ 0.0 0 1

Seq Scan on castoncast_central.dss_metric_results_68 r (cost=0.00..89,071.34 rows=15,956 width=8) (actual time=7,221.152..7,221.152 rows=0 loops=1)

  • Output: r.metric_id, r.object_id
  • Filter: ((r.metric_value_index = 1) AND ((r.snapshot_id + 0) = 92))
  • Rows Removed by Filter: 3326362
  • Buffers: shared read=30860
80. 9,267.542 9,267.542 ↓ 0.0 0 1

Seq Scan on castoncast_central.dss_metric_results_69 r (cost=0.00..89,048.68 rows=15,946 width=8) (actual time=9,267.542..9,267.542 rows=0 loops=1)

  • Output: r.metric_id, r.object_id
  • Filter: ((r.metric_value_index = 1) AND ((r.snapshot_id + 0) = 92))
  • Rows Removed by Filter: 3325639
  • Buffers: shared read=30850
81. 13,853.341 13,853.341 ↓ 0.0 0 1

Seq Scan on castoncast_central.dss_metric_results_70 r (cost=0.00..90,159.08 rows=16,120 width=8) (actual time=13,853.341..13,853.341 rows=0 loops=1)

  • Output: r.metric_id, r.object_id
  • Filter: ((r.metric_value_index = 1) AND ((r.snapshot_id + 0) = 92))
  • Rows Removed by Filter: 3366576
  • Buffers: shared read=31244
82. 10,057.932 10,057.932 ↓ 0.0 0 1

Seq Scan on castoncast_central.dss_metric_results_71 r (cost=0.00..90,091.33 rows=16,123 width=8) (actual time=10,057.932..10,057.932 rows=0 loops=1)

  • Output: r.metric_id, r.object_id
  • Filter: ((r.metric_value_index = 1) AND ((r.snapshot_id + 0) = 92))
  • Rows Removed by Filter: 3364476
  • Buffers: shared read=31213
83. 10,690.928 10,690.928 ↓ 0.0 0 1

Seq Scan on castoncast_central.dss_metric_results_72 r (cost=0.00..89,844.17 rows=16,068 width=8) (actual time=10,690.928..10,690.928 rows=0 loops=1)

  • Output: r.metric_id, r.object_id
  • Filter: ((r.metric_value_index = 1) AND ((r.snapshot_id + 0) = 92))
  • Rows Removed by Filter: 3355267
  • Buffers: shared read=31127
84. 10,293.312 10,293.312 ↓ 0.0 0 1

Seq Scan on castoncast_central.dss_metric_results_73 r (cost=0.00..89,935.22 rows=16,118 width=8) (actual time=10,293.312..10,293.312 rows=0 loops=1)

  • Output: r.metric_id, r.object_id
  • Filter: ((r.metric_value_index = 1) AND ((r.snapshot_id + 0) = 92))
  • Rows Removed by Filter: 3358641
  • Buffers: shared read=31159
85. 8,935.983 8,935.983 ↓ 0.0 0 1

Seq Scan on castoncast_central.dss_metric_results_74 r (cost=0.00..90,329.63 rows=16,176 width=8) (actual time=8,935.983..8,935.983 rows=0 loops=1)

  • Output: r.metric_id, r.object_id
  • Filter: ((r.metric_value_index = 1) AND ((r.snapshot_id + 0) = 92))
  • Rows Removed by Filter: 3373350
  • Buffers: shared read=31296
86. 6,073.631 6,073.631 ↓ 0.0 0 1

Seq Scan on castoncast_central.dss_metric_results_75 r (cost=0.00..91,583.40 rows=16,364 width=8) (actual time=6,073.631..6,073.631 rows=0 loops=1)

  • Output: r.metric_id, r.object_id
  • Filter: ((r.metric_value_index = 1) AND ((r.snapshot_id + 0) = 92))
  • Rows Removed by Filter: 3419680
  • Buffers: shared read=31739
87. 9,208.438 9,208.438 ↓ 0.0 0 1

Seq Scan on castoncast_central.dss_metric_results_76 r (cost=0.00..91,498.54 rows=16,397 width=8) (actual time=9,208.438..9,208.438 rows=0 loops=1)

  • Output: r.metric_id, r.object_id
  • Filter: ((r.metric_value_index = 1) AND ((r.snapshot_id + 0) = 92))
  • Rows Removed by Filter: 3416488
  • Buffers: shared read=31710
88. 10,674.299 10,674.299 ↓ 0.0 0 1

Seq Scan on castoncast_central.dss_metric_results_77 r (cost=0.00..91,344.16 rows=16,331 width=8) (actual time=10,674.299..10,674.299 rows=0 loops=1)

  • Output: r.metric_id, r.object_id
  • Filter: ((r.metric_value_index = 1) AND ((r.snapshot_id + 0) = 92))
  • Rows Removed by Filter: 3410752
  • Buffers: shared read=31656
89. 11,189.169 11,189.169 ↓ 0.0 0 1

Seq Scan on castoncast_central.dss_metric_results_78 r (cost=0.00..91,353.36 rows=16,318 width=8) (actual time=11,189.169..11,189.169 rows=0 loops=1)

  • Output: r.metric_id, r.object_id
  • Filter: ((r.metric_value_index = 1) AND ((r.snapshot_id + 0) = 92))
  • Rows Removed by Filter: 3411106
  • Buffers: shared read=31659
90. 10,395.272 10,395.272 ↓ 0.0 0 1

Seq Scan on castoncast_central.dss_metric_results_79 r (cost=0.00..89,923.21 rows=16,060 width=8) (actual time=10,395.272..10,395.272 rows=0 loops=1)

  • Output: r.metric_id, r.object_id
  • Filter: ((r.metric_value_index = 1) AND ((r.snapshot_id + 0) = 92))
  • Rows Removed by Filter: 3358126
  • Buffers: shared read=31156
91. 31,498.102 31,498.102 ↓ 0.0 0 1

Seq Scan on castoncast_central.dss_metric_results_80 r (cost=0.00..96,337.37 rows=17,197 width=8) (actual time=31,498.102..31,498.102 rows=0 loops=1)

  • Output: r.metric_id, r.object_id
  • Filter: ((r.metric_value_index = 1) AND ((r.snapshot_id + 0) = 92))
  • Rows Removed by Filter: 3596078
  • Buffers: shared read=33406
92. 10,598.763 10,598.763 ↓ 0.0 0 1

Seq Scan on castoncast_central.dss_metric_results_81 r (cost=0.00..94,010.66 rows=16,804 width=8) (actual time=10,598.763..10,598.763 rows=0 loops=1)

  • Output: r.metric_id, r.object_id
  • Filter: ((r.metric_value_index = 1) AND ((r.snapshot_id + 0) = 92))
  • Rows Removed by Filter: 3510552
  • Buffers: shared read=32576
93. 7,061.741 7,061.741 ↓ 0.0 0 1

Seq Scan on castoncast_central.dss_metric_results_82 r (cost=0.00..93,916.78 rows=16,766 width=8) (actual time=7,061.741..7,061.741 rows=0 loops=1)

  • Output: r.metric_id, r.object_id
  • Filter: ((r.metric_value_index = 1) AND ((r.snapshot_id + 0) = 92))
  • Rows Removed by Filter: 3507016
  • Buffers: shared read=32544
94. 9,127.262 9,127.262 ↓ 0.0 0 1

Seq Scan on castoncast_central.dss_metric_results_83 r (cost=0.00..93,751.26 rows=16,811 width=8) (actual time=9,127.262..9,127.262 rows=0 loops=1)

  • Output: r.metric_id, r.object_id
  • Filter: ((r.metric_value_index = 1) AND ((r.snapshot_id + 0) = 92))
  • Rows Removed by Filter: 3500815
  • Buffers: shared read=32487
95. 7,862.914 7,862.914 ↓ 0.0 0 1

Seq Scan on castoncast_central.dss_metric_results_84 r (cost=0.00..94,293.48 rows=16,842 width=8) (actual time=7,862.914..7,862.914 rows=0 loops=1)

  • Output: r.metric_id, r.object_id
  • Filter: ((r.metric_value_index = 1) AND ((r.snapshot_id + 0) = 92))
  • Rows Removed by Filter: 3520999
  • Buffers: shared read=32676
96. 6,481.737 6,481.737 ↓ 0.0 0 1

Seq Scan on castoncast_central.dss_metric_results_85 r (cost=0.00..83,483.39 rows=14,842 width=8) (actual time=6,481.737..6,481.737 rows=0 loops=1)

  • Output: r.metric_id, r.object_id
  • Filter: ((r.metric_value_index = 1) AND ((r.snapshot_id + 0) = 92))
  • Rows Removed by Filter: 3115051
  • Buffers: shared read=28970
97. 8,926.998 8,926.998 ↓ 0.0 0 1

Seq Scan on castoncast_central.dss_metric_results_86 r (cost=0.00..85,981.90 rows=15,273 width=8) (actual time=8,926.998..8,926.998 rows=0 loops=1)

  • Output: r.metric_id, r.object_id
  • Filter: ((r.metric_value_index = 1) AND ((r.snapshot_id + 0) = 92))
  • Rows Removed by Filter: 3208623
  • Buffers: shared read=29831
98. 8,943.601 8,943.601 ↓ 0.0 0 1

Seq Scan on castoncast_central.dss_metric_results_87 r (cost=0.00..86,039.67 rows=15,293 width=8) (actual time=8,943.601..8,943.601 rows=0 loops=1)

  • Output: r.metric_id, r.object_id
  • Filter: ((r.metric_value_index = 1) AND ((r.snapshot_id + 0) = 92))
  • Rows Removed by Filter: 3210724
  • Buffers: shared read=29852
99. 15,588.523 15,588.523 ↓ 0.0 0 1

Seq Scan on castoncast_central.dss_metric_results_88 r (cost=0.00..86,140.31 rows=15,322 width=8) (actual time=15,588.523..15,588.523 rows=0 loops=1)

  • Output: r.metric_id, r.object_id
  • Filter: ((r.metric_value_index = 1) AND ((r.snapshot_id + 0) = 92))
  • Rows Removed by Filter: 3214475
  • Buffers: shared read=29887
100. 11,172.620 11,172.620 ↓ 0.0 0 1

Seq Scan on castoncast_central.dss_metric_results_89 r (cost=0.00..86,125.67 rows=15,352 width=8) (actual time=11,172.620..11,172.620 rows=0 loops=1)

  • Output: r.metric_id, r.object_id
  • Filter: ((r.metric_value_index = 1) AND ((r.snapshot_id + 0) = 92))
  • Rows Removed by Filter: 3213924
  • Buffers: shared read=29882
101. 11,623.738 11,623.738 ↓ 0.0 0 1

Seq Scan on castoncast_central.dss_metric_results_90 r (cost=0.00..86,330.58 rows=15,343 width=8) (actual time=11,623.738..11,623.738 rows=0 loops=1)

  • Output: r.metric_id, r.object_id
  • Filter: ((r.metric_value_index = 1) AND ((r.snapshot_id + 0) = 92))
  • Rows Removed by Filter: 3221290
  • Buffers: shared read=29958
102. 12,473.764 12,473.764 ↓ 0.0 0 1

Seq Scan on castoncast_central.dss_metric_results_91 r (cost=0.00..92,668.90 rows=15,577 width=8) (actual time=12,473.764..12,473.764 rows=0 loops=1)

  • Output: r.metric_id, r.object_id
  • Filter: ((r.metric_value_index = 1) AND ((r.snapshot_id + 0) = 92))
  • Rows Removed by Filter: 3457480
  • Buffers: shared read=32163
103. 0.246 5.495 ↓ 103.5 207 1

Hash (cost=2,081.95..2,081.95 rows=2 width=4) (actual time=5.495..5.495 rows=207 loops=1)

  • Output: ht.metric_id
  • Buckets: 1024 Batches: 1 Memory Usage: 8kB
  • Buffers: shared hit=323
104. 0.494 5.249 ↓ 103.5 207 1

HashAggregate (cost=2,081.93..2,081.95 rows=2 width=4) (actual time=5.023..5.249 rows=207 loops=1)

  • Output: ht.metric_id
  • Buffers: shared hit=323
105. 0.493 4.755 ↓ 3.2 207 1

Hash Join (cost=379.00..2,081.77 rows=65 width=4) (actual time=3.830..4.755 rows=207 loops=1)

  • Output: ht.metric_id, (ht.metric_id + 1)
  • Hash Cond: (ht.metric_id = t.metric_id)
  • Buffers: shared hit=323
106. 0.497 0.642 ↓ 1.4 207 1

Bitmap Heap Scan on castoncast_central.dss_metric_histo_tree ht (cost=37.63..1,739.20 rows=144 width=4) (actual time=0.190..0.642 rows=207 loops=1)

  • Output: ht.snapshot_id, ht.metric_parent_id, ht.metric_id, ht.metric_index, ht.metric_type, ht.aggregate_weight, ht.metric_critical
  • Recheck Cond: (ht.snapshot_id = 92)
  • Filter: (ht.metric_critical = 1)
  • Rows Removed by Filter: 1973
  • Buffers: shared hit=33
107. 0.145 0.145 ↑ 1.1 2,180 1

Bitmap Index Scan on dss_metr_hty_idx (cost=0.00..37.59 rows=2,310 width=0) (actual time=0.145..0.145 rows=2,180 loops=1)

  • Index Cond: (ht.snapshot_id = 92)
  • Buffers: shared hit=14
108. 1.498 3.620 ↑ 1.0 1,277 1

Hash (cost=325.41..325.41 rows=1,277 width=4) (actual time=3.620..3.620 rows=1,277 loops=1)

  • Output: t.metric_id
  • Buckets: 1024 Batches: 1 Memory Usage: 45kB
  • Buffers: shared hit=290
109. 2.122 2.122 ↑ 1.0 1,277 1

Seq Scan on castoncast_central.dss_metric_types t (cost=0.00..325.41 rows=1,277 width=4) (actual time=0.017..2.122 rows=1,277 loops=1)

  • Output: t.metric_id
  • Filter: (t.metric_group = 1)
  • Rows Removed by Filter: 1556
  • Buffers: shared hit=290