explain.depesz.com

PostgreSQL's explain analyze made readable

Result: rDvj

Settings
# exclusive inclusive rows x rows loops node
1. 0.009 3.547 ↓ 2.9 26 1

Subquery Scan on z (cost=1,250.61..1,251.00 rows=9 width=32) (actual time=3.533..3.547 rows=26 loops=1)

  • Filter: (z.max_parent_version <= 602,951)
  • Rows Removed by Filter: 95
2. 0.044 3.538 ↓ 4.7 121 1

Sort (cost=1,250.61..1,250.68 rows=26 width=32) (actual time=3.532..3.538 rows=121 loops=1)

  • Sort Key: dd.deferred_delta_id, pv.version
  • Sort Method: quicksort Memory: 34kB
3. 0.063 3.494 ↓ 4.7 121 1

WindowAgg (cost=1,249.48..1,250.00 rows=26 width=32) (actual time=3.432..3.494 rows=121 loops=1)

4. 0.048 3.431 ↓ 4.7 121 1

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

  • Sort Key: dd.deferred_delta_id, pv.version DESC
  • Sort Method: quicksort Memory: 34kB
5. 0.032 3.383 ↓ 4.7 121 1

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

6. 3.243 3.243 ↓ 27.0 27 1

Seq Scan on deferred_delta dd (cost=0.00..1,066.04 rows=1 width=16) (actual time=0.751..3.243 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
7. 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
8. 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.194 ms
Execution time : 3.579 ms