explain.depesz.com

PostgreSQL's explain analyze made readable

Result: URGYa

Settings
# exclusive inclusive rows x rows loops node
1. 0.000 1,670.820 ↑ 1.0 1 1

Finalize Aggregate (cost=396,442.51..396,442.52 rows=1 width=8) (actual time=1,670.820..1,670.820 rows=1 loops=1)

2. 11.148 1,675.066 ↓ 1.2 5 1

Gather (cost=396,442.09..396,442.50 rows=4 width=8) (actual time=1,667.845..1,675.066 rows=5 loops=1)

  • Workers Planned: 4
  • Workers Launched: 4
3. 5.806 1,663.918 ↑ 1.0 1 5 / 5

Partial Aggregate (cost=395,442.09..395,442.10 rows=1 width=8) (actual time=1,663.917..1,663.918 rows=1 loops=5)

4. 12.534 1,658.112 ↑ 10.3 17,116 5 / 5

Nested Loop (cost=13,088.96..395,000.42 rows=176,670 width=297) (actual time=1,399.117..1,658.112 rows=17,116 loops=5)

5. 715.675 1,577.114 ↑ 10.3 17,116 5 / 5

Parallel Hash Join (cost=13,088.53..281,740.40 rows=176,670 width=8) (actual time=1,399.065..1,577.114 rows=17,116 loops=5)

  • Hash Cond: (eps.id = a.id)
6. 674.799 674.799 ↑ 1.2 1,084,962 5 / 5

Parallel Seq Scan on earlypaymentsettlement eps (cost=0.00..265,095.99 rows=1,354,620 width=16) (actual time=0.007..674.799 rows=1,084,962 loops=5)

  • Filter: (creationdate >= '2019-01-01'::date)
  • Rows Removed by Filter: 189854
7. 116.057 186.640 ↑ 2.1 166,262 5 / 5

Parallel Hash (cost=8,758.79..8,758.79 rows=346,379 width=8) (actual time=186.640..186.640 rows=166,262 loops=5)

  • Buckets: 1048576 Batches: 1 Memory Usage: 40800kB
8. 70.583 70.583 ↑ 2.1 166,262 5 / 5

Parallel Seq Scan on apfearlypaymentsettlement a (cost=0.00..8,758.79 rows=346,379 width=8) (actual time=0.006..70.583 rows=166,262 loops=5)

9. 68.464 68.464 ↑ 1.0 1 85,580 / 5

Index Scan using supplierinvoice_pkey on supplierinvoice si (cost=0.43..0.64 rows=1 width=305) (actual time=0.004..0.004 rows=1 loops=85,580)

  • Index Cond: (id = eps.invoice_id)
Planning time : 0.547 ms
Execution time : 1,675.156 ms