explain.depesz.com

PostgreSQL's explain analyze made readable

Result: EQQH

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

Nested Loop (cost=94.36..5,174.97 rows=644 width=1,326) (actual time=0.079..0.079 rows=0 loops=1)

2.          

CTE started

3. 0.067 0.067 ↓ 0.0 0 1

Index Scan using idx_entity_op_created on ticket ticket_1 (cost=0.56..10.40 rows=2 width=37) (actual time=0.066..0.067 rows=0 loops=1)

  • Index Cond: (((op_type)::text = 'SDD_SNAPSHOT'::text) AND ((entity_id)::text = 'sdb-services-prod:sdb3'::text))
4.          

CTE completed

5. 0.000 0.000 ↓ 0.0 0

Index Scan using idx_entity_op_created on ticket ticket_2 (cost=0.56..10.40 rows=2 width=37) (never executed)

  • Index Cond: (((op_type)::text = 'SDD_COPY_EXTENT_COMPLETE'::text) AND ((entity_id)::text = 'sdb-services-prod:sdb3'::text))
  • Filter: ((status)::text = ANY ('{COMPLETED,ABORT}'::text[]))
6. 0.000 0.078 ↓ 0.0 0 1

Unique (cost=0.05..0.06 rows=2 width=516) (actual time=0.078..0.078 rows=0 loops=1)

7. 0.010 0.078 ↓ 0.0 0 1

Sort (cost=0.05..0.06 rows=2 width=516) (actual time=0.078..0.078 rows=0 loops=1)

  • Sort Key: ((started.job_id)::text)
  • Sort Method: quicksort Memory: 25kB
8. 0.068 0.068 ↓ 0.0 0 1

CTE Scan on started (cost=0.00..0.04 rows=2 width=516) (actual time=0.068..0.068 rows=0 loops=1)

9. 0.000 0.000 ↓ 0.0 0

Bitmap Heap Scan on ticket (cost=73.51..2,573.83 rows=322 width=1,326) (never executed)

  • Recheck Cond: ((job_id)::text = (started.job_id)::text)
  • Filter: (NOT (hashed SubPlan 3))
10. 0.000 0.000 ↓ 0.0 0

Bitmap Index Scan on idx_job_op (cost=0.00..73.39 rows=644 width=0) (never executed)

  • Index Cond: ((job_id)::text = (started.job_id)::text)
11.          

SubPlan (for Bitmap Heap Scan)

12. 0.000 0.000 ↓ 0.0 0

CTE Scan on completed (cost=0.00..0.04 rows=2 width=516) (never executed)

Planning time : 0.560 ms
Execution time : 0.160 ms