explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 6S1n

Settings
# exclusive inclusive rows x rows loops node
1. 0.040 257.568 ↑ 1.0 1 1

Result (cost=3,935.55..3,935.56 rows=1 width=32) (actual time=257.567..257.568 rows=1 loops=1)

2.          

Initplan (for Result)

3. 0.383 257.528 ↑ 1.4 69 1

Nested Loop (cost=0.28..3,935.55 rows=100 width=32) (actual time=28.992..257.528 rows=69 loops=1)

4. 0.105 0.105 ↓ 1.4 140 1

Function Scan on jsonb_to_recordset t (cost=0.00..1.00 rows=100 width=8) (actual time=0.054..0.105 rows=140 loops=1)

5. 1.540 257.040 ↓ 0.0 0 140

Append (cost=0.28..39.11 rows=23 width=33) (actual time=1.832..1.836 rows=0 loops=140)

6. 0.280 0.280 ↓ 0.0 0 140

Index Only Scan using online_order_object_part_old_pkey on online_order_object_part_old oo (cost=0.28..0.70 rows=1 width=32) (actual time=0.002..0.002 rows=0 loops=140)

  • Index Cond: ((obj = t.rid) AND (obj_type = '1'::smallint))
  • Heap Fetches: 0
7. 0.280 0.280 ↓ 0.0 0 140

Index Only Scan using online_order_object_part_2020_04_26_pkey on online_order_object_part_2020_04_26 oo_1 (cost=0.41..1.53 rows=1 width=33) (actual time=0.002..0.002 rows=0 loops=140)

  • Index Cond: ((obj = t.rid) AND (obj_type = '1'::smallint))
  • Heap Fetches: 0
8. 0.280 0.280 ↓ 0.0 0 140

Index Only Scan using online_order_object_part_2020_04_27_pkey on online_order_object_part_2020_04_27 oo_2 (cost=0.41..1.88 rows=1 width=33) (actual time=0.002..0.002 rows=0 loops=140)

  • Index Cond: ((obj = t.rid) AND (obj_type = '1'::smallint))
  • Heap Fetches: 0
9. 0.280 0.280 ↓ 0.0 0 140

Index Only Scan using online_order_object_part_2020_04_28_pkey on online_order_object_part_2020_04_28 oo_3 (cost=0.41..1.61 rows=1 width=33) (actual time=0.002..0.002 rows=0 loops=140)

  • Index Cond: ((obj = t.rid) AND (obj_type = '1'::smallint))
  • Heap Fetches: 0
10. 0.280 0.280 ↓ 0.0 0 140

Index Only Scan using online_order_object_part_2020_04_29_pkey on online_order_object_part_2020_04_29 oo_4 (cost=0.41..1.35 rows=1 width=33) (actual time=0.002..0.002 rows=0 loops=140)

  • Index Cond: ((obj = t.rid) AND (obj_type = '1'::smallint))
  • Heap Fetches: 0
11. 0.280 0.280 ↓ 0.0 0 140

Index Only Scan using online_order_object_part_2020_04_30_pkey on online_order_object_part_2020_04_30 oo_5 (cost=0.41..1.48 rows=1 width=33) (actual time=0.002..0.002 rows=0 loops=140)

  • Index Cond: ((obj = t.rid) AND (obj_type = '1'::smallint))
  • Heap Fetches: 0
12. 0.280 0.280 ↓ 0.0 0 140

Index Only Scan using online_order_object_part_2020_05_01_pkey on online_order_object_part_2020_05_01 oo_6 (cost=0.41..1.43 rows=1 width=33) (actual time=0.002..0.002 rows=0 loops=140)

  • Index Cond: ((obj = t.rid) AND (obj_type = '1'::smallint))
  • Heap Fetches: 0
13. 0.280 0.280 ↓ 0.0 0 140

Index Only Scan using online_order_object_part_2020_05_02_pkey on online_order_object_part_2020_05_02 oo_7 (cost=0.41..1.49 rows=1 width=33) (actual time=0.002..0.002 rows=0 loops=140)

  • Index Cond: ((obj = t.rid) AND (obj_type = '1'::smallint))
  • Heap Fetches: 0
14. 0.280 0.280 ↓ 0.0 0 140

Index Only Scan using online_order_object_part_2020_05_03_pkey on online_order_object_part_2020_05_03 oo_8 (cost=0.41..1.39 rows=1 width=33) (actual time=0.002..0.002 rows=0 loops=140)

  • Index Cond: ((obj = t.rid) AND (obj_type = '1'::smallint))
  • Heap Fetches: 0
15. 0.280 0.280 ↓ 0.0 0 140

Index Only Scan using online_order_object_part_2020_05_04_pkey on online_order_object_part_2020_05_04 oo_9 (cost=0.41..1.36 rows=1 width=33) (actual time=0.002..0.002 rows=0 loops=140)

  • Index Cond: ((obj = t.rid) AND (obj_type = '1'::smallint))
  • Heap Fetches: 0
16. 0.280 0.280 ↓ 0.0 0 140

Index Only Scan using online_order_object_part_2020_05_05_pkey on online_order_object_part_2020_05_05 oo_10 (cost=0.41..1.48 rows=1 width=33) (actual time=0.002..0.002 rows=0 loops=140)

  • Index Cond: ((obj = t.rid) AND (obj_type = '1'::smallint))
  • Heap Fetches: 0
17. 0.280 0.280 ↓ 0.0 0 140

Index Only Scan using online_order_object_part_2020_05_06_pkey on online_order_object_part_2020_05_06 oo_11 (cost=0.41..1.52 rows=1 width=33) (actual time=0.002..0.002 rows=0 loops=140)

  • Index Cond: ((obj = t.rid) AND (obj_type = '1'::smallint))
  • Heap Fetches: 0
18. 0.280 0.280 ↓ 0.0 0 140

Index Only Scan using online_order_object_part_2020_05_07_pkey on online_order_object_part_2020_05_07 oo_12 (cost=0.41..1.48 rows=1 width=33) (actual time=0.002..0.002 rows=0 loops=140)

  • Index Cond: ((obj = t.rid) AND (obj_type = '1'::smallint))
  • Heap Fetches: 0
19. 0.280 0.280 ↓ 0.0 0 140

Index Only Scan using online_order_object_part_2020_05_08_pkey on online_order_object_part_2020_05_08 oo_13 (cost=0.42..2.57 rows=1 width=33) (actual time=0.002..0.002 rows=0 loops=140)

  • Index Cond: ((obj = t.rid) AND (obj_type = '1'::smallint))
  • Heap Fetches: 0
20. 0.280 0.280 ↓ 0.0 0 140

Index Only Scan using online_order_object_part_2020_05_09_pkey on online_order_object_part_2020_05_09 oo_14 (cost=0.42..2.53 rows=1 width=33) (actual time=0.002..0.002 rows=0 loops=140)

  • Index Cond: ((obj = t.rid) AND (obj_type = '1'::smallint))
  • Heap Fetches: 0
21. 0.280 0.280 ↓ 0.0 0 140

Index Only Scan using online_order_object_part_2020_05_10_pkey on online_order_object_part_2020_05_10 oo_15 (cost=0.43..2.12 rows=1 width=33) (actual time=0.002..0.002 rows=0 loops=140)

  • Index Cond: ((obj = t.rid) AND (obj_type = '1'::smallint))
  • Heap Fetches: 0
22. 0.420 0.420 ↓ 0.0 0 140

Index Only Scan using online_order_object_part_2020_05_11_pkey on online_order_object_part_2020_05_11 oo_16 (cost=0.43..2.15 rows=1 width=33) (actual time=0.003..0.003 rows=0 loops=140)

  • Index Cond: ((obj = t.rid) AND (obj_type = '1'::smallint))
  • Heap Fetches: 2
23. 0.420 0.420 ↓ 0.0 0 140

Index Only Scan using online_order_object_part_2020_05_12_pkey on online_order_object_part_2020_05_12 oo_17 (cost=0.43..1.55 rows=1 width=33) (actual time=0.003..0.003 rows=0 loops=140)

  • Index Cond: ((obj = t.rid) AND (obj_type = '1'::smallint))
  • Heap Fetches: 0
24. 0.980 0.980 ↓ 0.0 0 140

Index Only Scan using online_order_object_part_2020_05_13_pkey on online_order_object_part_2020_05_13 oo_18 (cost=0.43..1.80 rows=1 width=33) (actual time=0.007..0.007 rows=0 loops=140)

  • Index Cond: ((obj = t.rid) AND (obj_type = '1'::smallint))
  • Heap Fetches: 3
25. 0.560 0.560 ↓ 0.0 0 140

Index Only Scan using online_order_object_part_2020_05_14_pkey on online_order_object_part_2020_05_14 oo_19 (cost=0.55..1.84 rows=1 width=33) (actual time=0.004..0.004 rows=0 loops=140)

  • Index Cond: ((obj = t.rid) AND (obj_type = '1'::smallint))
  • Heap Fetches: 4
26. 0.840 0.840 ↓ 0.0 0 140

Index Only Scan using online_order_object_part_2020_05_15_pkey on online_order_object_part_2020_05_15 oo_20 (cost=0.55..1.73 rows=1 width=33) (actual time=0.005..0.006 rows=0 loops=140)

  • Index Cond: ((obj = t.rid) AND (obj_type = '1'::smallint))
  • Heap Fetches: 3
27. 247.380 247.380 ↓ 0.0 0 140

Index Only Scan using online_order_object_part_2020_05_16_pkey on online_order_object_part_2020_05_16 oo_21 (cost=0.43..1.75 rows=1 width=33) (actual time=1.766..1.767 rows=0 loops=140)

  • Index Cond: ((obj = t.rid) AND (obj_type = '1'::smallint))
  • Heap Fetches: 5
28. 0.420 0.420 ↓ 0.0 0 140

Index Only Scan using online_order_object_part_2020_05_17_pkey on online_order_object_part_2020_05_17 oo_22 (cost=0.42..2.26 rows=1 width=33) (actual time=0.003..0.003 rows=0 loops=140)

  • Index Cond: ((obj = t.rid) AND (obj_type = '1'::smallint))
  • Heap Fetches: 0