explain.depesz.com

PostgreSQL's explain analyze made readable

Result: T7SS

Settings
# exclusive inclusive rows x rows loops node
1. 0.001 0.020 ↓ 0.0 0 1

Nested Loop Anti Join (cost=0.00..2.02 rows=1 width=1,576) (actual time=0.020..0.020 rows=0 loops=1)

  • Join Filter: ((t2.progress_state_uuid <> t1.progress_state_uuid) AND (t2.guid > t1.guid))
2. 0.019 0.019 ↓ 0.0 0 1

Seq Scan on task_history t1 (cost=0.00..1.00 rows=1 width=1,576) (actual time=0.019..0.019 rows=0 loops=1)

  • Filter: ((task_ref)::text = '3ca05ddc-d295-4fee-8811-f5e7e67357e7'::text)
  • Rows Removed by Filter: 26
3. 0.000 0.000 ↓ 0.0 0

Materialize (cost=0.00..1.00 rows=1 width=20) (never executed)

4. 0.000 0.000 ↓ 0.0 0

Seq Scan on task_history t2 (cost=0.00..1.00 rows=1 width=20) (never executed)

  • Filter: ((task_ref)::text = '3ca05ddc-d295-4fee-8811-f5e7e67357e7'::text)