explain.depesz.com

PostgreSQL's explain analyze made readable

Result: LmE7

Settings
# exclusive inclusive rows x rows loops node
1. 1.545 44,307.414 ↑ 1.8 200 1

GroupAggregate (cost=144,561.05..144,943.64 rows=351 width=73) (actual time=44,305.923..44,307.414 rows=200 loops=1)

  • Group Key: sor.score, s.sender
2. 318.567 44,305.869 ↑ 1.7 201 1

Sort (cost=144,561.05..144,561.93 rows=351 width=93) (actual time=44,305.829..44,305.869 rows=201 loops=1)

  • Sort Key: sor.score DESC, s.sender DESC
  • Sort Method: quicksort Memory: 13343kB
3. 86.482 43,987.302 ↓ 208.1 73,035 1

Nested Loop Left Join (cost=30,816.75..144,546.21 rows=351 width=93) (actual time=80.599..43,987.302 rows=73,035 loops=1)

4. 79.612 21,406.040 ↓ 208.1 73,035 1

Nested Loop Left Join (cost=30,747.97..120,394.78 rows=351 width=77) (actual time=80.175..21,406.040 rows=73,035 loops=1)

5. 54.445 2,921.608 ↓ 208.1 73,035 1

Nested Loop Left Join (cost=30,668.91..92,633.31 rows=351 width=69) (actual time=79.784..2,921.608 rows=73,035 loops=1)

6. 44.346 1,844.673 ↓ 208.1 73,035 1

Nested Loop Left Join (cost=30,668.49..92,301.06 rows=351 width=65) (actual time=79.763..1,844.673 rows=73,035 loops=1)

7. 70.141 1,727.292 ↓ 208.1 73,035 1

Nested Loop (cost=30,668.34..92,242.21 rows=351 width=41) (actual time=79.755..1,727.292 rows=73,035 loops=1)

  • Join Filter: ((s.sender)::text = (sv.sender)::text)
8. 100.030 337.193 ↓ 208.9 73,331 1

Hash Join (cost=30,667.78..91,418.94 rows=351 width=46) (actual time=79.721..337.193 rows=73,331 loops=1)

  • Hash Cond: ((s.sender)::text = (sor.sender)::text)
9. 165.894 178.332 ↓ 1.1 75,241 1

Bitmap Heap Scan on sender s (cost=2,057.54..62,632.09 rows=67,281 width=25) (actual time=20.727..178.332 rows=75,241 loops=1)

  • Recheck Cond: (classification <> 'UNKNOWN'::sender_classification)
  • Heap Blocks: exact=49223
10. 12.438 12.438 ↓ 1.3 86,655 1

Bitmap Index Scan on sender_classification_reviewed_idx (cost=0.00..2,040.72 rows=67,281 width=0) (actual time=12.438..12.438 rows=86,655 loops=1)

11. 14.976 58.831 ↑ 1.0 74,055 1

Hash (cost=27,684.55..27,684.55 rows=74,055 width=21) (actual time=58.831..58.831 rows=74,055 loops=1)

  • Buckets: 131072 Batches: 1 Memory Usage: 4929kB
12. 43.855 43.855 ↑ 1.0 74,055 1

Seq Scan on sender_overview_report sor (cost=0.00..27,684.55 rows=74,055 width=21) (actual time=0.011..43.855 rows=74,055 loops=1)

13. 1,319.958 1,319.958 ↑ 1.0 1 73,331

Index Scan using sender_volumetrics_pkey on sender_volumetrics sv (cost=0.56..2.33 rows=1 width=21) (actual time=0.018..0.018 rows=1 loops=73,331)

  • Index Cond: ((sender)::text = (sor.sender)::text)
14. 73.035 73.035 ↓ 0.0 0 73,035

Index Scan using simbox_sender_metrics_pkey on simbox_sender_metrics ssm (cost=0.15..0.17 rows=1 width=102) (actual time=0.001..0.001 rows=0 loops=73,035)

  • Index Cond: ((s.sender)::text = (sender)::text)
15. 1,022.490 1,022.490 ↑ 1.0 1 73,035

Index Scan using sender_counter_pkey on sender_counter sc (cost=0.42..0.95 rows=1 width=17) (actual time=0.014..0.014 rows=1 loops=73,035)

  • Index Cond: ((s.sender)::text = (sender)::text)
16. 0.000 18,404.820 ↑ 1.0 1 73,035

Aggregate (cost=79.06..79.07 rows=1 width=8) (actual time=0.252..0.252 rows=1 loops=73,035)

17. 63.621 18,404.820 ↓ 0.0 0 73,035

Nested Loop (cost=68.33..79.05 rows=3 width=4) (actual time=0.252..0.252 rows=0 loops=73,035)

18. 219.105 18,331.785 ↓ 0.0 0 73,035

HashAggregate (cost=68.18..68.30 rows=10 width=65) (actual time=0.251..0.251 rows=0 loops=73,035)

  • Group Key: suspicious_sender_pattern_partitioned_2020010906.sender, suspicious_sender_pattern_partitioned_2020010906.text_pattern_id
19. 876.420 18,112.680 ↓ 0.0 0 73,035

Append (cost=0.42..67.98 rows=26 width=21) (actual time=0.225..0.248 rows=0 loops=73,035)

20. 730.350 730.350 ↓ 0.0 0 73,035

Index Scan using suspicious_sender_pattern_partitioned_2020010906_sender_pattern on suspicious_sender_pattern_partitioned_2020010906 (cost=0.42..2.64 rows=1 width=21) (actual time=0.010..0.010 rows=0 loops=73,035)

  • Index Cond: ((sender)::text = (s.sender)::text)
21. 730.350 730.350 ↓ 0.0 0 73,035

Index Scan using suspicious_sender_pattern_partitioned_2020010907_sender_pattern on suspicious_sender_pattern_partitioned_2020010907 (cost=0.42..2.64 rows=1 width=21) (actual time=0.010..0.010 rows=0 loops=73,035)

  • Index Cond: ((sender)::text = (s.sender)::text)
22. 730.350 730.350 ↓ 0.0 0 73,035

Index Scan using suspicious_sender_pattern_partitioned_2020010908_sender_pattern on suspicious_sender_pattern_partitioned_2020010908 (cost=0.42..2.64 rows=1 width=21) (actual time=0.010..0.010 rows=0 loops=73,035)

  • Index Cond: ((sender)::text = (s.sender)::text)
23. 730.350 730.350 ↓ 0.0 0 73,035

Index Scan using suspicious_sender_pattern_partitioned_2020010909_sender_pattern on suspicious_sender_pattern_partitioned_2020010909 (cost=0.42..2.64 rows=1 width=21) (actual time=0.010..0.010 rows=0 loops=73,035)

  • Index Cond: ((sender)::text = (s.sender)::text)
24. 730.350 730.350 ↓ 0.0 0 73,035

Index Scan using suspicious_sender_pattern_partitioned_2020010910_sender_pattern on suspicious_sender_pattern_partitioned_2020010910 (cost=0.42..2.64 rows=1 width=21) (actual time=0.010..0.010 rows=0 loops=73,035)

  • Index Cond: ((sender)::text = (s.sender)::text)
25. 730.350 730.350 ↓ 0.0 0 73,035

Index Scan using suspicious_sender_pattern_partitioned_2020010911_sender_pattern on suspicious_sender_pattern_partitioned_2020010911 (cost=0.42..2.64 rows=1 width=21) (actual time=0.010..0.010 rows=0 loops=73,035)

  • Index Cond: ((sender)::text = (s.sender)::text)
26. 730.350 730.350 ↓ 0.0 0 73,035

Index Scan using suspicious_sender_pattern_partitioned_2020010912_sender_pattern on suspicious_sender_pattern_partitioned_2020010912 (cost=0.42..2.64 rows=1 width=21) (actual time=0.010..0.010 rows=0 loops=73,035)

  • Index Cond: ((sender)::text = (s.sender)::text)
27. 730.350 730.350 ↓ 0.0 0 73,035

Index Scan using suspicious_sender_pattern_partitioned_2020010913_sender_pattern on suspicious_sender_pattern_partitioned_2020010913 (cost=0.42..2.64 rows=1 width=21) (actual time=0.010..0.010 rows=0 loops=73,035)

  • Index Cond: ((sender)::text = (s.sender)::text)
28. 730.350 730.350 ↓ 0.0 0 73,035

Index Scan using suspicious_sender_pattern_partitioned_2020010914_sender_pattern on suspicious_sender_pattern_partitioned_2020010914 (cost=0.42..2.64 rows=1 width=21) (actual time=0.010..0.010 rows=0 loops=73,035)

  • Index Cond: ((sender)::text = (s.sender)::text)
29. 657.315 657.315 ↓ 0.0 0 73,035

Index Scan using suspicious_sender_pattern_partitioned_2020010915_sender_pattern on suspicious_sender_pattern_partitioned_2020010915 (cost=0.42..2.64 rows=1 width=21) (actual time=0.009..0.009 rows=0 loops=73,035)

  • Index Cond: ((sender)::text = (s.sender)::text)
30. 657.315 657.315 ↓ 0.0 0 73,035

Index Scan using suspicious_sender_pattern_partitioned_2020010916_sender_pattern on suspicious_sender_pattern_partitioned_2020010916 (cost=0.41..2.63 rows=1 width=21) (actual time=0.009..0.009 rows=0 loops=73,035)

  • Index Cond: ((sender)::text = (s.sender)::text)
31. 584.280 584.280 ↓ 0.0 0 73,035

Index Scan using suspicious_sender_pattern_partitioned_2020010917_sender_pattern on suspicious_sender_pattern_partitioned_2020010917 (cost=0.29..2.51 rows=1 width=21) (actual time=0.008..0.008 rows=0 loops=73,035)

  • Index Cond: ((sender)::text = (s.sender)::text)
32. 511.245 511.245 ↓ 0.0 0 73,035

Index Scan using suspicious_sender_pattern_partitioned_2020010918_sender_pattern on suspicious_sender_pattern_partitioned_2020010918 (cost=0.29..2.50 rows=1 width=21) (actual time=0.007..0.007 rows=0 loops=73,035)

  • Index Cond: ((sender)::text = (s.sender)::text)
33. 511.245 511.245 ↓ 0.0 0 73,035

Index Scan using suspicious_sender_pattern_partitioned_2020010919_sender_pattern on suspicious_sender_pattern_partitioned_2020010919 (cost=0.29..2.50 rows=1 width=21) (actual time=0.007..0.007 rows=0 loops=73,035)

  • Index Cond: ((sender)::text = (s.sender)::text)
34. 511.245 511.245 ↓ 0.0 0 73,035

Index Scan using suspicious_sender_pattern_partitioned_2020010920_sender_pattern on suspicious_sender_pattern_partitioned_2020010920 (cost=0.29..2.50 rows=1 width=21) (actual time=0.007..0.007 rows=0 loops=73,035)

  • Index Cond: ((sender)::text = (s.sender)::text)
35. 511.245 511.245 ↓ 0.0 0 73,035

Index Scan using suspicious_sender_pattern_partitioned_2020010921_sender_pattern on suspicious_sender_pattern_partitioned_2020010921 (cost=0.29..2.51 rows=1 width=21) (actual time=0.007..0.007 rows=0 loops=73,035)

  • Index Cond: ((sender)::text = (s.sender)::text)
36. 657.315 657.315 ↓ 0.0 0 73,035

Index Scan using suspicious_sender_pattern_partitioned_2020010922_sender_pattern on suspicious_sender_pattern_partitioned_2020010922 (cost=0.41..2.63 rows=1 width=21) (actual time=0.009..0.009 rows=0 loops=73,035)

  • Index Cond: ((sender)::text = (s.sender)::text)
37. 657.315 657.315 ↓ 0.0 0 73,035

Index Scan using suspicious_sender_pattern_partitioned_2020010923_sender_pattern on suspicious_sender_pattern_partitioned_2020010923 (cost=0.42..2.64 rows=1 width=21) (actual time=0.009..0.009 rows=0 loops=73,035)

  • Index Cond: ((sender)::text = (s.sender)::text)
38. 657.315 657.315 ↓ 0.0 0 73,035

Index Scan using suspicious_sender_pattern_partitioned_2020011000_sender_pattern on suspicious_sender_pattern_partitioned_2020011000 (cost=0.42..2.64 rows=1 width=21) (actual time=0.009..0.009 rows=0 loops=73,035)

  • Index Cond: ((sender)::text = (s.sender)::text)
39. 657.315 657.315 ↓ 0.0 0 73,035

Index Scan using suspicious_sender_pattern_partitioned_2020011001_sender_pattern on suspicious_sender_pattern_partitioned_2020011001 (cost=0.42..2.64 rows=1 width=21) (actual time=0.009..0.009 rows=0 loops=73,035)

  • Index Cond: ((sender)::text = (s.sender)::text)
40. 657.315 657.315 ↓ 0.0 0 73,035

Index Scan using suspicious_sender_pattern_partitioned_2020011002_sender_pattern on suspicious_sender_pattern_partitioned_2020011002 (cost=0.42..2.64 rows=1 width=21) (actual time=0.009..0.009 rows=0 loops=73,035)

  • Index Cond: ((sender)::text = (s.sender)::text)
41. 730.350 730.350 ↓ 0.0 0 73,035

Index Scan using suspicious_sender_pattern_partitioned_2020011003_sender_pattern on suspicious_sender_pattern_partitioned_2020011003 (cost=0.42..2.64 rows=1 width=21) (actual time=0.009..0.010 rows=0 loops=73,035)

  • Index Cond: ((sender)::text = (s.sender)::text)
42. 657.315 657.315 ↓ 0.0 0 73,035

Index Scan using suspicious_sender_pattern_partitioned_2020011004_sender_pattern on suspicious_sender_pattern_partitioned_2020011004 (cost=0.42..2.64 rows=1 width=21) (actual time=0.009..0.009 rows=0 loops=73,035)

  • Index Cond: ((sender)::text = (s.sender)::text)
43. 657.315 657.315 ↓ 0.0 0 73,035

Index Scan using suspicious_sender_pattern_partitioned_2020011005_sender_pattern on suspicious_sender_pattern_partitioned_2020011005 (cost=0.42..2.64 rows=1 width=21) (actual time=0.009..0.009 rows=0 loops=73,035)

  • Index Cond: ((sender)::text = (s.sender)::text)
44. 730.350 730.350 ↓ 0.0 0 73,035

Index Scan using suspicious_sender_pattern_partitioned_2020011006_sender_pattern on suspicious_sender_pattern_partitioned_2020011006 (cost=0.42..2.64 rows=1 width=21) (actual time=0.010..0.010 rows=0 loops=73,035)

  • Index Cond: ((sender)::text = (s.sender)::text)
45. 657.315 657.315 ↓ 0.0 0 73,035

Index Scan using suspicious_sender_pattern_partitioned_2020011007_sender_pattern on suspicious_sender_pattern_partitioned_2020011007 (cost=0.41..2.63 rows=1 width=21) (actual time=0.009..0.009 rows=0 loops=73,035)

  • Index Cond: ((sender)::text = (s.sender)::text)
46. 9.414 9.414 ↓ 0.0 0 9,414

Index Scan using sender_simbox_classification_text_pattern_threshold_pkey on sender_simbox_classification_text_pattern_threshold ssctpt (cost=0.15..1.06 rows=1 width=8) (actual time=0.001..0.001 rows=0 loops=9,414)

  • Index Cond: (text_pattern_id = suspicious_sender_pattern_partitioned_2020010906.text_pattern_id)
  • Filter: (((sum(suspicious_sender_pattern_partitioned_2020010906.hit_count))::integer) >= threshold)
47. 584.280 22,494.780 ↑ 1.0 1 73,035

Aggregate (cost=68.78..68.79 rows=1 width=16) (actual time=0.308..0.308 rows=1 loops=73,035)

48. 730.350 21,910.500 ↑ 26.0 1 73,035

Append (cost=0.42..68.64 rows=26 width=21) (actual time=0.210..0.300 rows=1 loops=73,035)

49. 876.420 876.420 ↓ 0.0 0 73,035

Index Scan using sender_unique_destinations_partitioned_2020010906_sender_uidx on sender_unique_destinations_partitioned_2020010906 udp (cost=0.42..2.65 rows=1 width=22) (actual time=0.012..0.012 rows=0 loops=73,035)

  • Index Cond: ((s.sender)::text = (sender)::text)
  • Filter: ((period < '2020-01-09 13:00:00'::timestamp without time zone) AND (period >= '2020-01-08 12:00:00'::timestamp without time zone))
50. 876.420 876.420 ↓ 0.0 0 73,035

Index Scan using sender_unique_destinations_partitioned_2020010907_sender_uidx on sender_unique_destinations_partitioned_2020010907 udp_1 (cost=0.42..2.65 rows=1 width=22) (actual time=0.012..0.012 rows=0 loops=73,035)

  • Index Cond: ((s.sender)::text = (sender)::text)
  • Filter: ((period < '2020-01-09 13:00:00'::timestamp without time zone) AND (period >= '2020-01-08 12:00:00'::timestamp without time zone))
51. 876.420 876.420 ↓ 0.0 0 73,035

Index Scan using sender_unique_destinations_partitioned_2020010908_sender_uidx on sender_unique_destinations_partitioned_2020010908 udp_2 (cost=0.42..2.65 rows=1 width=21) (actual time=0.012..0.012 rows=0 loops=73,035)

  • Index Cond: ((s.sender)::text = (sender)::text)
  • Filter: ((period < '2020-01-09 13:00:00'::timestamp without time zone) AND (period >= '2020-01-08 12:00:00'::timestamp without time zone))
52. 876.420 876.420 ↓ 0.0 0 73,035

Index Scan using sender_unique_destinations_partitioned_2020010909_sender_uidx on sender_unique_destinations_partitioned_2020010909 udp_3 (cost=0.42..2.65 rows=1 width=22) (actual time=0.012..0.012 rows=0 loops=73,035)

  • Index Cond: ((s.sender)::text = (sender)::text)
  • Filter: ((period < '2020-01-09 13:00:00'::timestamp without time zone) AND (period >= '2020-01-08 12:00:00'::timestamp without time zone))
53. 876.420 876.420 ↓ 0.0 0 73,035

Index Scan using sender_unique_destinations_partitioned_2020010910_sender_uidx on sender_unique_destinations_partitioned_2020010910 udp_4 (cost=0.42..2.65 rows=1 width=21) (actual time=0.012..0.012 rows=0 loops=73,035)

  • Index Cond: ((s.sender)::text = (sender)::text)
  • Filter: ((period < '2020-01-09 13:00:00'::timestamp without time zone) AND (period >= '2020-01-08 12:00:00'::timestamp without time zone))
54. 876.420 876.420 ↓ 0.0 0 73,035

Index Scan using sender_unique_destinations_partitioned_2020010911_sender_uidx on sender_unique_destinations_partitioned_2020010911 udp_5 (cost=0.42..2.65 rows=1 width=20) (actual time=0.012..0.012 rows=0 loops=73,035)

  • Index Cond: ((s.sender)::text = (sender)::text)
  • Filter: ((period < '2020-01-09 13:00:00'::timestamp without time zone) AND (period >= '2020-01-08 12:00:00'::timestamp without time zone))
55. 876.420 876.420 ↓ 0.0 0 73,035

Index Scan using sender_unique_destinations_partitioned_2020010912_sender_uidx on sender_unique_destinations_partitioned_2020010912 udp_6 (cost=0.42..2.65 rows=1 width=20) (actual time=0.012..0.012 rows=0 loops=73,035)

  • Index Cond: ((s.sender)::text = (sender)::text)
  • Filter: ((period < '2020-01-09 13:00:00'::timestamp without time zone) AND (period >= '2020-01-08 12:00:00'::timestamp without time zone))
56. 876.420 876.420 ↓ 0.0 0 73,035

Index Scan using sender_unique_destinations_partitioned_2020010913_sender_uidx on sender_unique_destinations_partitioned_2020010913 udp_7 (cost=0.42..2.65 rows=1 width=20) (actual time=0.012..0.012 rows=0 loops=73,035)

  • Index Cond: ((s.sender)::text = (sender)::text)
  • Filter: ((period < '2020-01-09 13:00:00'::timestamp without time zone) AND (period >= '2020-01-08 12:00:00'::timestamp without time zone))
  • Rows Removed by Filter: 0
57. 803.385 803.385 ↓ 0.0 0 73,035

Index Scan using sender_unique_destinations_partitioned_2020010914_sender_uidx on sender_unique_destinations_partitioned_2020010914 udp_8 (cost=0.42..2.65 rows=1 width=20) (actual time=0.011..0.011 rows=0 loops=73,035)

  • Index Cond: ((s.sender)::text = (sender)::text)
  • Filter: ((period < '2020-01-09 13:00:00'::timestamp without time zone) AND (period >= '2020-01-08 12:00:00'::timestamp without time zone))
  • Rows Removed by Filter: 0
58. 803.385 803.385 ↓ 0.0 0 73,035

Index Scan using sender_unique_destinations_partitioned_2020010915_sender_uidx on sender_unique_destinations_partitioned_2020010915 udp_9 (cost=0.42..2.65 rows=1 width=20) (actual time=0.011..0.011 rows=0 loops=73,035)

  • Index Cond: ((s.sender)::text = (sender)::text)
  • Filter: ((period < '2020-01-09 13:00:00'::timestamp without time zone) AND (period >= '2020-01-08 12:00:00'::timestamp without time zone))
  • Rows Removed by Filter: 0
59. 730.350 730.350 ↓ 0.0 0 73,035

Index Scan using sender_unique_destinations_partitioned_2020010916_sender_uidx on sender_unique_destinations_partitioned_2020010916 udp_10 (cost=0.42..2.64 rows=1 width=21) (actual time=0.010..0.010 rows=0 loops=73,035)

  • Index Cond: ((s.sender)::text = (sender)::text)
  • Filter: ((period < '2020-01-09 13:00:00'::timestamp without time zone) AND (period >= '2020-01-08 12:00:00'::timestamp without time zone))
  • Rows Removed by Filter: 0
60. 730.350 730.350 ↓ 0.0 0 73,035

Index Scan using sender_unique_destinations_partitioned_2020010917_sender_uidx on sender_unique_destinations_partitioned_2020010917 udp_11 (cost=0.42..2.64 rows=1 width=20) (actual time=0.010..0.010 rows=0 loops=73,035)

  • Index Cond: ((s.sender)::text = (sender)::text)
  • Filter: ((period < '2020-01-09 13:00:00'::timestamp without time zone) AND (period >= '2020-01-08 12:00:00'::timestamp without time zone))
  • Rows Removed by Filter: 0
61. 730.350 730.350 ↓ 0.0 0 73,035

Index Scan using sender_unique_destinations_partitioned_2020010918_sender_uidx on sender_unique_destinations_partitioned_2020010918 udp_12 (cost=0.41..2.64 rows=1 width=20) (actual time=0.010..0.010 rows=0 loops=73,035)

  • Index Cond: ((s.sender)::text = (sender)::text)
  • Filter: ((period < '2020-01-09 13:00:00'::timestamp without time zone) AND (period >= '2020-01-08 12:00:00'::timestamp without time zone))
  • Rows Removed by Filter: 0
62. 584.280 584.280 ↓ 0.0 0 73,035

Index Scan using sender_unique_destinations_partitioned_2020010919_sender_uidx on sender_unique_destinations_partitioned_2020010919 udp_13 (cost=0.29..2.51 rows=1 width=21) (actual time=0.008..0.008 rows=0 loops=73,035)

  • Index Cond: ((s.sender)::text = (sender)::text)
  • Filter: ((period < '2020-01-09 13:00:00'::timestamp without time zone) AND (period >= '2020-01-08 12:00:00'::timestamp without time zone))
  • Rows Removed by Filter: 0
63. 584.280 584.280 ↓ 0.0 0 73,035

Index Scan using sender_unique_destinations_partitioned_2020010920_sender_uidx on sender_unique_destinations_partitioned_2020010920 udp_14 (cost=0.29..2.51 rows=1 width=20) (actual time=0.008..0.008 rows=0 loops=73,035)

  • Index Cond: ((s.sender)::text = (sender)::text)
  • Filter: ((period < '2020-01-09 13:00:00'::timestamp without time zone) AND (period >= '2020-01-08 12:00:00'::timestamp without time zone))
  • Rows Removed by Filter: 0
64. 730.350 730.350 ↓ 0.0 0 73,035

Index Scan using sender_unique_destinations_partitioned_2020010921_sender_uidx on sender_unique_destinations_partitioned_2020010921 udp_15 (cost=0.42..2.64 rows=1 width=19) (actual time=0.010..0.010 rows=0 loops=73,035)

  • Index Cond: ((s.sender)::text = (sender)::text)
  • Filter: ((period < '2020-01-09 13:00:00'::timestamp without time zone) AND (period >= '2020-01-08 12:00:00'::timestamp without time zone))
  • Rows Removed by Filter: 0
65. 803.385 803.385 ↓ 0.0 0 73,035

Index Scan using sender_unique_destinations_partitioned_2020010922_sender_uidx on sender_unique_destinations_partitioned_2020010922 udp_16 (cost=0.42..2.64 rows=1 width=19) (actual time=0.011..0.011 rows=0 loops=73,035)

  • Index Cond: ((s.sender)::text = (sender)::text)
  • Filter: ((period < '2020-01-09 13:00:00'::timestamp without time zone) AND (period >= '2020-01-08 12:00:00'::timestamp without time zone))
  • Rows Removed by Filter: 0
66. 803.385 803.385 ↓ 0.0 0 73,035

Index Scan using sender_unique_destinations_partitioned_2020010923_sender_uidx on sender_unique_destinations_partitioned_2020010923 udp_17 (cost=0.42..2.65 rows=1 width=19) (actual time=0.011..0.011 rows=0 loops=73,035)

  • Index Cond: ((s.sender)::text = (sender)::text)
  • Filter: ((period < '2020-01-09 13:00:00'::timestamp without time zone) AND (period >= '2020-01-08 12:00:00'::timestamp without time zone))
  • Rows Removed by Filter: 0
67. 803.385 803.385 ↓ 0.0 0 73,035

Index Scan using sender_unique_destinations_partitioned_2020011000_sender_uidx on sender_unique_destinations_partitioned_2020011000 udp_18 (cost=0.42..2.65 rows=1 width=20) (actual time=0.011..0.011 rows=0 loops=73,035)

  • Index Cond: ((s.sender)::text = (sender)::text)
  • Filter: ((period < '2020-01-09 13:00:00'::timestamp without time zone) AND (period >= '2020-01-08 12:00:00'::timestamp without time zone))
  • Rows Removed by Filter: 0
68. 876.420 876.420 ↓ 0.0 0 73,035

Index Scan using sender_unique_destinations_partitioned_2020011001_sender_uidx on sender_unique_destinations_partitioned_2020011001 udp_19 (cost=0.42..2.65 rows=1 width=21) (actual time=0.012..0.012 rows=0 loops=73,035)

  • Index Cond: ((s.sender)::text = (sender)::text)
  • Filter: ((period < '2020-01-09 13:00:00'::timestamp without time zone) AND (period >= '2020-01-08 12:00:00'::timestamp without time zone))
  • Rows Removed by Filter: 0
69. 876.420 876.420 ↓ 0.0 0 73,035

Index Scan using sender_unique_destinations_partitioned_2020011002_sender_uidx on sender_unique_destinations_partitioned_2020011002 udp_20 (cost=0.42..2.65 rows=1 width=21) (actual time=0.012..0.012 rows=0 loops=73,035)

  • Index Cond: ((s.sender)::text = (sender)::text)
  • Filter: ((period < '2020-01-09 13:00:00'::timestamp without time zone) AND (period >= '2020-01-08 12:00:00'::timestamp without time zone))
  • Rows Removed by Filter: 0
70. 876.420 876.420 ↓ 0.0 0 73,035

Index Scan using sender_unique_destinations_partitioned_2020011003_sender_uidx on sender_unique_destinations_partitioned_2020011003 udp_21 (cost=0.42..2.65 rows=1 width=22) (actual time=0.012..0.012 rows=0 loops=73,035)

  • Index Cond: ((s.sender)::text = (sender)::text)
  • Filter: ((period < '2020-01-09 13:00:00'::timestamp without time zone) AND (period >= '2020-01-08 12:00:00'::timestamp without time zone))
  • Rows Removed by Filter: 0
71. 876.420 876.420 ↓ 0.0 0 73,035

Index Scan using sender_unique_destinations_partitioned_2020011004_sender_uidx on sender_unique_destinations_partitioned_2020011004 udp_22 (cost=0.42..2.65 rows=1 width=21) (actual time=0.012..0.012 rows=0 loops=73,035)

  • Index Cond: ((s.sender)::text = (sender)::text)
  • Filter: ((period < '2020-01-09 13:00:00'::timestamp without time zone) AND (period >= '2020-01-08 12:00:00'::timestamp without time zone))
  • Rows Removed by Filter: 0
72. 876.420 876.420 ↓ 0.0 0 73,035

Index Scan using sender_unique_destinations_partitioned_2020011005_sender_uidx on sender_unique_destinations_partitioned_2020011005 udp_23 (cost=0.42..2.65 rows=1 width=21) (actual time=0.012..0.012 rows=0 loops=73,035)

  • Index Cond: ((s.sender)::text = (sender)::text)
  • Filter: ((period < '2020-01-09 13:00:00'::timestamp without time zone) AND (period >= '2020-01-08 12:00:00'::timestamp without time zone))
  • Rows Removed by Filter: 0
73. 876.420 876.420 ↓ 0.0 0 73,035

Index Scan using sender_unique_destinations_partitioned_2020011006_sender_uidx on sender_unique_destinations_partitioned_2020011006 udp_24 (cost=0.42..2.65 rows=1 width=21) (actual time=0.012..0.012 rows=0 loops=73,035)

  • Index Cond: ((s.sender)::text = (sender)::text)
  • Filter: ((period < '2020-01-09 13:00:00'::timestamp without time zone) AND (period >= '2020-01-08 12:00:00'::timestamp without time zone))
  • Rows Removed by Filter: 0
74. 803.385 803.385 ↓ 0.0 0 73,035

Index Scan using sender_unique_destinations_partitioned_2020011007_sender_uidx on sender_unique_destinations_partitioned_2020011007 udp_25 (cost=0.42..2.65 rows=1 width=21) (actual time=0.011..0.011 rows=0 loops=73,035)

  • Index Cond: ((s.sender)::text = (sender)::text)
  • Filter: ((period < '2020-01-09 13:00:00'::timestamp without time zone) AND (period >= '2020-01-08 12:00:00'::timestamp without time zone))
  • Rows Removed by Filter: 0