explain.depesz.com

PostgreSQL's explain analyze made readable

Result: VuNB

Settings
# exclusive inclusive rows x rows loops node
1. 0.002 166.180 ↑ 1.0 2 1

Append (cost=16.90..71,280.19 rows=2 width=8) (actual time=0.008..166.180 rows=2 loops=1)

2. 0.002 0.008 ↑ 1.0 1 1

Aggregate (cost=16.90..16.91 rows=1 width=8) (actual time=0.008..0.008 rows=1 loops=1)

3. 0.000 0.006 ↓ 0.0 0 1

Nested Loop (cost=0.85..16.90 rows=1 width=0) (actual time=0.006..0.006 rows=0 loops=1)

4. 0.006 0.006 ↓ 0.0 0 1

Index Scan using rental_update_time_desc_idx on rental r (cost=0.42..8.45 rows=1 width=16) (actual time=0.006..0.006 rows=0 loops=1)

  • Index Cond: ((update_time < '2020-12-30 05:13:21.97002'::timestamp without time zone) AND (update_time >= '2020-12-30 04:13:21.97002'::timestamp without time zone))
5. 0.000 0.000 ↓ 0.0 0

Index Only Scan using fki_billing_info_rental_id_fkey on billing_history bi (cost=0.42..8.44 rows=1 width=16) (never executed)

  • Index Cond: (rental_id = r.id)
  • Heap Fetches: 0
6. 0.003 166.170 ↑ 1.0 1 1

Aggregate (cost=71,263.25..71,263.26 rows=1 width=8) (actual time=166.170..166.170 rows=1 loops=1)

7. 0.000 166.167 ↓ 0.0 0 1

Nested Loop (cost=1,000.42..71,263.25 rows=1 width=0) (actual time=166.167..166.167 rows=0 loops=1)

8. 18.994 166.758 ↓ 0.0 0 1

Gather (cost=1,000.00..71,258.81 rows=1 width=16) (actual time=166.167..166.758 rows=0 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
9. 147.764 147.764 ↓ 0.0 0 3 / 3

Parallel Seq Scan on billing_history bi_1 (cost=0.00..70,258.71 rows=1 width=16) (actual time=147.764..147.764 rows=0 loops=3)

  • Filter: ((update_time < '2020-12-30 05:13:21.97002'::timestamp without time zone) AND (update_time >= '2020-12-30 04:13:21.97002'::timestamp without time zone))
  • Rows Removed by Filter: 334,224
10. 0.000 0.000 ↓ 0.0 0

Index Only Scan using rental_id_scooter_idx on rental r_1 (cost=0.42..4.44 rows=1 width=16) (never executed)

  • Index Cond: (id = bi_1.rental_id)
  • Heap Fetches: 0
Planning time : 0.793 ms
Execution time : 166.841 ms