explain.depesz.com

PostgreSQL's explain analyze made readable

Result: lE23

Settings
# exclusive inclusive rows x rows loops node
1. 65.276 41,819.336 ↑ 1.3 3 1

HashAggregate (cost=133,787.62..133,787.66 rows=4 width=10) (actual time=41,819.336..41,819.336 rows=3 loops=1)

  • Group Key: member.member_status_id
2. 211.312 41,754.060 ↓ 5.2 311,114 1

Hash Join (cost=107,500.21..133,487.88 rows=59,947 width=2) (actual time=39,865.399..41,754.060 rows=311,114 loops=1)

  • Hash Cond: (member_group_member.member_id = member.member_id)
3. 1,684.112 1,684.112 ↓ 1.0 311,114 1

Index Only Scan using member_group_member_pkey on member_group_member (cost=0.56..17,579.41 rows=308,626 width=8) (actual time=2.723..1,684.112 rows=311,114 loops=1)

  • Index Cond: (member_group_id = 5,105,939)
  • Heap Fetches: 0
4. 255.982 39,858.636 ↑ 1.2 718,358 1

Hash (cost=92,407.30..92,407.30 rows=868,188 width=10) (actual time=39,858.636..39,858.636 rows=718,358 loops=1)

  • Buckets: 1,048,576 Batches: 2 Memory Usage: 25,011kB
5. 35,582.269 39,602.654 ↑ 1.2 718,358 1

Bitmap Heap Scan on member (cost=22,786.41..92,407.30 rows=868,188 width=10) (actual time=4,029.088..39,602.654 rows=718,358 loops=1)

  • Recheck Cond: (account_id = 1,723,667)
  • Filter: (deleted_at IS NULL)
  • Rows Removed by Filter: 278,792
  • Heap Blocks: exact=38,441
6. 4,020.385 4,020.385 ↑ 1.0 997,150 1

Bitmap Index Scan on ix_member_account_id (cost=0.00..22,569.36 rows=1,001,191 width=0) (actual time=4,020.385..4,020.385 rows=997,150 loops=1)

  • Index Cond: (account_id = 1,723,667)