explain.depesz.com

PostgreSQL's explain analyze made readable

Result: ZXX4

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

Limit (cost=0..0 rows=0 width=0) (actual rows=200 loops=1)

2. 0.000 0.000 ↓ 0.0 200 1

Subquery Scan on a (cost=0..0 rows=0 width=0) (actual rows=200 loops=1)

3. 0.000 0.000 ↓ 0.0 200 1

LockRows (cost=0..0 rows=0 width=0) (actual rows=200 loops=1)

4. 0.000 0.000 ↓ 0.0 200 1

Nested Loop (cost=0..0 rows=0 width=0) (actual rows=200 loops=1)

5. 0.000 0.000 ↓ 0.0 105,809 1

Index Scan using ingestion_event_status_idx on ingestion_event e (cost=0..0 rows=0 width=0) (actual rows=105,809 loops=1)

  • Index Cond: (status = 'QUEUED'::text)
6. 0.000 0.000 ↓ 0.0 1 105,809

Index Scan using ingestion_dependency_object_key_idx on ingestion_dependency d (cost=0..0 rows=0 width=0) (actual rows=1 loops=105,809)

  • Index Cond: ((e.root_task_id = root_task_id) AND (e.object_key = object_key))