explain.depesz.com

PostgreSQL's explain analyze made readable

Result: i1Vw

Settings
# exclusive inclusive rows x rows loops node
1. 0.014 14,853.548 ↑ 57.5 54 1

Unique (cost=1,242,013.99..1,242,052.79 rows=3,104 width=24) (actual time=14,853.532..14,853.548 rows=54 loops=1)

  • Buffers: shared hit=108681 read=37193
2. 0.021 14,853.534 ↑ 57.5 54 1

Sort (cost=1,242,013.99..1,242,021.75 rows=3,104 width=24) (actual time=14,853.531..14,853.534 rows=54 loops=1)

  • Sort Key: p_2_1.id, p_2_1.portal_type_id, (min(g_22.id)), (min(s_1.last_synch))
  • Sort Method: quicksort Memory: 29kB
  • Buffers: shared hit=108681 read=37193
3. 0.000 14,853.513 ↑ 57.5 54 1

GroupAggregate (cost=1,240,192.14..1,241,833.96 rows=3,104 width=24) (actual time=14,853.471..14,853.513 rows=54 loops=1)

  • Group Key: p_2_1.id, p_2_1.portal_type_id
  • Buffers: shared hit=108681 read=37193
4. 475.782 15,123.864 ↑ 136.4 91 1

Gather Merge (cost=1,240,192.14..1,241,678.76 rows=12,416 width=24) (actual time=14,853.447..15,123.864 rows=91 loops=1)

  • Workers Planned: 4
  • Workers Launched: 4
  • Buffers: shared hit=483867 read=206560
5. 0.055 14,648.082 ↑ 172.4 18 5 / 5

Sort (cost=1,239,192.08..1,239,199.84 rows=3,104 width=24) (actual time=14,648.08..14,648.082 rows=18 loops=5)

  • Sort Key: p_2_1.id, p_2_1.portal_type_id
  • Sort Method: quicksort Memory: 25kB
  • Buffers: shared hit=483867 read=206560
6. 1.816 14,648.027 ↑ 172.4 18 5 / 5

HashAggregate (cost=1,238,981.01..1,239,012.05 rows=3,104 width=24) (actual time=14,647.994..14,648.027 rows=18 loops=5)

  • Group Key: p_2_1.id, p_2_1.portal_type_id
  • Buffers: shared hit=483835 read=206560
7. 16.581 14,646.211 ↑ 120.3 6,687 5 / 5

Hash Join (cost=2,745.37..1,230,937.84 rows=804,317 width=24) (actual time=11,237.834..14,646.211 rows=6,687 loops=5)

  • Buffers: shared hit=483835 read=206560
8. 4.031 3,659.949 ↑ 120.3 6,687 5 / 5

Append (cost=0..1,223,165.52 rows=804,315 width=12) (actual time=262.735..3,659.949 rows=6,687 loops=5)

  • Buffers: shared hit=482225 read=206560
9. 0.033 0.129 ↓ 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.646..0.646 rows=0 loops=1)

  • Filter: ((NOT g_22.frozen) AND (g_22.scheduled_time <= now()))
  • Buffers: shared hit=60
10. 0.096 0.096 ↑ 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.479..0.479 rows=328 loops=1)

  • Index Cond: (g_22.day >= ('now'::cstring)::date)
  • Buffers: shared hit=38
11. 0.015 0.027 ↓ 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.136..0.136 rows=0 loops=1)

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

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

  • Index Cond: (g_9.day >= ('now'::cstring)::date)
  • Buffers: shared hit=2
13. 40.867 40.867 ↑ 102.1 1,462 1 / 5

Index Scan using running_operations_entity_id_scheduled_time_day_idx on running_operations g_20 (cost=0.43..422,284.3 rows=149,198 width=12) (actual time=3.733..204.334 rows=1,462 loops=1)

  • Index Cond: ((g_20.scheduled_time <= now()) AND (g_20.day >= ('now'::cstring)::date))
  • Buffers: shared hit=5046
14. 3,300.051 3,300.051 ↑ 93.2 6,395 5 / 5

Seq Scan on running_operations g_1 (cost=0..695,263.2 rows=596,189 width=12) (actual time=14.357..3,300.051 rows=6,395 loops=5)

  • Filter: ((NOT g_1.frozen) AND (g_1.scheduled_time <= now()) AND (g_1.day >= ('now'::cstring)::date))
  • Buffers: shared hit=393697 read=206560
15. 194.884 194.884 ↓ 0.0 0 3 / 5

Seq Scan on running_operations g_14 (cost=0..59,337.6 rows=46,079 width=12) (actual time=324.806..324.806 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
16. 47.417 47.417 ↓ 0.0 0 1 / 5

Seq Scan on running_operations g_18 (cost=0..16,216.02 rows=8,596 width=12) (actual time=237.086..237.086 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
17. 40.277 40.277 ↓ 0.0 0 2 / 5

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

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

Seq Scan on running_operations g_12 (cost=0..4,339.4 rows=6 width=12) (actual time=99.703..99.703 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
19. 7.062 7.062 ↓ 0.0 0 1 / 5

Seq Scan on running_operations g_25 (cost=0..2,303.84 rows=278 width=12) (actual time=35.31..35.31 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
20. 0.970 0.970 ↓ 0.0 0 1 / 5

Seq Scan on running_operations g_19 (cost=0..1,208.14 rows=1 width=12) (actual time=4.851..4.851 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
21. 2.839 2.839 ↓ 0.0 0 1 / 5

Seq Scan on running_operations g_7 (cost=0..1,200.55 rows=234 width=12) (actual time=14.195..14.195 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
22. 0.845 0.845 ↓ 0.0 0 1 / 5

Seq Scan on running_operations g_11 (cost=0..998.9 rows=30 width=12) (actual time=4.227..4.227 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
23. 0.330 0.330 ↓ 0.0 0 1 / 5

Seq Scan on running_operations g_21 (cost=0..380.21 rows=1 width=12) (actual time=1.65..1.65 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
24. 0.146 0.146 ↓ 0.0 0 1 / 5

Seq Scan on running_operations g_8 (cost=0..147.91 rows=1 width=12) (actual time=0.729..0.729 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
25. 0.064 0.064 ↓ 0.0 0 1 / 5

Seq Scan on running_operations g_24 (cost=0..85.09 rows=1 width=12) (actual time=0.322..0.322 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
26. 0.059 0.059 ↓ 0.0 0 1 / 5

Seq Scan on running_operations g_3 (cost=0..59.16 rows=1 width=12) (actual time=0.295..0.295 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
27. 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.001..0.001 rows=0 loops=1)

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

Seq Scan on running_operations g_6 (cost=0..14.19 rows=8 width=12) (actual time=0.023..0.023 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
29. 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))
30. 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.001..0.001 rows=0 loops=1)

  • Filter: ((NOT g_17.frozen) AND (g_17.scheduled_time <= now()) AND (g_17.day >= ('now'::cstring)::date))
31. 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..0 rows=0 loops=1)

  • Filter: ((NOT g_2.frozen) AND (g_2.scheduled_time <= now()) AND (g_2.day >= ('now'::cstring)::date))
32. 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.001..0.001 rows=0 loops=1)

  • Filter: ((NOT g_4.frozen) AND (g_4.scheduled_time <= now()) AND (g_4.day >= ('now'::cstring)::date))
33. 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.001..0.001 rows=0 loops=1)

  • Filter: ((NOT g_10.frozen) AND (g_10.scheduled_time <= now()) AND (g_10.day >= ('now'::cstring)::date))
34. 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.001..0.001 rows=0 loops=1)

  • Filter: ((NOT g_23.frozen) AND (g_23.scheduled_time <= now()) AND (g_23.day >= ('now'::cstring)::date))
35. 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..0.001 rows=0 loops=1)

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

Seq Scan on running_operations g_5 (cost=0..2 rows=1 width=12) (actual time=0.008..0.008 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
37. 0.002 0.002 ↓ 0.0 0 1 / 5

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

  • Filter: ((NOT g.frozen) AND (g.scheduled_time <= now()) AND (g.day >= ('now'::cstring)::date))
  • Buffers: shared hit=1
38. 26.139 10,969.681 ↑ 1.4 13,854 5 / 5

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

  • Buffers: shared hit=1610
39. 7.515 10,943.542 ↑ 1.4 13,854 5 / 5

Hash Join (cost=352.18..2,507.56 rows=19,025 width=20) (actual time=10,928.271..10,943.542 rows=13,854 loops=5)

  • Buffers: shared hit=1610
40. 7.131 11.586 ↑ 1.3 15,056 5 / 5

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

  • Buffers: shared hit=1438
41. 2.649 2.649 ↑ 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.063..2.649 rows=9,042 loops=5)

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

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

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

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

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

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

  • Filter: e_16.enabled
  • Buffers: shared hit=62
45. 0.248 0.248 ↑ 1.2 1,682 2 / 5

Seq Scan on entities e_22 (cost=0..81.05 rows=1,978 width=8) (actual time=0.024..0.619 rows=1,682 loops=2)

  • Filter: e_22.enabled
  • Buffers: shared hit=61
46. 0.177 0.177 ↓ 1.7 3,407 1 / 5

Seq Scan on entities e_18 (cost=0..81.02 rows=2,002 width=8) (actual time=0.015..0.884 rows=3,407 loops=1)

  • Filter: e_18.enabled
  • Buffers: shared hit=60
47. 0.122 0.122 ↑ 1.2 890 2 / 5

Seq Scan on entities e_13 (cost=0..65.06 rows=1,065 width=8) (actual time=0.014..0.306 rows=890 loops=2)

  • Filter: e_13.enabled
  • Buffers: shared hit=48
48. 0.104 0.104 ↓ 1.7 2,263 1 / 5

Seq Scan on entities e_12 (cost=0..57.74 rows=1,334 width=8) (actual time=0.01..0.521 rows=2,263 loops=1)

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

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

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

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

  • Filter: e_11.enabled
  • Buffers: shared hit=24
51. 0.052 0.052 ↓ 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.258 rows=1,672 loops=1)

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

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

  • Filter: e_7.enabled
  • Buffers: shared hit=13
53. 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..0.001 rows=0 loops=1)

  • Filter: e_2.enabled
54. 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
55. 0.017 0.017 ↓ 1.7 440 1 / 5

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

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

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

  • Filter: e_5.enabled
  • Buffers: shared hit=7
57. 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
58. 0.013 0.013 ↓ 1.7 385 1 / 5

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

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

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

  • Filter: e_3.enabled
  • Buffers: shared hit=3
60. 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
61. 0.005 0.005 ↓ 1.7 80 1 / 5

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

  • Filter: e_17.enabled
  • Buffers: shared hit=2
62. 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.023 rows=76 loops=1)

  • Filter: e_6.enabled
  • Buffers: shared hit=2
63. 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
64. 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.006..0.015 rows=53 loops=1)

  • Filter: e_4.enabled
  • Buffers: shared hit=1
65. 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.017 rows=53 loops=1)

  • Filter: e_23.enabled
  • Buffers: shared hit=1
66. 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.008..0.015 rows=53 loops=1)

  • Filter: e_26.enabled
  • Buffers: shared hit=1
67. 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
68. 758.851 10,924.441 ↑ 1.3 610 5 / 5

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

  • Buffers: shared hit=172
69. 0.140 10,165.590 ↑ 1.3 610 5 / 5

Hash Join (cost=196.94..342.48 rows=776 width=16) (actual time=10,164.964..10,165.59 rows=610 loops=5)

  • Buffers: shared hit=172
70. 0.226 1.000 ↑ 1.3 610 5 / 5

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

  • Buffers: shared hit=158
71. 0.068 0.341 ↓ 3.9 3,051 1 / 5

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

  • Buffers: shared hit=94
72. 0.138 0.138 ↓ 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.028..0.689 rows=1,756 loops=1)

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

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

  • Filter: p_2_2.enabled
74. 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.002..0.002 rows=0 loops=1)

  • Filter: p_2_10.enabled
75. 0.019 0.019 ↓ 1.7 190 1 / 5

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

  • Filter: p_2_22.enabled
  • Buffers: shared hit=2
83. 0.004 0.004 ↓ 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.02 rows=44 loops=1)

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

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

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

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

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

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

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

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

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

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

  • Filter: p_2_7.enabled
  • Buffers: shared hit=1
89. 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.011..0.015 rows=24 loops=1)

  • Filter: p_2_25.enabled
  • Buffers: shared hit=1
90. 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.009..0.014 rows=24 loops=1)

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

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

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

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

  • Filter: p_2_3.enabled
  • Buffers: shared hit=1
93. 0.002 0.002 ↓ 1.7 5 1 / 5

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

  • Filter: p_2_4.enabled
  • Buffers: shared hit=1
94. 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.009..0.011 rows=5 loops=1)

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

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

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

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

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

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

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

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

  • Filter: p_2.enabled
  • Buffers: shared hit=1
99. 0.132 0.433 ↑ 3.5 636 5 / 5

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

  • Buffers: shared hit=64
100. 0.062 0.301 ↓ 1.4 3,178 1 / 5

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

  • Buffers: shared hit=64
101. 0.119 0.119 ↓ 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.058..0.596 rows=1,871 loops=1)

  • Buffers: shared hit=25
102. 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)

103. 0.001 0.001 ↓ 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.002..0.003 rows=0 loops=1)

104. 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.002..0.002 rows=0 loops=1)

105. 0.010 0.010 ↓ 1.7 138 1 / 5

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

  • Buffers: shared hit=5
106. 0.013 0.013 ↓ 1.7 194 1 / 5

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

  • Buffers: shared hit=4
107. 0.010 0.010 ↓ 1.7 153 1 / 5

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

  • Buffers: shared hit=4
108. 0.010 0.010 ↓ 1.7 153 1 / 5

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

  • Buffers: shared hit=4
109. 0.009 0.009 ↓ 1.7 132 1 / 5

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

  • Buffers: shared hit=2
110. 0.007 0.007 ↓ 1.7 107 1 / 5

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

  • Buffers: shared hit=2
111. 0.007 0.007 ↓ 1.7 32 1 / 5

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

  • Buffers: shared hit=2
112. 0.005 0.005 ↓ 1.7 24 1 / 5

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

  • Buffers: shared hit=2
113. 0.007 0.007 ↓ 1.7 76 1 / 5

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

  • Buffers: shared hit=1
114. 0.004 0.004 ↓ 1.7 64 1 / 5

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

  • Buffers: shared hit=1
115. 0.004 0.004 ↓ 1.7 44 1 / 5

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

  • Buffers: shared hit=1
116. 0.005 0.005 ↓ 1.7 42 1 / 5

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

  • Buffers: shared hit=1
117. 0.003 0.003 ↓ 1.7 36 1 / 5

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

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

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

  • Buffers: shared hit=1
119. 0.003 0.003 ↓ 1.7 27 1 / 5

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

  • Buffers: shared hit=1
120. 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.015..0.017 rows=22 loops=1)

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

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

  • Buffers: shared hit=1
122. 0.003 0.003 ↓ 1.8 9 1 / 5

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

  • Buffers: shared hit=1
123. 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.006..0.007 rows=5 loops=1)

  • Buffers: shared hit=1
124. 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.011..0.011 rows=5 loops=1)

  • Buffers: shared hit=1
125. 0.003 0.003 ↓ 1.5 3 1 / 5

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

  • Buffers: shared hit=1
126. 0.002 0.002 ↓ 2.0 2 1 / 5

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

  • Buffers: shared hit=1
127. 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..0 rows=0 loops=1)

128. 10,164.327 10,164.450 ↑ 1.0 302 5 / 5

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

  • Buffers: shared hit=14
129. 0.123 0.123 ↑ 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.054..0.123 rows=302 loops=5)

  • Buffers: shared hit=14
Planning time : 10.193 ms
Execution time : 15,225.678 ms