explain.depesz.com

PostgreSQL's explain analyze made readable

Result: dpPP : test1

Settings
# exclusive inclusive rows x rows loops node
1. 0.000 0.000 ↓ 0.0

Aggregate (cost=242,603.80..242,603.81 rows=1 width=8) (actual rows= loops=)

2. 0.000 0.000 ↓ 0.0

Unique (cost=232,860.92..235,644.60 rows=556,736 width=17) (actual rows= loops=)

3. 0.000 0.000 ↓ 0.0

Sort (cost=232,860.92..234,252.76 rows=556,736 width=17) (actual rows= loops=)

  • Sort Key: ftable.k1
4. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on ftable (cost=10,403.14..168,309.34 rows=556,736 width=17) (actual rows= loops=)

  • Recheck Cond: (sample = 1)
5. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on ftable_sample_idx (cost=0.00..10,263.95 rows=556,736 width=0) (actual rows= loops=)

  • Index Cond: (sample = 1)