explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 5uc2

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

Finalize Aggregate (cost=190,200.12..190,200.13 rows=1 width=8) (actual time=3,854.111..3,854.111 rows=1 loops=1)

2. 93.565 3,854.205 ↓ 1.2 5 1

Gather (cost=190,199.70..190,200.11 rows=4 width=8) (actual time=3,854.094..3,854.205 rows=5 loops=1)

  • Workers Planned: 4
  • Workers Launched: 4
3. 161.159 3,760.640 ↑ 1.0 1 5

Partial Aggregate (cost=189,199.70..189,199.71 rows=1 width=8) (actual time=3,760.640..3,760.640 rows=1 loops=5)

4. 702.694 3,599.481 ↑ 1.2 496,587 5

Hash Join (cost=133,992.30..187,650.38 rows=619,731 width=4) (actual time=2,654.391..3,599.481 rows=496,587 loops=5)

  • Hash Cond: (sdcd.consumption_entity_id = ce.id)
5. 243.609 243.609 ↑ 1.2 496,614 5

Parallel Seq Scan on service_data_consumption sdcd (cost=0.00..37,478.94 rows=620,621 width=8) (actual time=0.015..243.609 rows=496,614 loops=5)

  • Filter: (NOT deleted)
  • Rows Removed by Filter: 695
6. 1,131.571 2,653.178 ↑ 1.0 2,482,935 5

Hash (cost=93,255.43..93,255.43 rows=2,482,950 width=4) (actual time=2,653.178..2,653.178 rows=2,482,935 loops=5)

  • Buckets: 262144 Batches: 16 Memory Usage: 7501kB
7. 1,521.607 1,521.607 ↑ 1.0 2,482,935 5

Seq Scan on consumption_entity ce (cost=0.00..93,255.43 rows=2,482,950 width=4) (actual time=0.066..1,521.607 rows=2,482,935 loops=5)

  • Filter: ((NOT deleted) AND (client_id = 1007))
  • Rows Removed by Filter: 3607
Planning time : 0.321 ms
Execution time : 3,854.274 ms