explain.depesz.com

PostgreSQL's explain analyze made readable

Result: rFjj

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

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

2. 0.000 0.000 ↓ 0.0 100 1

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

3. 0.000 0.000 ↓ 0.0 100 1

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

4. 0.000 0.000 ↓ 0.0 100 1

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

5. 0.000 0.000 ↓ 0.0 37,748 1

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

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

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

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