explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 66FL

Settings
# exclusive inclusive rows x rows loops node
1. 18.067 56,971.064 ↓ 0.0 1 1

Custom Scan (Citus Adaptive) (cost=0.00..0.00 rows=0 width=0) (actual time=56,971.062..56,971.064 rows=1 loops=1)

  • Task Count: 1
  • Tuple data received from nodes: 9 bytes
  • Tasks Shown: All
  • -> Task
  • Tuple data received from node: 9 bytes
  • Node: host=178.63.56.13 port=5,444 dbname=projects
2. 16,552.538 56,952.997 ↑ 1.0 1 1

Aggregate (cost=569,869.24..569,869.25 rows=1 width=8) (actual time=56,952.965..56,952.997 rows=1 loops=1)

3. 33,796.269 40,400.459 ↓ 59,064.4 369,802,100 1

Hash Left Join (cost=569,044.11..569,853.59 rows=6,261 width=0) (actual time=570.582..40,400.459 rows=369,802,100 loops=1)

  • Hash Cond: ((sepeco_1.pe_id = x.pe_id) AND (co.br_id = x.br_id))
4. 5,971.380 6,604.190 ↓ 5,906.4 36,980,210 1

Merge Left Join (cost=568,753.10..569,453.01 rows=6,261 width=8) (actual time=569.964..6,604.190 rows=36,980,210 loops=1)

  • Merge Cond: (sepeco_1.co_id = "*SELECT* 1_1".co_id)
  • Join Filter: ("*SELECT* 1_1".pe_id = sepeco_1.pe_id)
5. 335.155 632.810 ↓ 1,632.5 1,038,270 1

Merge Left Join (cost=455,183.96..455,338.89 rows=636 width=12) (actual time=418.680..632.810 rows=1,038,270 loops=1)

  • Merge Cond: (sepeco_1.co_id = "*SELECT* 1".co_id)
  • Join Filter: ("*SELECT* 1".pe_id = sepeco_1.pe_id)
6. 17.490 297.655 ↓ 239.0 49,240 1

Sort (cost=121,711.76..121,712.27 rows=206 width=12) (actual time=290.891..297.655 rows=49,240 loops=1)

  • Sort Key: sepeco_1.co_id
  • Sort Method: quicksort Memory: 3,845kB
7. 10.776 280.165 ↓ 239.0 49,240 1

Hash Join (cost=29,854.21..121,703.84 rows=206 width=12) (actual time=25.667..280.165 rows=49,240 loops=1)

  • Hash Cond: (zo.re_id = re.id)
8. 28.493 269.365 ↓ 239.0 49,240 1

Nested Loop (cost=29,853.14..121,701.46 rows=206 width=16) (actual time=25.631..269.365 rows=49,240 loops=1)

9. 18.234 191.632 ↓ 239.0 49,240 1

Nested Loop (cost=29,852.85..121,637.71 rows=206 width=16) (actual time=25.620..191.632 rows=49,240 loops=1)

10. 35.594 124.158 ↓ 239.0 49,240 1

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

11. 4.583 39.324 ↓ 239.0 49,240 1

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

12. 0.035 0.035 ↑ 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.032..0.035 rows=1 loops=1)

  • Index Cond: ((alias)::text = 'active'::text)
13. 9.229 34.706 ↓ 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=25.547..34.706 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
14. 25.477 25.477 ↓ 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=25.477..25.477 rows=49,240 loops=1)

  • Index Cond: ((ad_id = s.id) AND (pe_id = 391))
15. 49.240 49.240 ↑ 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.001..0.001 rows=1 loops=49,240)

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

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

  • Index Cond: (lo_id = sepeco_1.co_id)
17. 49.240 49.240 ↑ 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.001..0.001 rows=1 loops=49,240)

  • Index Cond: (id = lo.zo_id)
18. 0.024 0.024 ↑ 1.0 3 1

Hash (cost=1.03..1.03 rows=3 width=4) (actual time=0.023..0.024 rows=3 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 9kB
19. 0.000 0.000 ↓ 0.0

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

Planning time : 14.194 ms
Execution time : 56,971.134 ms