explain.depesz.com

PostgreSQL's explain analyze made readable

Result: XlMA

Settings
# exclusive inclusive rows x rows loops node
1. 0.000 0.000 ↓ 0.0

Sort (cost=46,985,606.83..47,135,364.43 rows=59,903,040 width=228) (actual rows= loops=)

  • Sort Key: t.sku
2. 0.000 0.000 ↓ 0.0

Hash Left Join (cost=3,408,988.46..27,734,678.92 rows=59,903,040 width=228) (actual rows= loops=)

  • Hash Cond: (sir.robot_id = r.id)
3. 0.000 0.000 ↓ 0.0

Hash Left Join (cost=3,408,967.89..26,677,904.23 rows=59,903,040 width=212) (actual rows= loops=)

  • Hash Cond: ((si.name_id = b.id) AND (ss.country_id = b.country_id))
4. 0.000 0.000 ↓ 0.0

Hash Right Join (cost=13,733.81..19,818,530.20 rows=59,903,040 width=128) (actual rows= loops=)

  • Hash Cond: ((si.sku_id)::numeric = t.sku_id)
5. 0.000 0.000 ↓ 0.0

Merge Left Join (cost=82.24..18,606,817.82 rows=119,806,080 width=116) (actual rows= loops=)

  • Merge Cond: (si.sku_id = sir.sku_id)
6. 0.000 0.000 ↓ 0.0

Merge Left Join (cost=58.65..14,148,601.07 rows=119,806,080 width=100) (actual rows= loops=)

  • Merge Cond: (si.sku_id = uu.sku_id)
7. 0.000 0.000 ↓ 0.0

Merge Left Join (cost=28.06..8,150,248.69 rows=119,806,080 width=12) (actual rows= loops=)

  • Merge Cond: (si.sku_id = ss.id)
8. 0.000 0.000 ↓ 0.0

Index Scan using sku_info_pkey on sku_info si (cost=0.57..3,256,627.68 rows=119,806,080 width=8) (actual rows= loops=)

9. 0.000 0.000 ↓ 0.0

Index Scan using z_sku_pkey2 on sku ss (cost=0.57..3,094,541.16 rows=120,601,538 width=8) (actual rows= loops=)

10. 0.000 0.000 ↓ 0.0

Index Scan using sku_url_pkey on sku_url uu (cost=0.57..4,200,302.63 rows=120,234,152 width=92) (actual rows= loops=)

11. 0.000 0.000 ↓ 0.0

Index Scan using sku_image_robot_pkey on sku_image_robot sir (cost=0.57..2,772,974.15 rows=110,858,192 width=20) (actual rows= loops=)

12. 0.000 0.000 ↓ 0.0

Hash (cost=13,045.16..13,045.16 rows=48,513 width=16) (actual rows= loops=)

13. 0.000 0.000 ↓ 0.0

Merge Anti Join (cost=8,328.17..13,045.16 rows=48,513 width=16) (actual rows= loops=)

  • Merge Cond: (t.sku_id = ((rr.sku_id)::numeric))
14. 0.000 0.000 ↓ 0.0

Index Scan using prefixin_ikea_raw_data_sku_id_idx on prefixin_ikea_raw_data t (cost=0.42..2,735.01 rows=97,026 width=16) (actual rows= loops=)

15. 0.000 0.000 ↓ 0.0

Sort (cost=8,327.75..8,541.65 rows=85,558 width=4) (actual rows= loops=)

  • Sort Key: ((rr.sku_id)::numeric)
16. 0.000 0.000 ↓ 0.0

Seq Scan on prefixout_ikea_taxonomy rr (cost=0.00..1,318.58 rows=85,558 width=4) (actual rows= loops=)

17. 0.000 0.000 ↓ 0.0

Hash (cost=1,578,935.83..1,578,935.83 rows=59,307,683 width=100) (actual rows= loops=)

18. 0.000 0.000 ↓ 0.0

Seq Scan on name_t b (cost=0.00..1,578,935.83 rows=59,307,683 width=100) (actual rows= loops=)

19. 0.000 0.000 ↓ 0.0

Hash (cost=11.92..11.92 rows=692 width=17) (actual rows= loops=)

20. 0.000 0.000 ↓ 0.0

Seq Scan on robot r (cost=0.00..11.92 rows=692 width=17) (actual rows= loops=)