explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 3KX9

Settings
# exclusive inclusive rows x rows loops node
1. 0.012 16,082.547 ↑ 172.4 18 1

Unique (cost=1,242,275.33..1,242,314.13 rows=3,104 width=24) (actual time=16,082.535..16,082.547 rows=18 loops=1)

  • Buffers: shared hit=139020 read=45653
2. 0.018 16,082.535 ↑ 172.4 18 1

Sort (cost=1,242,275.33..1,242,283.09 rows=3,104 width=24) (actual time=16,082.534..16,082.535 rows=18 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: 26kB
  • Buffers: shared hit=139020 read=45653
3. 0.000 16,082.517 ↑ 172.4 18 1

GroupAggregate (cost=1,240,453.48..1,242,095.3 rows=3,104 width=24) (actual time=16,081.807..16,082.517 rows=18 loops=1)

  • Group Key: p_2_1.id, p_2_1.portal_type_id
  • Buffers: shared hit=139020 read=45653
4. 568.628 16,396.653 ↑ 376.2 33 1

Gather Merge (cost=1,240,453.48..1,241,940.1 rows=12,416 width=24) (actual time=16,081.785..16,396.653 rows=33 loops=1)

  • Workers Planned: 4
  • Workers Launched: 4
  • Buffers: shared hit=498456 read=191842
5. 0.044 15,828.025 ↑ 443.4 7 5 / 5

Sort (cost=1,239,453.42..1,239,461.18 rows=3,104 width=24) (actual time=15,828.023..15,828.025 rows=7 loops=5)

  • Sort Key: p_2_1.id, p_2_1.portal_type_id
  • Sort Method: quicksort Memory: 25kB
  • Buffers: shared hit=498456 read=191842
6. 1.841 15,827.981 ↑ 443.4 7 5 / 5

HashAggregate (cost=1,239,242.35..1,239,273.39 rows=3,104 width=24) (actual time=15,827.935..15,827.981 rows=7 loops=5)

  • Group Key: p_2_1.id, p_2_1.portal_type_id
  • Buffers: shared hit=498424 read=191842
7. 8.396 15,826.140 ↑ 113.2 7,100 5 / 5

Hash Join (cost=2,745.38..1,231,204.19 rows=803,816 width=24) (actual time=11,987.72..15,826.14 rows=7,100 loops=5)

  • Buffers: shared hit=498424 read=191842
8. 0.975 4,165.145 ↑ 113.2 7,100 5 / 5

Append (cost=0..1,223,435 rows=803,814 width=12) (actual time=334.729..4,165.145 rows=7,100 loops=5)

  • Buffers: shared hit=496814 read=191842
9. 0.286 0.380 ↓ 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=1.898..1.898 rows=0 loops=1)

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

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

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

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

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

Index Scan using running_operations_entity_id_scheduled_time_day_idx on running_operations g_20 (cost=0.43..422,403.25 rows=149,240 width=12) (actual time=33.032..198.903 rows=1,268 loops=1)

  • Index Cond: ((g_20.scheduled_time <= now()) AND (g_20.day >= ('now'::cstring)::date))
  • Buffers: shared hit=4877
14. 3,798.735 3,798.735 ↑ 87.0 6,847 5 / 5

Seq Scan on running_operations g_1 (cost=0..695,416.24 rows=595,646 width=12) (actual time=16.895..3,798.735 rows=6,847 loops=5)

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

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

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

  • Filter: ((NOT g_18.frozen) AND (g_18.scheduled_time <= now()) AND (g_18.day >= ('now'::cstring)::date))
  • Buffers: shared hit=13069
17. 30.024 30.024 ↓ 0.0 0 2 / 5

Seq Scan on running_operations g_16 (cost=0..13,265.29 rows=7,492 width=12) (actual time=75.06..75.06 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. 11.349 11.349 ↓ 0.0 0 1 / 5

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

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

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

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

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

Seq Scan on running_operations g_21 (cost=0..380.21 rows=1 width=12) (actual time=1.69..1.69 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.73..0.73 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.231 0.231 ↓ 0.0 0 1 / 5

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

Seq Scan on running_operations g_3 (cost=0..59.16 rows=1 width=12) (actual time=0.286..0.286 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..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.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))
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..0 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.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))
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.652 11,652.599 ↑ 1.4 13,855 5 / 5

Hash (cost=2,507.57..2,507.57 rows=19,025 width=20) (actual time=11,652.599..11,652.599 rows=13,855 loops=5)

  • Buffers: shared hit=1610
39. 14.180 11,625.947 ↑ 1.4 13,855 5 / 5

Hash Join (cost=352.18..2,507.57 rows=19,025 width=20) (actual time=11,605.609..11,625.947 rows=13,855 loops=5)

  • Buffers: shared hit=1610
40. 3.825 10.930 ↑ 1.3 15,057 5 / 5

Append (cost=0..2,036.48 rows=19,026 width=8) (actual time=0.073..10.93 rows=15,057 loops=5)

  • Buffers: shared hit=1438
41. 5.515 5.515 ↑ 3.0 9,044 5 / 5

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

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

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

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

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

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

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

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

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

  • Filter: e_22.enabled
  • Buffers: shared hit=61
46. 0.172 0.172 ↑ 1.2 1,704 2 / 5

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

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

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

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

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

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

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

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

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

  • Filter: e_11.enabled
  • Buffers: shared hit=24
51. 0.053 0.053 ↓ 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.265 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.005..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.006..0.092 rows=417 loops=1)

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

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

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

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

  • Filter: e_9.enabled
  • Buffers: shared hit=3
59. 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.005..0.037 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.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.005..0.022 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.006..0.025 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.017 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.004 0.004 ↓ 1.7 53 1 / 5

Seq Scan on entities e_23 (cost=0..1.31 rows=31 width=8) (actual time=0.007..0.018 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.007..0.015 rows=53 loops=1)

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

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

  • Filter: e.enabled
  • Buffers: shared hit=1
68. 674.852 11,600.837 ↑ 1.3 610 5 / 5

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

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

Hash Join (cost=196.95..342.48 rows=776 width=16) (actual time=10,919.844..10,925.985 rows=610 loops=5)

  • Buffers: shared hit=172
70. 0.223 6.399 ↑ 1.3 610 5 / 5

Hash Join (cost=186.29..329.76 rows=776 width=16) (actual time=0.377..6.399 rows=610 loops=5)

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

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

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

  • Filter: p_2_1.enabled
  • Buffers: shared hit=46
73. 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..0.001 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..0 rows=0 loops=1)

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

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

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

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

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

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

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

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

  • Filter: p_2_11.enabled
  • Buffers: shared hit=4
79. 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
80. 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
81. 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.018 rows=38 loops=1)

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

Seq Scan on portals p_2_22 (cost=0..2.45 rows=44 width=8) (actual time=0.004..0.021 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.005..0.018 rows=44 loops=1)

  • Filter: p_2_12.enabled
  • Buffers: shared hit=2
84. 0.003 0.003 ↓ 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.016 rows=41 loops=1)

  • Filter: p_2_15.enabled
  • Buffers: shared hit=2
85. 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.014 rows=35 loops=1)

  • Filter: p_2_9.enabled
  • Buffers: shared hit=2
86. 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.005..0.013 rows=37 loops=1)

  • Filter: p_2_17.enabled
  • Buffers: shared hit=1
87. 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.011 rows=34 loops=1)

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

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

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

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

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

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

  • Filter: p_2_19.enabled
  • Buffers: shared hit=1
91. 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
92. 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
93. 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
94. 0.001 0.001 ↓ 1.7 5 1 / 5

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

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

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

  • Filter: p_2_26.enabled
  • Buffers: shared hit=1
96. 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.004..0.005 rows=3 loops=1)

  • Filter: p_2_6.enabled
  • Buffers: shared hit=1
97. 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
98. 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
99. 0.127 0.325 ↑ 3.5 636 5 / 5

Hash (cost=158.18..158.18 rows=2,249 width=12) (actual time=0.324..0.325 rows=636 loops=5)

  • Buffers: shared hit=64
100. 0.057 0.198 ↓ 1.4 3,179 1 / 5

Append (cost=0..158.18 rows=2,249 width=12) (actual time=0.021..0.989 rows=3,179 loops=1)

  • Buffers: shared hit=64
101. 0.069 0.069 ↓ 1.7 1,872 1 / 5

Seq Scan on writer_consumer_stats s_1 (cost=0..36.01 rows=1,101 width=12) (actual time=0.009..0.347 rows=1,872 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..0 rows=0 loops=1)

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

105. 0.006 0.006 ↓ 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.031 rows=138 loops=1)

  • Buffers: shared hit=5
106. 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.009..0.043 rows=194 loops=1)

  • Buffers: shared hit=4
107. 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
108. 0.007 0.007 ↓ 1.7 153 1 / 5

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

  • Buffers: shared hit=4
109. 0.005 0.005 ↓ 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.024 rows=132 loops=1)

  • Buffers: shared hit=2
110. 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.009..0.024 rows=107 loops=1)

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

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

  • Buffers: shared hit=2
112. 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.005..0.011 rows=24 loops=1)

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

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

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

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

  • Buffers: shared hit=1
115. 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
116. 0.002 0.002 ↓ 1.7 42 1 / 5

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

  • Buffers: shared hit=1
117. 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
118. 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.007..0.01 rows=29 loops=1)

  • Buffers: shared hit=1
119. 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.006..0.009 rows=27 loops=1)

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

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

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

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

Seq Scan on writer_consumer_stats s_3 (cost=0..1.05 rows=5 width=12) (actual time=0.006..0.007 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.003..0.004 rows=5 loops=1)

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

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

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

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

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

Seq Scan on writer_consumer_stats s_8 (cost=0..1.01 rows=1 width=12) (actual time=0.018..0.019 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.002..0.002 rows=0 loops=1)

128. 10,919.340 10,919.446 ↑ 1.0 302 5 / 5

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

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

  • Buffers: shared hit=14
Planning time : 10.53 ms
Execution time : 16,559.417 ms