explain.depesz.com

PostgreSQL's explain analyze made readable

Result: qpL

Settings
# exclusive inclusive rows x rows loops node
1. 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)))
2. 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)

3. 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))
4. 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))