explain.depesz.com

PostgreSQL's explain analyze made readable

Result: Skud

Settings
# exclusive inclusive rows x rows loops node
1. 332.405 3,678.529 ↓ 958.0 958 1

Hash Join (cost=1,010.27..897,764.21 rows=1 width=270) (actual time=1,150.954..3,678.529 rows=958 loops=1)

  • Hash Cond: (((ccgs.server)::text = (rpt.server)::text) AND (ccgs.platform_id = rpt.platform_id) AND (ccgs.brand_id = rpt.brand_id))
2. 613.094 3,346.081 ↓ 18.6 1,578,600 1

Gather (cost=1,000.00..896,801.64 rows=84,648 width=270) (actual time=1,149.974..3,346.081 rows=1,578,600 loops=1)

  • Workers Planned: 7
  • Workers Launched: 7
3. 2,732.987 2,732.987 ↓ 16.3 197,325 8 / 8

Parallel Seq Scan on invoice_summary ccgs (cost=0.00..887,336.83 rows=12,093 width=270) (actual time=1,132.012..2,732.987 rows=197,325 loops=8)

  • Filter: (date_trunc('MONTH'::text, (summary)::timestamp with time zone) = date_trunc('MONTH'::text, ('2019-10-01'::date)::timestamp with time zone))
  • Rows Removed by Filter: 2,119,986
4. 0.009 0.043 ↑ 10.0 1 1

Hash (cost=10.10..10.10 rows=10 width=182) (actual time=0.043..0.043 rows=1 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 9kB
5. 0.034 0.034 ↑ 10.0 1 1

Seq Scan on revenue_parameters_temp rpt (cost=0.00..10.10 rows=10 width=182) (actual time=0.033..0.034 rows=1 loops=1)

Planning time : 0.696 ms
Execution time : 3,691.941 ms