explain.depesz.com

PostgreSQL's explain analyze made readable

Result: Js9D

Settings
# exclusive inclusive rows x rows loops node
1. 0.000 45,175.976 ↑ 1.0 1 1

Finalize Aggregate (cost=4,066,067.81..4,066,067.82 rows=1 width=8) (actual time=45,175.975..45,175.976 rows=1 loops=1)

  • Output: count(*)
  • Buffers: shared hit=370,167 read=676,438, temp read=500,945 written=506,028
  • I/O Timings: read=3,303.644
2. 838.222 46,001.818 ↓ 1.5 3 1

Gather (cost=4,066,067.59..4,066,067.80 rows=2 width=8) (actual time=45,168.863..46,001.818 rows=3 loops=1)

  • Output: (PARTIAL count(*))
  • Workers Planned: 2
  • Workers Launched: 2
  • Buffers: shared hit=370,167 read=676,438, temp read=500,945 written=506,028
  • I/O Timings: read=3,303.644
3. 2,120.119 45,163.596 ↑ 1.0 1 3 / 3

Partial Aggregate (cost=4,065,067.59..4,065,067.60 rows=1 width=8) (actual time=45,163.595..45,163.596 rows=1 loops=3)

  • Output: PARTIAL count(*)
  • Buffers: shared hit=370,167 read=676,438, temp read=500,945 written=506,028
  • I/O Timings: read=3,303.644
  • Worker 0: actual time=45,161.266..45161.267 rows=1 loops=1
  • Buffers: shared hit=119,996 read=224,929, temp read=167,129 written=166,580
  • I/O Timings: read=1,095.080
  • Worker 1: actual time=45,160.987..45160.987 rows=1 loops=1
  • Buffers: shared hit=122,070 read=230,314, temp read=167,282 written=169,844
  • I/O Timings: read=1,112.599
4. 26,433.739 43,043.477 ↑ 1.3 28,411,014 3 / 3

Parallel Hash Join (cost=2,298,512.66..3,976,282.81 rows=35,513,913 width=0) (actual time=23,017.821..43,043.477 rows=28,411,014 loops=3)

  • Inner Unique: true
  • Hash Cond: (s.id_ref_parcel_fk = p.id)
  • Buffers: shared hit=370,167 read=676,438, temp read=500,945 written=506,028
  • I/O Timings: read=3,303.644
  • Worker 0: actual time=23,055.863..43091.195 rows=28,359,666 loops=1
  • Buffers: shared hit=119,996 read=224,929, temp read=167,129 written=166,580
  • I/O Timings: read=1,095.080
  • Worker 1: actual time=22,954.675..43074.402 rows=28,562,607 loops=1
  • Buffers: shared hit=122,070 read=230,314, temp read=167,282 written=169,844
  • I/O Timings: read=1,112.599
5. 5,858.515 5,858.515 ↑ 1.3 28,411,014 3 / 3

Parallel Seq Scan on public.parcel_surface_new s (cost=0.00..1,168,391.13 rows=35,513,913 width=4) (actual time=0.109..5,858.515 rows=28,411,014 loops=3)

  • Output: s.id_ref_parcel_fk
  • Buffers: shared hit=136,814 read=676,438
  • I/O Timings: read=3,303.644
  • Worker 0: actual time=0.150..5823.186 rows=28,135,118 loops=1
  • Buffers: shared hit=43,525 read=224,929
  • I/O Timings: read=1,095.080
  • Worker 1: actual time=0.158..5944.821 rows=28,744,261 loops=1
  • Buffers: shared hit=43,941 read=230,314
  • I/O Timings: read=1,112.599
6. 6,221.924 10,751.223 ↑ 1.2 28,411,014 3 / 3

Parallel Hash (cost=1,715,971.41..1,715,971.41 rows=35,507,220 width=4) (actual time=10,751.222..10,751.223 rows=28,411,014 loops=3)

  • Output: p.id
  • Buckets: 524,288 Batches: 512 Memory Usage: 10,688kB
  • Buffers: shared hit=233,259, temp written=252,508
  • Worker 0: actual time=10,750.248..10750.248 rows=27,925,068 loops=1
  • Buffers: shared hit=76,424, temp written=82,728
  • Worker 1: actual time=10,750.237..10750.237 rows=28,531,591 loops=1
  • Buffers: shared hit=78,082, temp written=84,168
7. 4,529.299 4,529.299 ↑ 1.2 28,411,014 3 / 3

Parallel Index Only Scan using parcel_new_pkey on public.parcel_new p (cost=0.57..1,715,971.41 rows=35,507,220 width=4) (actual time=0.191..4,529.299 rows=28,411,014 loops=3)

  • Output: p.id
  • Heap Fetches: 0
  • Buffers: shared hit=233,259
  • Worker 0: actual time=0.274..4550.366 rows=27,925,068 loops=1
  • Buffers: shared hit=76,424
  • Worker 1: actual time=0.254..4595.926 rows=28,531,591 loops=1
  • Buffers: shared hit=78,082
Planning time : 0.677 ms
Execution time : 46,002.228 ms