explain.depesz.com

PostgreSQL's explain analyze made readable

Result: tCSN : load nodes

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

Limit (cost=586.41..586.46 rows=20 width=783) (actual rows= loops=)

2. 0.000 0.000 ↓ 0.0

Sort (cost=586.41..586.56 rows=61 width=783) (actual rows= loops=)

  • Sort Key: (lower(edge_data.current)) DESC
3. 0.000 0.000 ↓ 0.0

Nested Loop (cost=8.41..584.78 rows=61 width=783) (actual rows= loops=)

4. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on edge_data (cost=5.35..340.69 rows=46 width=150) (actual rows= loops=)

  • Recheck Cond: ((from_revision = '890928ca-656a-4c71-a86c-28c938170630'::uuid) OR (from_stable = '5c174d91-6e01-4e31-9ff8-467dd5ea9207'::uuid))
  • Filter: (is_current AND (type = 'INCLUDESFILE'::relationtype))
5. 0.000 0.000 ↓ 0.0

BitmapOr (cost=5.35..5.35 rows=302 width=0) (actual rows= loops=)

6. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on edge_data_btree_from_revision (cost=0.00..2.65 rows=149 width=0) (actual rows= loops=)

  • Index Cond: (from_revision = '890928ca-656a-4c71-a86c-28c938170630'::uuid)
7. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on edge_data_btree_from_stable (cost=0.00..2.68 rows=153 width=0) (actual rows= loops=)

  • Index Cond: (from_stable = '5c174d91-6e01-4e31-9ff8-467dd5ea9207'::uuid)
8. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on node_data (cost=3.06..5.29 rows=1 width=648) (actual rows= loops=)

  • Recheck Cond: ((edge_data.to_revision = revision_id) OR (edge_data.to_stable = stable_id))
  • Filter: ((is_current IS TRUE) AND ((edge_data.to_revision = revision_id) OR ((edge_data.all_revisions IS TRUE) AND (edge_data.to_stable = stable_id))))
9. 0.000 0.000 ↓ 0.0

BitmapOr (cost=3.06..3.06 rows=2 width=0) (actual rows= loops=)

10. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on node_data_pkey (cost=0.00..1.54 rows=1 width=0) (actual rows= loops=)

  • Index Cond: (revision_id = edge_data.to_revision)
11. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on node_data_stable_id_current_excl (cost=0.00..1.52 rows=1 width=0) (actual rows= loops=)

  • Index Cond: (stable_id = edge_data.to_stable)