explain.depesz.com

PostgreSQL's explain analyze made readable

Result: l5bI

Settings
# exclusive inclusive rows x rows loops node
1. 0.003 5,025.034 ↑ 1.0 2 1

Append (cost=408,779.03..791,732.28 rows=2 width=16) (actual time=3,143.046..5,025.034 rows=2 loops=1)

2. 0.000 3,143.045 ↑ 1.0 1 1

Finalize Aggregate (cost=408,779.03..408,779.04 rows=1 width=16) (actual time=3,143.045..3,143.045 rows=1 loops=1)

3. 76.712 3,174.276 ↓ 1.5 3 1

Gather (cost=408,778.81..408,779.02 rows=2 width=16) (actual time=3,095.580..3,174.276 rows=3 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
4. 33.894 3,097.564 ↑ 1.0 1 3 / 3

Partial Aggregate (cost=408,777.81..408,777.82 rows=1 width=16) (actual time=3,097.564..3,097.564 rows=1 loops=3)

5. 26.625 3,063.670 ↓ 101.5 649,559 3 / 3

Parallel Append (cost=14,588.31..408,745.81 rows=6,400 width=8) (actual time=591.223..3,063.670 rows=649,559 loops=3)

6. 23.394 2,906.428 ↓ 442,082.0 442,082 3 / 3

Subquery Scan on *SELECT* 2 (cost=372,576.44..391,209.12 rows=1 width=8) (actual time=1,367.399..2,906.428 rows=442,082 loops=3)

7. 0.000 2,883.034 ↓ 442,082.0 442,082 3 / 3

Nested Loop Anti Join (cost=372,576.44..391,209.11 rows=1 width=68) (actual time=1,367.398..2,883.034 rows=442,082 loops=3)

  • Join Filter: (av_1_1.pe_id = rtpe.id)
8. 116.054 1,474.712 ↓ 51.6 475,383 3 / 3

Parallel Hash Join (cost=372,576.44..382,309.31 rows=9,221 width=28) (actual time=1,367.365..1,474.712 rows=475,383 loops=3)

  • Hash Cond: ((act_1.co_id = av.co_id) AND (act_1.se_id = av.se_id))
9. 0.044 0.195 ↑ 1.3 1,011 3 / 3

Parallel Append (cost=0.00..45.62 rows=1,265 width=12) (actual time=0.008..0.195 rows=1,011 loops=3)

10. 0.151 0.151 ↑ 1.8 1,011 3 / 3

Parallel Seq Scan on rmv_active_sepeco_88 act_1 (cost=0.00..39.29 rows=1,784 width=12) (actual time=0.007..0.151 rows=1,011 loops=3)

  • Filter: (pe_id = 88)
11. 0.000 0.000 ↓ 0.0 0 1 / 3

Parallel Seq Scan on rmv_active_sepeco act (cost=0.00..0.00 rows=1 width=12) (actual time=0.001..0.001 rows=0 loops=1)

  • Filter: (pe_id = 88)
12. 61.904 1,358.463 ↑ 1.9 475,383 3 / 3

Parallel Hash (cost=359,123.08..359,123.08 rows=896,891 width=28) (actual time=1,358.462..1,358.463 rows=475,383 loops=3)

  • Buckets: 4194304 Batches: 1 Memory Usage: 122112kB
13. 300.507 1,296.559 ↑ 1.9 475,383 3 / 3

Hash Join (cost=2.33..359,123.08 rows=896,891 width=28) (actual time=982.339..1,296.559 rows=475,383 loops=3)

  • Hash Cond: (av.pe_id = rtpe.baseline_id)
14. 230.065 996.034 ↑ 1.3 6,738,658 3 / 3

Parallel Append (cost=0.00..327,030.55 rows=8,423,729 width=28) (actual time=0.021..996.034 rows=6,738,658 loops=3)

15. 0.008 0.008 ↓ 0.0 0 1 / 3

Seq Scan on rtsepezocoav av (cost=0.00..0.00 rows=1 width=28) (actual time=0.023..0.023 rows=0 loops=1)

  • Filter: ((se_id = ANY ('{1}'::integer[])) AND (ad_id = 26))
16. 239.806 239.806 ↓ 2.4 6,344,456 1 / 3

Parallel Seq Scan on rtsepezocoav_1_84_26 av_5 (cost=0.00..89,219.45 rows=2,643,523 width=28) (actual time=0.019..719.417 rows=6,344,456 loops=1)

  • Filter: ((se_id = ANY ('{1}'::integer[])) AND (ad_id = 26))
17. 202.713 202.713 ↓ 2.4 5,268,231 1 / 3

Parallel Seq Scan on rtsepezocoav_1_94_26 av_7 (cost=0.00..74,084.57 rows=2,195,096 width=28) (actual time=0.008..608.138 rows=5,268,231 loops=1)

  • Filter: ((se_id = ANY ('{1}'::integer[])) AND (ad_id = 26))
18. 173.346 173.346 ↑ 1.3 1,560,562 3 / 3

Parallel Seq Scan on rtsepezocoav_1_91_26 av_10 (cost=0.00..65,837.81 rows=1,950,750 width=28) (actual time=0.011..173.346 rows=1,560,562 loops=3)

  • Filter: ((se_id = ANY ('{1}'::integer[])) AND (ad_id = 26))
19. 56.729 56.729 ↓ 1.2 713,074 2 / 3

Parallel Seq Scan on rtsepezocoav_1_3_26 av_15 (cost=0.00..20,055.65 rows=594,229 width=28) (actual time=0.006..85.094 rows=713,074 loops=2)

  • Filter: ((se_id = ANY ('{1}'::integer[])) AND (ad_id = 26))
20. 38.325 38.325 ↓ 2.4 1,037,666 1 / 3

Parallel Seq Scan on rtsepezocoav_1_85_26 av_8 (cost=0.00..14,592.96 rows=432,361 width=28) (actual time=0.005..114.976 rows=1,037,666 loops=1)

  • Filter: ((se_id = ANY ('{1}'::integer[])) AND (ad_id = 26))
21. 23.361 23.361 ↓ 2.4 622,430 1 / 3

Parallel Seq Scan on rtsepezocoav_1_88_26 av_6 (cost=0.00..8,753.01 rows=259,346 width=28) (actual time=0.005..70.084 rows=622,430 loops=1)

  • Filter: ((se_id = ANY ('{1}'::integer[])) AND (ad_id = 26))
22. 22.523 22.523 ↓ 2.4 594,187 1 / 3

Parallel Seq Scan on rtsepezocoav_1_117_26 av_14 (cost=0.00..8,356.20 rows=247,578 width=28) (actual time=0.005..67.570 rows=594,187 loops=1)

  • Filter: ((se_id = ANY ('{1}'::integer[])) AND (ad_id = 26))
23. 4.375 4.375 ↓ 1.7 116,124 1 / 3

Parallel Seq Scan on rtsepezocoav_1_527_26 av_13 (cost=0.00..1,907.24 rows=68,308 width=28) (actual time=0.005..13.124 rows=116,124 loops=1)

  • Filter: ((se_id = ANY ('{1}'::integer[])) AND (ad_id = 26))
24. 4.419 4.419 ↓ 1.7 115,528 1 / 3

Parallel Seq Scan on rtsepezocoav_1_156_26 av_11 (cost=0.00..1,897.42 rows=67,958 width=28) (actual time=0.004..13.256 rows=115,528 loops=1)

  • Filter: ((se_id = ANY ('{1}'::integer[])) AND (ad_id = 26))
25. 0.280 0.280 ↓ 1.7 7,365 1 / 3

Parallel Seq Scan on rtsepezocoav_1_526_26 av_12 (cost=0.00..121.57 rows=4,332 width=28) (actual time=0.004..0.841 rows=7,365 loops=1)

  • Filter: ((se_id = ANY ('{1}'::integer[])) AND (ad_id = 26))
26. 0.041 0.041 ↓ 1.7 1,077 1 / 3

Parallel Seq Scan on rtsepezocoav_1_114_26 av_3 (cost=0.00..17.71 rows=634 width=28) (actual time=0.004..0.123 rows=1,077 loops=1)

  • Filter: ((se_id = ANY ('{1}'::integer[])) AND (ad_id = 26))
27. 0.042 0.042 ↓ 1.7 1,077 1 / 3

Parallel Seq Scan on rtsepezocoav_1_81_26 av_4 (cost=0.00..17.71 rows=634 width=28) (actual time=0.006..0.127 rows=1,077 loops=1)

  • Filter: ((se_id = ANY ('{1}'::integer[])) AND (ad_id = 26))
28. 0.000 0.000 ↓ 0.0 0 1 / 3

Parallel Seq Scan on rtsepezocoav_1_111_26 av_1 (cost=0.00..16.88 rows=1 width=28) (actual time=0.000..0.000 rows=0 loops=1)

  • Filter: ((se_id = ANY ('{1}'::integer[])) AND (ad_id = 26))
29. 0.000 0.000 ↓ 0.0 0 1 / 3

Parallel Seq Scan on rtsepezocoav_1_112_26 av_2 (cost=0.00..16.88 rows=1 width=28) (actual time=0.000..0.001 rows=0 loops=1)

  • Filter: ((se_id = ANY ('{1}'::integer[])) AND (ad_id = 26))
30. 0.000 0.000 ↓ 0.0 0 1 / 3

Parallel Seq Scan on rtsepezocoav_1_66_26 av_9 (cost=0.00..16.88 rows=500 width=28) (actual time=0.001..0.001 rows=0 loops=1)

  • Filter: ((se_id = ANY ('{1}'::integer[])) AND (ad_id = 26))
31. 0.005 0.018 ↑ 1.0 1 3 / 3

Hash (cost=2.31..2.31 rows=1 width=8) (actual time=0.018..0.018 rows=1 loops=3)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
32. 0.013 0.013 ↑ 1.0 1 3 / 3

Seq Scan on rtpe (cost=0.00..2.31 rows=1 width=8) (actual time=0.011..0.013 rows=1 loops=3)

  • Filter: (id = 88)
  • Rows Removed by Filter: 24
33. 508.684 1,426.149 ↓ 0.0 0 1,426,149 / 3

Append (cost=0.00..0.93 rows=3 width=20) (actual time=0.003..0.003 rows=0 loops=1,426,149)

34. 0.000 0.000 ↓ 0.0 0 1,426,149 / 3

Seq Scan on rtsepezocoav av_1_1 (cost=0.00..0.00 rows=1 width=20) (actual time=0.000..0.000 rows=0 loops=1,426,149)

  • Filter: ((pe_id = 88) AND (ad_id = 26) AND (ad_id = av.ad_id) AND (se_id = av.se_id) AND (zo_id = av.zo_id) AND (co_id = av.co_id))
35. 475.383 475.383 ↓ 0.0 0 1,426,149 / 3

Index Scan using rtsepezocoav_1_88_26_zo_co_uniq on rtsepezocoav_1_88_26 av_1_2 (cost=0.42..0.46 rows=1 width=20) (actual time=0.001..0.001 rows=0 loops=1,426,149)

  • Index Cond: ((zo_id = av.zo_id) AND (co_id = av.co_id))
  • Filter: ((pe_id = 88) AND (ad_id = 26) AND (ad_id = av.ad_id) AND (se_id = av.se_id))
36. 442.082 442.082 ↓ 0.0 0 1,326,246 / 3

Index Scan using rtsepezocoav_2_88_26_zo_co_uniq on rtsepezocoav_2_88_26 av_1_3 (cost=0.42..0.46 rows=1 width=20) (actual time=0.001..0.001 rows=0 loops=1,326,246)

  • Index Cond: ((zo_id = av.zo_id) AND (co_id = av.co_id))
  • Filter: ((pe_id = 88) AND (ad_id = 26) AND (ad_id = av.ad_id) AND (se_id = av.se_id))
  • Rows Removed by Filter: 0
37. 9.099 130.617 ↓ 48.6 311,215 2 / 3

Subquery Scan on *SELECT* 1 (cost=14,588.31..17,504.69 rows=6,399 width=8) (actual time=131.747..195.926 rows=311,215 loops=2)

38. 37.078 121.518 ↓ 116.7 311,215 2 / 3

Parallel Hash Join (cost=14,588.31..17,440.70 rows=2,666 width=68) (actual time=131.746..182.277 rows=311,215 loops=2)

  • Hash Cond: ((act_3.co_id = rtsepezocoav_1_88_26.co_id) AND (act_3.se_id = rtsepezocoav_1_88_26.se_id))
39. 0.038 0.163 ↓ 1.2 1,516 2 / 3

Parallel Append (cost=0.00..45.62 rows=1,265 width=12) (actual time=0.007..0.244 rows=1,516 loops=2)

40. 0.124 0.124 ↑ 1.2 1,516 2 / 3

Parallel Seq Scan on rmv_active_sepeco_88 act_3 (cost=0.00..39.29 rows=1,784 width=12) (actual time=0.006..0.186 rows=1,516 loops=2)

  • Filter: (pe_id = 88)
41. 0.000 0.000 ↓ 0.0 0 1 / 3

Parallel Seq Scan on rmv_active_sepeco act_2 (cost=0.00..0.00 rows=1 width=12) (actual time=0.000..0.001 rows=0 loops=1)

  • Filter: (pe_id = 88)
42. 48.775 84.277 ↓ 1.2 311,215 2 / 3

Parallel Hash (cost=10,698.10..10,698.10 rows=259,347 width=20) (actual time=126.416..126.416 rows=311,215 loops=2)

  • Buckets: 1048576 Batches: 1 Memory Usage: 42304kB
43. 7.733 35.503 ↓ 1.2 311,215 2 / 3

Parallel Append (cost=0.00..10,698.10 rows=259,347 width=20) (actual time=0.024..53.254 rows=311,215 loops=2)

44. 27.769 27.769 ↓ 1.2 311,215 2 / 3

Parallel Seq Scan on rtsepezocoav_1_88_26 (cost=0.00..9,401.37 rows=259,346 width=20) (actual time=0.020..41.653 rows=311,215 loops=2)

  • Filter: ((se_id = ANY ('{1}'::integer[])) AND (pe_id = 88) AND (ad_id = 26))
45. 0.001 0.001 ↓ 0.0 0 1 / 3

Parallel Seq Scan on rtsepezocoav (cost=0.00..0.00 rows=1 width=20) (actual time=0.002..0.003 rows=0 loops=1)

  • Filter: ((se_id = ANY ('{1}'::integer[])) AND (pe_id = 88) AND (ad_id = 26))
46. 0.000 1,881.986 ↑ 1.0 1 1

Finalize Aggregate (cost=382,953.20..382,953.21 rows=1 width=16) (actual time=1,881.985..1,881.986 rows=1 loops=1)

47. 47.483 1,895.034 ↓ 1.5 3 1

Gather (cost=382,952.98..382,953.19 rows=2 width=16) (actual time=1,835.604..1,895.034 rows=3 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
48. 23.450 1,847.551 ↑ 1.0 1 3 / 3

Partial Aggregate (cost=382,951.98..382,951.99 rows=1 width=16) (actual time=1,847.551..1,847.551 rows=1 loops=3)

49. 17.565 1,824.101 ↓ 21.5 475,383 3 / 3

Parallel Append (cost=0.00..382,841.40 rows=22,117 width=8) (actual time=1,369.409..1,824.101 rows=475,383 loops=3)

50. 21.800 1,806.535 ↓ 21.5 475,383 3 / 3

Subquery Scan on *SELECT* 2_1 (cost=372,576.44..382,722.47 rows=22,116 width=8) (actual time=1,369.408..1,806.535 rows=475,383 loops=3)

51. 313.037 1,784.735 ↓ 51.6 475,383 3 / 3

Nested Loop Anti Join (cost=372,576.44..382,501.31 rows=9,215 width=68) (actual time=1,369.407..1,784.735 rows=475,383 loops=3)

  • Join Filter: ((av_1_4.pe_id = rtpe_1.id) AND (av_1_4.ad_id = av_16.ad_id) AND (av_1_4.se_id = av_16.se_id) AND (av_1_4.zo_id = av_16.zo_id) AND (av_1_4.co_id = av_16.co_id))
52. 110.144 1,471.698 ↓ 51.6 475,383 3 / 3

Parallel Hash Join (cost=372,576.44..382,293.97 rows=9,215 width=28) (actual time=1,369.397..1,471.698 rows=475,383 loops=3)

  • Hash Cond: ((act_5.co_id = av_16.co_id) AND (act_5.se_id = av_16.se_id))
53. 0.040 0.178 ↑ 1.3 1,010 3 / 3

Parallel Append (cost=0.00..45.59 rows=1,263 width=12) (actual time=0.008..0.178 rows=1,010 loops=3)

54. 0.138 0.138 ↑ 1.8 1,010 3 / 3

Parallel Seq Scan on rmv_active_sepeco_83 act_5 (cost=0.00..39.28 rows=1,782 width=12) (actual time=0.007..0.138 rows=1,010 loops=3)

  • Filter: (pe_id = 83)
55. 0.000 0.000 ↓ 0.0 0 1 / 3

Parallel Seq Scan on rmv_active_sepeco act_4 (cost=0.00..0.00 rows=1 width=12) (actual time=0.001..0.001 rows=0 loops=1)

  • Filter: (pe_id = 83)
56. 68.891 1,361.376 ↑ 1.9 475,383 3 / 3

Parallel Hash (cost=359,123.08..359,123.08 rows=896,891 width=28) (actual time=1,361.376..1,361.376 rows=475,383 loops=3)

  • Buckets: 4194304 Batches: 1 Memory Usage: 122080kB
57. 295.025 1,292.485 ↑ 1.9 475,383 3 / 3

Hash Join (cost=2.33..359,123.08 rows=896,891 width=28) (actual time=1,058.372..1,292.485 rows=475,383 loops=3)

  • Hash Cond: (av_16.pe_id = rtpe_1.baseline_id)
58. 233.288 997.432 ↑ 1.3 6,738,658 3 / 3

Parallel Append (cost=0.00..327,030.55 rows=8,423,729 width=28) (actual time=0.030..997.432 rows=6,738,658 loops=3)

59. 0.005 0.005 ↓ 0.0 0 1 / 3

Seq Scan on rtsepezocoav av_16 (cost=0.00..0.00 rows=1 width=28) (actual time=0.014..0.014 rows=0 loops=1)

  • Filter: ((se_id = ANY ('{1}'::integer[])) AND (ad_id = 26))
60. 237.268 237.268 ↓ 2.4 6,344,456 1 / 3

Parallel Seq Scan on rtsepezocoav_1_84_26 av_21 (cost=0.00..89,219.45 rows=2,643,523 width=28) (actual time=0.019..711.804 rows=6,344,456 loops=1)

  • Filter: ((se_id = ANY ('{1}'::integer[])) AND (ad_id = 26))
61. 201.895 201.895 ↓ 2.4 5,268,231 1 / 3

Parallel Seq Scan on rtsepezocoav_1_94_26 av_23 (cost=0.00..74,084.57 rows=2,195,096 width=28) (actual time=0.032..605.684 rows=5,268,231 loops=1)

  • Filter: ((se_id = ANY ('{1}'::integer[])) AND (ad_id = 26))
62. 173.098 173.098 ↑ 1.3 1,560,562 3 / 3

Parallel Seq Scan on rtsepezocoav_1_91_26 av_26 (cost=0.00..65,837.81 rows=1,950,750 width=28) (actual time=0.009..173.098 rows=1,560,562 loops=3)

  • Filter: ((se_id = ANY ('{1}'::integer[])) AND (ad_id = 26))
63. 57.134 57.134 ↓ 2.4 1,426,149 1 / 3

Parallel Seq Scan on rtsepezocoav_1_3_26 av_31 (cost=0.00..20,055.65 rows=594,229 width=28) (actual time=0.005..171.401 rows=1,426,149 loops=1)

  • Filter: ((se_id = ANY ('{1}'::integer[])) AND (ad_id = 26))
64. 39.038 39.038 ↓ 2.4 1,037,666 1 / 3

Parallel Seq Scan on rtsepezocoav_1_85_26 av_24 (cost=0.00..14,592.96 rows=432,361 width=28) (actual time=0.005..117.114 rows=1,037,666 loops=1)

  • Filter: ((se_id = ANY ('{1}'::integer[])) AND (ad_id = 26))
65. 23.733 23.733 ↓ 2.4 622,430 1 / 3

Parallel Seq Scan on rtsepezocoav_1_88_26 av_22 (cost=0.00..8,753.01 rows=259,346 width=28) (actual time=0.005..71.200 rows=622,430 loops=1)

  • Filter: ((se_id = ANY ('{1}'::integer[])) AND (ad_id = 26))
66. 22.610 22.610 ↓ 2.4 594,187 1 / 3

Parallel Seq Scan on rtsepezocoav_1_117_26 av_30 (cost=0.00..8,356.20 rows=247,578 width=28) (actual time=0.004..67.830 rows=594,187 loops=1)

  • Filter: ((se_id = ANY ('{1}'::integer[])) AND (ad_id = 26))
67. 4.406 4.406 ↓ 1.7 116,124 1 / 3

Parallel Seq Scan on rtsepezocoav_1_527_26 av_29 (cost=0.00..1,907.24 rows=68,308 width=28) (actual time=0.005..13.219 rows=116,124 loops=1)

  • Filter: ((se_id = ANY ('{1}'::integer[])) AND (ad_id = 26))
68. 4.516 4.516 ↓ 1.7 115,528 1 / 3

Parallel Seq Scan on rtsepezocoav_1_156_26 av_27 (cost=0.00..1,897.42 rows=67,958 width=28) (actual time=0.004..13.549 rows=115,528 loops=1)

  • Filter: ((se_id = ANY ('{1}'::integer[])) AND (ad_id = 26))
69. 0.331 0.331 ↓ 1.7 7,365 1 / 3

Parallel Seq Scan on rtsepezocoav_1_526_26 av_28 (cost=0.00..121.57 rows=4,332 width=28) (actual time=0.005..0.993 rows=7,365 loops=1)

  • Filter: ((se_id = ANY ('{1}'::integer[])) AND (ad_id = 26))
70. 0.053 0.053 ↓ 1.7 1,077 1 / 3

Parallel Seq Scan on rtsepezocoav_1_114_26 av_19 (cost=0.00..17.71 rows=634 width=28) (actual time=0.005..0.160 rows=1,077 loops=1)

  • Filter: ((se_id = ANY ('{1}'::integer[])) AND (ad_id = 26))
71. 0.056 0.056 ↓ 1.7 1,077 1 / 3

Parallel Seq Scan on rtsepezocoav_1_81_26 av_20 (cost=0.00..17.71 rows=634 width=28) (actual time=0.013..0.167 rows=1,077 loops=1)

  • Filter: ((se_id = ANY ('{1}'::integer[])) AND (ad_id = 26))
72. 0.000 0.000 ↓ 0.0 0 1 / 3

Parallel Seq Scan on rtsepezocoav_1_111_26 av_17 (cost=0.00..16.88 rows=1 width=28) (actual time=0.001..0.001 rows=0 loops=1)

  • Filter: ((se_id = ANY ('{1}'::integer[])) AND (ad_id = 26))
73. 0.000 0.000 ↓ 0.0 0 1 / 3

Parallel Seq Scan on rtsepezocoav_1_112_26 av_18 (cost=0.00..16.88 rows=1 width=28) (actual time=0.000..0.000 rows=0 loops=1)

  • Filter: ((se_id = ANY ('{1}'::integer[])) AND (ad_id = 26))
74. 0.001 0.001 ↓ 0.0 0 1 / 3

Parallel Seq Scan on rtsepezocoav_1_66_26 av_25 (cost=0.00..16.88 rows=500 width=28) (actual time=0.002..0.002 rows=0 loops=1)

  • Filter: ((se_id = ANY ('{1}'::integer[])) AND (ad_id = 26))
75. 0.009 0.028 ↑ 1.0 1 3 / 3

Hash (cost=2.31..2.31 rows=1 width=8) (actual time=0.028..0.028 rows=1 loops=3)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
76. 0.019 0.019 ↑ 1.0 1 3 / 3

Seq Scan on rtpe rtpe_1 (cost=0.00..2.31 rows=1 width=8) (actual time=0.015..0.019 rows=1 loops=3)

  • Filter: (id = 83)
  • Rows Removed by Filter: 24
77. 0.000 0.000 ↓ 0.0 0 1,426,149 / 3

Seq Scan on rtsepezocoav av_1_4 (cost=0.00..0.00 rows=1 width=20) (actual time=0.000..0.000 rows=0 loops=1,426,149)

  • Filter: ((pe_id = 83) AND (ad_id = 26))
78. 0.000 0.001 ↓ 0.0 0 1 / 3

Subquery Scan on *SELECT* 1_1 (cost=0.00..8.34 rows=1 width=8) (actual time=0.002..0.002 rows=0 loops=1)

79. 0.000 0.000 ↓ 0.0 0 1 / 3

Nested Loop (cost=0.00..8.33 rows=1 width=68) (actual time=0.001..0.001 rows=0 loops=1)

80. 0.000 0.000 ↓ 0.0 0 1 / 3

Parallel Seq Scan on rtsepezocoav rtsepezocoav_1 (cost=0.00..0.00 rows=1 width=20) (actual time=0.001..0.001 rows=0 loops=1)

  • Filter: ((se_id = ANY ('{1}'::integer[])) AND (pe_id = 83) AND (ad_id = 26))
81. 0.000 0.000 ↓ 0.0 0 / 3

Append (cost=0.00..8.31 rows=2 width=12) (never executed)

82. 0.000 0.000 ↓ 0.0 0 / 3

Seq Scan on rmv_active_sepeco act_6 (cost=0.00..0.00 rows=1 width=12) (never executed)

  • Filter: ((pe_id = 83) AND (rtsepezocoav_1.co_id = co_id) AND (rtsepezocoav_1.se_id = se_id))
83. 0.000 0.000 ↓ 0.0 0 / 3

Index Only Scan using rmv_active_sepeco_83_se_id_pe_id_co_id_idx on rmv_active_sepeco_83 act_7 (cost=0.28..8.30 rows=1 width=12) (never executed)

  • Index Cond: ((se_id = rtsepezocoav_1.se_id) AND (pe_id = 83) AND (co_id = rtsepezocoav_1.co_id))
  • Heap Fetches: 0
Planning time : 18.278 ms
Execution time : 5,071.006 ms