explain.depesz.com

PostgreSQL's explain analyze made readable

Result: LzZG

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

Limit (cost=7,463.02..7,463.13 rows=1 width=196) (actual time=8.021..8.021 rows=0 loops=1)

  • Output: plaid_transactions.id, plaid_transactions.account_id, plaid_transactions.plaid_account_id, plaid_transactions.transaction_id, plaid_transactions.date, plaid_transactions.pending, plaid_transactions.amount, plaid_transactions.name, plaid_transactions.transaction_type, plaid_transactions.categories, plaid_transactions.is_student_loan
  • Buffers: shared hit=874
2. 3.812 9.502 ↓ 0.0 0 1

Gather Merge (cost=7,463.02..7,496.60 rows=292 width=196) (actual time=8.019..9.502 rows=0 loops=1)

  • Output: plaid_transactions.id, plaid_transactions.account_id, plaid_transactions.plaid_account_id, plaid_transactions.transaction_id, plaid_transactions.date, plaid_transactions.pending, plaid_transactions.amount, plaid_transactions.name, plaid_transactions.transaction_type, plaid_transactions.categories, plaid_transactions.is_student_loan
  • Workers Planned: 1
  • Workers Launched: 1
  • Buffers: shared hit=1313
3. 0.024 5.690 ↓ 0.0 0 2 / 2

Sort (cost=6,463.01..6,463.74 rows=292 width=196) (actual time=5.690..5.690 rows=0 loops=2)

  • Output: plaid_transactions.id, plaid_transactions.account_id, plaid_transactions.plaid_account_id, plaid_transactions.transaction_id, plaid_transactions.date, plaid_transactions.pending, plaid_transactions.amount, plaid_transactions.name, plaid_transactions.transaction_type, plaid_transactions.categories, plaid_transactions.is_student_loan
  • Sort Key: plaid_transactions.date DESC
  • Sort Method: quicksort Memory: 25kB
  • Worker 0: Sort Method: quicksort Memory: 25kB
  • Buffers: shared hit=1313
  • Worker 0: actual time=3.751..3.751 rows=0 loops=1
  • Buffers: shared hit=439
4. 0.001 5.666 ↓ 0.0 0 2 / 2

Nested Loop (cost=0.43..6,461.55 rows=292 width=196) (actual time=5.666..5.666 rows=0 loops=2)

  • Output: plaid_transactions.id, plaid_transactions.account_id, plaid_transactions.plaid_account_id, plaid_transactions.transaction_id, plaid_transactions.date, plaid_transactions.pending, plaid_transactions.amount, plaid_transactions.name, plaid_transactions.transaction_type, plaid_transactions.categories, plaid_transactions.is_student_loan
  • Buffers: shared hit=1306
  • Worker 0: actual time=3.714..3.714 rows=0 loops=1
  • Buffers: shared hit=432
5. 5.665 5.665 ↓ 0.0 0 2 / 2

Parallel Seq Scan on public.plaid_accounts (cost=0.00..1,836.02 rows=3 width=4) (actual time=5.665..5.665 rows=0 loops=2)

  • Output: plaid_accounts.id, plaid_accounts.item_id, plaid_accounts.name, plaid_accounts.account_id, plaid_accounts.plaid_type, plaid_accounts.plaid_subtype, plaid_accounts.current_balance, plaid_accounts.official_name, plaid_accounts.mask, plaid_accounts.created_at, plaid_accounts.is_removed, plaid_accounts.updated_at
  • Filter: (plaid_accounts.item_id = 1)
  • Rows Removed by Filter: 35022
  • Buffers: shared hit=1306
  • Worker 0: actual time=3.714..3.714 rows=0 loops=1
  • Buffers: shared hit=432
6. 0.000 0.000 ↓ 0.0 0 / 2

Index Scan using idx_account_id on public.plaid_transactions (cost=0.43..1,532.84 rows=900 width=196) (never executed)

  • Output: plaid_transactions.id, plaid_transactions.plaid_account_id, plaid_transactions.transaction_id, plaid_transactions.date, plaid_transactions.pending, plaid_transactions.amount, plaid_transactions.name, plaid_transactions.transaction_type, plaid_transactions.categories, plaid_transactions.is_student_loan, plaid_transactions.account_id
  • Index Cond: (plaid_transactions.account_id = plaid_accounts.id)
Planning time : 11,690.419 ms
Execution time : 9.632 ms