explain.depesz.com

PostgreSQL's explain analyze made readable

Result: fxxk

Settings
# exclusive inclusive rows x rows loops node
1. 0.018 0.031 ↓ 0.0 0 1

Sort (cost=92.01..92.05 rows=16 width=196) (actual time=0.031..0.031 rows=0 loops=1)

  • Sort Key: t0.id
  • Sort Method: quicksort Memory: 25kB
2. 0.001 0.013 ↓ 0.0 0 1

Nested Loop (cost=8.92..91.69 rows=16 width=196) (actual time=0.013..0.013 rows=0 loops=1)

3. 0.001 0.012 ↓ 0.0 0 1

Bitmap Heap Scan on job_instance t0 (cost=4.43..12.22 rows=2 width=37) (actual time=0.012..0.012 rows=0 loops=1)

  • Recheck Cond: ((parent_id)::text = 'xx'::text)
4. 0.011 0.011 ↓ 0.0 0 1

Bitmap Index Scan on job_instance_parent_id_index (cost=0.00..4.43 rows=2 width=0) (actual time=0.011..0.011 rows=0 loops=1)

  • Index Cond: ((parent_id)::text = 'xx'::text)
5. 0.000 0.000 ↓ 0.0 0

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

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

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

  • Index Cond: ((job_instance_id)::text = (t0.id)::text)
Planning time : 0.721 ms
Execution time : 0.076 ms