explain.depesz.com

PostgreSQL's explain analyze made readable

Result: Ryu9

Settings
# exclusive inclusive rows x rows loops node
1. 0.000 36,793.807 ↑ 1.0 1 1

Finalize Aggregate (cost=2,060,574.96..2,060,574.97 rows=1 width=8) (actual time=36,793.807..36,793.807 rows=1 loops=1)

  • Buffers: shared hit=3215719 read=239620 dirtied=228
  • I/O Timings: read=23353.442
2. 3.620 36,794.883 ↓ 1.5 3 1

Gather (cost=2,060,574.74..2,060,574.95 rows=2 width=8) (actual time=36,793.695..36,794.883 rows=3 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
  • Buffers: shared hit=3215719 read=239620 dirtied=228
  • I/O Timings: read=23353.442
3. 6,401.660 36,791.263 ↑ 1.0 1 3 / 3

Partial Aggregate (cost=2,059,574.74..2,059,574.75 rows=1 width=8) (actual time=36,791.262..36,791.263 rows=1 loops=3)

  • Buffers: shared hit=3215719 read=239620 dirtied=228
  • I/O Timings: read=23353.442
4. 30,389.603 30,389.603 ↑ 1.4 18,184,784 3 / 3

Parallel Index Only Scan using streaming_file_inserted_at_index on streaming_file (cost=0.56..1,994,039.61 rows=26,214,052 width=0) (actual time=0.015..30,389.603 rows=18,184,784 loops=3)

  • Heap Fetches: 149814
  • Buffers: shared hit=3215719 read=239620 dirtied=228
  • I/O Timings: read=23353.442
Planning time : 0.155 ms
Execution time : 36,794.942 ms