explain.depesz.com

PostgreSQL's explain analyze made readable

Result: STX3

Settings
# exclusive inclusive rows x rows loops node
1. 0.072 3.946 ↓ 4.7 121 1

Sort (cost=1,249.48..1,249.55 rows=26 width=24) (actual time=3.936..3.946 rows=121 loops=1)

  • Sort Key: dd.deferred_delta_id, pv.version
  • Sort Method: quicksort Memory: 34kB
2. 0.044 3.874 ↓ 4.7 121 1

Nested Loop (cost=4.79..1,248.87 rows=26 width=24) (actual time=1.193..3.874 rows=121 loops=1)

3. 3.722 3.722 ↓ 27.0 27 1

Seq Scan on deferred_delta dd (cost=0.00..1,066.04 rows=1 width=16) (actual time=1.179..3.722 rows=27 loops=1)

  • Filter: ((parent_branch_id = '1cfc4c0e-2c74-40df-aac4-7e95aec7e91b'::uuid) AND (child_branch_id = '1e5ef6cd-3a74-44b7-9b67-33ce05d388eb'::uuid) AND ((status)::text = 'ACTIVE'::text))
  • Rows Removed by Filter: 28,625
4. 0.027 0.108 ↑ 12.0 4 27

Bitmap Heap Scan on parent_version pv (cost=4.79..182.36 rows=48 width=24) (actual time=0.004..0.004 rows=4 loops=27)

  • Recheck Cond: (deferred_delta_id = dd.deferred_delta_id)
  • Heap Blocks: exact=28
5. 0.081 0.081 ↑ 12.0 4 27

Bitmap Index Scan on parent_version_deferred_delta_id_idx (cost=0.00..4.78 rows=48 width=0) (actual time=0.003..0.003 rows=4 loops=27)

  • Index Cond: (deferred_delta_id = dd.deferred_delta_id)
Planning time : 0.236 ms
Execution time : 3.977 ms