explain.depesz.com

PostgreSQL's explain analyze made readable

Result: ARYqE

Settings
# exclusive inclusive rows x rows loops node
1. 434.192 3,066.857 ↑ 1.3 7 1

HashAggregate (cost=3,201,571.30..3,201,571.39 rows=9 width=3) (actual time=3,066.856..3,066.857 rows=7 loops=1)

  • Group Key: modality
2. 1,804.431 2,632.665 ↓ 1.1 2,537,921 1

Bitmap Heap Scan on archtable (cost=261,650.25..3,195,587.57 rows=2,393,492 width=3) (actual time=867.323..2,632.665 rows=2,537,921 loops=1)

  • Recheck Cond: ((tapenumber)::text = 'tasma25'::text)
  • Filter: ((aetitle)::text = 'ARPACS'::text)
  • Heap Blocks: exact=153,033
3. 828.234 828.234 ↓ 1.1 2,537,921 1

Bitmap Index Scan on archtable_up_idx2 (cost=0.00..261,051.88 rows=2,393,492 width=0) (actual time=828.234..828.234 rows=2,537,921 loops=1)

  • Index Cond: ((tapenumber)::text = 'tasma25'::text)
Planning time : 0.149 ms
Execution time : 3,069.131 ms