explain.depesz.com

PostgreSQL's explain analyze made readable

Result: f632

Settings
# exclusive inclusive rows x rows loops node
1. 0.108 202,964.299 ↑ 1.0 1,000 1

Limit (cost=1,082,296.56..1,082,413.23 rows=1,000 width=129) (actual time=201,976.453..202,964.299 rows=1,000 loops=1)

2. 0.000 202,964.191 ↑ 33.0 1,000 1

Gather Merge (cost=1,082,296.56..1,086,148.23 rows=33,012 width=129) (actual time=201,976.452..202,964.191 rows=1,000 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
3. 283.974 605,901.525 ↑ 33.9 487 3

Sort (cost=1,081,296.53..1,081,337.80 rows=16,506 width=129) (actual time=201,967.085..201,967.175 rows=487 loops=3)

  • Sort Key: a.updated_at
  • Sort Method: top-N heapsort Memory: 378kB
  • Worker 0: Sort Method: top-N heapsort Memory: 377kB
  • Worker 1: Sort Method: top-N heapsort Memory: 381kB
4. 23,618.901 605,617.551 ↓ 12.3 203,361 3

Parallel Hash Semi Join (cost=1,033,150.38..1,080,391.53 rows=16,506 width=129) (actual time=194,303.744..201,872.517 rows=203,361 loops=3)

  • Hash Cond: (a.id = b.agreement_id)
5. 13,895.607 13,895.607 ↑ 1.2 203,377 3

Parallel Seq Scan on billing_admin_agreement a (cost=0.00..18,831.23 rows=245,823 width=129) (actual time=3.556..4,631.869 rows=203,377 loops=3)

6. 3,482.307 568,103.043 ↑ 1.3 2,874,726 3

Parallel Hash (cost=969,152.82..969,152.82 rows=3,681,645 width=16) (actual time=189,367.681..189,367.681 rows=2,874,726 loops=3)

  • Buckets: 131072 Batches: 256 Memory Usage: 2784kB
7. 87,730.785 564,620.736 ↑ 1.3 2,874,726 3

Parallel Hash Semi Join (cost=229,135.58..969,152.82 rows=3,681,645 width=16) (actual time=161,005.606..188,206.912 rows=2,874,726 loops=3)

  • Hash Cond: (b.id = c.billing_definition_id)
8. 453,225.396 453,225.396 ↑ 1.3 2,929,358 3

Parallel Seq Scan on billing_admin_billingdefinition b (cost=0.00..607,185.45 rows=3,681,645 width=32) (actual time=1.647..151,075.132 rows=2,929,358 loops=3)

9. 4,516.704 23,664.555 ↑ 1.3 2,874,737 3

Parallel Hash (cost=164,818.13..164,818.13 rows=3,700,036 width=16) (actual time=7,888.185..7,888.185 rows=2,874,737 loops=3)

  • Buckets: 131072 Batches: 256 Memory Usage: 2656kB
10. 19,147.851 19,147.851 ↑ 1.3 2,874,737 3

Parallel Seq Scan on billing_admin_cycletime c (cost=0.00..164,818.13 rows=3,700,036 width=16) (actual time=0.977..6,382.617 rows=2,874,737 loops=3)

  • Filter: ((frequency)::text = 'realtime'::text)
  • Rows Removed by Filter: 57719
Planning time : 1.847 ms
Execution time : 202,964.500 ms