explain.depesz.com

PostgreSQL's explain analyze made readable

Result: ute

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

Gather (cost=219,998.78..60,442,257.51 rows=156,319 width=68) (actual rows= loops=)

  • Workers Planned: 2
2. 0.000 0.000 ↓ 0.0

Nested Loop Left Join (cost=218,998.78..60,425,625.61 rows=65,133 width=68) (actual rows= loops=)

3. 0.000 0.000 ↓ 0.0

Parallel Hash Left Join (cost=218,998.21..59,880,506.99 rows=65,133 width=36) (actual rows= loops=)

  • Hash Cond: (am.account_id = accounts.id)
4. 0.000 0.000 ↓ 0.0

Parallel Hash Left Join (cost=150,100.73..59,811,438.54 rows=65,133 width=32) (actual rows= loops=)

  • Hash Cond: (users.id = am.user_id)
5. 0.000 0.000 ↓ 0.0

Parallel Hash Left Join (cost=109,701.09..59,770,525.73 rows=65,133 width=32) (actual rows= loops=)

  • Hash Cond: (receipt_history_entries.user_id = users.id)
6. 0.000 0.000 ↓ 0.0

Parallel Seq Scan on receipt_history_entries (cost=0.00..59,655,957.66 rows=65,133 width=20) (actual rows= loops=)

  • Filter: ((action_key = 'merged_manually'::receipt_history_action) AND ((created_at)::date > '2019-09-01'::date))
7. 0.000 0.000 ↓ 0.0

Parallel Hash (cost=95,704.04..95,704.04 rows=805,204 width=12) (actual rows= loops=)

8. 0.000 0.000 ↓ 0.0

Parallel Seq Scan on users (cost=0.00..95,704.04 rows=805,204 width=12) (actual rows= loops=)

9. 0.000 0.000 ↓ 0.0

Parallel Hash (cost=30,425.95..30,425.95 rows=797,895 width=8) (actual rows= loops=)

10. 0.000 0.000 ↓ 0.0

Parallel Seq Scan on account_memberships am (cost=0.00..30,425.95 rows=797,895 width=8) (actual rows= loops=)

11. 0.000 0.000 ↓ 0.0

Parallel Hash (cost=61,488.88..61,488.88 rows=592,688 width=12) (actual rows= loops=)

12. 0.000 0.000 ↓ 0.0

Parallel Seq Scan on accounts (cost=0.00..61,488.88 rows=592,688 width=12) (actual rows= loops=)

13. 0.000 0.000 ↓ 0.0

Index Scan using receipts_pkey on receipts (cost=0.57..8.36 rows=1 width=8) (actual rows= loops=)

  • Index Cond: (id = receipt_history_entries.receipt_id)