explain.depesz.com

PostgreSQL's explain analyze made readable

Result: dYz3 : Optimization for: plan #l5HX

Settings

Optimization path:

Optimization(s) for this plan:

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

Limit (cost=80.62..155.29 rows=20 width=2,413) (actual rows= loops=)

2. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on node (cost=80.62..7,562.92 rows=2,004 width=2,413) (actual rows= loops=)

  • Recheck Cond: ((long_paths ~ 'fb63623d721e4a89b53909377b84fa29.*{1}'::lquery) OR (long_paths ~ '*{1}.fb63623d721e4a89b53909377b84fa29.*{1}'::lquery))
3. 0.000 0.000 ↓ 0.0

BitmapOr (cost=80.62..80.62 rows=2,005 width=0) (actual rows= loops=)

4. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on node_long_paths_gist_index (cost=0.00..39.81 rows=1,003 width=0) (actual rows= loops=)

  • Index Cond: (long_paths ~ 'fb63623d721e4a89b53909377b84fa29.*{1}'::lquery)
5. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on node_long_paths_gist_index (cost=0.00..39.81 rows=1,003 width=0) (actual rows= loops=)

  • Index Cond: (long_paths ~ '*{1}.fb63623d721e4a89b53909377b84fa29.*{1}'::lquery)