explain.depesz.com

PostgreSQL's explain analyze made readable

Result: gL4P

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

WindowAgg (cost=519.58..521.98 rows=96 width=85) (actual time=4.498..4.509 rows=0 loops=1)

2. 0.024 4.505 ↓ 0.0 0 1

Sort (cost=519.58..519.82 rows=96 width=77) (actual time=4.496..4.505 rows=0 loops=1)

  • Sort Key: fpe.attribute_value_id, fpe.property_type, fpe.version DESC
  • Sort Method: quicksort Memory: 25kB
3. 0.005 4.481 ↓ 0.0 0 1

Append (cost=0.56..516.42 rows=96 width=77) (actual time=4.474..4.481 rows=0 loops=1)

4. 0.012 0.012 ↓ 0.0 0 1

Index Scan using lidx_fpe_1e5ef6cd_3a74_44b7_9b67_33ce05d388eb_idver_only on fpe_1e5ef6cd_3a74_44b7_9b67_33ce05d388eb fpe (cost=0.56..390.02 rows=95 width=77) (actual time=0.012..0.012 rows=0 loops=1)

  • Index Cond: (feature_id = '0000474c-4200-0002-0000-00002fd40f4b'::uuid)
  • Filter: (((branch = '1e5ef6cd-3a74-44b7-9b67-33ce05d388eb'::uuid) AND (version > 1) AND (version <= 500,000)) OR ((branch = '11110ce2-fc94-4c7c-a425-68b08d5a1111'::uuid) AND (version > 0) AND (version <= 1)))
5. 0.004 4.464 ↓ 0.0 0 1

Bitmap Heap Scan on fpe_default fpe_1 (cost=121.90..125.93 rows=1 width=77) (actual time=4.459..4.464 rows=0 loops=1)

  • Recheck Cond: (((feature_id = '0000474c-4200-0002-0000-00002fd40f4b'::uuid) AND (branch = '1e5ef6cd-3a74-44b7-9b67-33ce05d388eb'::uuid) AND (version > 1) AND (version <= 500,000)) OR ((branch = '11110ce2-fc94-4c7c-a425-68b08d5a1111'::uuid) AND (version > 0) AND (version <= 1)))
  • Filter: (feature_id = '0000474c-4200-0002-0000-00002fd40f4b'::uuid)
6. 0.005 4.460 ↓ 0.0 0 1

BitmapOr (cost=121.90..121.90 rows=1 width=0) (actual time=4.456..4.460 rows=0 loops=1)

7. 4.219 4.219 ↓ 0.0 0 1

Bitmap Index Scan on fpe_default_pkey (cost=0.00..117.18 rows=1 width=0) (actual time=4.218..4.219 rows=0 loops=1)

  • Index Cond: ((feature_id = '0000474c-4200-0002-0000-00002fd40f4b'::uuid) AND (branch = '1e5ef6cd-3a74-44b7-9b67-33ce05d388eb'::uuid) AND (version > 1) AND (version <= 500,000))
8. 0.236 0.236 ↓ 0.0 0 1

Bitmap Index Scan on lidx_fpe_branch_version (cost=0.00..4.71 rows=1 width=0) (actual time=0.235..0.236 rows=0 loops=1)

  • Index Cond: ((branch = '11110ce2-fc94-4c7c-a425-68b08d5a1111'::uuid) AND (version > 0) AND (version <= 1))