explain.depesz.com

PostgreSQL's explain analyze made readable

Result: zCIg

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

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

2. 175.003 4,168.250 ↓ 1.2 5 1

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

  • Workers Planned: 4
  • Workers Launched: 4
3. 161.605 3,993.247 ↑ 1.0 1 5

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

4. 731.902 3,831.642 ↑ 1.2 496,587 5

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

  • Hash Cond: (sdcd.consumption_entity_id = ce.id)
5. 295.448 295.448 ↑ 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.018..295.448 rows=496,614 loops=5)

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

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

  • Buckets: 262144 Batches: 16 Memory Usage: 7501kB
7. 1,587.089 1,587.089 ↑ 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.061..1,587.089 rows=2,482,935 loops=5)

  • Filter: ((NOT deleted) AND (client_id = 1007))
  • Rows Removed by Filter: 3607
Planning time : 0.344 ms
Execution time : 4,168.336 ms