explain.depesz.com

PostgreSQL's explain analyze made readable

Result: TVBl

Settings
# exclusive inclusive rows x rows loops node
1. 16.387 12,899.456 ↓ 0.0 1 1

Custom Scan (Citus Adaptive) (cost=0.00..0.00 rows=0 width=0) (actual time=12,899.454..12,899.456 rows=1 loops=1)

  • Task Count: 1
  • Tuple data received from nodes: 8 bytes
  • Tasks Shown: All
  • -> Task
  • Tuple data received from node: 8 bytes
  • Node: host=178.63.56.13 port=5,444 dbname=projects
2. 1,588.335 12,883.069 ↑ 1.0 1 1

Aggregate (cost=459,122.32..459,122.33 rows=1 width=8) (actual time=12,883.054..12,883.069 rows=1 loops=1)

3. 5,613.836 11,294.734 ↓ 3,092.8 36,980,210 1

Merge Left Join (cost=458,777.55..459,092.43 rows=11,957 width=0) (actual time=5,644.200..11,294.734 rows=36,980,210 loops=1)

  • Merge Cond: (sepeco_1.co_id = "*SELECT* 1".co_id)
  • Join Filter: ("*SELECT* 1".pe_id = sepeco_1.pe_id)
4. 534.660 5,680.898 ↓ 452.5 1,752,580 1

Sort (cost=125,305.35..125,315.03 rows=3,873 width=8) (actual time=5,525.258..5,680.898 rows=1,752,580 loops=1)

  • Sort Key: sepeco_1.co_id
  • Sort Method: external merge Disk: 30,880kB
5. 149.955 5,146.238 ↓ 452.5 1,752,580 1

Nested Loop Left Join (cost=29,854.64..125,074.53 rows=3,873 width=8) (actual time=28.134..5,146.238 rows=1,752,580 loops=1)

6. 16.831 367.723 ↓ 239.0 49,240 1

Hash Join (cost=29,854.21..121,703.84 rows=206 width=8) (actual time=28.073..367.723 rows=49,240 loops=1)

  • Hash Cond: (zo.re_id = re.id)
7. 12.263 350.875 ↓ 239.0 49,240 1

Nested Loop (cost=29,853.14..121,701.46 rows=206 width=12) (actual time=28.047..350.875 rows=49,240 loops=1)

8. 32.765 240.132 ↓ 239.0 49,240 1

Nested Loop (cost=29,852.85..121,637.71 rows=206 width=12) (actual time=28.036..240.132 rows=49,240 loops=1)

9. 9.755 158.127 ↓ 239.0 49,240 1

Nested Loop (cost=29,852.57..121,573.65 rows=206 width=16) (actual time=28.022..158.127 rows=49,240 loops=1)

10. 7.068 49.892 ↓ 239.0 49,240 1

Nested Loop (cost=29,852.15..121,426.26 rows=206 width=8) (actual time=28.001..49.892 rows=49,240 loops=1)

11. 0.020 0.020 ↑ 1.0 1 1

Index Scan using rtad_alias_uindex_102088 on rtad_102088 s (cost=0.27..8.29 rows=1 width=4) (actual time=0.019..0.020 rows=1 loops=1)

  • Index Cond: ((alias)::text = 'active'::text)
12. 14.902 42.804 ↓ 13.4 49,240 1

Bitmap Heap Scan on rtsepecoav_115753 sepeco_1 (cost=29,851.87..121,381.15 rows=3,682 width=12) (actual time=27.976..42.804 rows=49,240 loops=1)

  • Recheck Cond: ((ad_id = s.id) AND (pe_id = 391))
  • Filter: (value_num = '1'::double precision)
  • Heap Blocks: exact=391
13. 27.902 27.902 ↓ 1.1 49,240 1

Bitmap Index Scan on rtsepecoav_unique_115753 (cost=0.00..29,850.95 rows=43,846 width=0) (actual time=27.901..27.902 rows=49,240 loops=1)

  • Index Cond: ((ad_id = s.id) AND (pe_id = 391))
14. 98.480 98.480 ↑ 1.0 1 49,240

Index Scan using rtlo_pkey_102096 on rtlo_102096 lo (cost=0.42..0.72 rows=1 width=8) (actual time=0.002..0.002 rows=1 loops=49,240)

  • Index Cond: (id = sepeco_1.co_id)
15. 49.240 49.240 ↑ 1.0 1 49,240

Index Only Scan using rtco_pkey_120185 on rtco_120185 co (cost=0.29..0.31 rows=1 width=4) (actual time=0.001..0.001 rows=1 loops=49,240)

  • Index Cond: (lo_id = sepeco_1.co_id)
  • Heap Fetches: 49,240
16. 98.480 98.480 ↑ 1.0 1 49,240

Index Scan using rtzo_pkey_102093 on rtzo_102093 zo (cost=0.29..0.31 rows=1 width=8) (actual time=0.002..0.002 rows=1 loops=49,240)

  • Index Cond: (id = lo.zo_id)
17. 0.006 0.017 ↑ 1.0 3 1

Hash (cost=1.03..1.03 rows=3 width=4) (actual time=0.016..0.017 rows=3 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 9kB
18. 0.011 0.011 ↑ 1.0 3 1

Seq Scan on rtre_102091 re (cost=0.00..1.03 rows=3 width=4) (actual time=0.009..0.011 rows=3 loops=1)

19. 4,628.560 4,628.560 ↓ 1.9 36 49,240

Index Scan using rtpecoav_co_id_idx_115754 on rtpecoav_115754 peco (cost=0.43..16.17 rows=19 width=8) (actual time=0.047..0.094 rows=36 loops=49,240)

  • Index Cond: (co_id = sepeco_1.co_id)
  • Filter: ((pe_id = 391) AND (pe_id = sepeco_1.pe_id) AND (ad_id = ANY ('{{17,18,19,20,21,23,24,25,26,27,28,29,30,31,32,33,34,35,39,40,41,42,43,44
Planning time : 14.247 ms
Execution time : 12,899.501 ms