explain.depesz.com

PostgreSQL's explain analyze made readable

Result: tByL

Settings
# exclusive inclusive rows x rows loops node
1. 110.854 1,525.705 ↓ 4.6 1,255,768 1

Nested Loop (cost=174.74..196,115.21 rows=273,622 width=12) (actual time=5.033..1,525.705 rows=1,255,768 loops=1)

2. 0.477 0.477 ↓ 4.6 78 1

Seq Scan on hzone hz (cost=0.00..71.69 rows=17 width=12) (actual time=0.005..0.477 rows=78 loops=1)

  • Filter: (length(name) = 2)
  • Rows Removed by Filter: 3235
3. 1,238.094 1,414.374 ↓ 1.0 16,100 78

Bitmap Heap Scan on client_serves_zone csz (cost=174.74..11,371.02 rows=16,095 width=8) (actual time=4.596..18.133 rows=16,100 loops=78)

  • Recheck Cond: (zone_id = hz.id)
  • Heap Blocks: exact=1255522
4. 176.280 176.280 ↓ 1.0 16,100 78

Bitmap Index Scan on client_serves_zone_zone_id_idx (cost=0.00..170.71 rows=16,095 width=0) (actual time=2.260..2.260 rows=16,100 loops=78)

  • Index Cond: (zone_id = hz.id)
Planning time : 0.219 ms
Execution time : 1,560.597 ms