explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 8tLS : Optimization for: plan #fQ6U

Settings

Optimization path:

# exclusive inclusive rows x rows loops node
1. 112.715 2,593.116 ↓ 502.0 502 1

Hash Join (cost=719.62..763,466.32 rows=1 width=76) (actual time=114.635..2,593.116 rows=502 loops=1)

  • Hash Cond: ((temp_dat_09272019102625_72056.begbates)::text = (temp_opt_09272019102625_72056.docid_cp)::text)
2. 2,474.936 2,474.936 ↑ 1.0 1,000,000 1

Seq Scan on temp_dat_09272019102625_72056 (cost=0.00..758,991.59 rows=1,001,359 width=12) (actual time=0.031..2,474.936 rows=1,000,000 loops=1)

3. 0.093 5.465 ↓ 502.0 502 1

Hash (cost=719.61..719.61 rows=1 width=24) (actual time=5.465..5.465 rows=502 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 36kB
4. 0.516 5.372 ↓ 502.0 502 1

Hash Join (cost=565.76..719.61 rows=1 width=24) (actual time=4.843..5.372 rows=502 loops=1)

  • Hash Cond: ((temp_opt_09272019102625_72056.pagelabel)::text = (t_e20so1_pages.c_pagealias)::text)
5. 0.372 0.372 ↑ 1.0 2,534 1

Seq Scan on temp_opt_09272019102625_72056 (cost=0.00..144.34 rows=2,534 width=30) (actual time=0.009..0.372 rows=2,534 loops=1)

6. 0.095 4.484 ↓ 516.0 516 1

Hash (cost=565.74..565.74 rows=1 width=17) (actual time=4.484..4.484 rows=516 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 37kB
7. 0.926 4.389 ↓ 516.0 516 1

Hash Right Join (cost=240.93..565.74 rows=1 width=17) (actual time=4.222..4.389 rows=516 loops=1)

  • Hash Cond: (t_e20so1_pages_int.c_pagesid = t_e20so1_pages.c_pagesid)
  • Filter: (t_e20so1_pages_int.c_intid IS NULL)
  • Rows Removed by Filter: 4,014
8. 1.572 1.572 ↑ 1.0 4,993 1

Seq Scan on t_e20so1_pages_int (cost=0.00..311.70 rows=4,993 width=16) (actual time=0.007..1.572 rows=4,993 loops=1)

  • Filter: (c_fieldid = 'd318fdbd-8867-4fbb-9cd1-37a146b23366'::uuid)
  • Rows Removed by Filter: 4,183
9. 0.760 1.891 ↑ 1.0 4,530 1

Hash (cost=184.30..184.30 rows=4,530 width=17) (actual time=1.891..1.891 rows=4,530 loops=1)

  • Buckets: 8,192 Batches: 1 Memory Usage: 282kB
10. 1.131 1.131 ↑ 1.0 4,530 1

Seq Scan on t_e20so1_pages (cost=0.00..184.30 rows=4,530 width=17) (actual time=0.008..1.131 rows=4,530 loops=1)

Planning time : 0.469 ms
Execution time : 2,596.419 ms