explain.depesz.com

PostgreSQL's explain analyze made readable

Result: HhOZ

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

Sort (cost=1,708.34..1,708.38 rows=16 width=196) (actual rows= loops=)

  • Sort Key: t0.id
2. 0.000 0.000 ↓ 0.0

Nested Loop (cost=4.49..1,708.02 rows=16 width=196) (actual rows= loops=)

3. 0.000 0.000 ↓ 0.0

Seq Scan on job_instance t0 (cost=0.00..1,628.55 rows=2 width=37) (actual rows= loops=)

  • Filter: ((parent_id)::text = 'xx'::text)
4. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on job_attribute t1 (cost=4.49..39.65 rows=9 width=159) (actual rows= loops=)

  • Recheck Cond: ((job_instance_id)::text = (t0.id)::text)
5. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on job_attribute_job_instance_id_index (cost=0.00..4.49 rows=9 width=0) (actual rows= loops=)

  • Index Cond: ((job_instance_id)::text = (t0.id)::text)