explain.depesz.com

PostgreSQL's explain analyze made readable

Result: eNGr

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

Gather Motion 4:1 (slice2; segments: 4) (cost=114.00..451.00 rows=10,000 width=16) (actual rows= loops=)

  • Rows out: 10,000 rows at destination with 6.146 ms to first row, 13 ms to end, start offset by 0.616 ms.
  • Hash Cond: t2.col2 = t1.col1
  • Rows out: Avg 2500.0 rows x 4 workers. Max 2501 rows (seg2) with 7.449 ms to first row, 8.642 ms to end, start offset by 1.391 ms.
  • Executor memory: 32K bytes avg, 32K bytes max (seg0).
  • Work_mem used: 32K bytes avg, 32K bytes max (seg0). Workfile: (0 spilling, 0 reused)
  • (seg2) Hash chain length 1.0 avg, 1 max, using 1000 of 524341 buckets.
  • Rows out: Avg 2500.0 rows x 4 workers. Max 2501 rows (seg2) with 0.023 ms to first row, 0.182 ms to end, start offset by 8.815 ms.
  • Rows in: Avg 1000.0 rows x 4 workers. Max 1000 rows (seg0) with 0.369 ms to end, start offset by 12 ms.
  • Slice statistics:
  • (slice0) Executor memory: 386K bytes.
  • (slice1) Executor memory: 207K bytes avg x 4 workers, 207K bytes max (seg0).
  • (slice2) Executor memory: 8,488K bytes avg x 4 workers, 8488K bytes max (seg0). Work_mem: 32K bytes max.
  • Statement statistics:
  • Memory used: 128,000K bytes
  • Settings: optimizer=off
  • Optimizer status: legacy query optimizer
2. 0.000 0.000 ↓ 0.0

Hash Join (cost=114.00..451.00 rows=2,500 width=16) (actual rows= loops=)

3. 0.000 0.000 ↓ 0.0

Seq Scan on table2 t2 (cost=0.00..112.00 rows=2,500 width=8) (actual rows= loops=)

4. 0.000 0.000 ↓ 0.0

Hash (cost=64.00..64.00 rows=1,000 width=8) (actual rows= loops=)

5. 0.000 0.000 ↓ 0.0

Broadcast Motion 4:4 (slice1; segments: 4) (cost=0.00..64.00 rows=1,000 width=8) (actual rows= loops=)

  • Rows out: Avg 1000.0 rows x 4 workers at destination. Max 1000 rows (seg0) with 0.042 ms to first row, 0.212 ms to end, start offset by 12 ms.
6. 0.000 0.000 ↓ 0.0

Seq Scan on table1 t1 (cost=0.00..14.00 rows=250 width=8) (actual rows= loops=)

  • Rows out: Avg 250.0 rows x 4 workers. Max 251 rows (seg2) with 0.727 ms to first row, 0.749 ms to end, start offset by 3.875 ms.
Total runtime : 14.718 ms