explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 3HN3

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

Finalize Aggregate (cost=9,197,037.88..9,197,037.89 rows=1 width=8) (actual time=33,262.561..33,262.561 rows=1 loops=1)

  • Output: count(*)
  • Buffers: shared hit=1,121 read=5,444,119
  • I/O Timings: read=8,505.185
2. 3.555 33,264.153 ↓ 1.5 3 1

Gather (cost=9,197,037.67..9,197,037.88 rows=2 width=8) (actual time=33,262.497..33,264.153 rows=3 loops=1)

  • Output: (PARTIAL count(*))
  • Workers Planned: 2
  • Workers Launched: 2
  • Buffers: shared hit=1,121 read=5,444,119
  • I/O Timings: read=8,505.185
3. 13,276.499 33,260.598 ↑ 1.0 1 3 / 3

Partial Aggregate (cost=9,196,037.67..9,196,037.68 rows=1 width=8) (actual time=33,260.597..33,260.598 rows=1 loops=3)

  • Output: PARTIAL count(*)
  • Buffers: shared hit=1,121 read=5,444,119
  • I/O Timings: read=8,505.185
  • Worker 0: actual time=33,259.563..33259.563 rows=1 loops=1
  • Buffers: shared hit=365 read=1,799,948
  • I/O Timings: read=2,798.484
  • Worker 1: actual time=33,259.915..33259.916 rows=1 loops=1
  • Buffers: shared hit=376 read=1,830,486
  • I/O Timings: read=2,889.051
4. 19,984.099 19,984.099 ↑ 1.3 240,003,148 3 / 3

Parallel Seq Scan on public."MongoDocumentDetails" (cost=0.00..8,445,878.13 rows=300,063,813 width=0) (actual time=0.029..19,984.099 rows=240,003,148 loops=3)

  • Output: "MongoDocumentId", "Category", "Anomaly", "CompanyId_DocCode_DocTypeID
  • Buffers: shared hit=1,121 read=5,444,119
  • I/O Timings: read=8,505.185
  • Worker 0: actual time=0.035..20175.549 rows=238,025,878 loops=1
  • Buffers: shared hit=365 read=1,799,948
  • I/O Timings: read=2,798.484
  • Worker 1: actual time=0.038..19817.858 rows=242,063,458 loops=1
  • Buffers: shared hit=376 read=1,830,486
  • I/O Timings: read=2,889.051