explain.depesz.com

PostgreSQL's explain analyze made readable

Result: XCX9

Settings
# exclusive inclusive rows x rows loops node
1. 9.677 134,111.453 ↓ 100.0 100 1

Limit (cost=585,266.98..794,973.00 rows=1 width=13) (actual time=58,627.810..134,111.453 rows=100 loops=1)

2. 75,483.726 134,101.776 ↓ 100.0 100 1

Gather (cost=585,266.98..794,973.00 rows=1 width=13) (actual time=58,627.808..134,101.776 rows=100 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
3. 12,255.046 58,618.050 ↓ 34.0 34 3

Parallel Hash Anti Join (cost=584,266.98..793,972.90 rows=1 width=13) (actual time=58,614.750..58,618.050 rows=34 loops=3)

  • Hash Cond: ((mt.itemid)::text = (li.linkeditemid)::text)
4. 878.059 878.059 ↑ 1.3 968,775 3

Parallel Index Only Scan using ix_itemtype_fieldname on maintable mt (cost=0.56..127,933.83 rows=1,216,331 width=13) (actual time=0.060..878.059 rows=968,775 loops=3)

  • Index Cond: (itemtype = 1)
  • Heap Fetches: 0
5. 32,964.780 45,484.945 ↓ 1.1 14,445,990 3

Parallel Hash (cost=357,101.33..357,101.33 rows=13,068,327 width=13) (actual time=45,484.945..45,484.945 rows=14,445,990 loops=3)

  • Buckets: 131072 (originally 131072) Batches: 1024 (originally 512) Memory Usage: 3104kB
6. 10,347.401 12,520.165 ↓ 1.1 14,445,990 3

Parallel Hash Join (cost=149,077.97..357,101.33 rows=13,068,327 width=13) (actual time=3,050.747..12,520.165 rows=14,445,990 loops=3)

  • Hash Cond: ((li.itemid)::text = (parenttypes.itemid)::text)
7. 481.978 481.978 ↑ 1.3 1,073,005 3

Parallel Seq Scan on linkeditems li (cost=0.00..37,082.57 rows=1,341,257 width=26) (actual time=0.130..481.978 rows=1,073,005 loops=3)

8. 776.484 1,690.786 ↑ 1.3 968,775 3

Parallel Hash (cost=127,933.83..127,933.83 rows=1,216,331 width=13) (actual time=1,690.786..1,690.786 rows=968,775 loops=3)

  • Buckets: 131072 Batches: 64 Memory Usage: 3328kB
9. 914.302 914.302 ↑ 1.3 968,775 3

Parallel Index Only Scan using ix_itemtype_fieldname on maintable parenttypes (cost=0.56..127,933.83 rows=1,216,331 width=13) (actual time=0.148..914.302 rows=968,775 loops=3)

  • Index Cond: (itemtype = 1)
  • Heap Fetches: 0