explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 6O3K : test

Settings
# exclusive inclusive rows x rows loops node
1. 0.000 0.055 ↑ 1.0 1 1

Bitmap Heap Scan on geographic_location_point glp (cost=5.91..7.93 rows=1 width=8) (actual time=0.054..0.055 rows=1 loops=1)

2. 0.046 0.046 ↓ 0.0 0 1

BitmapAnd (cost=5.91..5.91 rows=1 width=0) (actual time=0.046..0.046 rows=0 loops=1)

3. 0.030 0.030 ↑ 16.0 2 1

Bitmap Index Scan on geographic_location_point_3ix (cost=0.00..2.81 rows=32 width=0) (actual time=0.030..0.030 rows=2 loops=1)

4. 0.014 0.014 ↑ 12.7 3 1

Bitmap Index Scan on geographic_location_point_2ix (cost=0.00..2.85 rows=38 width=0) (actual time=0.014..0.014 rows=3 loops=1)