explain.depesz.com

PostgreSQL's explain analyze made readable

Result: sK4p

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

Limit (cost=0.00..431.00 rows=1 width=84) (actual rows= loops=)

  • Rows out: 100 rows with 6173 ms to end.
  • (slice0) Executor memory: 482K bytes.
  • (slice1) Executor memory: 1,539K bytes avg x 16 workers, 1539K bytes max (seg0). Work_mem: 1,209K bytes max.
  • Memory used: 1,048,576K bytes
2. 0.000 0.000 ↓ 0.0

Gather Motion 16:1 (slice1; segments: 16) (cost=0.00..431.00 rows=1 width=84) (actual rows= loops=)

  • Merge Key: process_date
  • Rows out: 100 rows at destination with 6173 ms to end.
3. 0.000 0.000 ↓ 0.0

Sequence (cost=0.00..431.00 rows=1 width=84) (actual rows= loops=)

  • Rows out: Avg 486.6 rows x 16 workers. Max 536 rows (seg2) with 5876 ms to first row, 5877 ms to end.
4. 0.000 0.000 ↓ 0.0

Partition Selector for stage_lon_mst (dynamic scan id: 1) (cost=10.00..100.00 rows=7 width=4) (actual rows= loops=)

  • Partitions selected: 3 (out of 3)
  • Rows out: 0 rows (seg0) with 66 ms to end.
5. 0.000 0.000 ↓ 0.0

Sort (cost=0.00..431.00 rows=1 width=84) (actual rows= loops=)

  • Sort Key: process_date
  • Sort Method: quicksort Max Memory: 1,209KB Avg Memory: 1,209KB (16 segments)
  • Rows out: Avg 486.6 rows x 16 workers. Max 536 rows (seg2) with 5876 ms to end.
  • Executor memory: 1,209K bytes avg, 1209K bytes max (seg0).
  • Work_mem used: 1,209K bytes avg, 1209K bytes max (seg0). Workfile: (0 spilling)
6. 0.000 0.000 ↓ 0.0

Dynamic Table Scan on stage_lon_mst (dynamic scan id: 1) (cost=0.00..431.00 rows=1 width=84) (actual rows= loops=)

  • Rows out: Avg 4199.8 rows x 16 workers. Max 4209 rows (seg14) with 1896 ms to first row, 5499 ms to end.
  • Partitions scanned: Avg 3.0 (out of 3) x 16 workers. Max 3 parts (seg0).
Total runtime : 7,829.368 ms