explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 3vc4

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

Update on billings b (cost=7,631,270.40..7,766,786.99 rows=268,458 width=122) (actual rows= loops=)

2. 0.000 0.000 ↓ 0.0

Merge Join (cost=7,631,270.40..7,766,786.99 rows=268,458 width=122) (actual rows= loops=)

  • Merge Cond: ((f.old_uuid)::text = (b.uuid)::text)
3. 0.000 0.000 ↓ 0.0

Sort (cost=7,113,990.73..7,179,556.81 rows=26,226,432 width=70) (actual rows= loops=)

  • Sort Key: f.old_uuid
4. 0.000 0.000 ↓ 0.0

Seq Scan on billtest f (cost=0.00..655,221.32 rows=26,226,432 width=70) (actual rows= loops=)

5. 0.000 0.000 ↓ 0.0

Materialize (cost=517,279.68..517,994.80 rows=143,025 width=125) (actual rows= loops=)

6. 0.000 0.000 ↓ 0.0

Sort (cost=517,279.68..517,637.24 rows=143,025 width=125) (actual rows= loops=)

  • Sort Key: b.uuid
7. 0.000 0.000 ↓ 0.0

Index Scan using idx_billing_timestamp on billings b (cost=0.58..495,743.51 rows=143,025 width=125) (actual rows= loops=)

  • Index Cond: (("timestamp" >= '2018-11-14 00:00:00'::timestamp without time zone) AND ("timestamp" < '2018-11-14 00:10:00'::timestamp without time zone))