explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 5TP3

Settings
# exclusive inclusive rows x rows loops node
1. 46,414.565 56,248.829 ↓ 26.1 5,937,301 1

Gather Motion 8:1 (slice1; segments: 8) (cost=0.00..1,355.86 rows=227,200 width=496) (actual time=313.933..56,248.829 rows=5,937,301 loops=1)

  • (slice0) Executor memory: 4298K bytes.
  • (slice1) Executor memory: 6003K bytes avg x 8 workers, 6003K bytes max (seg0). Work_mem: 1272K bytes max.
  • Memory used: 128000kB
  • Optimizer: Pivotal Optimizer (GPORCA) version 3.88.0
2. 8,841.725 9,834.264 ↓ 27.2 773,696 1

Result (cost=0.00..1,043.43 rows=28,400 width=496) (actual time=333.042..9,834.264 rows=773,696 loops=1)

3. 627.509 992.539 ↓ 27.2 773,696 1

Hash Left Join (cost=0.00..1,029.34 rows=28,400 width=1,224) (actual time=332.949..992.539 rows=773,696 loops=1)

  • Hash Cond: (cdp_main."BRANCH_ID" = cdp_dict."BRANCH_ID")
  • Extra Text: (seg1) Hash chain length 11.0 avg, 166 max, using 123 of 16384 buckets.
4. 362.686 362.686 ↓ 1.0 12,805 1

Seq Scan on cdp_main (cost=0.00..433.23 rows=12,500 width=311) (actual time=330.383..362.686 rows=12,805 loops=1)

5. 1.382 2.344 ↑ 1.0 1,356 1

Hash (cost=431.79..431.79 rows=1,356 width=923) (actual time=2.344..2.344 rows=1,356 loops=1)

6. 0.962 0.962 ↑ 1.0 1,356 1

Seq Scan on cdp_dict (cost=0.00..431.79 rows=1,356 width=923) (actual time=0.027..0.962 rows=1,356 loops=1)

Planning time : 83.199 ms
Execution time : 56,851.162 ms