explain.depesz.com

PostgreSQL's explain analyze made readable

Result: t7Wd

Settings
# exclusive inclusive rows x rows loops node
1. 0.006 53,964.567 ↑ 1.0 1 1

Finalize Aggregate (cost=40,936.22..40,936.23 rows=1 width=8) (actual time=53,950.758..53,964.567 rows=1 loops=1)

  • Buffers: shared hit=86,959 read=15,997 dirtied=4,587
  • I/O Timings: read=114,988.094
2. 324.599 53,964.561 ↓ 1.5 3 1

Gather (cost=40,936.01..40,936.22 rows=2 width=8) (actual time=53,950.751..53,964.561 rows=3 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
  • Buffers: shared hit=86,959 read=15,997 dirtied=4,587
  • I/O Timings: read=114,988.094
3. 47.662 53,639.962 ↑ 1.0 1 3 / 3

Partial Aggregate (cost=39,936.01..39,936.02 rows=1 width=8) (actual time=53,639.961..53,639.962 rows=1 loops=3)

  • Buffers: shared hit=86,959 read=15,997 dirtied=4,587
  • I/O Timings: read=114,988.094
4. 53,592.300 53,592.300 ↑ 1.3 701,459 3 / 3

Parallel Index Only Scan using pg_attribute_relid_attnum_index on pg_attribute (cost=0.43..37,686.33 rows=899,871 width=0) (actual time=35.585..53,592.300 rows=701,459 loops=3)

  • Heap Fetches: 507,270
  • Buffers: shared hit=86,959 read=15,997 dirtied=4,587
  • I/O Timings: read=114,988.094
Planning time : 0.125 ms
Execution time : 53,964.598 ms