explain.depesz.com

PostgreSQL's explain analyze made readable

Result: VOl

Settings
# exclusive inclusive rows x rows loops node
1. 0.000 1,405.537 ↓ 1.3 2,004,062 1

Gather Merge (cost=524,876.30..710,537.90 rows=1,591,274 width=73) (actual time=749.926..1,405.537 rows=2,004,062 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
2. 979.353 2,492.187 ↑ 1.2 668,021 3

Sort (cost=523,876.28..525,865.37 rows=795,637 width=73) (actual time=743.272..830.729 rows=668,021 loops=3)

  • Sort Key: properties.lastmod DESC
  • Sort Method: external merge Disk: 57360kB
3. 132.735 1,512.834 ↑ 1.2 668,021 3

Append (cost=0.00..375,189.89 rows=795,637 width=73) (actual time=102.457..504.278 rows=668,021 loops=3)

4. 0.003 0.003 ↓ 0.0 0 3

Parallel Seq Scan on properties (cost=0.00..0.00 rows=1 width=40) (actual time=0.000..0.001 rows=0 loops=3)

  • Filter: (((NOT ishidden) OR (ishidden IS NULL)) AND ((NOT undisclosedaddress) OR (undisclosedaddress IS NULL)) AND (hometype <> ALL ('{70,88}'::integer[])) AND ((brokerid <> 13592) OR (brokerid IS NULL)) AND (stateid = 9) AND (countyid = 3101) AND (listingtype = 'OFF_MARKET'::listingtypeenum))
5. 1,228.878 1,325.979 ↑ 1.2 668,021 3

Parallel Bitmap Heap Scan on ca_us (cost=43,493.59..367,695.32 rows=795,635 width=73) (actual time=102.455..441.993 rows=668,021 loops=3)

  • Recheck Cond: (countyid = 3101)
  • Rows Removed by Index Recheck: 322655
  • Filter: (((NOT ishidden) OR (ishidden IS NULL)) AND ((NOT undisclosedaddress) OR (undisclosedaddress IS NULL)) AND (hometype <> ALL ('{70,88}'::integer[])) AND ((brokerid <> 13592) OR (brokerid IS NULL)) AND (stateid = 9) AND (listingtype = 'OFF_MARKET'::listingtypeenum))
  • Rows Removed by Filter: 107428
  • Heap Blocks: exact=13787 lossy=22174
6. 97.101 97.101 ↑ 1.0 2,326,346 1

Bitmap Index Scan on uidx_ca_us_countyid (cost=0.00..43,016.21 rows=2,329,037 width=0) (actual time=97.101..97.101 rows=2,326,346 loops=1)

  • Index Cond: (countyid = 3101)
7. 54.117 54.117 ↓ 0.0 0 3

Parallel Seq Scan on properties_catch_all (cost=0.00..7,494.57 rows=1 width=78) (actual time=18.039..18.039 rows=0 loops=3)

  • Filter: (((NOT ishidden) OR (ishidden IS NULL)) AND ((NOT undisclosedaddress) OR (undisclosedaddress IS NULL)) AND (hometype <> ALL ('{70,88}'::integer[])) AND ((brokerid <> 13592) OR (brokerid IS NULL)) AND (stateid = 9) AND (countyid = 3101) AND (listingtype = 'OFF_MARKET'::listingtypeenum))
  • Rows Removed by Filter: 135167