explain.depesz.com

PostgreSQL's explain analyze made readable

Result: DF00

Settings
# exclusive inclusive rows x rows loops node
1. 90.839 991.907 ↓ 0.0 4,924 1

Custom Scan (Citus Adaptive) (cost=0.00..0.00 rows=0 width=0) (actual time=991.191..991.907 rows=4,924 loops=1)

  • Task Count: 1
  • Tuple data received from nodes: 545 kB
  • Tasks Shown: All
  • -> Task
  • Tuple data received from node: 545 kB
  • Node: host=178.63.56.13 port=5,444 dbname=projects
2. 303.364 901.068 ↓ 21.5 4,924 1

GroupAggregate (cost=177,127.78..177,187.89 rows=229 width=400) (actual time=573.248..901.068 rows=4,924 loops=1)

  • Group Key: sepeco_1.se_id, sepeco_1.pe_id, sepeco_1.co_id, co.br_id, lo.zo_id, re.id
3. 152.304 597.704 ↓ 1,542.2 353,159 1

Sort (cost=177,127.78..177,128.35 rows=229 width=60) (actual time=573.138..597.704 rows=353,159 loops=1)

  • Sort Key: sepeco_1.co_id, co.br_id, lo.zo_id, re.id
  • Sort Method: quicksort Memory: 61,951kB
4. 77.706 445.400 ↓ 1,542.2 353,159 1

Hash Left Join (cost=137,719.08..177,118.81 rows=229 width=60) (actual time=218.909..445.400 rows=353,159 loops=1)

  • Hash Cond: ((sepeco_1.pe_id = x.pe_id) AND (sepeco_1.se_id = x.se_id) AND (co.br_id = x.br_id))
5. 287.020 367.694 ↓ 1,542.2 353,159 1

Hash Left Join (cost=137,604.37..176,999.24 rows=229 width=48) (actual time=218.822..367.694 rows=353,159 loops=1)

  • Hash Cond: ((sepeco_1.pe_id = "*SELECT* 1_1".pe_id) AND (sepeco_1.co_id = "*SELECT* 1_1".co_id))
6. 2.476 80.674 ↓ 413.0 9,912 1

Hash Join (cost=31,381.74..70,234.08 rows=24 width=36) (actual time=9.377..80.674 rows=9,912 loops=1)

  • Hash Cond: (zo.re_id = re.id)
7. 20.882 78.198 ↓ 413.0 9,912 1

Nested Loop (cost=31,380.68..70,232.86 rows=24 width=36) (actual time=9.353..78.198 rows=9,912 loops=1)

8. 17.096 57.316 ↓ 413.0 9,912 1

Nested Loop (cost=31,380.39..70,225.43 rows=24 width=32) (actual time=9.342..57.316 rows=9,912 loops=1)

9. 15.049 40.220 ↓ 413.0 9,912 1

Nested Loop (cost=31,379.97..70,187.16 rows=24 width=32) (actual time=9.330..40.220 rows=9,912 loops=1)

10. 10.586 25.171 ↓ 413.0 9,912 1

Hash Right Join (cost=31,379.68..70,178.11 rows=24 width=24) (actual time=9.316..25.171 rows=9,912 loops=1)

  • Hash Cond: (("*SELECT* 1".pe_id = sepeco_1.pe_id) AND ("*SELECT* 1".se_id = sepeco_1.se_id) AND ("*SELECT* 1".co_id = sepeco_1.co_id))
11. 0.915 14.585 ↓ 3.0 9,912 1

Append (cost=15,467.66..53,940.56 rows=3,338 width=24) (actual time=3.076..14.585 rows=9,912 loops=1)

  • -> Subquery Scan on "*SELECT* 2" (cost=1.69..17294.25 rows=1 width=24) (actual tim
12. 1.073 13.670 ↓ 3.0 9,912 1

Subquery Scan on *SELECT* 1 (cost=15,467.66..36,629.61 rows=3,337 width=24) (actual time=3.075..13.670 rows=9,912 loops=1)

13. 4.726 12.597 ↓ 3.0 9,912 1

Hash Join (cost=15,467.66..36,596.24 rows=3,337 width=64) (actual time=3.074..12.597 rows=9,912 loops=1)

  • Hash Cond: (rtsepecoav.co_id = act.co_id)
14. 4.845 4.845 ↓ 2.0 13,254 1

Index Scan using rtsepecoav_unique_115753 on rtsepecoav_115753 rtsepecoav (cost=0.56..21,111.54 rows=6,703 width=24) (actual time=0.028..4.845 rows=13,254 loops=1)

  • Index Cond: ((ad_id = ANY ('{{22,298,299,NULL}}'::integer[])) AND (se_id = 12) AND (pe_id = 391))
15. 1.236 3.026 ↓ 1.0 4,924 1

Hash (cost=15,408.45..15,408.45 rows=4,692 width=12) (actual time=3.025..3.026 rows=4,924 loops=1)

  • Buckets: 8,192 Batches: 1 Memory Usage: 276kB
16. 1.314 1.790 ↓ 1.0 4,924 1

Bitmap Heap Scan on rmv_active_sepeco_bkp_102098 act (cost=124.65..15,408.45 rows=4,692 width=12) (actual time=0.488..1.790 rows=4,924 loops=1)

  • Recheck Cond: ((se_id = 12) AND (pe_id = 391))
  • Heap Blocks: exact=28
17. 0.476 0.476 ↓ 1.0 4,924 1

Bitmap Index Scan on rmv_active_sepeco_se_id_pe_id_co_id_idx_102098 (cost=0.00..123.48 rows=4,692 width=0) (actual time=0.476..0.476 rows=4,924 loops=1)

  • Index Cond: ((se_id = 12) AND (pe_id = 391))
Planning time : 15.360 ms
Execution time : 992.351 ms