explain.depesz.com

PostgreSQL's explain analyze made readable

Result: VzDH

Settings
# exclusive inclusive rows x rows loops node
1. 4.279 4.597 ↓ 0.0 0 1

Gather Merge (cost=33,277.67..33,552.33 rows=2,354 width=42) (actual time=3.229..4.597 rows=0 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
2. 0.111 0.318 ↓ 0.0 0 3

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

  • Sort Key: a2.id
  • Sort Method: quicksort Memory: 25kB
3. 0.174 0.207 ↓ 0.0 0 3

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

  • Hash Cond: (ail.affair_invoice_id = a2.id)
4. 0.015 0.015 ↑ 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)

5. 0.000 0.018 ↓ 0.0 0 3

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

  • Buckets: 1024 Batches: 1 Memory Usage: 8kB
6. 0.018 0.018 ↓ 0.0 0 3

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

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