explain.depesz.com

PostgreSQL's explain analyze made readable

Result: syD6 : Test

Settings
# exclusive inclusive rows x rows loops node
1. 0.000 0.000 ↓ 0.0

Limit (cost=0.00..0.42 rows=10 width=352) (actual rows= loops=)

  • Rows out: 10 rows with 2.866 ms to first row, 2.874 ms to end, start offset by 206 ms.
  • (slice0) Executor memory: 290K bytes.
  • (slice1) Executor memory: 260K bytes avg x 25 workers, 268K bytes max (seg17).
  • Memory used: 128000K bytes
2. 0.000 0.000 ↓ 0.0

Gather Motion 25:1 (slice1; segments: 25) (cost=0.00..0.42 rows=10 width=352) (actual rows= loops=)

  • Rows out: 10 rows at destination with 2.864 ms to first row, 2.865 ms to end, start offset by 206 ms.
3. 0.000 0.000 ↓ 0.0

Limit (cost=0.00..0.22 rows=1 width=352) (actual rows= loops=)

  • Rows out: Avg 10.0 rows x 25 workers. Max 10 rows (seg0) with 0.397 ms to first row, 0.398 ms to end, start offset by 209 ms.
4. 0.000 0.000 ↓ 0.0

Seq Scan on rsc_customer (cost=0.00..2,666.87 rows=4,776 width=352) (actual rows= loops=)

  • Rows out: Avg 10.0 rows x 25 workers. Max 10 rows (seg0) with 0.394 ms to end, start offset by 209 ms.