explain.depesz.com

PostgreSQL's explain analyze made readable

Result: oSNs

Settings
# exclusive inclusive rows x rows loops node
1. 0.002 3.389 ↓ 0.0 0 1

Finalize GroupAggregate (cost=33,289.65..33,289.69 rows=1 width=68) (actual time=3.388..3.389 rows=0 loops=1)

  • Group Key: a2.id
2. 0.000 3.387 ↓ 0.0 0 1

Sort (cost=33,289.65..33,289.65 rows=2 width=68) (actual time=3.387..3.387 rows=0 loops=1)

  • Sort Key: a2.id
  • Sort Method: quicksort Memory: 25kB
3. 5.839 5.907 ↓ 0.0 0 1

Gather (cost=33,277.65..33,289.64 rows=2 width=68) (actual time=3.384..5.907 rows=0 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
4. 0.000 0.068 ↓ 0.0 0 3

Partial GroupAggregate (cost=32,277.65..32,289.44 rows=1 width=68) (actual time=0.068..0.068 rows=0 loops=3)

  • Group Key: a2.id
5. 0.037 0.068 ↓ 0.0 0 3

Sort (cost=32,277.65..32,280.59 rows=1,177 width=42) (actual time=0.068..0.068 rows=0 loops=3)

  • Sort Key: a2.id
  • Sort Method: quicksort Memory: 25kB
6. 0.021 0.031 ↓ 0.0 0 3

Hash Join (cost=16.01..32,217.62 rows=1,177 width=42) (actual time=0.031..0.031 rows=0 loops=3)

  • Hash Cond: (ail.affair_invoice_id = a2.id)
7. 0.005 0.005 ↑ 470,852.0 1 3

Parallel Seq Scan on account_invoice_line ail (cost=0.00..30,952.53 rows=470,852 width=10) (actual time=0.005..0.005 rows=1 loops=3)

8. 0.000 0.005 ↓ 0.0 0 3

Hash (cost=16.00..16.00 rows=1 width=36) (actual time=0.005..0.005 rows=0 loops=3)

  • Buckets: 1024 Batches: 1 Memory Usage: 8kB
9. 0.005 0.005 ↓ 0.0 0 3

Seq Scan on cesbron_affair_invoice a2 (cost=0.00..16.00 rows=1 width=36) (actual time=0.005..0.005 rows=0 loops=3)

  • Filter: ((invoice_date < '2019-01-01'::date) AND (affair_id = 1))