explain.depesz.com

PostgreSQL's explain analyze made readable

Result: nO9R

Settings
# exclusive inclusive rows x rows loops node
1. 0.019 306.491 ↑ 1.0 1 1

Result (cost=3,931.15..3,931.16 rows=1 width=32) (actual time=306.491..306.491 rows=1 loops=1)

2.          

Initplan (for Result)

3. 0.142 306.472 ↑ 3.7 27 1

Nested Loop (cost=0.28..3,931.15 rows=100 width=32) (actual time=0.291..306.472 rows=27 loops=1)

4. 0.042 0.042 ↑ 2.1 48 1

Function Scan on jsonb_to_recordset t (cost=0.00..1.00 rows=100 width=8) (actual time=0.024..0.042 rows=48 loops=1)

5. 0.960 306.288 ↑ 23.0 1 48

Append (cost=0.28..39.07 rows=23 width=33) (actual time=6.361..6.381 rows=1 loops=48)

6. 0.096 0.096 ↓ 0.0 0 48

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=48)

  • Index Cond: ((obj = t.rid) AND (obj_type = $19))
  • Heap Fetches: 0
7. 0.096 0.096 ↓ 0.0 0 48

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=48)

  • Index Cond: ((obj = t.rid) AND (obj_type = $19))
  • Heap Fetches: 0
8. 0.096 0.096 ↓ 0.0 0 48

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=48)

  • Index Cond: ((obj = t.rid) AND (obj_type = $19))
  • Heap Fetches: 0
9. 0.096 0.096 ↓ 0.0 0 48

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=48)

  • Index Cond: ((obj = t.rid) AND (obj_type = $19))
  • Heap Fetches: 0
10. 0.096 0.096 ↓ 0.0 0 48

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=48)

  • Index Cond: ((obj = t.rid) AND (obj_type = $19))
  • Heap Fetches: 0
11. 0.096 0.096 ↓ 0.0 0 48

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=48)

  • Index Cond: ((obj = t.rid) AND (obj_type = $19))
  • Heap Fetches: 0
12. 0.096 0.096 ↓ 0.0 0 48

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=48)

  • Index Cond: ((obj = t.rid) AND (obj_type = $19))
  • Heap Fetches: 0
13. 0.096 0.096 ↓ 0.0 0 48

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.48 rows=1 width=33) (actual time=0.002..0.002 rows=0 loops=48)

  • Index Cond: ((obj = t.rid) AND (obj_type = $19))
  • Heap Fetches: 0
14. 0.096 0.096 ↓ 0.0 0 48

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=48)

  • Index Cond: ((obj = t.rid) AND (obj_type = $19))
  • Heap Fetches: 0
15. 0.144 0.144 ↓ 0.0 0 48

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.003..0.003 rows=0 loops=48)

  • Index Cond: ((obj = t.rid) AND (obj_type = $19))
  • Heap Fetches: 0
16. 0.144 0.144 ↓ 0.0 0 48

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.003..0.003 rows=0 loops=48)

  • Index Cond: ((obj = t.rid) AND (obj_type = $19))
  • Heap Fetches: 0
17. 0.144 0.144 ↓ 0.0 0 48

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.003..0.003 rows=0 loops=48)

  • Index Cond: ((obj = t.rid) AND (obj_type = $19))
  • Heap Fetches: 0
18. 0.144 0.144 ↓ 0.0 0 48

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.003..0.003 rows=0 loops=48)

  • Index Cond: ((obj = t.rid) AND (obj_type = $19))
  • Heap Fetches: 0
19. 0.144 0.144 ↓ 0.0 0 48

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.003..0.003 rows=0 loops=48)

  • Index Cond: ((obj = t.rid) AND (obj_type = $19))
  • Heap Fetches: 0
20. 0.144 0.144 ↓ 0.0 0 48

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.003..0.003 rows=0 loops=48)

  • Index Cond: ((obj = t.rid) AND (obj_type = $19))
  • Heap Fetches: 0
21. 300.528 300.528 ↓ 0.0 0 48

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=6.261..6.261 rows=0 loops=48)

  • Index Cond: ((obj = t.rid) AND (obj_type = $19))
  • Heap Fetches: 7
22. 2.160 2.160 ↓ 0.0 0 48

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.045..0.045 rows=0 loops=48)

  • Index Cond: ((obj = t.rid) AND (obj_type = $19))
  • Heap Fetches: 5
23. 0.192 0.192 ↓ 0.0 0 48

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.004..0.004 rows=0 loops=48)

  • Index Cond: ((obj = t.rid) AND (obj_type = $19))
  • Heap Fetches: 0
24. 0.144 0.144 ↓ 0.0 0 48

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.76 rows=1 width=33) (actual time=0.003..0.003 rows=0 loops=48)

  • Index Cond: ((obj = t.rid) AND (obj_type = $19))
  • Heap Fetches: 0
25. 0.144 0.144 ↓ 0.0 0 48

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.74 rows=1 width=33) (actual time=0.003..0.003 rows=0 loops=48)

  • Index Cond: ((obj = t.rid) AND (obj_type = $19))
  • Heap Fetches: 0
26. 0.144 0.144 ↓ 0.0 0 48

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.96 rows=1 width=33) (actual time=0.003..0.003 rows=0 loops=48)

  • Index Cond: ((obj = t.rid) AND (obj_type = $19))
  • Heap Fetches: 0
27. 0.144 0.144 ↓ 0.0 0 48

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.67 rows=1 width=33) (actual time=0.003..0.003 rows=0 loops=48)

  • Index Cond: ((obj = t.rid) AND (obj_type = $19))
  • Heap Fetches: 0
28. 0.144 0.144 ↓ 0.0 0 48

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.22 rows=1 width=33) (actual time=0.003..0.003 rows=0 loops=48)

  • Index Cond: ((obj = t.rid) AND (obj_type = $19))
  • Heap Fetches: 0