explain.depesz.com

PostgreSQL's explain analyze made readable

Result: b3v3

Settings
# exclusive inclusive rows x rows loops node
1. 0.000 5,913.246 ↑ 172.4 18 1

GroupAggregate (cost=1,240,288.68..1,241,930.51 rows=3,104 width=24) (actual time=5,912.303..5,913.246 rows=18 loops=1)

  • Group Key: p_2_1.id, p_2_1.portal_type_id
  • Buffers: shared hit=122187 read=41647
2. 227.669 6,061.555 ↑ 200.3 62 1

Gather Merge (cost=1,240,288.68..1,241,775.31 rows=12,416 width=24) (actual time=5,912.291..6,061.555 rows=62 loops=1)

  • Workers Planned: 4
  • Workers Launched: 4
  • Buffers: shared hit=484587 read=205656
3. 0.068 5,833.886 ↑ 258.7 12 5 / 5

Sort (cost=1,239,288.63..1,239,296.39 rows=3,104 width=24) (actual time=5,833.885..5,833.886 rows=12 loops=5)

  • Sort Key: p_2_1.id, p_2_1.portal_type_id
  • Sort Method: quicksort Memory: 26kB
  • Buffers: shared hit=484587 read=205656
4. 1.648 5,833.818 ↑ 258.7 12 5 / 5

HashAggregate (cost=1,239,077.56..1,239,108.6 rows=3,104 width=24) (actual time=5,833.752..5,833.818 rows=12 loops=5)

  • Group Key: p_2_1.id, p_2_1.portal_type_id
  • Buffers: shared hit=484555 read=205656
5. 2.983 5,832.170 ↑ 130.9 6,140 5 / 5

Hash Join (cost=2,745.37..1,231,040.22 rows=803,734 width=24) (actual time=4,570.549..5,832.17 rows=6,140 loops=5)

  • Buffers: shared hit=484555 read=205656
6. 0.855 1,356.495 ↑ 130.9 6,140 5 / 5

Append (cost=0..1,223,271.55 rows=803,732 width=12) (actual time=97.55..1,356.495 rows=6,140 loops=5)

  • Buffers: shared hit=482945 read=205656
7. 0.052 0.127 ↓ 0.0 0 1 / 5

Bitmap Heap Scan on running_operations g_22 (cost=1,614.37..1,942.67 rows=19 width=12) (actual time=0.633..0.633 rows=0 loops=1)

  • Filter: ((NOT g_22.frozen) AND (g_22.scheduled_time <= now()))
  • Buffers: shared hit=60
8. 0.075 0.075 ↑ 1.0 328 1 / 5

Bitmap Index Scan on day_running_operations_idx (cost=0..1,614.36 rows=328 width=0) (actual time=0.373..0.373 rows=328 loops=1)

  • Index Cond: (g_22.day >= ('now'::cstring)::date)
  • Buffers: shared hit=38
9. 0.004 0.024 ↓ 0.0 0 1 / 5

Bitmap Heap Scan on running_operations g_9 (cost=1.24..2.35 rows=1 width=12) (actual time=0.12..0.12 rows=0 loops=1)

  • Filter: ((NOT g_9.frozen) AND (g_9.scheduled_time <= now()))
  • Buffers: shared hit=2
10. 0.020 0.020 ↓ 0.0 0 1 / 5

Bitmap Index Scan on day_running_operations_idx (cost=0..1.24 rows=1 width=0) (actual time=0.102..0.102 rows=0 loops=1)

  • Index Cond: (g_9.day >= ('now'::cstring)::date)
  • Buffers: shared hit=2
11. 22.098 22.098 ↑ 234.2 637 2 / 5

Index Scan using running_operations_entity_id_scheduled_time_day_idx on running_operations g_20 (cost=0.43..422,286.55 rows=149,199 width=12) (actual time=13.231..55.244 rows=637 loops=2)

  • Index Cond: ((g_20.scheduled_time <= now()) AND (g_20.day >= ('now'::cstring)::date))
  • Buffers: shared hit=4862
12. 1,216.229 1,216.229 ↑ 102.5 5,811 5 / 5

Seq Scan on running_operations g_1 (cost=0..695,369.9 rows=595,605 width=12) (actual time=2.792..1,216.229 rows=5,811 loops=5)

  • Filter: ((NOT g_1.frozen) AND (g_1.scheduled_time <= now()) AND (g_1.day >= ('now'::cstring)::date))
  • Buffers: shared hit=394601 read=205656
13. 76.538 76.538 ↓ 0.0 0 3 / 5

Seq Scan on running_operations g_14 (cost=0..59,337.6 rows=46,079 width=12) (actual time=127.563..127.563 rows=0 loops=3)

  • Filter: ((NOT g_14.frozen) AND (g_14.scheduled_time <= now()) AND (g_14.day >= ('now'::cstring)::date))
  • Buffers: shared hit=51649
14. 14.896 14.896 ↓ 0.0 0 1 / 5

Seq Scan on running_operations g_18 (cost=0..16,216.02 rows=8,596 width=12) (actual time=74.481..74.481 rows=0 loops=1)

  • Filter: ((NOT g_18.frozen) AND (g_18.scheduled_time <= now()) AND (g_18.day >= ('now'::cstring)::date))
  • Buffers: shared hit=13069
15. 14.013 14.013 ↑ 40.5 185 2 / 5

Seq Scan on running_operations g_16 (cost=0..13,265.29 rows=7,492 width=12) (actual time=14.049..35.032 rows=185 loops=2)

  • Filter: ((NOT g_16.frozen) AND (g_16.scheduled_time <= now()) AND (g_16.day >= ('now'::cstring)::date))
  • Buffers: shared hit=11188
16. 5.228 5.228 ↓ 0.0 0 1 / 5

Seq Scan on running_operations g_12 (cost=0..4,339.4 rows=6 width=12) (actual time=26.142..26.142 rows=0 loops=1)

  • Filter: ((NOT g_12.frozen) AND (g_12.scheduled_time <= now()) AND (g_12.day >= ('now'::cstring)::date))
  • Buffers: shared hit=2888
17. 2.159 2.159 ↓ 0.0 0 1 / 5

Seq Scan on running_operations g_25 (cost=0..2,303.84 rows=278 width=12) (actual time=10.793..10.793 rows=0 loops=1)

  • Filter: ((NOT g_25.frozen) AND (g_25.scheduled_time <= now()) AND (g_25.day >= ('now'::cstring)::date))
  • Buffers: shared hit=1531
18. 0.955 0.955 ↓ 0.0 0 1 / 5

Seq Scan on running_operations g_19 (cost=0..1,208.14 rows=1 width=12) (actual time=4.774..4.774 rows=0 loops=1)

  • Filter: ((NOT g_19.frozen) AND (g_19.scheduled_time <= now()) AND (g_19.day >= ('now'::cstring)::date))
  • Buffers: shared hit=908
19. 1.071 1.071 ↓ 0.0 0 1 / 5

Seq Scan on running_operations g_7 (cost=0..1,200.55 rows=234 width=12) (actual time=5.353..5.353 rows=0 loops=1)

  • Filter: ((NOT g_7.frozen) AND (g_7.scheduled_time <= now()) AND (g_7.day >= ('now'::cstring)::date))
  • Buffers: shared hit=909
20. 0.900 0.900 ↓ 0.0 0 1 / 5

Seq Scan on running_operations g_11 (cost=0..998.9 rows=30 width=12) (actual time=4.5..4.5 rows=0 loops=1)

  • Filter: ((NOT g_11.frozen) AND (g_11.scheduled_time <= now()) AND (g_11.day >= ('now'::cstring)::date))
  • Buffers: shared hit=744
21. 0.348 0.348 ↓ 0.0 0 1 / 5

Seq Scan on running_operations g_21 (cost=0..380.21 rows=1 width=12) (actual time=1.739..1.739 rows=0 loops=1)

  • Filter: ((NOT g_21.frozen) AND (g_21.scheduled_time <= now()) AND (g_21.day >= ('now'::cstring)::date))
  • Buffers: shared hit=284
22. 0.932 0.932 ↓ 0.0 0 1 / 5

Seq Scan on running_operations g_8 (cost=0..147.91 rows=1 width=12) (actual time=4.659..4.659 rows=0 loops=1)

  • Filter: ((NOT g_8.frozen) AND (g_8.scheduled_time <= now()) AND (g_8.day >= ('now'::cstring)::date))
  • Buffers: shared hit=125
23. 0.066 0.066 ↓ 0.0 0 1 / 5

Seq Scan on running_operations g_24 (cost=0..85.09 rows=1 width=12) (actual time=0.328..0.328 rows=0 loops=1)

  • Filter: ((NOT g_24.frozen) AND (g_24.scheduled_time <= now()) AND (g_24.day >= ('now'::cstring)::date))
  • Buffers: shared hit=59
24. 0.051 0.051 ↓ 0.0 0 1 / 5

Seq Scan on running_operations g_3 (cost=0..59.16 rows=1 width=12) (actual time=0.253..0.253 rows=0 loops=1)

  • Filter: ((NOT g_3.frozen) AND (g_3.scheduled_time <= now()) AND (g_3.day >= ('now'::cstring)::date))
  • Buffers: shared hit=49
25. 0.000 0.000 ↓ 0.0 0 1 / 5

Seq Scan on running_operations g_13 (cost=0..14.24 rows=188 width=12) (actual time=0..0 rows=0 loops=1)

  • Filter: ((NOT g_13.frozen) AND (g_13.scheduled_time <= now()) AND (g_13.day >= ('now'::cstring)::date))
26. 0.004 0.004 ↓ 0.0 0 1 / 5

Seq Scan on running_operations g_6 (cost=0..14.19 rows=8 width=12) (actual time=0.021..0.021 rows=0 loops=1)

  • Filter: ((NOT g_6.frozen) AND (g_6.scheduled_time <= now()) AND (g_6.day >= ('now'::cstring)::date))
  • Buffers: shared hit=14
27. 0.000 0.000 ↓ 0.0 0 1 / 5

Seq Scan on running_operations g_15 (cost=0..11.59 rows=71 width=12) (actual time=0.001..0.001 rows=0 loops=1)

  • Filter: ((NOT g_15.frozen) AND (g_15.scheduled_time <= now()) AND (g_15.day >= ('now'::cstring)::date))
28. 0.000 0.000 ↓ 0.0 0 1 / 5

Seq Scan on running_operations g_17 (cost=0..11.59 rows=51 width=12) (actual time=0..0 rows=0 loops=1)

  • Filter: ((NOT g_17.frozen) AND (g_17.scheduled_time <= now()) AND (g_17.day >= ('now'::cstring)::date))
29. 0.000 0.000 ↓ 0.0 0 1 / 5

Seq Scan on running_operations g_2 (cost=0..10.93 rows=2 width=12) (actual time=0.001..0.001 rows=0 loops=1)

  • Filter: ((NOT g_2.frozen) AND (g_2.scheduled_time <= now()) AND (g_2.day >= ('now'::cstring)::date))
30. 0.000 0.000 ↓ 0.0 0 1 / 5

Seq Scan on running_operations g_4 (cost=0..10.93 rows=2 width=12) (actual time=0..0 rows=0 loops=1)

  • Filter: ((NOT g_4.frozen) AND (g_4.scheduled_time <= now()) AND (g_4.day >= ('now'::cstring)::date))
31. 0.000 0.000 ↓ 0.0 0 1 / 5

Seq Scan on running_operations g_10 (cost=0..10.93 rows=2 width=12) (actual time=0..0.001 rows=0 loops=1)

  • Filter: ((NOT g_10.frozen) AND (g_10.scheduled_time <= now()) AND (g_10.day >= ('now'::cstring)::date))
32. 0.000 0.000 ↓ 0.0 0 1 / 5

Seq Scan on running_operations g_23 (cost=0..10.93 rows=2 width=12) (actual time=0..0 rows=0 loops=1)

  • Filter: ((NOT g_23.frozen) AND (g_23.scheduled_time <= now()) AND (g_23.day >= ('now'::cstring)::date))
33. 0.000 0.000 ↓ 0.0 0 1 / 5

Seq Scan on running_operations g_26 (cost=0..10.93 rows=2 width=12) (actual time=0.001..0.001 rows=0 loops=1)

  • Filter: ((NOT g_26.frozen) AND (g_26.scheduled_time <= now()) AND (g_26.day >= ('now'::cstring)::date))
34. 0.001 0.001 ↓ 0.0 0 1 / 5

Seq Scan on running_operations g_5 (cost=0..2 rows=1 width=12) (actual time=0.006..0.007 rows=0 loops=1)

  • Filter: ((NOT g_5.frozen) AND (g_5.scheduled_time <= now()) AND (g_5.day >= ('now'::cstring)::date))
  • Buffers: shared hit=2
35. 0.001 0.001 ↓ 0.0 0 1 / 5

Seq Scan on running_operations g (cost=0..1.09 rows=1 width=12) (actual time=0.004..0.005 rows=0 loops=1)

  • Filter: ((NOT g.frozen) AND (g.scheduled_time <= now()) AND (g.day >= ('now'::cstring)::date))
  • Buffers: shared hit=1
36. 8.432 4,472.692 ↑ 1.4 13,854 5 / 5

Hash (cost=2,507.56..2,507.56 rows=19,025 width=20) (actual time=4,472.692..4,472.692 rows=13,854 loops=5)

  • Buffers: shared hit=1610
37. 3.814 4,464.260 ↑ 1.4 13,854 5 / 5

Hash Join (cost=352.18..2,507.56 rows=19,025 width=20) (actual time=4,455.077..4,464.26 rows=13,854 loops=5)

  • Buffers: shared hit=1610
38. 1.428 5.764 ↑ 1.3 15,056 5 / 5

Append (cost=0..2,036.48 rows=19,026 width=8) (actual time=0.128..5.764 rows=15,056 loops=5)

  • Buffers: shared hit=1438
39. 2.589 2.589 ↑ 3.0 9,042 5 / 5

Seq Scan on entities e_1 (cost=0..1,135.98 rows=26,848 width=8) (actual time=0.041..2.589 rows=9,042 loops=5)

  • Filter: e_1.enabled
  • Buffers: shared hit=850
40. 0.334 0.334 ↓ 1.7 4,115 1 / 5

Seq Scan on entities e_20 (cost=0..136.91 rows=2,411 width=8) (actual time=0.135..1.67 rows=4,115 loops=1)

  • Filter: e_20.enabled
  • Buffers: shared hit=107
41. 0.248 0.248 ↓ 1.7 4,402 1 / 5

Seq Scan on entities e_14 (cost=0..106.12 rows=2,568 width=8) (actual time=0.215..1.238 rows=4,402 loops=1)

  • Filter: e_14.enabled
  • Buffers: shared hit=80
42. 0.196 0.196 ↓ 1.6 3,301 1 / 5

Seq Scan on entities e_16 (cost=0..82.72 rows=2,040 width=8) (actual time=0.121..0.981 rows=3,301 loops=1)

  • Filter: e_16.enabled
  • Buffers: shared hit=62
43. 0.168 0.168 ↓ 1.7 3,364 1 / 5

Seq Scan on entities e_22 (cost=0..81.05 rows=1,978 width=8) (actual time=0.019..0.842 rows=3,364 loops=1)

  • Filter: e_22.enabled
  • Buffers: shared hit=61
44. 0.193 0.193 ↑ 1.8 1,136 3 / 5

Seq Scan on entities e_18 (cost=0..81.02 rows=2,002 width=8) (actual time=0.03..0.322 rows=1,136 loops=3)

  • Filter: e_18.enabled
  • Buffers: shared hit=60
45. 0.121 0.121 ↓ 1.7 1,781 1 / 5

Seq Scan on entities e_13 (cost=0..65.06 rows=1,065 width=8) (actual time=0.056..0.607 rows=1,781 loops=1)

  • Filter: e_13.enabled
  • Buffers: shared hit=48
46. 0.125 0.125 ↑ 1.2 1,132 2 / 5

Seq Scan on entities e_12 (cost=0..57.74 rows=1,334 width=8) (actual time=0.032..0.313 rows=1,132 loops=2)

  • Filter: e_12.enabled
  • Buffers: shared hit=44
47. 0.102 0.102 ↓ 1.7 1,729 1 / 5

Seq Scan on entities e_24 (cost=0..41.91 rows=1,018 width=8) (actual time=0.013..0.508 rows=1,729 loops=1)

  • Filter: e_24.enabled
  • Buffers: shared hit=31
48. 0.071 0.071 ↓ 1.7 1,296 1 / 5

Seq Scan on entities e_11 (cost=0..32.12 rows=761 width=8) (actual time=0.016..0.353 rows=1,296 loops=1)

  • Filter: e_11.enabled
  • Buffers: shared hit=24
49. 0.057 0.057 ↓ 1.7 1,672 1 / 5

Seq Scan on entities e_25 (cost=0..30.84 rows=984 width=8) (actual time=0.006..0.283 rows=1,672 loops=1)

  • Filter: e_25.enabled
  • Buffers: shared hit=21
50. 0.025 0.025 ↓ 1.6 545 1 / 5

Seq Scan on entities e_7 (cost=0..16.81 rows=337 width=8) (actual time=0.009..0.123 rows=545 loops=1)

  • Filter: e_7.enabled
  • Buffers: shared hit=13
51. 0.000 0.000 ↓ 0.0 0 1 / 5

Seq Scan on entities e_2 (cost=0..11.29 rows=65 width=8) (actual time=0.001..0.001 rows=0 loops=1)

  • Filter: e_2.enabled
52. 0.000 0.000 ↓ 0.0 0 1 / 5

Seq Scan on entities e_10 (cost=0..11.29 rows=65 width=8) (actual time=0.001..0.001 rows=0 loops=1)

  • Filter: e_10.enabled
53. 0.018 0.018 ↓ 1.7 440 1 / 5

Seq Scan on entities e_19 (cost=0..10.69 rows=258 width=8) (actual time=0.006..0.09 rows=440 loops=1)

  • Filter: e_19.enabled
  • Buffers: shared hit=8
54. 0.019 0.019 ↓ 1.7 417 1 / 5

Seq Scan on entities e_5 (cost=0..9.47 rows=245 width=8) (actual time=0.006..0.096 rows=417 loops=1)

  • Filter: e_5.enabled
  • Buffers: shared hit=7
55. 0.014 0.014 ↓ 1.7 299 1 / 5

Seq Scan on entities e_21 (cost=0..6.99 rows=176 width=8) (actual time=0.006..0.072 rows=299 loops=1)

  • Filter: e_21.enabled
  • Buffers: shared hit=5
56. 0.014 0.014 ↓ 1.7 385 1 / 5

Seq Scan on entities e_9 (cost=0..5.26 rows=226 width=8) (actual time=0.005..0.071 rows=385 loops=1)

  • Filter: e_9.enabled
  • Buffers: shared hit=3
57. 0.007 0.007 ↓ 1.7 133 1 / 5

Seq Scan on entities e_3 (cost=0..3.92 rows=78 width=8) (actual time=0.006..0.037 rows=133 loops=1)

  • Filter: e_3.enabled
  • Buffers: shared hit=3
58. 0.006 0.006 ↓ 1.7 122 1 / 5

Seq Scan on entities e_15 (cost=0..2.75 rows=72 width=8) (actual time=0.005..0.032 rows=122 loops=1)

  • Filter: e_15.enabled
  • Buffers: shared hit=2
59. 0.004 0.004 ↓ 1.7 80 1 / 5

Seq Scan on entities e_17 (cost=0..2.51 rows=47 width=8) (actual time=0.006..0.022 rows=80 loops=1)

  • Filter: e_17.enabled
  • Buffers: shared hit=2
60. 0.005 0.005 ↓ 1.7 76 1 / 5

Seq Scan on entities e_6 (cost=0..2.46 rows=45 width=8) (actual time=0.005..0.025 rows=76 loops=1)

  • Filter: e_6.enabled
  • Buffers: shared hit=2
61. 0.003 0.003 ↓ 1.7 71 1 / 5

Seq Scan on entities e_8 (cost=0..1.42 rows=42 width=8) (actual time=0.006..0.016 rows=71 loops=1)

  • Filter: e_8.enabled
  • Buffers: shared hit=1
62. 0.003 0.003 ↓ 1.7 53 1 / 5

Seq Scan on entities e_4 (cost=0..1.31 rows=31 width=8) (actual time=0.005..0.015 rows=53 loops=1)

  • Filter: e_4.enabled
  • Buffers: shared hit=1
63. 0.003 0.003 ↓ 1.7 53 1 / 5

Seq Scan on entities e_23 (cost=0..1.31 rows=31 width=8) (actual time=0.006..0.016 rows=53 loops=1)

  • Filter: e_23.enabled
  • Buffers: shared hit=1
64. 0.003 0.003 ↓ 1.7 53 1 / 5

Seq Scan on entities e_26 (cost=0..1.31 rows=31 width=8) (actual time=0.006..0.014 rows=53 loops=1)

  • Filter: e_26.enabled
  • Buffers: shared hit=1
65. 0.006 0.006 ↓ 1.7 12 1 / 5

Seq Scan on entities e (cost=0..1.07 rows=7 width=8) (actual time=0.028..0.032 rows=12 loops=1)

  • Filter: e.enabled
  • Buffers: shared hit=1
66. 82.851 4,454.682 ↑ 1.3 610 5 / 5

Hash (cost=342.48..342.48 rows=776 width=16) (actual time=4,454.682..4,454.682 rows=610 loops=5)

  • Buffers: shared hit=172
67. 0.151 4,371.831 ↑ 1.3 610 5 / 5

Hash Join (cost=196.94..342.48 rows=776 width=16) (actual time=4,371.278..4,371.831 rows=610 loops=5)

  • Buffers: shared hit=172
68. 0.231 0.854 ↑ 1.3 610 5 / 5

Hash Join (cost=186.29..329.75 rows=776 width=16) (actual time=0.424..0.854 rows=610 loops=5)

  • Buffers: shared hit=158
69. 0.061 0.280 ↓ 3.9 3,051 1 / 5

Append (cost=0..138.63 rows=774 width=8) (actual time=0.011..1.401 rows=3,051 loops=1)

  • Buffers: shared hit=94
70. 0.122 0.122 ↓ 1.7 1,756 1 / 5

Seq Scan on portals p_2_1 (cost=0..57.62 rows=1,032 width=8) (actual time=0.005..0.608 rows=1,756 loops=1)

  • Filter: p_2_1.enabled
  • Buffers: shared hit=46
71. 0.000 0.000 ↓ 0.0 0 1 / 5

Seq Scan on portals p_2_2 (cost=0..10.29 rows=15 width=8) (actual time=0.001..0.001 rows=0 loops=1)

  • Filter: p_2_2.enabled
72. 0.000 0.000 ↓ 0.0 0 1 / 5

Seq Scan on portals p_2_10 (cost=0..10.29 rows=15 width=8) (actual time=0.001..0.001 rows=0 loops=1)

  • Filter: p_2_10.enabled
73. 0.012 0.012 ↓ 1.7 190 1 / 5

Seq Scan on portals p_2_20 (cost=0..6.16 rows=113 width=8) (actual time=0.009..0.061 rows=190 loops=1)

  • Filter: p_2_20.enabled
  • Buffers: shared hit=5
74. 0.010 0.010 ↓ 1.6 149 1 / 5

Seq Scan on portals p_2_16 (cost=0..6.13 rows=96 width=8) (actual time=0.008..0.048 rows=149 loops=1)

  • Filter: p_2_16.enabled
  • Buffers: shared hit=5
75. 0.009 0.009 ↓ 1.7 152 1 / 5

Seq Scan on portals p_2_18 (cost=0..4.93 rows=88 width=8) (actual time=0.009..0.043 rows=152 loops=1)

  • Filter: p_2_18.enabled
  • Buffers: shared hit=4
76. 0.008 0.008 ↓ 1.7 135 1 / 5

Seq Scan on portals p_2_11 (cost=0..4.84 rows=80 width=8) (actual time=0.005..0.038 rows=135 loops=1)

  • Filter: p_2_11.enabled
  • Buffers: shared hit=4
77. 0.007 0.007 ↓ 1.7 138 1 / 5

Seq Scan on portals p_2_13 (cost=0..4.81 rows=80 width=8) (actual time=0.004..0.036 rows=138 loops=1)

  • Filter: p_2_13.enabled
  • Buffers: shared hit=4
78. 0.006 0.006 ↓ 1.7 99 1 / 5

Seq Scan on portals p_2_14 (cost=0..3.64 rows=57 width=8) (actual time=0.005..0.03 rows=99 loops=1)

  • Filter: p_2_14.enabled
  • Buffers: shared hit=3
79. 0.004 0.004 ↓ 1.6 38 1 / 5

Seq Scan on portals p_2_24 (cost=0..2.47 rows=24 width=8) (actual time=0.005..0.019 rows=38 loops=1)

  • Filter: p_2_24.enabled
  • Buffers: shared hit=2
80. 0.005 0.005 ↓ 1.7 76 1 / 5

Seq Scan on portals p_2_22 (cost=0..2.45 rows=44 width=8) (actual time=0.005..0.023 rows=76 loops=1)

  • Filter: p_2_22.enabled
  • Buffers: shared hit=2
81. 0.005 0.005 ↓ 1.7 44 1 / 5

Seq Scan on portals p_2_12 (cost=0..2.29 rows=26 width=8) (actual time=0.01..0.026 rows=44 loops=1)

  • Filter: p_2_12.enabled
  • Buffers: shared hit=2
82. 0.004 0.004 ↓ 1.7 41 1 / 5

Seq Scan on portals p_2_15 (cost=0..2.27 rows=24 width=8) (actual time=0.005..0.021 rows=41 loops=1)

  • Filter: p_2_15.enabled
  • Buffers: shared hit=2
83. 0.003 0.003 ↓ 2.9 35 1 / 5

Seq Scan on portals p_2_9 (cost=0..2.25 rows=12 width=8) (actual time=0.005..0.013 rows=35 loops=1)

  • Filter: p_2_9.enabled
  • Buffers: shared hit=2
84. 0.003 0.003 ↓ 1.7 37 1 / 5

Seq Scan on portals p_2_17 (cost=0..1.22 rows=22 width=8) (actual time=0.009..0.016 rows=37 loops=1)

  • Filter: p_2_17.enabled
  • Buffers: shared hit=1
85. 0.002 0.002 ↓ 1.7 34 1 / 5

Seq Scan on portals p_2_5 (cost=0..1.2 rows=20 width=8) (actual time=0.005..0.012 rows=34 loops=1)

  • Filter: p_2_5.enabled
  • Buffers: shared hit=1
86. 0.002 0.002 ↓ 1.7 32 1 / 5

Seq Scan on portals p_2_7 (cost=0..1.2 rows=19 width=8) (actual time=0.008..0.012 rows=32 loops=1)

  • Filter: p_2_7.enabled
  • Buffers: shared hit=1
87. 0.003 0.003 ↓ 1.8 24 1 / 5

Seq Scan on portals p_2_25 (cost=0..1.18 rows=13 width=8) (actual time=0.009..0.014 rows=24 loops=1)

  • Filter: p_2_25.enabled
  • Buffers: shared hit=1
88. 0.003 0.003 ↓ 1.5 24 1 / 5

Seq Scan on portals p_2_19 (cost=0..1.17 rows=16 width=8) (actual time=0.01..0.016 rows=24 loops=1)

  • Filter: p_2_19.enabled
  • Buffers: shared hit=1
89. 0.002 0.002 ↓ 1.7 20 1 / 5

Seq Scan on portals p_2_21 (cost=0..1.13 rows=12 width=8) (actual time=0.005..0.009 rows=20 loops=1)

  • Filter: p_2_21.enabled
  • Buffers: shared hit=1
90. 0.001 0.001 ↓ 1.5 12 1 / 5

Seq Scan on portals p_2_3 (cost=0..1.09 rows=8 width=8) (actual time=0.004..0.007 rows=12 loops=1)

  • Filter: p_2_3.enabled
  • Buffers: shared hit=1
91. 0.001 0.001 ↓ 1.7 5 1 / 5

Seq Scan on portals p_2_4 (cost=0..1.03 rows=3 width=8) (actual time=0.004..0.005 rows=5 loops=1)

  • Filter: p_2_4.enabled
  • Buffers: shared hit=1
92. 0.002 0.002 ↓ 1.7 5 1 / 5

Seq Scan on portals p_2_23 (cost=0..1.03 rows=3 width=8) (actual time=0.008..0.01 rows=5 loops=1)

  • Filter: p_2_23.enabled
  • Buffers: shared hit=1
93. 0.002 0.002 ↓ 0.0 0 1 / 5

Seq Scan on portals p_2_26 (cost=0..1.03 rows=1 width=8) (actual time=0.01..0.01 rows=0 loops=1)

  • Filter: p_2_26.enabled
  • Buffers: shared hit=1
94. 0.001 0.001 ↓ 1.5 3 1 / 5

Seq Scan on portals p_2_6 (cost=0..1.02 rows=2 width=8) (actual time=0.005..0.007 rows=3 loops=1)

  • Filter: p_2_6.enabled
  • Buffers: shared hit=1
95. 0.001 0.001 ↓ 2.0 2 1 / 5

Seq Scan on portals p_2_8 (cost=0..1.01 rows=1 width=8) (actual time=0.005..0.006 rows=2 loops=1)

  • Filter: p_2_8.enabled
  • Buffers: shared hit=1
96. 0.001 0.001 ↓ 0.0 0 1 / 5

Seq Scan on portals p_2 (cost=0..1.01 rows=1 width=8) (actual time=0.005..0.005 rows=0 loops=1)

  • Filter: p_2.enabled
  • Buffers: shared hit=1
97. 0.130 0.343 ↑ 3.5 636 5 / 5

Hash (cost=158.17..158.17 rows=2,249 width=12) (actual time=0.342..0.343 rows=636 loops=5)

  • Buffers: shared hit=64
98. 0.058 0.213 ↓ 1.4 3,178 1 / 5

Append (cost=0..158.17 rows=2,249 width=12) (actual time=0.025..1.067 rows=3,178 loops=1)

  • Buffers: shared hit=64
99. 0.071 0.071 ↓ 1.7 1,871 1 / 5

Seq Scan on writer_consumer_stats s_1 (cost=0..36.01 rows=1,101 width=12) (actual time=0.01..0.356 rows=1,871 loops=1)

  • Buffers: shared hit=25
100. 0.000 0.000 ↓ 0.0 0 1 / 5

Seq Scan on writer_consumer_stats s_2 (cost=0..21.41 rows=1,141 width=12) (actual time=0.001..0.001 rows=0 loops=1)

101. 0.000 0.000 ↓ 0.0 0 1 / 5

Seq Scan on writer_consumer_stats s_10 (cost=0..21.41 rows=1,141 width=12) (actual time=0..0 rows=0 loops=1)

102. 0.000 0.000 ↓ 0.0 0 1 / 5

Seq Scan on writer_consumer_stats s_26 (cost=0..21.41 rows=1,141 width=12) (actual time=0..0 rows=0 loops=1)

103. 0.007 0.007 ↓ 1.7 138 1 / 5

Seq Scan on writer_consumer_stats s_13 (cost=0..5.81 rows=81 width=12) (actual time=0.009..0.034 rows=138 loops=1)

  • Buffers: shared hit=5
104. 0.009 0.009 ↓ 1.7 194 1 / 5

Seq Scan on writer_consumer_stats s_20 (cost=0..5.14 rows=114 width=12) (actual time=0.014..0.047 rows=194 loops=1)

  • Buffers: shared hit=4
105. 0.007 0.007 ↓ 1.7 153 1 / 5

Seq Scan on writer_consumer_stats s_16 (cost=0..4.9 rows=90 width=12) (actual time=0.009..0.034 rows=153 loops=1)

  • Buffers: shared hit=4
106. 0.008 0.008 ↓ 1.7 153 1 / 5

Seq Scan on writer_consumer_stats s_18 (cost=0..4.9 rows=90 width=12) (actual time=0.005..0.041 rows=153 loops=1)

  • Buffers: shared hit=4
107. 0.007 0.007 ↓ 1.7 132 1 / 5

Seq Scan on writer_consumer_stats s_11 (cost=0..2.78 rows=78 width=12) (actual time=0.005..0.033 rows=132 loops=1)

  • Buffers: shared hit=2
108. 0.005 0.005 ↓ 1.7 107 1 / 5

Seq Scan on writer_consumer_stats s_14 (cost=0..2.63 rows=63 width=12) (actual time=0.01..0.024 rows=107 loops=1)

  • Buffers: shared hit=2
109. 0.006 0.006 ↓ 1.7 32 1 / 5

Seq Scan on writer_consumer_stats s_7 (cost=0..2.19 rows=19 width=12) (actual time=0.021..0.032 rows=32 loops=1)

  • Buffers: shared hit=2
110. 0.002 0.002 ↓ 1.7 24 1 / 5

Seq Scan on writer_consumer_stats s_25 (cost=0..2.14 rows=14 width=12) (actual time=0.006..0.012 rows=24 loops=1)

  • Buffers: shared hit=2
111. 0.004 0.004 ↓ 1.7 76 1 / 5

Seq Scan on writer_consumer_stats s_22 (cost=0..1.45 rows=45 width=12) (actual time=0.014..0.02 rows=76 loops=1)

  • Buffers: shared hit=1
112. 0.002 0.002 ↓ 1.7 64 1 / 5

Seq Scan on writer_consumer_stats s_24 (cost=0..1.38 rows=38 width=12) (actual time=0.006..0.012 rows=64 loops=1)

  • Buffers: shared hit=1
113. 0.002 0.002 ↓ 1.7 44 1 / 5

Seq Scan on writer_consumer_stats s_12 (cost=0..1.26 rows=26 width=12) (actual time=0.008..0.012 rows=44 loops=1)

  • Buffers: shared hit=1
114. 0.003 0.003 ↓ 1.7 42 1 / 5

Seq Scan on writer_consumer_stats s_15 (cost=0..1.25 rows=25 width=12) (actual time=0.011..0.015 rows=42 loops=1)

  • Buffers: shared hit=1
115. 0.002 0.002 ↓ 1.7 36 1 / 5

Seq Scan on writer_consumer_stats s_17 (cost=0..1.21 rows=21 width=12) (actual time=0.004..0.009 rows=36 loops=1)

  • Buffers: shared hit=1
116. 0.002 0.002 ↓ 1.7 29 1 / 5

Seq Scan on writer_consumer_stats s_5 (cost=0..1.17 rows=17 width=12) (actual time=0.006..0.009 rows=29 loops=1)

  • Buffers: shared hit=1
117. 0.002 0.002 ↓ 1.7 27 1 / 5

Seq Scan on writer_consumer_stats s_19 (cost=0..1.16 rows=16 width=12) (actual time=0.007..0.009 rows=27 loops=1)

  • Buffers: shared hit=1
118. 0.003 0.003 ↓ 1.7 22 1 / 5

Seq Scan on writer_consumer_stats s_21 (cost=0..1.13 rows=13 width=12) (actual time=0.011..0.013 rows=22 loops=1)

  • Buffers: shared hit=1
119. 0.001 0.001 ↓ 1.7 10 1 / 5

Seq Scan on writer_consumer_stats s_9 (cost=0..1.06 rows=6 width=12) (actual time=0.005..0.007 rows=10 loops=1)

  • Buffers: shared hit=1
120. 0.002 0.002 ↓ 1.8 9 1 / 5

Seq Scan on writer_consumer_stats s_3 (cost=0..1.05 rows=5 width=12) (actual time=0.009..0.01 rows=9 loops=1)

  • Buffers: shared hit=1
121. 0.001 0.001 ↓ 1.7 5 1 / 5

Seq Scan on writer_consumer_stats s_4 (cost=0..1.03 rows=3 width=12) (actual time=0.007..0.007 rows=5 loops=1)

  • Buffers: shared hit=1
122. 0.002 0.002 ↓ 1.7 5 1 / 5

Seq Scan on writer_consumer_stats s_23 (cost=0..1.03 rows=3 width=12) (actual time=0.007..0.008 rows=5 loops=1)

  • Buffers: shared hit=1
123. 0.001 0.001 ↓ 1.5 3 1 / 5

Seq Scan on writer_consumer_stats s_6 (cost=0..1.02 rows=2 width=12) (actual time=0.006..0.007 rows=3 loops=1)

  • Buffers: shared hit=1
124. 0.005 0.005 ↓ 2.0 2 1 / 5

Seq Scan on writer_consumer_stats s_8 (cost=0..1.01 rows=1 width=12) (actual time=0.022..0.023 rows=2 loops=1)

  • Buffers: shared hit=1
125. 0.000 0.000 ↓ 0.0 0 1 / 5

Seq Scan on writer_consumer_stats s (cost=0..0 rows=1 width=12) (actual time=0.002..0.002 rows=0 loops=1)

126. 4,370.687 4,370.826 ↑ 1.0 302 5 / 5

Hash (cost=6.88..6.88 rows=302 width=4) (actual time=4,370.826..4,370.826 rows=302 loops=5)

  • Buffers: shared hit=14
127. 0.139 0.139 ↑ 1.0 302 5 / 5

Index Only Scan using portal_types_pkey on portal_types t_1 (cost=0.15..6.88 rows=302 width=4) (actual time=0.052..0.139 rows=302 loops=5)

  • Buffers: shared hit=14
Planning time : 10.73 ms
Execution time : 6,108.945 ms