explain.depesz.com

PostgreSQL's explain analyze made readable

Result: xwv

Settings
# exclusive inclusive rows x rows loops node
1. 113.793 14,322.315 ↓ 138.6 106,299 1

Subquery Scan t (cost=170,692.25..175,678.27 rows=767 width=205) (actual time=13,762.783..14,322.315 rows=106,299 loops=1)

  • Filter: (t.row_number = 1)
2. 379.938 14,208.522 ↑ 1.0 149,557 1

WindowAgg (cost=170,692.25..173,760.57 rows=153,416 width=86) (actual time=13,762.774..14,208.522 rows=149,557 loops=1)

3. 296.864 13,828.584 ↑ 1.0 149,557 1

Sort (cost=170,692.25..171,075.79 rows=153,416 width=86) (actual time=13,762.745..13,828.584 rows=149,557 loops=1)

  • Sort Key: version_crs_coordinate_revision.id, version_crs_coordinate_revision._revision_created'
  • Sort Method: quicksort Memory: 23,960kB
4. 13,478.070 13,531.720 ↑ 1.0 149,557 1

Bitmap Heap Scan on version_crs_coordinate_revision (cost=3,319.13..157,477.69 rows=153,416 width=86) (actual time=70.925..13,531.720 rows=149,557 loops=1)

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

BitmapOr (cost=3,319.13..3,319.13 rows=154,372 width=0) (actual time=53.650..53.650 rows=0 loops=1)

6. 37.773 37.773 ↑ 1.0 110,326 1

Bitmap Index Scan on idx_crs_coordinate_revision_expired (cost=0.00..2,331.76 rows=111,041 width=0) (actual time=37.773..37.773 rows=110,326 loops=1)

  • Index Cond: ((_revision_expired > 16) AND (_revision_expired <= 40))
7. 15.872 15.872 ↑ 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=15.872..15.872 rows=43,258 loops=1)

  • Index Cond: ((_revision_created > 16) AND (_revision_created <= 40))
Total runtime : 14,359.747 ms