explain.depesz.com

PostgreSQL's explain analyze made readable

Result: lTtd

Settings
# exclusive inclusive rows x rows loops node
1. 14.584 8,013.449 ↓ 0.0 1 1

Custom Scan (Citus Adaptive) (cost=0.00..0.00 rows=0 width=0) (actual time=8,013.448..8,013.449 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,630.797 7,998.865 ↑ 1.0 1 1

Aggregate (cost=568,161.76..568,161.77 rows=1 width=8) (actual time=7,998.841..7,998.865 rows=1 loops=1)

3. 5,733.893 6,368.068 ↓ 6,103.4 36,980,210 1

Merge Left Join (cost=567,464.24..568,146.61 rows=6,059 width=0) (actual time=585.591..6,368.068 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)
4. 142.797 634.175 ↓ 1,632.5 1,038,270 1

Merge Left Join (cost=455,183.96..455,338.89 rows=636 width=8) (actual time=437.202..634.175 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)
5. 16.665 316.233 ↓ 239.0 49,240 1

Sort (cost=121,711.76..121,712.27 rows=206 width=8) (actual time=310.718..316.233 rows=49,240 loops=1)

  • Sort Key: sepeco_1.co_id
  • Sort Method: quicksort Memory: 3,845kB
6. 12.211 299.568 ↓ 239.0 49,240 1

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

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

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

8. 22.910 203.287 ↓ 239.0 49,240 1

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

9. 38.420 131.137 ↓ 239.0 49,240 1

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

10. 4.991 43.477 ↓ 239.0 49,240 1

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

11. 0.022 0.022 ↑ 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.022 rows=1 loops=1)

  • Index Cond: ((alias)::text = 'active'::text)
12. 9.330 38.464 ↓ 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=29.214..38.464 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. 29.134 29.134 ↓ 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=29.134..29.134 rows=49,240 loops=1)

  • Index Cond: ((ad_id = s.id) AND (pe_id = 391))
14. 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)
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. 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)
17. 0.005 0.015 ↑ 1.0 3 1

Hash (cost=1.03..1.03 rows=3 width=4) (actual time=0.014..0.015 rows=3 loops=1)

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

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

19. 175.145 175.145 ↓ 35.6 1,038,261 1

Sort (cost=333,472.20..333,545.18 rows=29,190 width=8) (actual time=126.477..175.145 rows=1,038,261 loops=1)

  • Sort Key: "*SELECT* 1".co_id
  • Sort Method: quicksort Memory: 7,939kB
  • -> Append (cost=119,887.15..33
Planning time : 12.519 ms
Execution time : 8,013.498 ms