explain.depesz.com

PostgreSQL's explain analyze made readable

Result: gLb

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

Aggregate (cost=0.00..862.00 rows=1 width=16) (actual rows= loops=)

  • Rows out: 1 rows with 10 ms to end.
  • Executor memory: 8K bytes.
  • (slice0) Executor memory: 386K bytes.
  • (slice1) Executor memory: 175K bytes avg x 2 workers, 175K bytes max (seg0).
  • (slice2) Executor memory: 175K bytes avg x 2 workers, 175K bytes max (seg0).
  • (slice3) Executor memory: 4267K bytes avg x 2 workers, 4267K bytes max (seg0).
  • Memory used: 128000K bytes
2. 0.000 0.000 ↓ 0.0

Gather Motion 2:1 (slice3; segments: 2) (cost=0.00..862.00 rows=1 width=16) (actual rows= loops=)

  • Rows out: 2 rows at destination with 10 ms to end.
3. 0.000 0.000 ↓ 0.0

Aggregate (cost=0.00..862.00 rows=1 width=16) (actual rows= loops=)

  • Rows out: Avg 1.0 rows x 2 workers. Max 1 rows (seg0) with 8.475 ms to end.
  • Executor memory: 8K bytes avg, 8K bytes max (seg0).
4. 0.000 0.000 ↓ 0.0

Hash Join (cost=0.00..862.00 rows=1 width=24) (actual rows= loops=)

  • Hash Cond: incident.incident_id::text = incident_resolution.incident_id::text
  • Rows out: 0 rows (seg0) with 8.466 ms to end.
5. 0.000 0.000 ↓ 0.0

Redistribute Motion 2:2 (slice1; segments: 2) (cost=0.00..431.00 rows=1 width=53) (actual rows= loops=)

  • Hash Key: incident.incident_id
  • Rows out: (No row requested) 0 rows at destination (seg0) with 0 ms to end.
6. 0.000 0.000 ↓ 0.0

Table Scan on incident (cost=0.00..431.00 rows=1 width=53) (actual rows= loops=)

  • Filter: status::text = 'COMPLETED'::text AND type::text = 'RR_TEST_AUTOMATION.HTTP_RRTESTAUTOMATION_RRHTTPFieldNameWithSpecialChar1'::text
  • Rows out: 0 rows (seg0) with 0.284 ms to end.
7. 0.000 0.000 ↓ 0.0

Hash (cost=431.00..431.00 rows=1 width=45) (actual rows= loops=)

  • Rows in: 0 rows (seg0) with 2.093 ms to end, start offset by 39 ms.
8. 0.000 0.000 ↓ 0.0

Redistribute Motion 2:2 (slice2; segments: 2) (cost=0.00..431.00 rows=1 width=45) (actual rows= loops=)

  • Hash Key: incident_resolution.incident_id
  • Rows out: 0 rows at destination (seg0) with 2.092 ms to end.
9. 0.000 0.000 ↓ 0.0

Table Scan on incident_resolution (cost=0.00..431.00 rows=1 width=45) (actual rows= loops=)

  • Filter: time_started > 1565589600000::bigint AND time_started < 1565596800000::bigint AND time_completed < 1565596800000::bigint AND time_started <> 0 AND time_completed <> 0
  • Rows out: 0 rows (seg0) with 7.270 ms to end.