explain.depesz.com

PostgreSQL's explain analyze made readable

Result: BD4v

Settings
# exclusive inclusive rows x rows loops node
1. 0.004 0.131 ↓ 0.0 0 1

Subquery Scan on allmatching (cost=26.39..26.46 rows=1 width=85) (actual time=0.110..0.131 rows=0 loops=1)

  • Filter: (allmatching.rank = 1)
2. 0.005 0.127 ↓ 0.0 0 1

WindowAgg (cost=26.39..26.44 rows=2 width=85) (actual time=0.109..0.127 rows=0 loops=1)

3. 0.039 0.122 ↓ 0.0 0 1

Sort (cost=26.39..26.39 rows=2 width=77) (actual time=0.106..0.122 rows=0 loops=1)

  • Sort Key: fpe.attribute_value_id, fpe.property_type, fpe.version DESC
  • Sort Method: quicksort Memory: 25kB
4. 0.007 0.083 ↓ 0.0 0 1

Append (cost=9.15..26.38 rows=2 width=77) (actual time=0.068..0.083 rows=0 loops=1)

5. 0.014 0.049 ↓ 0.0 0 1

Bitmap Heap Scan on fpe_ccebc7e7_d60c_4355_a841_6c854721e6e8 fpe (cost=9.15..13.18 rows=1 width=77) (actual time=0.043..0.049 rows=0 loops=1)

  • Recheck Cond: (((feature_id = '0000474c-4200-0001-0000-0000c0890fae'::uuid) AND (version > 35) AND (version <= 100)) OR ((feature_id = '0000474c-4200-0001-0000-0000c0890fae'::uuid) AND (version > 13) AND (version <= 51)))
  • Filter: (((branch = 'ccebc7e7-d60c-4355-a841-6c854721e6e8'::uuid) AND (version > 35) AND (version <= 100)) OR ((branch = 'ccebc7e7-d60c-4355-a841-6c854721e6e1'::uuid) AND (version > 13) AND (version <= 51)))
  • Rows Removed by Filter: 9
  • Heap Blocks: exact=1
6. 0.005 0.035 ↓ 0.0 0 1

BitmapOr (cost=9.15..9.15 rows=1 width=0) (actual time=0.031..0.035 rows=0 loops=1)

7. 0.021 0.021 ↓ 0.0 0 1

Bitmap Index Scan on lidx_fpe_ccebc7e7_d60c_4355_a841_6c854721e6e8_idver_only (cost=0.00..4.58 rows=1 width=0) (actual time=0.020..0.021 rows=0 loops=1)

  • Index Cond: ((feature_id = '0000474c-4200-0001-0000-0000c0890fae'::uuid) AND (version > 35) AND (version <= 100))
8. 0.009 0.009 ↓ 9.0 9 1

Bitmap Index Scan on lidx_fpe_ccebc7e7_d60c_4355_a841_6c854721e6e8_idver_only (cost=0.00..4.58 rows=1 width=0) (actual time=0.008..0.009 rows=9 loops=1)

  • Index Cond: ((feature_id = '0000474c-4200-0001-0000-0000c0890fae'::uuid) AND (version > 13) AND (version <= 51))
9. 0.004 0.027 ↓ 0.0 0 1

Bitmap Heap Scan on fpe_default fpe_1 (cost=9.16..13.19 rows=1 width=77) (actual time=0.021..0.027 rows=0 loops=1)

  • Recheck Cond: (((branch = 'ccebc7e7-d60c-4355-a841-6c854721e6e8'::uuid) AND (version > 35) AND (version <= 100)) OR ((branch = 'ccebc7e7-d60c-4355-a841-6c854721e6e1'::uuid) AND (version > 13) AND (version <= 51)))
  • Filter: (feature_id = '0000474c-4200-0001-0000-0000c0890fae'::uuid)
10. 0.005 0.023 ↓ 0.0 0 1

BitmapOr (cost=9.16..9.16 rows=1 width=0) (actual time=0.019..0.023 rows=0 loops=1)

11. 0.012 0.012 ↓ 0.0 0 1

Bitmap Index Scan on lidx_fpe_branch_version (cost=0.00..4.58 rows=1 width=0) (actual time=0.011..0.012 rows=0 loops=1)

  • Index Cond: ((branch = 'ccebc7e7-d60c-4355-a841-6c854721e6e8'::uuid) AND (version > 35) AND (version <= 100))
12. 0.006 0.006 ↓ 0.0 0 1

Bitmap Index Scan on lidx_fpe_branch_version (cost=0.00..4.58 rows=1 width=0) (actual time=0.005..0.006 rows=0 loops=1)

  • Index Cond: ((branch = 'ccebc7e7-d60c-4355-a841-6c854721e6e1'::uuid) AND (version > 13) AND (version <= 51))