explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 53JN

Settings
# exclusive inclusive rows x rows loops node
1. 2,764.583 5,394.689 ↓ 1.9 3,570 1

Gather (cost=252,289.06..12,232,264.73 rows=1,908 width=4,823) (actual time=0.665..5,394.689 rows=3,570 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
2. 9.360 2,630.106 ↓ 1.5 1,190 3

Nested Loop (cost=251,289.06..12,231,073.93 rows=795 width=4,823) (actual time=1.510..2,630.106 rows=1,190 loops=3)

3. 2,619.882 2,619.882 ↓ 1.8 11 3

Parallel Index Scan using account_pkey on account (cost=0.42..2,310,381.45 rows=6 width=4) (actual time=0.662..2,619.882 rows=11 loops=3)

  • Filter: ((deleted_at IS NULL) AND (user_id = 1))
  • Rows Removed by Filter: 2041091
4. 0.801 0.864 ↑ 3,319.7 112 32

Bitmap Heap Scan on transaction (cost=251,288.64..1,649,730.69 rows=371,806 width=4,823) (actual time=0.080..0.864 rows=112 loops=32)

  • Recheck Cond: (account_id = account.id)
  • Heap Blocks: exact=843
5. 0.063 0.063 ↑ 3,319.7 112 32

Bitmap Index Scan on transaction_account_id (cost=0.00..251,195.68 rows=371,806 width=0) (actual time=0.063..0.063 rows=112 loops=32)

  • Index Cond: (account_id = account.id)