explain.depesz.com

PostgreSQL's explain analyze made readable

Result: dwiv

Settings
# exclusive inclusive rows x rows loops node
1. 0.000 33,570.638 ↑ 1.0 1 1

Finalize Aggregate (cost=4,675,811.17..4,675,811.18 rows=1 width=8) (actual time=33,570.638..33,570.638 rows=1 loops=1)

  • Output: count(*)
  • Buffers: shared hit=699,074 read=232,902
  • I/O Timings: read=6,415.090
2. 280.174 33,846.651 ↓ 1.5 3 1

Gather (cost=4,675,810.95..4,675,811.16 rows=2 width=8) (actual time=33,570.440..33,846.651 rows=3 loops=1)

  • Output: (PARTIAL count(*))
  • Workers Planned: 2
  • Workers Launched: 2
  • Buffers: shared hit=699,074 read=232,902
  • I/O Timings: read=6,415.090
3. 2,166.688 33,566.477 ↑ 1.0 1 3 / 3

Partial Aggregate (cost=4,674,810.95..4,674,810.96 rows=1 width=8) (actual time=33,566.477..33,566.477 rows=1 loops=3)

  • Output: PARTIAL count(*)
  • Buffers: shared hit=699,074 read=232,902
  • I/O Timings: read=6,415.090
  • Worker 0: actual time=33,564.659..33564.659 rows=1 loops=1
  • Buffers: shared hit=233,025 read=77,526
  • I/O Timings: read=2,200.069
  • Worker 1: actual time=33,564.648..33564.649 rows=1 loops=1
  • Buffers: shared hit=233,024 read=76,387
  • I/O Timings: read=2,177.371
4. 13,941.739 31,399.789 ↑ 1.3 28,411,014 3 / 3

Merge Join (cost=225.36..4,586,026.17 rows=35,513,913 width=0) (actual time=2.350..31,399.789 rows=28,411,014 loops=3)

  • Inner Unique: true
  • Merge Cond: (s.id_ref_parcel_fk = p.id)
  • Buffers: shared hit=699,074 read=232,902
  • I/O Timings: read=6,415.090
  • Worker 0: actual time=2.945..31399.202 rows=28,371,954 loops=1
  • Buffers: shared hit=233,025 read=77,526
  • I/O Timings: read=2,200.069
  • Worker 1: actual time=2.803..31420.182 rows=27,955,080 loops=1
  • Buffers: shared hit=233,024 read=76,387
  • I/O Timings: read=2,177.371
5. 7,405.773 7,405.773 ↑ 1.3 28,411,014 3 / 3

Parallel Index Only Scan using parcel_surface_new_id_ref_parcel_fk on public.parcel_surface_new s (cost=0.57..1,716,118.66 rows=35,513,913 width=4) (actual time=0.636..7,405.773 rows=28,411,014 loops=3)

  • Output: s.id_ref_parcel_fk
  • Heap Fetches: 0
  • Buffers: shared hit=55 read=232,901
  • I/O Timings: read=6,414.272
  • Worker 0: actual time=0.378..7353.318 rows=28,371,954 loops=1
  • Buffers: shared hit=18 read=77,526
  • I/O Timings: read=2,200.069
  • Worker 1: actual time=0.265..7294.089 rows=27,955,080 loops=1
  • Buffers: shared hit=19 read=76,386
  • I/O Timings: read=2,176.553
6. 10,052.277 10,052.277 ↓ 1.0 85,232,880 3 / 3

Index Only Scan using parcel_new_pkey on public.parcel_new p (cost=0.57..2,213,072.49 rows=85,217,328 width=4) (actual time=0.669..10,052.277 rows=85,232,880 loops=3)

  • Output: p.id
  • Heap Fetches: 0
  • Buffers: shared hit=699,019 read=1
  • I/O Timings: read=0.818
  • Worker 0: actual time=0.923..10235.301 rows=85,232,982 loops=1
  • Buffers: shared hit=233,007
  • Worker 1: actual time=1.053..10301.752 rows=85,232,616 loops=1
  • Buffers: shared hit=233,005 read=1
  • I/O Timings: read=0.818
Planning time : 0.385 ms
Execution time : 33,846.835 ms