explain.depesz.com

PostgreSQL's explain analyze made readable

Result: VmO

Settings
# exclusive inclusive rows x rows loops node
1. 113.450 1,358.983 ↓ 138.7 106,405 1

Subquery Scan t (cost=170,707.59..175,695.79 rows=767 width=205) (actual time=795.476..1,358.983 rows=106,405 loops=1)

  • Filter: (t.row_number = 1)
2. 383.039 1,245.533 ↑ 1.0 149,663 1

WindowAgg (cost=170,707.59..173,777.25 rows=153,483 width=86) (actual time=795.443..1,245.533 rows=149,663 loops=1)

3. 285.518 862.494 ↑ 1.0 149,663 1

Sort (cost=170,707.59..171,091.30 rows=153,483 width=86) (actual time=795.401..862.494 rows=149,663 loops=1)

  • Sort Key: version_crs_coordinate_revision.id, version_crs_coordinate_revision._revision_created
  • Sort Method: quicksort Memory: 23,974kB
4. 238.118 576.976 ↑ 1.0 149,663 1

Bitmap Heap Scan on version_crs_coordinate_revision (cost=3,319.84..157,486.78 rows=153,483 width=86) (actual time=355.183..576.976 rows=149,663 loops=1)

  • Recheck Cond: (((_revision_expired > 16) AND (_revision_expired <= 42)) OR ((_revision_created > 16) AND (_revision_created <= 42)))
  • Filter: (((_revision_created <= 16) AND (_revision_expired > 16) AND (_revision_expired <= 42)) OR ((_revision_created > 16) AND (_revision_created <= 42)))
5. 0.005 338.858 ↓ 0.0 0 1

BitmapOr (cost=3,319.84..3,319.84 rows=154,439 width=0) (actual time=338.858..338.858 rows=0 loops=1)

6. 333.125 333.125 ↑ 1.0 110,432 1

Bitmap Index Scan on idx_crs_coordinate_revision_expired (cost=0.00..2,332.43 rows=111,108 width=0) (actual time=333.125..333.125 rows=110,432 loops=1)

  • Index Cond: ((_revision_expired > 16) AND (_revision_expired <= 42))
7. 5.728 5.728 ↑ 1.0 43,258 1

Bitmap Index Scan on idx_crs_coordinate_revision_created (cost=0.00..910.66 rows=43,331 width=0) (actual time=5.728..5.728 rows=43,258 loops=1)

  • Index Cond: ((_revision_created > 16) AND (_revision_created <= 42))'
Total runtime : 1,399.633 ms