explain.depesz.com

PostgreSQL's explain analyze made readable

Result: MA2J

Settings
# exclusive inclusive rows x rows loops node
1. 67.884 1,858.728 ↓ 15,934.0 15,934 1

Hash Join (cost=54,646.56..86,543.88 rows=1 width=964) (actual time=1,711.022..1,858.728 rows=15,934 loops=1)

  • Hash Cond: (((d.full_path)::text = (dd.full_path)::text) AND (d.data_revision = dd.dr) AND ((d.revision_action)::text = (dd.revision_action)::text))
  • Index Cond: (revision_number > '61133901'::bigint)
  • Index Cond: ((revision_id)::text = (irh.rid)::text)
  • Group Key: iscale_revision_detail.revision_action, iscale_revision_detail.full_path
  • Sort Key: iscale_revision_detail.revision_action, iscale_revision_detail.full_path
  • Sort Method: external merge Disk: 10712kB
  • Worker 0: Sort Method: external merge Disk: 10440kB
  • Worker 1: Sort Method: external merge Disk: 10392kB
2. 0.000 81.023 ↓ 1.1 30,631 1

Gather (cost=1,000.84..25,078.13 rows=29,083 width=964) (actual time=0.740..81.023 rows=30,631 loops=1)

  • Workers Planned: 1
  • Workers Launched: 1
3. 81.358 86.670 ↑ 1.1 15,316 2

Nested Loop (cost=0.84..21,169.83 rows=17,108 width=964) (actual time=0.159..86.670 rows=15,316 loops=2)

4. 5.307 5.307 ↑ 1.1 15,316 2

Parallel Index Scan using ai1_iscale_revision_history on iscale_revision_history irh (cost=0.42..995.44 rows=17,104 width=45) (actual time=0.067..5.307 rows=15,316 loops=2)

5. 0.005 0.005 ↑ 1.0 1 30,631

Index Scan using ix1_iscale_revision_detail on iscale_revision_detail d (cost=0.42..1.17 rows=1 width=993) (actual time=0.005..0.005 rows=1 loops=30,631)

6. 0.000 1,709.821 ↓ 4.1 121,621 1

Hash (cost=52,583.03..52,583.03 rows=29,468 width=128) (actual time=1,709.820..1,709.821 rows=121,621 loops=1)

  • Buckets: 32768 (originally 32768) Batches: 8 (originally 2) Memory Usage: 3841kB
7. 7.639 1,672.246 ↓ 4.1 121,621 1

Subquery Scan on dd (cost=43,525.35..52,583.03 rows=29,468 width=128) (actual time=955.481..1,672.246 rows=121,621 loops=1)

8. 1,664.607 1,664.607 ↓ 4.1 121,621 1

Finalize GroupAggregate (cost=43,525.35..52,288.35 rows=29,468 width=128) (actual time=955.479..1,664.607 rows=121,621 loops=1)

9. 0.000 1,637.814 ↓ 2.1 122,094 1

Gather Merge (cost=43,525.35..51,551.65 rows=58,936 width=128) (actual time=955.455..1,637.814 rows=122,094 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
10. 41.724 3,566.682 ↓ 1.4 40,698 3

Partial GroupAggregate (cost=42,525.32..43,748.95 rows=29,468 width=128) (actual time=947.047..1,188.894 rows=40,698 loops=3)

  • Group Key: iscale_revision_detail.revision_action, iscale_revision_detail.full_path
11. 3,524.958 3,524.958 ↑ 1.3 74,258 3

Sort (cost=42,525.32..42,757.56 rows=92,895 width=128) (actual time=947.035..1,174.986 rows=74,258 loops=3)

12. 147.138 147.138 ↑ 1.3 74,258 3

Parallel Seq Scan on iscale_revision_detail (cost=0.00..31,411.95 rows=92,895 width=128) (actual time=0.014..49.046 rows=74,258 loops=3)